Microsoft SQL Server

Snippets


Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.

NO Image:
08
Try running . . . . exec sp_updatestats; SQL, DNN
12
COALESCE (Transact-SQL)
31
PROCEDURE: This article tells you how to shrink a DotNetNuke database’s log file via Microsoft’s SQL Server Management Studio. 1) Lo...

[Read the rest of this article...]

ldf, logfile, sql log, truncate, shrink database, full transaction log error
07
To work around this problem, follow these steps on the computer that Windows Server 2003 or Windows XP SP2 is installed on: Make sure that the ...

[Read the rest of this article...]

SQL, Network DTC Access
09
Oracle: "Provider=MSDAORA; Data Source=ORACLE8i7;Persist Security Info=False;Integrated Security=yes" Microsoft Access: "Provider=Microsoft.Jet.OLEDB...

[Read the rest of this article...]

Connection Strings, SQL, Oracle, Microsoft Access, MySQL, IBM AS/400
10
Here's a great sql script to use for the DotNetNuke Reports Module: Select --   AU.Username,    U.FirstName,   ...

[Read the rest of this article...]

Page 2 of 3First   Previous   1  [2]  3  Next   Last