Really, this is a case of the road to hell being paved with good intentions.  You can see the spirit of what the IT Director wanted to do its just...

Yes, I know what MODEL is for, its just that it has been hammered into me since SQL6.5 that the MASTER is and always should be sacrosanct.

Robert did bring up...

Presumably you have an ordering sequence?

Without details of your table structure the only way that I can think of doing it is by using a cursor, however I would tend...

Has Scott Adams drawn a picture of your IT director by any chance?

I was told by an old sergeant that when officers gives a stupid order you follow that order...

There is an old SQL6.5 trick that still works.

sp_addalias <login>,'dbo'

If you run that in your database then your developer login will be the dbo and therefore all objects created in...

Let us suppose that your procedure inserts records into a customer table, and order table and an order item table.

You could have a single procedure to do this, but there...

You set @insertSql statement is trying to concatenate a string and a date, and therefore throws the error.

If you want to build the string then simply do the following

set @insertSql='Insert...

Surely, this is what the MODEL database is for?

I think the great thing about MIDI was that it was a standard when there weren't any standards.

To come up with a replacement for MIDI would be a major achievement, after...

There is an IGNORE_DUP_KEY when creating and index which has to be on a unique index.

If you run an insert statement that adds rows to a table and some of...

I take it you have some performance problems?

If your staging and production database are on the same box then I would use one of the methods you mention.

If the two...

We have just had our first contract tester and I have to say that it has been a very positive experience.

Our QA environment highlighted the need for a change in...

If you can login to one server with the SA password then you can hack into any other SQL Server on the network.

Try sp_addlinkedserver!

Because SA always has id 1 you...

In the majority of cases it works.  In the past year it has failed 15 times on scheduled runs.

It is more the fact that I cannot get any diagnostic information...

NORMALISATION

Normalise when it is practical to do so.  If you have a sales by day of week arrangement then there would be little point in normalising it down to a...