Viewing 15 posts - 76 through 90 (of 314 total)
I normally write in SQL and execute in QA and save the script based on the date. This helps me to look back what happend earlier kinda scenarios. But if...
September 10, 2003 at 9:24 am
Great Idea. My 2 cents for $15.
September 9, 2003 at 5:31 pm
Thank You Brian. I remote logged into Server. I saw the processes using Task Manager--> Processes & killed scm.exe.
I was not sure to kill this like this earlier.
Thanks Again.
...
September 9, 2003 at 1:25 pm
Allen:
My command xp_cmdshell 'scm.exe \\NCCHASQL01 query SQLSERVERAGENT' is still active on the server in RUNNABALE state with KILLED/ROLLBACK in the command.
I tried to kill the process... But nothing is happening...
PLEASE...
September 9, 2003 at 1:01 pm
Antares686 & Brian: Can we find it thru ERRORLOG file??
hgranja:What is your SQL Server Version?
September 9, 2003 at 12:50 pm
This is a duplicate post... See in http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=16087
September 9, 2003 at 12:50 pm
You might want to check ERRORLOG file in \\Microsoft SQL Server\MSSQL\LOG\ directory. Or if they have restarted the database server you might want to look into ERRORLOG.1 thru ERRORLOG.9.
What...
September 9, 2003 at 12:44 pm
Couple of months back, when we increased disk space on our production server, we increased by 2*72 gig with RAID1 (with mirroring) as a separate array apart from our existing...
September 9, 2003 at 12:02 pm
I couldn't find sc.exe on the server. I have executed the following command from QA:
xp_cmdshell 'scm.exe \\NCCHASQL01 query SQLSERVERAGENT'
It never completed. after 10 minutes, I stopped the query from QA....
September 9, 2003 at 10:10 am
Allen,
Is it scm.exe or sc.exe??
September 9, 2003 at 9:40 am
You select "SAVE AS" option after opening the DTS package. Choose "Structured Storage File" in "Location". Give the path and File Name you would like to save to. Then copy...
September 9, 2003 at 6:59 am
The institution I am mentioning is in Chennai. But I understood that he is travelling to & from Chennai and Bangalore. Not sure of any other cities. But they are...
September 9, 2003 at 6:46 am
Which city are you in? We have recently organised a session for our junior DBAs using Video Conferance from India to USA. This instructor is too good with realtime exp...
September 8, 2003 at 1:32 pm
I did this installation for evaluation purposes on my laptop. Didn't have any issues on this so far.
September 8, 2003 at 9:43 am
You would be using the newly registered Extended Stored Procedure (xp_smtp_sendmail)for notifications.
September 4, 2003 at 9:42 am
Viewing 15 posts - 76 through 90 (of 314 total)