I do wish that SQL server gave sensible default names to constraints. Would also be nice if constraint names were only scoped to object they belong to so you could...

I think these are the articles describing the problem with this technique being non-deterministic. Complete with examples that may or may not work depending upon your optimiser, the version of...

Bob Hovious (9/7/2009)

If the index were a clustered index, I would agree. But rememeber that you...

Though for such small amounts of data at first I thought they might all perform a table scan as it decides there is no point using an index.

Its this decision...

I found the answer courtesy of Remus Rusanu from stack overflow, the solution was to use certificates and code signing of the trigger.

The full example can be found at http://stackoverflow.com/questions/1265386/current-transaction-id-in-an-audit-trigger/1267562#1267562

Try using GRANT EXECUTE on xp_cmdshell to [india\xg536]

You can use fn_my_permissions to check your permissions for a specific object in the database. http://msdn.microsoft.com/en-us/library/ms176097.aspx

If you're after the current logins, roles, etc. that you are a member of this...

Its difficult to ensure such security, along with the aforementioned transaction log, you have:

Backups

A row's data isn't zeroed out so can sit on disk for a while before sql server...

Another reason other than a large number of columns is if you are using two result sets that...

It's worth noting that pre-2008 the dependencies catalogue might not list all the dependencies.

Dependencies were tracked by object id, so if you create the objects out of order, or drop...

You have a run-away <pre> block in there after the first result set which is breaking the formatting. (and I didn't expect to have to html encode <)

Ignoring the 2 byte overhead for a varchar, char can still work out better for physical storage due to it being a fixed size which can be a benefit later...

Interestingly I can get it to work if I prefix the name of the view with sp_ but unfortunatly that doesn't work when I try to put the views under...

The new layout is very nice, but I noticed the "Add to Briefcase" link in articles is now missing the words "Add to".

It took me a moment to workout this...

This is of course assuming there are no possible cycles in the table:

ie the route was: 1 -> 2 -> 3 -> 2 -> 4

Otherwise you're going to get an...