March 4, 2009 at 2:27 pm
What do you get from SELECT @@servername;
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 4, 2009 at 2:36 pm
The correct computer name \ instance name. This is different than what I'm seeing in the Maintenance Plan >> Manage Connections >> Local Area Connection. The server names are different. This is crazy, lol.
March 4, 2009 at 2:47 pm
Okay - try the following:
SELECT * FROM msdb.dbo.sysjobservers;
Edit: fixed type from sysservers to sysjobservers.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 4, 2009 at 2:52 pm
Another thing you do is to look in cliconfg to see what aliases are there.
March 4, 2009 at 2:53 pm
And, while you are at it - check the value of 'orginating_server_id' in the sysjobs table.
SELECT * FROM msdb.dbo.sysjobs;
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 4, 2009 at 2:59 pm
How do I check the cliconfg?
I ran both queries these queries:
SELECT * FROM msdb.dbo.sysjobservers
SELECT * FROM msdb.dbo.sysjobs
Both the originating_server_id and the server_id are 0.
March 4, 2009 at 3:02 pm
Well - I am not sure where that is being stored. I am going to keep looking and will let you know if I find anything.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 4, 2009 at 4:21 pm
Check the command line for the SQL Agent Job. The command line should have something like:
ESCAPE_NONE(SRVR) for the SRV parameter. Another shot in the dark...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 5, 2009 at 12:26 pm
another shot in the dark - but, run the following and let me know what you find:
SELECT * FROM dbo.sysoriginatingservers;
SELECT * FROM dbo.sysoriginatingservers_view;
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 5, 2009 at 2:42 pm
Hmm...
Nothing is returned when I run --> SELECT * FROM dbo.sysoriginatingservers;
But when I run --- SELECT * FROM dbo.sysoriginatingservers_view; --- I see
originating_server_idoriginating_server master_server
0 computername\instancename 0
The computername and instancename are the correct computer name and instance name, but again, it does not match up with what is in the maintenance plan, manage connections, local area connection field.
Any ideas?
Again, thanks!
March 5, 2009 at 3:41 pm
Well, I would have to guess that this information is stored in the SSIS package. You would have to export the package and open it in BIDS to verify what is stored there.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 11 posts - 31 through 40 (of 40 total)
You must be logged in to reply to this topic. Login to reply