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,795 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,517 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,421 reads
2011-03-01 (first published: 2011-02-18)
3,986 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,825 reads
2010-10-04 (first published: 2010-09-29)
2,912 reads
2010-09-22
3,294 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...