Viewing 15 posts - 2,146 through 2,160 (of 6,216 total)
May 9, 2003 at 8:51 am
May 9, 2003 at 7:56 am
If after reaching that point you BCP out/in, then try to modify, do you get the error then?
Andy
May 9, 2003 at 7:54 am
To some degree it will, depends on how you replicate the transactions. If you replicate the stored proc call, one big transaction is one big transaction. If you're replicating the...
May 8, 2003 at 11:16 am
Havent seen that before. Just a guess, maybe an instance where someone renamed the proc in Enterprise Manager?
Andy
May 8, 2003 at 9:31 am
DMO will detect any server on the network (within the subnet I think) that advertises it's existence.
Andy
May 8, 2003 at 4:38 am
I've seen similar stuff - I think the MSI's guid's get mixed somehow and it's downhill from there. I've worked through it before, but not with any kind of reproduceable...
May 7, 2003 at 4:30 pm
Depending on how/where you build your connection string, add some additional information to it so you can easily identify the spid. Add the IP address to the hostname or tweak...
May 7, 2003 at 5:19 am
Readers, this looks interesting - so let's make it interesting! I've got a copy of a book on ADO.Net or MDX for the person with the 'best' response that works!...
May 6, 2003 at 2:58 pm
No issues with transactions issued once all subscriptions are dropped. My point is still that you're doing a LOT more work than you need to just because a pub got...
May 6, 2003 at 2:55 pm
It's only an issue with SQL logins, NT logins don't have the problem. If you're backing up from one system and restoring to another, save yourself a lot of headache...
May 6, 2003 at 2:53 pm
I don't know that it's as simple as just changing it to simple mode. I run on average about 200 db's, all fully logged. On any given day maybe 25%...
May 6, 2003 at 5:56 am
Transactions will only be held in the log if there is one or more active subscriptions to a publication. Transactions only stay in the log until the log reader processes...
May 5, 2003 at 6:16 pm
Dave, I agree that leaving space tied up may not be a good thing, but wouldn't you consider it better to either do after hours or at a time when...
May 5, 2003 at 4:32 pm
You might want to visit a web development centric site, get their input on this. In general we use a sql login with the minimum access needed for all our...
May 5, 2003 at 4:31 pm
Viewing 15 posts - 2,146 through 2,160 (of 6,216 total)