SQL Server 2008 R2

Snippets


SQL Server 2008 R2

 

NO Image:
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