SQL Server needs to have all the drives which it would be using included under resource depenedencies. Can you verify the dependencies are still in place. Also verify that the...

Below are some of the responsibility

Full/Tran Backups

Space Requirement

Fragmentation

Security Audit

We have scripts which generate reports for all the above duties. We check backups and space reqt. daily, fragmentation weekly, and audit...

Can you post the output of

select user_name(memberuid) as username ,user_name(groupuid) as group_name from sysmembers

select object_name(id),case action  when 26  then 'REFERENCES'

when 178 then 'CREATE FUNCTION'

when 193 then 'SELECT'

when 195 then 'INSERT'

when 196 then 'DELETE'

when 197 then 'UPDATE'

when 198 then 'CREATE TABLE'

when 203 then 'CREATE...

we run Mcafee on our Clusters but we have the following exclusions.

.mdf

.ldf

.bak

c:\winnt\cluster

The reason why anti-virus software is not recommended on SQL servers is if you have a big data/log file and...

Greg,

Not sure about the time but try to break your transaction into smaller chunks. If your transaction gets killed in between for any reason, you don't end up rolling back...

Don't forget to include members of the fixed database roles i.e. db_datareader, db_datawriter etc.

By default, bcp picks up the default instance of the local server. For clusters, you have to specify the virtual server name and the instance name(if applicable)

Kevin,

you can try using suser_sname or suser_name for SQL 7.0 to capture the user who is running that session.

There was a bug post sp3 that if you try running your job under a windows account, it will fail even if you have access. I remember running into this....

The above suggesstion is probably the best solution. below is a small explaination.

The transaction log is divided into virtual log files. When you truncate  a log the virtual log files...

You need to shut down the trace and close it before viewing.

exec sp_trace_setstatus 2,0

exec sp_trace_setstatus 2,2

Can you just write a small vbscript and verify that there is nothing wrong in the connection string which you have mentioned. Try also logging into the server through query ...

FYI -

Below is the definition for DBCC UPDATEUSAGE from books online.

Reports and corrects inaccuracies in the sysindexes table, which may result in incorrect space usage reports by the sp_spaceused...

Check this out.

http://support.microsoft.com/default.aspx?scid=kb;en-us;286134