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:
24
Logging SSIS information to the Windows Event Log
DNN Expert
posted on March 24, 2017 06:00
First you need to add, using System.Diagnostics. This provides the hook to the classes that will enable you to push your error to the Windows Ev...
[Read the rest of this article...]
SSIS
Posted in:
SQL Server 2008 R2
Actions:
E-mail
|
Permalink
|
Comments (0)
16
DNN Region Lookup
DNN Expert
posted on February 16, 2016 06:20
(SELECT [Value] FROM Lists where EntryID = (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT ...
[Read the rest of this article...]
DNN Region Lookup
Posted in:
DNN
,
Microsoft SQL Server
,
SQL Server 2008 R2
,
SQL Scripts
Actions:
E-mail
|
Permalink
|
Comments (0)
24
SQL Server Reporting Services Permissions Error
DNN Expert
posted on December 24, 2014 06:33
To get this resolved you need to start you Internet Explorer as Administrator -> Run as Administrator then open the url http://<Server name>/...
[Read the rest of this article...]
SQL Reporting
,
SSRS
Posted in:
Microsoft SQL Server
,
SQL Server 2008 R2
,
SQL Server 2014
Actions:
E-mail
|
Permalink
|
Comments (0)
15
Pivot Query for Ventrian Property Agent
DNN Expert
posted on December 15, 2014 08:22
I had a need for getting a property details for a SSR report and came up with the following store procedure . . . I thought it might be useful t...
[Read the rest of this article...]
Ventrian Property Agent
Posted in:
Microsoft SQL Server
,
Stored Procedures
,
SQL Server 2008 R2
,
SQL Scripts
,
Modules
,
Custom Modules
Actions:
E-mail
|
Permalink
|
Comments (0)
24
Get a List of all Databases on a SQL Server Installation
DNN Expert
posted on October 24, 2014 05:57
Get a list of the database names and database size in a sql server instance using tsql: EXEC sp_databases
sp_databases
Posted in:
Microsoft SQL Server
,
SQL Server 2008 R2
Actions:
E-mail
|
Permalink
|
Comments (0)
08
SQL Timeout on Custom DNN module
DNN Expert
posted on October 08, 2014 15:33
Try running . . . . exec sp_updatestats;
SQL
,
DNN
Posted in:
DNN
,
Microsoft SQL Server
,
SQL Server 2008 R2
Actions:
E-mail
|
Permalink
|
Comments (0)
Page 1 of 2
First
Previous
[1]
2
Next
Last
Archives
Azure (1)
C Sharp - C# (37)
..private void function() (11)
CraigsList (0)
CSS (15)
DNN (56)
..Modules (21)
....Core Modules (6)
....Custom Modules (33)
..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 (15)
..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 (138)
VbScript (3)
Web Design (7)
Web.Config (5)