Viewing 15 posts - 76 through 90 (of 315 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 315 total)