lock out sa = lock yourself out of the server (unless you have other admin access rights).

Why do you want to do this?

Can C2 audit (failures) get you on your...

I don't know if DDL triggers can be used for that...

but you could always have a job run every hour to see if new procs have been created... then set...

You must list the columns you want to insert both in the insert statement and in the select.

INSERT INTO dbo.Table (Col1, Col2, Coln) Select Col1, Col2, Coln FROM dbo.Table2

I think this wipes out the stats : AND I.is_hypothetical = 0

I'm not sure though, I have not done such tasks in...

Yes it can, that's just a standard sql script. Create an sql script task (sorry, don't know the exact name) and put the code in there. That'll work...

I never had to enforce something like that. I was most fortunate to be able to tell them to stay off the server adn remove any and all permissions...

Thanks for all the usefull info man.

Thanks Sergiy, that answers part one of the question...

How do you deal with update SPs on table with a ton of column?

Do you preffer to have the dev only pass...

Sergiy (9/15/2008)

---

Normalizing of your attribute storage would be much more effective and much more simple in terms of coding.

Yes, it would be not so comfortable for editing from EM.

But you...

Need to insert the identity column in the table?

SET IDENTITY_INSERT dbo.TableName ON

INSERT INTO dbo.TableName.....

SET IDENTITY_INSERT dbo.TableName OFF

Yup :

Alter Table

Add FkColumn

Alter Table

Add Fk Constraint

Update Table SET CityID = Cities.CityID FROM Table Inner join Cities ON Table.City = Cites.City

ALTER TABLE

DROP COLUMN City --you must drop any associated...

The only thing your DR plan doesn't seem to cover is an asteroid destroying earth... you need a fileserver on the moon, just to be safe :D.

You might also want to check the correct syntax for an inner join!!! That'll save you a lot of troubles down the road.

I ran this on a clean install of 2005 (sorry, don't have 2000 installed anywhere)

EXEC dbo.sp_dbfixedrolepermission 'DB_ddladmin'

db_ddladminAll DDL but GRANT, REVOKE, DENY

db_ddladmindbcc cleantable

db_ddladmindbcc show_statistics

db_ddladmindbcc showcontig

db_ddladminREFERENCES permission on any table

db_ddladminsp_changeobjectowner

db_ddladminsp_fulltext_column

db_ddladminsp_fulltext_table

db_ddladminsp_recompile

db_ddladminsp_rename

db_ddladminsp_tableoption

db_ddladminTRUNCATE TABLE

That's still ovbious to split all those files.

What's the point of putting the backups on the same drive of the DB. When that drive is gone, everything is gone......