SQL Server 2008 R2

Snippets


SQL Server 2008 R2

 

24
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
16
  (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
24
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
15
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
24
Get a list of the database names and database size in a sql server instance using tsql: EXEC sp_databases sp_databases
08
Try running . . . . exec sp_updatestats; SQL, DNN
Page 1 of 2First   Previous   [1]  2  Next   Last