It returns the default database from sys.server_principals but it doesn't return that SQL logins from sys.database_principals. But if you go through SSMS, that user has valid permission to the...

Some of them were disabled. I enabled them and used the password to login; but it still says Login failed for user....

From DTS, when I try to upgrade, here is the error.

Anybody? I am at a hard stop.

Package Upgrade: Failed to save package file "c:\users\documents\visual studio 2010\projects\SSISMigration\SSISMigration\SSIS_Package1_F.dtsx" with error 0xC0014061...

When I try to execute from SDT also, it throws the same error.

Thanks. Any idea how to copy the list of linked server from 2005 to 2012? I didn't see the option in SDT.

can't take compressed backup on 2005...what are other options? because other dbs are pretty similar in size.

It failed on master stored proc objects. I skipped that and its working now. But its been alreay an hour and the process to copy is still runnng. DB size...

19Table is a Typo. I meant MyTable.

Query runs fine. How do I filter the ones that haven't been used by query optimizer for certain days. I am interested only in _WA stats.

U rock!! It worked awesome. I would never thought of rewritting it like that. Runtime is now 1 sec from 7-8 sec which is awesome. Thank you!!!

Where are you doing SELECT @Var5 = max(mycol) FROM Mytable WHERE mycol = @a ? I need to get max on that column from Mytable.

Sorry, I cannot post the actual code for security reasons. I have figured out a way to write a function that returns the value that I am looking for which...

Can you give me some pointers of rewriting this query? Can data be grabbed at 1 shot instead of doing UNION ALL.

Is recursive CTE possible to rewrite this? If yes, how?

How can i write a recursive function for this?

select col1, col2, col3

From BaseTable

Left Join dbo.Table6 Table6 on (BaseTable.z = Table6.ID6)

Left Join dbo.Table5 Table5 on (BaseTable.z = Table5.ID5)

Left Join...