What option you dont have? script data option or Generate Script option?

Nag

As Dave Ballantyne said, if you can provide sql query and execution plans from both the servers then it will be helpful provide any advice.

Nag

Completely agree with eric_russell, I think there is no comparison between coding on GUI and on database, there are so many features to handle things same as you we do...

Check the indexes and their fragmentation levels. if they are identical then there should not me more difference.

Nag

Confused with your question, what do you mean by combining multiple databases into a single, you mean to transfer the tables and other objects form different databases to single?

Nag

I had similar kind of problem whereas i was not even able to see any databases in object explorer of SSMS2008 but quires were running fine, but this article helped...

Hay Post your data in the form of INSERT statements which will help people who want to help you. you should probably study the article in the link below. It'll...

Try this query, no need of using sub query:

SELECT Gender, CMType, BreedName, COUNT(*) AS 'Nr By Gender/Type/Breed'

FROM BREED JOIN K9 AS CNTR

ON BREED.BreedID = CNTR.BreedID

JOIN CMTYPE ON CNTR.CMID = CMTYPE.CMID

GROUP...

I think you are missing group by clause for the main query.

Nag

search for mru.dat file in Application Data folder and delete that file.

Hope that should work.

Thanks,

Nag

I am sorry ColdCoffee I pointed my reply to Jeff whereas you are the one who wrote the code... I started participating on this forum frequently which is giving me...

give some example for the rate column of second table.

Nags

One thing I have understood from all these great personalities is that, there is no end for hunger and there is no end for learning.

Thanks,

Nag

Jeff i learned more about CTE from this post as I have started my carrier as SQL Developer, but for 3 to 4 years i am working as DBA, but...

To get list of orphaned users user the following query

USE databasename;

GO

EXECUTE sp_change_users_login @Action='Report';

To fix the Orphaned users logins one at a time

USE databasename;

GO

EXEC sp_change_users_login 'Update_One', 'database_User', 'ServerlevelDet'