Viewing 15 posts - 646 through 660 (of 1,583 total)
Why the log reader agent?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 8, 2013 at 8:30 pm
I am wondering even stopping the distribution job some batch of transactions was still in progress can cause this or not .
This was my original thought. Perhaps we...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 8, 2013 at 2:10 pm
Could you not turn this into a stored-procedure and pass in the parameters using SSIS's "?" flag for parameters? I believe the syntax is EXECUTE dbo.MyProc ?, ?, ?...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 8, 2013 at 2:02 pm
I use Idera SQL Safe for our company's backup solution, if you are looking for a solution with multiple servers they will really work with you on the price/server (comparable...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 8, 2013 at 1:59 pm
To answer your questions:
1. No
2. No
3. It appears to be the same table(s). We were going to try and drop the articles and add them back in to see...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 8, 2013 at 1:54 pm
Thanks Lynn, yes I was aware of this occurring when you do it via SSMS but I was more curious as to why the same thing doesn't happen when you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 4, 2013 at 8:37 pm
Query the distribution database:SELECT article FROM distribution.dbo.msarticles WHERE publication_id = X order by article_id
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 4, 2013 at 8:24 pm
This is interesting - When you alter a column i.e.(increase the size) in SSMS using the GUI in it creates a temp table, locks the temp table, inserts all the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
June 4, 2013 at 7:16 am
I forgot to mention: on the production server, transactional replication and log shipping is set up (which is not running on the other DB were I was successful running the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 30, 2013 at 9:02 pm
At our shop the versions where this error randomly occurs are:
ProductVersionEditionProductLevel
10.0.4000.0 Enterprise Edition (64-bit)SP2
ProductVersionEditionProductLevel
10.0.5500.0 Enterprise Edition (64-bit)SP3
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 15, 2013 at 10:14 am
If you see my prior post, it won't allow you to uninstall and reinstall the framework unless you completely remove SQL Server and it's components...so i didn't go that route....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 14, 2013 at 2:38 pm
Nothing seems to work other than a complete reboot of the server (unfortunately), and it returns randomly...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 14, 2013 at 2:22 pm
Are you able to print the results of the print here?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 24, 2013 at 10:12 am
Instead of EXEC (@SQL) , please DO a PRINT and then post the results so we can see the output
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 24, 2013 at 9:07 am
Is ServerA and ServerB that actual names of the servers?
Linked servers cannot be referenced with special characters in them unless they are enclosed in [brackets] - Ex: SELECT * FROM...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 24, 2013 at 7:47 am
Viewing 15 posts - 646 through 660 (of 1,583 total)