i would like to ask what the difference between sql server 2000 and 2005
View Complete Post
Could you please advise me on this issue.
I have installed sql server 2000 client tools, and complete set up of sql server 2005 on my system.
The enterprise manager on sql 2000, crashes and and window vanishes, when ever i try to create DTS package.
They doubt its becos i am runnning both instance of sql server on the same machine- So its having some compactability issues.?
Can we run SQL server 2000, 2005 and 2008 on same machine with different instance ?
I am using windows 7 and i3 processor.
Thanks in advance.
Here at work most of us have SQL Server 2000 and 2005 installed on our machines. When one of us creates a 2000 DTS package on our machine, it cannot be opened on on any other machine with the same setup. It will only open on the machine where it was
created. We have had to use a machine that has only a 2000 installation in order to create DTS packages that can be opened on other machines.
Is there a solution to this problem?
cannot restore the databse made in sql server 2000 in sql server 2005 in windows 7 with thw following error message
TITLE: Microsoft SQL Server Management Studio Express
Restore failed for Server 'KHURANA\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
plz help me out
Request to provide the tips and details for migrating data from SQL 2000 to 2005.
Thanks in advance
I plan to migrate a SQL 2000 instance with everything in it to another SQL2000 server, and eventually in the future to SQL 2005.
I've pretty much figured out how to migrate everything execept the linked server configuration (there're many linked servers configured in the old server with different security credentials).ÃÂ I'm wondering if there's way I can save the linked server configuration and restore it to the other server.
Could anyone tell me the features comparision between sql server 2000, 2005 and 2008 in the table format like below.
sql server 2000 features | Extra features added/supported in 2005 | Extra features supported in 2008
Note: Please do not give any links.
In SQL server 2000 and 2005, I used to have a nice practical list of all SQL Server sessions and list of locks with useful details make troubleshooting quite easy.
In SQL Server 2008 list of locks are taken out from the “Management” section of SSMS and there is a clumsy “Activity Monitor” option which
doesn’t provide information about sessions and locks in the nice way we used to have in SSMS 2005.
Using SSMS 2008, Is there any way to get the same list of locks and sessions similar to what we had in SSMS 2005?
· * ´
I am using google transliteration to display the text in Hindi/Tamiletc.I tried to store the text appear as Hindi from textarea in an nvarcharfield of database (SQL Server 2005) , the text saved as "???????".After retireving text from the same it display the text as "???????".Can anyone help me how to store and retrieve the actual data from SQLServer 2005?I am using ASP.net,VB.Net and SQL Server 2005
I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.
I have two SQL Server instances installed.
1- UserLT (this is sql 2000)2- UserLT\SQL2005 (this is SQL 2005 named instance)
But when i try to add a database to my VS website project I get the following error:
Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925
I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)
and changed the "SQLEXPRESS" to "USERLT\SQL2005".
But I still get the same error message. Any ideas how i can resolve this issue?
sql serve 2005 enterprise edition is required to work with microsoft enterprise blocks