In SQL Server 2005 by default users of a database that are only in the public role cannot see the definitions of an object while using sp_help, sp_helptext or the object_definition function.
2018-08-22
3,287 reads
2013-11-11
1,836 reads
This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.
2011-10-25
6,650 reads
Setting up multi-node clustered SQL instances from scratch is common practice for companies that want to implement high availability, but adding a new node to an existing clustered SQL instance that has been running for a while may have a few sticking points, especially for a SQL 2005 instance.
2011-10-12
2,577 reads
To merge data in SQL 2005 from various table, we do not have a MERGE function as in SQL 2008. The following script gives an alternative approach of implementing in SQL 2005
2011-06-15 (first published: 2011-06-03)
1,476 reads
2011-03-01 (first published: 2011-02-18)
4,064 reads
Microsoft completed SQL Server 2005 Service Pack 4 recently and made it available at the end of last week.
2010-12-20
4,684 reads
2010-11-03
2,981 reads
2010-10-04 (first published: 2010-09-29)
2,951 reads
2010-09-22
3,353 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hi, I have a trigger, that works fine elsewhere but is not working at...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers