Viewing 15 posts - 34,471 through 34,485 (of 39,726 total)
I'd agree about using roles. This is exactly why you do it. Take a few minutes and move the permissions to a role and then ad your new user.
October 18, 2004 at 7:13 am
You can use this to try and shrink the log
http://www.sqlservercentral.com/scripts/contributions/26.asp
October 18, 2004 at 7:12 am
You can move these selects to the FROM clause.
select a, b, c, d
from main, (select c, d, from mytable) b
October 18, 2004 at 7:11 am
It seems the IE pastes them in as highlights, but Firefox does not. I'll see if we can do something in the forum code for this.
October 14, 2004 at 10:35 am
Yes, sigs need to be manually done, but this is a cut and paste:
http://www.sqlservercentral.com/columnists/sjones/
October 14, 2004 at 10:34 am
Haven't seen this. Course, I haven't restored a v7 db in quite some time.
Are you restoring through the GUI or with T-sQL? I might try TSQL to see if any...
October 14, 2004 at 10:32 am
Wow, offhand, I'm not sure what to do here. Since some items are not in ", I'm not sure the above will work.
I think I'd write some VBScript or small...
October 14, 2004 at 10:31 am
Or "fix" the existing user in the prod database with the test login by using SP_CHANGE_USERS_LOGIN.
October 14, 2004 at 10:29 am
You can also look at SET STATISTICS IO ON and see the reads and writes that are required.
October 14, 2004 at 10:28 am
What about a delay between the start of execution? Or call 1 proc and have it fire the other 2?
October 14, 2004 at 10:26 am
I think Profiler is the best way if you suspect a problem. If you are trying to troubleshoot, get the user to open another connection and see what comes through....
October 14, 2004 at 10:25 am
This is an incredibly broad question. I think you should read the articles on this site as well as keep an eye on the active posts in this forum to...
October 14, 2004 at 10:24 am
Apologies for the mistake. And yes, these things get through QA sometimes. I didn't catch the different table names because I cut and paste the query into QA, create the...
October 14, 2004 at 10:09 am
There isn't a good way. You can run sp_who2 on each system every 5 minutes and get a high water mark for connections. That would tell you the per server...
October 13, 2004 at 11:34 am
Viewing 15 posts - 34,471 through 34,485 (of 39,726 total)