View Complete Post
How to Import data from sql server 2008 to sql server 2000 ? (i don't have any idea about SSIS, expect this any chance is there? i was try with import functionality some records are copy after it was faild i have nearly 80 Lacks records)
Please help me how to solve this issue this is very urgent form me...
I have several apps written in VB.net 2003. these are connecting to SQL Server 2000. What do I need to do to host the data on SQL Server 2008.
I recently upgrade from SQL Server 2000 x32 to SQLServer 2008 R2 x64 but only the database engine not the Analysis Server, I used to use this code to proces the cubes.
but now it do not work more with the error:
Error at create server:
Error Source Description HelpFile HelpID
---------- ------------------------- -------------------- -------- -----------
0x80040154 ODSOLE Extended Procedure Clase no registrada NULL 0
(1 row(s) affected)
I found this article:
It means that I can not process the cube using the same method any more ?
can any one tell me how to read the data's in the text file using sql server 2000 and 2008.
i have a text file in a server and it contains one column name with the multiple column values i need to read that informations and i need to update in a table in the database.
how can we do this.
Hello All !
I'm installing a log shipping solution with SQL Server 2008 Standard SP1 (on x64 US). I use a monitor logshipping with SQL Server Express Edition x64 SP1 US. When I try to connect it, I have this message when i tried to use w.x.y.z\SQLEXPRESS as a
'w.x.y.z\SQLEXPRESS' is not a valid monitor server instance. A monitor server instance must be SQL Server Standard Edition, SQL Server Workgroup Edition, or SQL Server Enterprise Edition.'
In SQL 2005, it is possible to do that with SQL Express. And with 2008 R2, is it possible too or it is the same problem ?
I've just restored a db (MS SQL 2000) unto MS SQL 2008. All went well and the users for that db were also created. But they were created on the db level.
On the server level, these logins were not there. I tried to create them manually at the server level. When I try to assign the login to the db it understandably says that the user with the same name already exists in the db.
I tried dropping the login created in the db level but I can't do so as there is a schema in the database with the username.
How should I go about getting the same login unto 2008 without dropping any schemas as I am trying to keep everything the same as it was in 2000 for testing purposes in 2008.
Thanks in advance.
How to create linked Server to connect from SQL Server 2008 to SQL Server 2000.
I following the steps to create the linked server in the GUI but failed with the following error message.
I used the full computer network name as the 'Linked Server' name
OLE DB provider "SQLNCLI10" for linked server "my_server_network_name" returned message "Unspecified error".
OLE DB provider "SQLNCLI10" for linked server "my_server_network_name" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server "my_server_network_name". The provider supports the interface, but returns a failure code when it is used.
Thanks a lot for your help.
Hello, I am having some trouble upgrading an existing SQL Server 2000 Reporting Services installation from an old server to a new one commissioned for this purpose, which is running SQL Server 2008 Reporting Services. I have been following the instructions here:
but after trying to connect with reporting services 2008, i get this error:
The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'C.0.6.54'. The expected
version is '147'. (rsInvalidReportServerDatabase)
before starting the process, I ran upgrade advisor and got back the following results:
DescriptionSetup can upgrade a SQL Server 2000 Reporting Services instance that uses a SQL Server 2000 Database Engine in the same instance. However, upgrade is blocked if the report server database is in a different instance, on a remote instance, or runs on a remote SQL Server 2005 instance in SQL Server 2000 compatibility mode.******note, our reporting services IS in the same instance as the SQL Server 2000 database engine. However, upgrade advisor still reported that this instance can not be au
Hello we have a WSS 3.0 on a Windows Server 2003 with a single site, and we are trying to migrate it to another server with Windows Server 2008. All database are on a Microsoft SQL Server 2000.
We installed WSS 3.0 from scratch on the new server. We put the default databases on a server with Microsoft SQL Server 2008.
Then we made a backup in the production server with the following command: stsadm -o backup -url
https://portal -filename musa.bak
After that we restored the backup in the new server with the following command: stsadm -o restore -url
https://uymvd18 -filename c:\sharepoint\portal-2010-10-05-21-00-06.dat -overwrite
(portal is the name of the old server and uymvd18 is the name of the new one)
Everything worked ok, but the when we try to do a search in the new se
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.