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

The package is a binary object. It is stored as such. If you want the package documented internally, add an Active X task, and type in the documentation as a...

You can use DATEDIFF to calculate time intervals. Look it up in BOL for the parameters for minutes and ordering of the dates.

You could use an insert select() where your...

May work differently in SQL Server 2005. Sorry, in the middle of a workstation switch and ss2k5 isnt set up yet

You might be...

How are you doing the restore? Through EM or isql/osql or QA? EM opens multiple connections. The QA Object Browser opens a separate connection.

Not the max . Might be less for some editions, but the max is the max for all versions.