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
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,389 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
918 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
958 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
859 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
416 reads
Blogs
Why I tweet about work and personal topics from the same account
Over the last few years, I’ve had a few people ask me why I...
Daily Coping 26 Sep 2022
By Steve Jones
Today’s coping tip is to enjoy photos from a time with happy memories. On...
Daily Coping 23 Sep 2022
By Steve Jones
Today’s coping tip is to notice what you are feeling without any judgment. Today...
Forums
Seggregating access within a database to users
For some folks that have gotten used to working in Oracle where a user...
Replication Error on identity Column : Transactional Replication
I have manually deleted data from a subscriber replicated table, and broken replication....
Two fact tables related
Hi all, I have a couple of modelling questions using several star schemas. There...
Ask SSC