Check to see if there's a server trigger that disables that login.

You can also lookup alter login. Maybe that'll spark you on the right direction.

From my quick research, it...

I happenned to me all the time in EM.

The only I found around that was to close EM, open again, then I could hit the column and the sort would...

Also you can concatenate without using the cursor like this :

DECLARE @v-2 AS NVARCHAR(MAX)

SELECT TOP 10000 @v-2 = coalesce(@v + ', ' + M1.Name, M1.Name) FROM master.Sys.Columns M1 CROSS...

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.