Well you are likely to get more than one "Chris Smith" as well as more than one "Chris" and more than one "Smith".

ALTER TABLE dbo.MyTable

ADD CONSTRAINT unq_MyTable UNIQUE (FirstName,LastName)

If I get a vague definition of what an update on a table is supposed to do I carry out something similar to the SQL below:

CREATE PROC dbo.setTable @id Int,...

I wish that the editorial was included in the home page of the site.

It adds a bit of variety and is a reminder that there is a human...

If all your tables have a clustered index then

SELECT object_name(id),SUM(rows)

FROM sysindexes

WHERE indid=1

GROUP BY object_name(id)

WITH ROLLUP

indid=1 is the clustered index

I don't have BOL to hand but I seem to remember that you can do something like SELECT @@SERVERNAME

Developer edition is supposed to be limited to 5 connections but apart from that they should be identical.

There is an explicit role called db_accessadmin that allows existing logins to be added as users in a database.

Where possible my approach would be to have Windows authentication and granting...

It sounds like someone set the initial size of TEMPDB to 15GB so if you reboot it will get built at that level.

You can check this by running the following...

If you CREATE TABLE #TableName it should be for the current connection only.

If you CREATE TABLE ##TableName then it will persists until the creating connection disconnects.

Thanks, Old SQL 6.5 habits die hard. Although I know it exists I rarely use the object_name function.

Does anyone know the correct syntax for getting decimal places to appear...

There are two solutions and they require db_owner or db_DDLAdmin privileges.

If you want to DELETE FROM Table1 then use TRUNCATE TABLE Table1. Not only will this reset the Identity...

The problem is not my creating objects out of sync the problem is that I have inherrited a plethora of ancient databases with convoluted dependencies and need to be able...

Is the nature of the single stored procedure such that it cannot be broken out into much simpler non-dynamic SQL?

Let us assume that the proc cannot be broken out.

Even if...

Sir Bob Geldoff says his productivity is directly proportional to the number of emails he ignores!

He also says that e-mail can be counter productive because the rapid fire responses it...

I would use the ADO Command object to call your stored procedure.

I don't have my ADO books to hand but it is a case of setting

Command.CommandText to the name of...