Yes.

GilaMonster (3/11/2009)

Bet you a coffee that either he comes back...

If I'm not mistaken, you can use Visual Studio to debug procs. I haven't done so, but I've heard it can be done. That might count as an...

You can give the query a column alias. If you don't, SQL Sever makes one up on its own, and it's not consistent.

Ends up looking like:

select

(select col1, col2

from...

sa = "system administrator"

If you use it at all, use it for that purpose, and nothing else.

Otherwise, you can end up leaving your database open to all kinds of security...

Separate databases also works. The scripting idea is based on the idea that any changes the person made to their own copy of the database would be carried over...

As far as enforcing structural requirements on tables, that's too easy. Before a table create/modify script goes from QA to production, check it. You can even create a...

You'll either need to record the server and it's location as part of the same key that the timestamp is in, or at least the time zone. SQL 2008...

I generally use Union All because of the transaction control that gives. I have run into problems with the stack when I tried to union too many operators together...

There are a few options.

You could have the SSIS package disable the trigger when it starts and enable it when it finishes. That's only a good option...

I like the idea of a database that gradually increases in complexity as you progress through various training exercises in it.

Start out with a table of customers, a table of...

If the primary objection to doing this in triggers is "writing out all of the columns", here's a little trick:

In Management Studio, go to the view you want, expand the...

You're welcome.

Jeff's right. That does have the sound of a sort of lynch mob kind of thing. Could be misinterpreting it, but it sounds that way. I've never...

Unique indexes don't work that way. You were talking about a constraint. Have you tried that?