Viewing 15 posts - 1,261 through 1,275 (of 1,583 total)
Through the GUI, the TSQL is:
EXEC sys.sp_configure N'remote proc trans', N'1'
GO
RECONFIGURE WITH OVERRIDE
GO
I noticed "WITH OVERRIDE"...
I guess I don't fully understand the difference between the two and why it would...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 19, 2011 at 11:32 am
David, your first link helped. In reference to a post in the blog:
EXEC sp_configure 'remote proc trans', '0';
RECONFIGURE;
While I don't understand the difference between running the above script...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 19, 2011 at 11:28 am
I thought it would be helpful to point these few things out:
- The distribution database exists on another server
- The server I'm creating the publication on is set up as...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 19, 2011 at 9:13 am
Has anyone any additional advice on this?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 19, 2011 at 8:20 am
Appreciate it Dev, but I've tried that already. In fact, I've completely disabled Distribution/Publication on the server, dropped all subscriptions and started over from scratch...I still get the same...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 17, 2011 at 8:55 am
1. Can you post your Cmd code?
2. Does it work properly when you run it via a command window?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 15, 2011 at 1:21 pm
Not sure if you resolved this issue or not, but I had the same issue on only one server in our company, it was resolved by the advice offered on...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 12, 2011 at 1:23 pm
Wow, I can't believe took over 30 mins going through google (NOTHING came up on any microsoft sites..) but finally found this - in case anyone is interested:
http://www.sqllion.com/2011/11/job-running-status-report-in-ssrs/
0 - Completed...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 9, 2011 at 1:30 pm
Another note to aid in what has been already offered above...when thinking about running reports off the standby db's (logshipped) you need to remember that you cannot create indexes there....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 9, 2011 at 10:31 am
Difficult to tell with out a StartTime reference as well but those are some seriously long durations. Looks to me that a LOT of SSIS jobs are running between...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 8, 2011 at 3:13 pm
Did you find anything?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 8, 2011 at 1:55 pm
This is a 2008 forum...so you should post things like this to http://www.sqlservercentral.com/Forums/Group406.aspx
When you create the table, make sure you have:
USE YOURDB
GO
Depending on how you opened the query window, by...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 8, 2011 at 11:07 am
how can i change the default location and get management studio to see the F: drive?
Thought it won't help your see local storage, If you are usintg SQL 2008...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 8, 2011 at 10:29 am
Have you checked your SQL Logs? Have you checked the default trace file (should be in the log folder of your default SQL installation folder) to see if there's...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 8, 2011 at 9:15 am
I have verified that the files were differential backups. I understand it seems very odd, however, these were all generated from a standard maintenance plan...bizzarre!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 6, 2011 at 2:26 pm
Viewing 15 posts - 1,261 through 1,275 (of 1,583 total)