Well, different approaches for different folks. I actually like this approach. Talk hard and weed out anyone not really interested. Even if the environment is hard like they say (and...

SQL Server service and agent account service should be running under the same account as you have for the email account. Once that is set, logon to the server under...

"Printers - Who cares? If you do on your SQL box, take your hand, put it in front of you palm up and smack yourself on the forehead. Don't put...

There are none that I know of. We developed a Word document that included information about each of the steps, inputs to the package (i.e. files), outputs from, etc. that...

I looked at this for a while and I don't believe that MS provided that functionality with the xp_sendmail functionality. If you find out different I would love to hear...

Shawn,

Check out the following MS Articles and see if they help. Let the site know with a reply.

240853

238637

Hope this helps.

David

I would actually connect to the server or go to the console and run Task Manager and see which process is using all the CPU. It sounds like the results...

Ignore my reply, I thought you were referring to transaction logs.

David

Edited by - DavidB on 04/28/2003 09:27:17 AM

Edited by - DavidB on 04/28/2003 09:27:31 AM

You can use a command line to run a DTS package. The best way that I have found to run a DTS package on an as needed basis is to...

You could accomplish the owner change through DTS, a job, ADO command from your app, etc.

The stored proc you will want to execute is sp_changeobjectowner. Look in SQL Server...

I usually try to stay away from topics like this but..... Not enough intelligence. Must be a DBA (and I am)!

Just some quick thoughts. I agree that management makes a...

Check out this article.

http://www.sqlservercentral.com/columnists/awarren/introductiontoadothecommandobject.asp

David

Can't speak to the view through EM but, to get the formula I would GUESS that you could script out the table and see the computation associated with that column....

First, I would recommend you take a backup of the Database and the Transaction Log. Then, you should be able to run dbcc shrinkdatabase ('YourDB', Target%) and shrink the database...

If you can run sp_who2 and sp_lock, I would start there. When you run sp_who2 look at the BlkBy column to see what process is blocking the others. Check that...