Hello guys,

Please revert me... I am doing in-place upgradation and still the same error confusing me.

" Rule SQL Server 2008 Feature upgrade failed. The specified edition upgrade is not supported."

So it is not possible to add primary key on any populated table? or i need to another coulumn which will not allow null vaules ?

Using Export - import wizard, I am able to import excel sheet with more that 10 worksheets. All the first raw in the excel sheet will be treated as header...

Thanks Pettis..!

I again try to upgrade it.. but it stuck at SQL Server 2008 Feature upgrade.. I recieved an error message " Rule SQL Server 2008 Feature upgrade failed. The...

Service pack of My current sql server 2000 is SP2 so to upgrade it to SQL2K8 it is must upgraded to SP4. I downloaded "SQL2000-KB884525-SP4-ENU.exe" to upgrade service pack of...

Ok, cool. Lemme go with Transactional Replication. but how long it takes to synch in Snapshot replication ?

Hi Anthony,

Yes, its working now... I Re-insall SQL instance, and have configured Log shipping again. And now its working.. fine. The issue was Servername. I dont know why it was...

I have not configured any monitoring node. But i can see at SQL Server AGent-->Jobs-->LSAlert_BOM1-7HD1H1S as one of the logshipping job. So might be its an issue of renaming.

I am...

The secondary host name is "SQLTEST".

Hi Anthony,

Thanks a lot for your reply !

I think there is issue related to server name. The Primary server name is BOM-TEST, but dont know in the logs it shows...

Thanks a lot. I was in imression that without default instance we can not install named instance.

I have created three tables as per you want... and below is the query with inner join which gives you result that you want....

SELECT Table_1.[Person Name], Table_2.Description, Table_3.[created date], Table_3.[Actual...

Which OS you are working on? and Which version of SQL you are installing.. ? This matters and might led you to that error message. Pls look on

I have created 3 tables with below design and have fire inner join query.

Table_1 = ID, Name

Table_3 = ID, Designation

Table_4 = ID, Reporting_to

SELECT Table_1.ID, Table_1.name,...

Hey Erik,

I am newbie too.. 🙂 and have installed trial version to test SQL 2008. According to my knowledge you should first stop the services of the sql server and...