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,292 reads
Marty
- Interests: Playing Guitar, Music Theory
- Website: http://martincatherall.com/
Check that what you expected is actually what you got - DB's and SQLCMD
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
Check that what you expected is actually what you got - DB's and SQLCMD
I feel that it is wise move for a script to actually check itself that the database connection that is...
2011-01-16
1,390 reads
The OUTPUT clause
One of the features that I have been using quite a lot lately is the OUTPUT clause.
This clause can be...
2011-01-09
924 reads
Aliases in SQL Server 2008
Recently I set up replication and as the target server was not on our domain I initially used an IP...
2010-09-20
971 reads
SQL Server 2008 Surface Area Configuration
Ever wondered what happened to the SQL 2005 Surface Area Configuration Utility in SQL SERVER 2008.
Well you can accomplish pretty...
2010-09-14
868 reads
Naming Keys & Constraints
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
430 reads
Blogs
SQL Saturday NYC Recap 2025
By DataOnWheels
My first time at SQL Saturday New York City was an absolute blast! Thank...
Why Data Silos Hurt Your Business Performance
By Chris Yates
Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...
Forums
SSPI handshake failed error code 0x80090311
Hi, I have a workstation with SQL Express 2019 installed and I have a...
Need query help - MAX record
Hello - I have attached a Word document here with details about my issue....
Need query help - MAX record
I am having trouble writing linking the MAX query that I created back to...
Question of the Day
Removing Log Shipping
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers