Viewing 15 posts - 34,996 through 35,010 (of 39,723 total)
Like I said, it depends. They don't need any of those roles necessarily. If I want someone to run imports via DTS from Excel, I can add him as a...
April 9, 2004 at 4:45 pm
depends on how they do it. Could get by with insert and select (maybe update). Sys admin isn't something I'd give out.
April 9, 2004 at 3:51 pm
It can take awhile if it's lots of GB of space. Glad it's fixed for you.
April 9, 2004 at 3:43 pm
I don't think so, but you may email or check Ken Henderson's book.
April 9, 2004 at 10:29 am
Apologies gentleman.
I tested -na and forgot to change my text.![]()
April 9, 2004 at 10:28 am
rename in windows
sp_dropserver <old servername)
sp_addserver <new windows name>, local
April 9, 2004 at 10:17 am
You want to use roles, as mentioned above. Either those mentioned above or make your own.
April 9, 2004 at 10:13 am
Litespeed will do the job for you, encrypts the file. You still have the password management problem. Don't take this too lightly, if you do, it could be your job.
April 9, 2004 at 10:12 am
You can write a script that runs continuously, basically something to read sp_who2 and watch the last batch and the CPU and/or diskio values. If they are growing beyond some...
April 9, 2004 at 10:10 am
If you didn't detach, reattach then I'm not surprised. the entry in the table is static, probably (my guess) changed only when attach detach. The parameter on startup is an...
April 9, 2004 at 10:09 am
SQL Standard or Enterprise? Not that it should matter, just wondering.
I haven't seen this error, but this is one of those areas that is probably worth a call to PSS...
April 9, 2004 at 10:07 am
I don't think they are shipping B1 anymore, not sure if it's in MSDN.
The last rumor I heard was May/June for B2. There was a summit this week for MVPs,...
April 9, 2004 at 9:55 am
DMO could script the proc and then you'd execute this on the target server. Or select the source code from syscomments and execute on the target server. Be wary of...
April 8, 2004 at 5:25 pm
Viewing 15 posts - 34,996 through 35,010 (of 39,723 total)