sanketahir1985 (5/21/2010)

---

but let me tell u my scenario

actually SP_ClientBPS runs after every 5 sec. thru console program

while Sp_IEActiveScreen gets fired randomly by users avg freq is 5-10 hits per...

If these are SQL 2000 Jobs you are talking about I would set each step to "on failure go to" and send it to a special "Send e-mail on failure"...

You can just genereate the commands for each database by running this in master. Then run the output in master. Just replace UserName with the name in the database. If...

Correct, dropping a login doesn't remove the user from the database. You need to go through each database and find all the orphaned users and drop them at the database...

Brad is normally very good, but I think he got this one back to front. CHECKSUM checks every bit on the page and creates the checksum, written to the page...

Personally since they broke it, I'd get the vendor in and tell them to fix it.

I'm also trying to work out how they managed to double up your data. Tables...

sanketahir1985 (5/20/2010)

---

Hi frndz

2010-05-20 14:57:42.770 spid6s SPID: 189 ECID: 0 Statement Type: TRUNCATE TABLE Line #: 240

.....

.....

2010-05-20 14:57:42.770 spid6s ...

If all you want is for them to see the meta-data, but not make changes...

Create a SQL Job that will cycle the error log on a regular basis. I typically recommend once a week, but you would need to see what gives you a...

Leo.Miller (5/19/2010)

---

You can use this as a base

select 'EXEC sp_addrolemember ' +char(39) + db_name() + char(39)

+ ', ' + char(39) + name + char(39) from sys.sysusers

where uid > 4...

You can use this as a base

select 'EXEC sp_addrolemember ' +char(39) + db_name() + char(39)

+ ', ' + char(39) + name + char(39) from sys.sysusers

where uid > 4 and...

True, but it is good to have something to baseline against, that's why it's...

I agree with the others EXCEPT...

If you have created indexes that closely match those recommended in the DMVs SQL will clear the matching indexe information from the vews.

Leo

Striving to provide...

Another reason to find what caused the log file to blow out to 50GB is that if it happens again it will mess up your log shipping. It's reasonable to...

What do you mean by the above?

You could just export the data to a file and then import it.

I've recently had to do this for...