June 6, 2012 at 5:52 am
Dear Friends,
I Created a Backup from Databases on Sql2000 and Restore in sqlserver2008 r2.
but i worry about which not granteed in sqlserver2008 r2?
how can i find list of which that not guarantee in sqlserver2008 r2?
for example order by in view not guaranteed
and what s another ones?
Best Regards
zohreh
June 6, 2012 at 6:38 am
I am not sure what you are asking here - do you mean deprecated features that was in SQL 2000 and no longer available in SQL 2008 R2?
If so, take a look at: http://msdn.microsoft.com/en-us/library/bb510680.aspx
June 6, 2012 at 6:55 am
This was removed by the editor as SPAM
June 6, 2012 at 6:57 am
zsafakhah (6/6/2012)
Dear Friends,I Created a Backup from Databases on Sql2000 and Restore in sqlserver2008 r2.
but i worry about which not granteed in sqlserver2008 r2?
how can i find list of which that not guarantee in sqlserver2008 r2?
for example order by in view not guaranteed
and what s another ones?
Best Regards
zohreh
Are you referring to a list of orphaned users?
Use the following to list orphaned users for a particular database
USE [yourdbname];
exec sp_change_users_login 'report'
Post back if you get any records returned
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply