In the Query Editor, run the following command and post what the resultset is.

SELECT SERVERPROPERTY ('productlevel')

Welcome ! 🙂

Gus is right, uninstall all components related to SQL Server and Visual Studio, since they would all be installed by Developer Edition.

Which method worked, the one given in the link you mentioned earlier or Ignore error suggested by me?

Look at the following Link http://msdn.microsoft.com/en-us/library/ms143393.aspx

According to that list, it says yes, but I haven't personally upgraded from Express 2008 to Developer Edition, it may end up being a side-by-side...

SQL Server 2008 is in the 2nd year in the market now, and...

From your description, it looks like there is no Index on the account_id column, can you make sure that there exists an Index on that column, if not create an...

Few more questions other than what Gail has asked.

What do you mean by replication for every 5 Minutes?

If it's Snapshot Replication running atevery 5 mins interval it would be...

It basically needs to be addressed by you keeping in mind of your application needs, for example, does it need more than 2 node cluster? Does it need other features...

Have you installed SP3? The earlier replies have all been older than 21 months.

If you have to uninstall, why do you have to modify the registry, earlier replies have not...

Yeah Lynn, he wants the data for the tours that are going on, so tour end date can be NULL or some future date when compared to a particular day,...

Add this to the existing one, remove the non working query.

DECLARE @SQL123 VARCHAR(8000)

SELECT @SQL123 = Col_02 FROM From_upd WHERE Col_01 = '2'

SET @SQL123 = '(' + @SQL123 + ')'

EXEC ('SELECT...

Yeah, I run SQL Server 2008 Dev Edition on my Windows 7 laptop (3 Gigs RAM) work fine..

Well, that is the problem here, I can't give a straight solution unless, I know how you are looking at the problem is. It would be a good point to...

May I suggest you go to the link below

View SQL Server Error Logs through T-SQL code

Use the code mentioned there to retrieve the last 24 hours of the Active Error...