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,289 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,289 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
965 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
863 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
420 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers