Viewing 15 posts - 33,811 through 33,825 (of 39,804 total)
Does netstat -a show the port as open?
August 15, 2005 at 9:33 am
DMO could do it, but you have a rights issue. What I'd do is create a good process the sysadmin can use. Then setup a job to restore the db...
August 15, 2005 at 9:32 am
No script and I've never really felt the need to use them. Don't see them as that useful and changes occur way more often than I see benefits.
August 15, 2005 at 9:31 am
That might be an EM thing. Processadmin should have rights to kill processes, according to BOL. Have you tried using KILL through QA?
August 15, 2005 at 9:30 am
There isn't a good way. You could centralize the scripts and just have the DBA or admin run the scripts as DBO, which removes the rights issue, but adds work...
August 15, 2005 at 9:28 am
None I know of. How many databases are you talking about? Seems like even at 100 it would be easy by hand.
The other issue is what if you have two...
August 15, 2005 at 9:25 am
The backup process is extremely intolerant of any delays in writing data out. That means that if there is a hiccup in the network or a delay in getting packets...
August 12, 2005 at 3:49 pm
There is a limited go live license, but you need to apply with Microsoft and be accepted or you will not get support and they will consider your installation unlicensed.
August 12, 2005 at 3:47 pm
It comes in the newsletter everyday
August 12, 2005 at 10:44 am
If you were not aware of the code, you can contact PASS and let them know you pinged us here. I'll confirm emails that have been sent to me or...
August 10, 2005 at 11:02 pm
A SQL Server is a SQL Server instance. Having multiple instances means that you have multiple SQL Servers running on one Windows servers.
The answers state: each database has it's own...
August 9, 2005 at 8:29 am
Not mention anything!!?!!?
It's been in a few editorials and a few ads. Register with the source code of "SSC".
August 8, 2005 at 9:00 am
Viewing 15 posts - 33,811 through 33,825 (of 39,804 total)