Fair point. I'll have to make the change. The times that I used it I wasn't looking for anything with special characters or keywords.

Actually I know a fair number of developers who became DBA's, or developer/DBA's. But a developer shouldn't be all of a sudden assigned the tasks of a DBA or...

Honestly I tried creating a script like that at one point. Its not easy .. at all. I ended up going with a 3rd party freeware application called...

You've probably already done this but just in case have you checked to make sure that you can create the constraint at all?

Ie run queries to make sure there isn't...

SQL Server must shut down in order to recover a database (database ID 1). The database is either a user database that could not be shut down or a system...

Have you run dbcc checkdb on your system databases? (not tempdb) and if so what information did you get?

Kenneth

Sorry I should have mentioned you have to go into the advanced tab and change that.

Glad you found it though 🙂

Kenneth

server.master.sys.sp_executesql

Here is an example

declare @sql nvarchar(2000)

set @sql = 'create procedure test as select * from sysdatabases'

exec [liked server].master.sys.sp_executesql @sql

Kenneth

Honestly sounds really cool, and really scary at the same time :).

I can see that as being really useful to enforce that a backup login (for instance) is only used...

Fair enough, good luck and you have my sympathies 🙂

Just remember that sp_changeobjectowner is a SQL 2000 function and is being deprocated. They recommend using ALTER SCHEMA or ALTER AUTHORIZATION in SQL 2005.

One very important thing you should remember (that I just thought of). Its a very bad idea for the DBA to tick off the Network/Hardware guys :).

Your better answer is to use profiler and create a trace on those users. Create a standard trace and filter on NTUserName (can't remember the exact column name) ....

Either change the user so that he no longer owns the schema or use ALTER SCHEMA to change the schema of your table.

You are probably better off changing the owner...

One other thing I would consider is when you set up your identity column specify the initial value as the "next" value from your orriginal table. That way if...