Register
Login
Register
Login
Search
Home
Applications
Content Management System
Custom DNN Modules
Business Directory
Restaurant Menu Manager
Custom Database Reporting
Distributor Locator
Gift Certificates
Date Time Calculator
Consulting
Design
Surveillance Systems
Business Links
Support
Knowledge Base
Contact
SQL Server 2008 R2
Support
/
Knowledge Base
/
Microsoft SQL Server
/
SQL Server 2008 R2
Snippets
Current Articles
|
Archives
|
Search
SQL Server 2008 R2
NO Image:
16
Replace Null or Empty Value with String
DNN Expert
posted on September 16, 2014 06:28
Select ISNULL(NULLIF(GIBS_FBLineItems.ReportType, ''), '--Undefined--') as ReportType from GIBS_FBLineItems
SQL
Posted in:
Stored Procedures
,
SQL Server 2008 R2
,
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
18
Identify SQL User Roles
DNN Expert
posted on October 18, 2012 05:00
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
Posted in:
SQL Server 2008 R2
Actions:
E-mail
|
Permalink
|
Comments (0)
31
How to Shrink Your DotNetNuke Database Log File / Truncate Transaction Log
DNN Expert
posted on December 31, 2011 08:05
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
Posted in:
DNN
,
Microsoft SQL Server
,
SQL Server 2008 R2
Actions:
E-mail
|
Permalink
|
Comments (0)
17
Finding the Port of MS SQL Named Instance
DNN Expert
posted on March 17, 2011 06:12
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...]
Posted in:
Microsoft SQL Server
,
Stored Procedures
,
SQL Server 2008 R2
Actions:
E-mail
|
Permalink
|
Comments (0)
20
Create a New Database From an Existing Database Backup (SQL Server Management Studio)
DNN Expert
posted on December 20, 2010 07:52
This topic explains how to create a new database from an existing full database backup. Security Note ...
[Read the rest of this article...]
Posted in:
Microsoft SQL Server
,
SQL Server 2008 R2
Actions:
E-mail
|
Permalink
|
Comments (0)
Page 2 of 2
First
Previous
1
[2]
Next
Last
Archives
Azure (1)
C Sharp - C# (37)
..private void function() (11)
CraigsList (0)
CSS (15)
DNN (58)
..Modules (21)
....Core Modules (6)
....Custom Modules (34)
..Resource Links (2)
..Skin Objects (2)
..Social (1)
DNS (0)
E-Mail (3)
IIS (3)
Malware (1)
Microsoft SQL Server (17)
..Azure SQL Database (1)
..SQL Scripts (16)
..SQL Server 2008 R2 (11)
..SQL Server 2014 (1)
..Stored Procedures (6)
Networking Problems (7)
Operating Systems (1)
..Windows 7 (3)
..Windows Server 2003 (1)
..Windows Server 2008 (2)
..Windows Server 2012 (2)
..Windows Vista (2)
..Windows XP (4)
PCI DSS Compliance (1)
SSRS (1)
Technology (139)
VbScript (3)
Web Design (7)
Web.Config (5)