SQL Server 2008 R2

Snippets


SQL Server 2008 R2

 

NO Image:
16
Select ISNULL(NULLIF(GIBS_FBLineItems.ReportType, ''), '--Undefined--') as ReportType from GIBS_FBLineItems SQL
18
select dp2.name as role, dp1.name as owner from sys.database_principals as dp1 inner join sys.database_principals as dp2 on dp1.principal_id = dp2.own...

[Read the rest of this article...]

SQL Roles
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
17
When running a named instance of MS SQL the instance will run on a port other than the usual port 1433. To determine the port you can use th...

[Read the rest of this article...]

20
This topic explains how to create a new database from an existing full database backup. Security Note ...

[Read the rest of this article...]

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