Viewing 15 posts - 2,701 through 2,715 (of 6,216 total)
I dont run 24x7, but I use a technique that might help. Rather than change the code, I create a new proc. See this article for more:
http://www.sqlservercentral.com/columnists/awarren/versioncontrolforstoredprocedures.asp
Basically this puts the...
January 10, 2003 at 5:01 pm
When it happens, what do you have listed in sysservers? Can you pinpoint what happened prior to the problem beginning? Why is it tied to replication?
Andy
January 10, 2003 at 4:52 pm
You have to back up each one individually - just cursor through the list. Why wouldnt the maint plan work? Probalby have some scdripts in the scdript library that...
January 10, 2003 at 1:00 pm
Dont know. I wouldnt think so. Figure its easier to evalulate the function each time than to keep track of whether you've already evaluated. If done each time, they could...
January 10, 2003 at 12:14 pm
Easiest way is to build a maintenance plan. If you want to do it yourself you can just do a select against sysdatabases (or some other table with the db...
January 10, 2003 at 11:28 am
Maybe? If both db's are owned by same owner, you could create a view to your data in the main db, give the roles access to it.
Andy
January 10, 2003 at 10:58 am
I'd look hard for a way around this, I count this along with having different objects as featurs they could drop anytime. I typically use a view to restrict which...
January 10, 2003 at 8:52 am
If you search for blob, you'll get tons of opinions, probably 90% in favor of keeping in the file system. I like putting them in the db so that I...
January 10, 2003 at 8:50 am
It does add a guid and also restricts row length to 6k or so. Transactional is simple and fairly low impact. If you're running 20 log readers at once you'll...
January 10, 2003 at 8:45 am
What does the agent say? Im not a merge guy, so closest I can offer off the top of my head is from transactional land - if the agent goes...
January 10, 2003 at 8:40 am
You don't free up resources not being used. On a personal or low intensity dev machine with lesser resources, it might make sense to enable. In production never makes sense,...
January 9, 2003 at 5:01 pm
No reason you can't do a for/each loop to check to see which tables are already in the pub.
Andy
January 9, 2003 at 5:00 pm
Your log may also increase in size since you're doing it in a single transaction. For something that lot, better to run in chunks that complete in a reasonable amount...
January 9, 2003 at 11:27 am
January 9, 2003 at 11:01 am
January 9, 2003 at 10:59 am
Viewing 15 posts - 2,701 through 2,715 (of 6,216 total)