June 15, 2011 at 3:11 pm
I was setting up replication today and did fine on the first server...When I moved on to the next server to set replication up, I was setting up my publisher and as it was about to finialize, it bombed on me and gave this error message:
View or function 'master.sys.dm_exec_sessions' has more column names specified than columns defined
So I look at the system views and see this view and try to open it and again, it gave me this error...Can someone please explain in detail what I need to do? Bc I googled this and it seems that this is due to maybe a service pack issue or server build issue??? Im not sure, this is over my head and couldnt figure out what I needed to do to fix this issue...I have never seen this error before so I do not know exactly how to handle it!
Thanks to any who respond!
June 15, 2011 at 4:47 pm
Run this on both servers and let us know the results.
select SERVERPROPERTY('productlevel') as SPLevel,SERVERPROPERTY('engineedition') as EngineEdition
,SERVERPROPERTY('edition') as SQLEdtion,SERVERPROPERTY('productversion') as SQLVersion
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 16, 2011 at 7:12 am
I was just setting up a publication and received that error so I wasnt connecting to another server...I point it to the other server when I set up the subscription and I have not got that far yet...
But I ran that on the server I was setting up the publication and here is that info:
SP Level: RTM
Engine Edition: 3
SQL Edition: Enterprise Edition (64-bit)
SQL Version: 9.00.1399.06
And when I run select @@version:
Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Can anyone tell me what I need to do to get around this issue???????
June 16, 2011 at 7:16 am
I thought you said you had set it up on a different server already prior to this error. That was the other server I was looking for the information on.
I would like to compare what has been done differently between the two servers and the differences in version and sp if there are any.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 16, 2011 at 7:27 am
I got ya...I thought you were referring to the server that I was going to set up as a subscription...Ok the information from the server that I successfully set up snapshot replication is as follows:
SP Level: SP3
Engine Edition: 2
SQL Edition: Standard Edition
SQL Version: 9.00.4053
And the information from select @@version:Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
I notice the SP levels are different as the one that worked is SP3 and the one that did not work is RTM...
And the Engine Editions are different as the one that worked is 2 and the one that did not work is 3...
And the SQL Versions are different as the one that worked is 9.00.4053 and one that did not work is 9.00.1399.06...
I would not think the SQL Edition matters as Enterprise Edition (one that is on the server that did not work) is more powerful than Standard Edition (one that is on the server that did work)...
Also when I run select @@version on both machines at the end they both say Build 3790: Service Pack 2...
Any suggestions? If it is just a matter of upgrading the SP Level, how do I do that?? Im just really confused on this issue!
June 16, 2011 at 7:33 am
The bit at the end is the Windows version, so that part doesn't matter.
What you need to do is apply the latest service pack for SQL 2005 to that server. You'll need to test that before you do it, preferably not on a production server. Do you have an environment where you can test that?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 16, 2011 at 7:39 am
yeah i would like to test that but that server that needs it is a production server and all our other boxes have been upgraded!
June 16, 2011 at 7:43 am
Then it looks like you'll need to plan a downtime and patch that server to bring it up to proper patch level.
=============================================================
/* Backups are worthless, Restores are priceless */
Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management
June 16, 2011 at 9:11 am
Yep that is what the problem was...
Thanks to all for the responses!
June 16, 2011 at 9:13 am
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply