Viewing 15 posts - 35,986 through 36,000 (of 39,903 total)
Patrol can do this, but I'm not sure you really want this in "one console". Sounds good, doesn't work. You need to be able to distribute work from multiple consoles....
September 24, 2003 at 10:12 am
Why use a temp table? Could you not use a perm table? What does the sproc do?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 24, 2003 at 10:11 am
Backup and restore is the best way. If it's a template db, this is easy to script in T-SQL.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 24, 2003 at 10:09 am
maybe add a cscript to the front of the call? Might have a pathing issue.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 24, 2003 at 10:08 am
no way I know of. You'd have to handle this at the client for now. Yukon (next version of SQL) will introduce Try..Catch, which will help with this. Error Handling...
September 24, 2003 at 10:05 am
only by "shelling" out with xm_cmdshell or by interfacing with it as a COM object with sp_oacreate.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 24, 2003 at 10:01 am
Security is incredible hard and encryption has lots of downfalls. Having a scheme to do it is only a small part of the issue. Managing the keys is the hard...
September 24, 2003 at 9:59 am
no choice. Only sysadmins can run sp_oacreate.
What are you wanting to allow them to do?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 24, 2003 at 9:54 am
We use BMC's Patrol here. Kind of expensive, but monitors all Perf Mon counters and can take actions on threshholds.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 24, 2003 at 9:52 am
reboot the server or kill them on the linked server side.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 24, 2003 at 9:51 am
The book is softback, perfect bound, glued, so if you have any of these books, you'll have an idea of what it's like
SQL Server Security Distilled (ISBN 9781904347071)
Brian Knight's...
September 24, 2003 at 9:49 am
http://www.sqlservercentral.com/scripts/contributions/26.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 23, 2003 at 5:54 pm
Which version of SQL is this?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 23, 2003 at 10:47 am
I suspect that some of the pointers are potentially out of whack. Can you drop and rebuild this index and then try to run the dbcc. That has worked in...
September 23, 2003 at 10:35 am
That is the easiest way. What doesn't work with this?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 23, 2003 at 10:31 am
Viewing 15 posts - 35,986 through 36,000 (of 39,903 total)