Viewing 15 posts - 33,256 through 33,270 (of 39,810 total)
Why would you do this? It is a bad idea and there's real reason to do it. Each time the trigger ran it would create a new table, which...
March 29, 2006 at 9:37 am
off the cuff:
set rowcount 1
select @i = col1, @j-2 = col2, @k = col3
from mytable
where intcol is null
if exists( select intcol from mytable
...
March 29, 2006 at 9:36 am
I think if you set a role in msdb for them and grant execute on sp_startjob, they can do it.
Alternatively, create a job that queries a table (some new one)...
March 29, 2006 at 9:33 am
I agree with Yelena. You're playing with fire here.
March 29, 2006 at 9:32 am
Don't say horse. Got enough horses, too many horses, shoveling too much as it is.
March 29, 2006 at 9:02 am
I didn't see a great map when searching on Google.
Plus I liked this one ![]()
March 29, 2006 at 9:01 am
Not sure I agree we'll fail in the US. We might not employ the most IT people as I can see China or India giving us competition there, but high...
March 28, 2006 at 8:55 am
Is this a generic program or specifically for your databases? If specific, figure out the hierarchy and load it from an xml/ini file.
If generic, license the depends code from Red...
March 28, 2006 at 8:51 am
Write the stored proc. You'll do it once and it will work. Even if you need to write 50 procs, it's small compared to the issues you might face with...
March 28, 2006 at 8:49 am
Search sp_helprevlogin on Technet and use that to move the logins you need to the new server.
March 28, 2006 at 8:47 am
I'm not sure I understand. Is this what happens?
1. Start server in single user mode
2. connect and run proc.
3. Another user attempts to connect and gets the errir
4. You think...
March 28, 2006 at 8:46 am
Based on BOL, you DO NOT set working set size when SQL is dynamically managing memory. BOL doesn't seem to detail much on this, but this (http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx) says to set...
March 28, 2006 at 7:56 am
If you client alias, be sure you specify a server port setting and not use dynamic ports.
I know you said the port was open, be sure it's open on the...
March 28, 2006 at 7:47 am
John has the right idea. I'd guess security or an invalid path. The SQL or Windows error log should show this.
March 28, 2006 at 7:47 am
Gordon,
There could be good reasons to limit your access. Not that I'd like it either, but you should work within your limits. If you need a test restore, then note...
March 28, 2006 at 7:42 am
Viewing 15 posts - 33,256 through 33,270 (of 39,810 total)