Viewing 15 posts - 3,886 through 3,900 (of 6,216 total)
For what its worth, MS recommends using sp_revokedbaccess instead of sp_dropuser, though if you check the code, sp_dropuser just calls sp_revokedbaccess!
Andy
July 4, 2002 at 5:11 am
Dont know that these will help, but I'll ask anyway?
1) Table is indexed, you've checked the query plan to see that it makes sense?
2) Updated statistics?
3) Double checked what any...
July 4, 2002 at 5:09 am
A lot of times it will be you - if you open QA to that db or click on the db in EM, you'll have a connection.
Andy
July 3, 2002 at 3:39 pm
I've seen that a couple times, at the time I suspected it had to do with index changes being made, but didnt definitely corrolate the two.
Andy
July 3, 2002 at 3:37 pm
SQL does use checksums for comparing replicated tables, probably makes sense less data to move across the link. Agree with Steve that you'd have to test to see. Might also...
July 3, 2002 at 12:47 pm
Not that I know of. What is the exact error message?
Andy
July 3, 2002 at 12:44 pm
I think some of that is left over from the 6.5 days. You can just issue an alter and the rest will happen, EM scripts out all the stuff the...
July 3, 2002 at 12:43 pm
I had the user try it orignally and it didnt work. I'll try to test again to see.
Andy
July 3, 2002 at 10:10 am
Nope. I'll try to experiment a little when I have time.
Andy
July 3, 2002 at 10:08 am
July 3, 2002 at 7:44 am
I think DTS is the exception - everything else should run on the server. EM does tend to "hang up" on some of these operations, I think only because its...
July 3, 2002 at 7:43 am
But the linked server does show up? Logins are stored in sysxlogins in master. Look for the ones that have a serverid >0 - that value should correspond to the...
July 2, 2002 at 5:51 pm
I agree that an indexed computed column is a good idea. Even without it though the key is to try to do a set operation instead of a cursor operation....
July 2, 2002 at 5:44 pm
July 2, 2002 at 8:04 am
Dont know if I can present one yet. I'll see if I can find something where they outline their reasons. I kinda use hungarian, mostly for controls on VB forms....
July 2, 2002 at 8:03 am
Viewing 15 posts - 3,886 through 3,900 (of 6,216 total)