Viewing 15 posts - 1,846 through 1,860 (of 6,216 total)
Hey Jim,
I've done a little more testing and still don't see the problem, let's see what other readers can come up with - article about it will run on Wed!
http://www.sqlservercentral.com/columnists/awarren/lotsoftablesandalittledmo.asp
Andy
July 27, 2003 at 9:05 am
The error is only because single user mode cant be set, not because anything is wrong with the db. In 3 years I've seen one error on a DBCC. My...
July 25, 2003 at 5:51 pm
Hard to say what is common. 2000 seems like a lot, but you should build what you need. Are you granting permissions to the user, or do you have them...
July 25, 2003 at 5:48 pm
No problem. If you'll drop an email to bknight@sqlservercentral.com, he can put you in contact with some people at Pass that can help get the word out, and arrange to...
July 25, 2003 at 5:46 pm
No way to establish a temporary connection over a VPN? You can export to COM files, copy them to the other server that way. Or even export as VB code...
July 25, 2003 at 1:18 pm
You have to dig a little. For example, there is a dboption object that roughly corresponds so the sp_dboption proc. For file growth, you have to dig down through filesgroups...
July 25, 2003 at 10:28 am
I'd guess corrupted stats, or maybe you just had bad query plans in memory. If it happens again, those two are easy enough to investigate.
Andy
July 25, 2003 at 6:06 am
That will happen if anything/anyone is holding a connection. Could be a user session left open, replication log reader, anything. Only way to guarantee is to run a job to...
July 25, 2003 at 6:05 am
Its been a while since I upgraded, but I dont remember any commands that work differently. It's a pretty painless upgrade. Only thing you need to do is run sp_updatestats...
July 25, 2003 at 6:02 am
I think what it says is that you shouldnt check the repair problems option. No reason not to run DBCC anytime, it doesn't require single user mode unless you're fixing...
July 24, 2003 at 6:00 pm
It does run MDAC, but I dont know if it overwrites a newer MDAC - would be surprised if it did. Sorry, I know that's not quite an answer.
Andy
July 24, 2003 at 5:55 pm
Could you post what you're running? I can try to repro it here.
Andy
July 24, 2003 at 5:54 pm
Shouldnt be replication. Make the network dudes work!
Andy
July 24, 2003 at 5:52 pm
That will work as long as you make it the primarykey. I know they aren't easy to read, but uniqueidentifiers are great for merge replication. They also don't meet your...
July 24, 2003 at 5:51 pm
Easiest way is to just reinitialize the publication and send over a new snapshot. You want it to fail on error or not?
Andy
July 24, 2003 at 5:49 pm
Viewing 15 posts - 1,846 through 1,860 (of 6,216 total)