Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11
SSMS 9

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

Common migration issues (version 2000 to 2005)

Aug 12 2008 9:41AM by Madhivanan   

Many users complain that some new features are not working in SQL Server 2005 when the server is migrated from SQL Server 2000

These are the common tasks that should be done to avoid some migration issues

1 Change the compatibility level to 90
 
  EXEC sp_dbcmptlevel 'your_db_name',90

This will solve the errors that occur during the execution of the code that contains newly introduced functions like row_number(), rank(),etc

2 Enable Ad Hoc Distributed Queries
  EXEC SP_CONFIGURE 'show advanced options', 1
  RECONFIGURE 
  go
  EXEC SP_CONFIGURE 'Ad Hoc Distributed Queries', 1
  RECONFIGURE 
  go
  EXEC SP_CONFIGURE 'show advanced options', 0
  RECONFIGURE 

This will solve the errors that occur when you use OPENROWSET and OPENDATASOURCE commands

3 Install Service Pack2 for SQL Server 2005

This will solve the errors that occur when you use Import/Export wizard

Tags: t-sql, sql_server, migration,


Madhivanan
3 · 40% · 12899
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]