Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Server 2005 Vs SQL Server 2000

Author  Topic 

knpn
Starting Member

1 Post

Posted - 2008-01-24 : 03:24:11
Hello guys,

I am new to this. I have an ASP.NET application that is currently working with SQL Server 2000. I am planning to change my server database to SQL Server 2005. I would like to know whether my application work without any hassles even though I do not make any changes in the tables and stored procedures that are already created. Please help me.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2008-01-24 : 04:11:18
you realize that there is no way we can answer this question. You need to test your app.




-ec
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-01-24 : 04:15:13
Generally speaking , it should be OK. As long as you are using the right drivers, logon etc.
You may encounter some compatibility issues if the 2005 is set at compatibility level 90 .
Such as the use of ";"

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com
Go to Top of Page
   

- Advertisement -