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
958 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
This is part of a series of new job blog posts. You can find...
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Back in December 2019, I started presenting my session on mental health with lots...
Comments posted to this topic are about the item Managed Instance Link and SQL...
Comments posted to this topic are about the item Passing parameters to query without...
Comments posted to this topic are about the item Capturing Data Changes