We've used Litespeed here for years, though now moved to Red Gate's SQLBackup for obvious reasons.

Litespeed works well. A little pricey, so compare the value with other tools (SQL Backup,...

Your jobs run under the SQL Server Agent service account. This account needs to log into SQL Server and likely did so because it got login rights because of membership...

In a clusered environment, you have two different instances (or more) of SQL server running. One is on each clustered node.

The service account is found in Enterprise Manager under...

You can truncate and shrink it, but if there's a process that needs that much space it will grow again. The idea is to size tempdb at it's max, so...

DDL Triggers are SQL Server 2005 only.

In SQL Server 2000 the best solution I've come up with is to log a list of object names and versions from sysobjects and...

The above advice is good and you should be able to use those ideas.

What you want to do is gather as many examples of your addresses that need splitting...

I'm not entirely sure what's wrong, but I'd suggest running a trace when you access the job list in EM and one when your assistant does and compare them. Likely...

Thanks for the update. I'd really rebuild all indexes and then see. Also let us know.

http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart1.asp

Use PATINDEX or CHARINDEX to find the "". You can then use SUBSTRING to remove the middle piece.

http://www.sqlservercentral.com/columnists/sjones/tamestrings1.asp

http://www.sqlservercentral.com/columnists/sjones/20010424135929_1.asp

Mike,

good luck and hope it's not too late a night for you.

You need a trigger to record the time and then a field or table to store the data in.

http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart2.asp

Don't do this in a trigger. It's a bad use of triggers and can pause or hang the db. Use a trigger to log the event in a table. Then...

Use a script:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=71

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1162

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1161

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1843

Are you sure that the NDF is just indexes? NDF files are just additional data files, which can store indexes or data.

Since this is for compliance, I'd think about getting...