Microsoft SQL Server

Snippets


Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.

NO Image:
03
Declare @todays_date Date set @todays_date = CAST(SYSDATETIMEOFFSET() AT TIME ZONE 'Eastern Standard Time' AS date) For example, if you wa...

[Read the rest of this article...]

Azure SQL GetDate()
06
Set font to Wingdings . . . . Expression:  =IIF(Fields!Parishioner.Value,chr(254),chr(168)) SSRS
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
12
COALESCE (Transact-SQL)
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
07
http://support.microsoft.com/kb/839279

[Read the rest of this article...]

SQL, Network DTC Access
Page 1 of 2First   Previous   [1]  2  Next   Last