What is the util? I found a couple on sqlsecurity.com but they were for SQL Server 7. I didn't really find anything too helpful for 2000.

I am planning to...

I like Visio as well. I tried using the diagram functionality in SQL Server and it just was clunky and not flexible enough. Visio hooks up to the database and...

I agree this is a good fact to be aware of - I didn't know of it. May save me some time one day!

I saw the title and thought...

When you make a stored procedure with a cursor to kill each connection, do you pass a parameter to the kill command?

I recently tried to do something similar but...

The trace is set for trace file rollover.

After a restart or a manual closing of the trace, if the file name in the stored procedure is already existing then...

Also, in Windows Explorer the .trc file that the trace is writing to shows that the size is 0 until the trace is closed. It even shows size 0 when...

Thanks! I made a stored procedure out of the trace create files and used sp_procoption to configure it to execute at startup.

Do you know if the the .trc file the...

Thanks for bringing up the subject. Our team uses mixed mode. We have a web application written in Cold Fusion. We have to use SQL logins for Cold Fusion to...

I didn't log to a text file but I did try to run the T-SQL statement I got from the SQL Server Agent job history in Query Analyzer.

It showed that...

My team has SQL Server 2000 SP2 on NT. I recently set up maintenance plans for two databases. The SQL Server Agent job history shows the DB backups failed, but...

Try the Data Warehousing forum/DTS subject. There is a post called "DTS works but schedule job don't" This has lot of replies from people having the same problem : DTS...

We discussed VPN or PC anywhere with the hosting facility and they said they didn't have VPN software. PC Anywhere might be a possiblity but they admitted they are not...

Well, we solved our problem. We can't believe it was something this simple, but the agent starting running the DTS jobs fine after we rebooted after applying SQL...

Nelson,

My team is having the same issue as you.

We have DTS packages scheduled through Agent. They will run through EM or dtsrun.exe but will not run when scheduled with...