Just a quick comment on this - removing data, especially characters like '-' and ' ', can leads to incorrect results. For example, 3 different companies:

'SuperTech'

'Super-Tech'

'Super Tech'

All become:

'SuperTech'

Just a thought....

As mentioned above, assumming sufficient space locally, local may be preferable, as long as you ensure that you are moving this elsewhere afters, i.e. your off-site storage site, which I...

Found the following links in reference:

http://support.microsoft.com/default.aspx/kb/885290?

http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.server/2004-07/3596.html

See if these help ...

One is ponder the potential to create a central server that control an environemnt, eg dev/test, that could use such commands to shut down server's, etc.

Not sure if it would...

Look at your server event viewer, check out your application logs.

Look at your SQL server logs - look for unexpected termination, etc.

Do you have scheduled maintenance jobs doing DBCC CHECKDB,...

NOTE - that is for spids effectively - I am hoping you can use if to find you jobs

SC ? Is that a SBS server comand, or SQL - I'm kinda interested as well ....

Would this help you at all ... I wrote it quite a while ago - I comment better now... will revisit at some time and update, but it should work,...

Thanks Nicholas!

Thanks for the responses.

Does anyone have any idea why it might be happening, though? I kinda HATE having things I can't explain, happening on server's I have a...

Found it!!!

*sigh* - a blonde moment!

Just before I add the filters, I exec:

exec sp_trace_setstatus @TraceId,1

In other words, I start the trace, hence I cannot apply filters. And because I...

found my folly - a typo, as usual!

a17062004perAGT04 versus

a17062004perGAT04

oh well, off to more fun

vbenus,

Local on the box? sounds vaguely familiar. On the server, open up Client Network Utility (from the MS SQL Server grouping on Menu).

Look and see whether the "Enable Shared Memory...

If you can (a) run a backup, (b) free up space on the log drive <assuming your DB has autogrowth for log's - which it should>, then you can do...

OK ... it worked !!!!

KIDS - do not try this at home, and NOWHERE near your prod boxes (or as in our case, your busy-implementing, soon-to-be, prod...