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...

If you have a current backup of msdb you can try this:

Restore the backup under a different name - Mymsdb

stop the sql server and Agent services

rename the msdb files so...

The default trace is limited to 20MB, but the last 5 trace files are kept. Hopefully there...

If your application fails because of a SQL Error you need to fix the app. There should be (almost) no unhandled errors within the app, related to its SQL interaction,...

You should know at least enough to install and configure these so they work, even on a cluster environmnet. Then you should be able to do basic things like export,...

It also depends on what the users are doing. Is it possible for them to use SQL Express? It's free!

If it's just an app connecting to a database and...