Some or all SQL Server 2005 services are not listed in SQL Server Configuration Manager, or you receive a “No…
- Swetha Sankaran
- September 14, 2009
- 5 min read
- 0
Category: SQL Server
– Get the current name of the SQL Server instance for later comparison. SELECT @@servername – Remove server from the…
- Swetha Sankaran
- September 8, 2009
- 1 min read
- 0
Retrieving rows for the last 3 months: This query is for retrieving the last 3 months data from sql table: SELECT…
- Swetha Sankaran
- September 8, 2009
- 1 min read
- 0
Requirement: ServerName and InstanceName to be displayed in a ToolPart Data: The classes required to retrieve the DataSource(this contains the…
- Swetha Sankaran
- September 8, 2009
- 1 min read
- 0
Well, after almost exactly 6 hours, I’ve succeeded at installing SQL Server 2005 Reporting Services on a server with more…
- Swetha Sankaran
- April 10, 2009
- 4 min read
- 0
What? SQL Server 2005’s Analysis Services uses a process titled Msmdsrv.exe The memory used by this process does not decrease…
- Swetha Sankaran
- April 9, 2009
- 2 min read
- 0