Viewing 15 posts - 1,471 through 1,485 (of 1,790 total)
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
June 3, 2003 at 3:18 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 15, 2003 at 8:04 am
"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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 15, 2003 at 7:54 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 9, 2003 at 8:20 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 8, 2003 at 1:33 pm
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
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 8, 2003 at 1:29 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2003 at 10:13 am
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
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 28, 2003 at 9:26 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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 25, 2003 at 10:52 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 25, 2003 at 8:14 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 25, 2003 at 7:55 am
Check out this article.
http://www.sqlservercentral.com/columnists/awarren/introductiontoadothecommandobject.asp
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 23, 2003 at 2:10 pm
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....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 23, 2003 at 8:59 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 23, 2003 at 8:56 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 23, 2003 at 8:50 am
Viewing 15 posts - 1,471 through 1,485 (of 1,790 total)