Hi! I was trying to execute a server side trace but It just doesn't create the trace file.

I followed this tutorial:

http://www.mssqltips.com/tip.asp?tip=1035

I get no error but the physical file...

Thanks for the answer. I'm afraid that It could kill the server for long and it's a production server. I wouldn't like to knock down the entire system for 2...

GilaMonster,Steve Jones,SQLBOT,Grant Fritchey: Thanks a LOT!

Now I understood my mistake. I'll fix my script with your suggestions

Thanks you all for your answers! My script will be executes on MANY servers and I think a couple of them are sql server 2000 so Try Catch is not...

Thanks Grant Fritchey!

So the only way to be 100% sure that no data will be corrupted because an error during the execution of a script is A GOOD BACKUP...