Remember OBJECTPROPERTY(..) when investigating objects.
The object property function appears to be often overlooked.
This function will tell us about any schema scoped object in the...
2011-01-20
1,285 reads
The object property function appears to be often overlooked.
This function will tell us about any schema scoped object in the...
2011-01-20
1,285 reads
I feel that it is wise move for a script to actually check itself that the database connection that is...
2011-01-20
1,930 reads
I feel that it is wise move for a script to actually check itself that the database connection that is...
2011-01-16
1,389 reads
One of the features that I have been using quite a lot lately is the OUTPUT clause.
This clause can be...
2011-01-09
918 reads
Recently I set up replication and as the target server was not on our domain I initially used an IP...
2010-09-20
957 reads
Ever wondered what happened to the SQL 2005 Surface Area Configuration Utility in SQL SERVER 2008.
Well you can accomplish pretty...
2010-09-14
859 reads
G'day,
This is pretty much my first blog post - at least on sqlservercentral.com - so to get started I thought that I'd...
2010-09-01
416 reads
By kleegeek
You’re invited! I’m thrilled to be co-presenting a session on the top five SQL...
By Steve Jones
We added a solar system to the ranch as a way to hedge against...
TLDR; The code to do this is below but it’s a bit hokey and...
Comments posted to this topic are about the item Shared Work Spaces: Hell, Heaven,...
Hello, Consider the following table that gives the validity dates of an item :...
Comments posted to this topic are about the item Migrate the SSIS Catalog in...