can not backup a 2000 db, dbcc checkdb ok. see following: Errorlog: 2008-01-08 09:54:40.69 spid62 Starting up database 'CP2005'. 2008-01-08 09:54:41.00 backup BACKUP failed to complete the command BACKUP DATABASE [education] TO DISK = N'C:\fjs1\education_db_200801080954.BAK' WITH INIT , NOUNLOAD ,...
I'm working on FINGERPRINT RECOGNITION SYSTEM. I'm using VB.NET as front end and SQL Server 2000 as back end. I had saved fingerprint images in sql server using image datatype, now I need suggestion on how to compare fingerprint images.
what is the diffrences between oracle proprietary join and sql 1999 compliant joins
Now, I'm a beginner using SQL Server and I'm looking to learn more about the advantages / disadvantages between "nvarchar(max)" and "NText" data types. Now, I don't need to know backward compatibility so I already know that "nvarchar(max)" isn't supported by previous SQL Server releases.
How would I go about migrating SQL Server 2005 back to SQL Server 2000?
One of our clients gets the following error when trying to backup a database:quote:________________________________________System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x121db60d; actual: 0x521db60d). It occurred during...
What are the Basic difference between SQL 2000 and 2005? Thanks!
I am trying to connect to Google cloud SQL instance from eclipse in my app engine connected android project. So far I'm able to connect to cloud SQL instance using Class.forname("com.mysql.jdbc.Driver"). But it requires authorizing my IP address in Google cloud SQL every time I want to use the...
What are the benefits of upgrading to SQL Server 2005 from SQL Server 2000?
I am having database a and b. I want to update database a according to adaptations in database b. b is same as a operations are done on b database and after completion a will get updated for permanent change? How can I do this automatically by using information_schema in SQL Server 2000
I have 2 servers. Server 1 has SQL 2000 (SP2). Server 2 has SQl 2000 + SQL 2005 (sp2). I'm trying to create a linked server on Server 1 to Server 2 SQL 2005. I can get SQL 2005 linked into SQL 2000 on server 2 itself but when I got to Server 1 and try to create a linked server to SQl 2005, I get...
How do I restore a SQL Server 2000 backup file?
I want to transfer data from access to SQL table and vice versa through Windows service. So, please help me.
How can I make backup 4 file only and restore in SQL Server 2000?
We are trying to install a software (on about 70 workstations) that uses a SQL type database that is stored on our server. We all have Windows XP and our server is Windows Server 2003. About half the Workstations are able to connect to the database with no problems. The rest are unable to connect...
Hi - When I run this: select cast ('461129' as datetime). I get 2046-11-29 00:00:00.000 instead of 1946-11-29 00:00:00.000 Can you please let me know why and what I need to do in order to get the required results? Thanks.
Hi all, I have a SQL2000 machine that has a linked server that runs SQL2005 (before this was a SQL2000) When the systems were both SQL2000 from ServerA it was possible to run: BEGIN TRAN SELECT * FROM MYSVR.MYBD.DBO.MYTABLE COMMIT TRAN After the ServerB has been upgraded to SQl2005 the code above...
How would I transfer a database from Microsoft Access to SQL Server 2000?
Hi friends, I am using d2k as front end and for back end. I want to use my SQL Server 2000 data. How can I connect it? Thanks!
Has anyone ever seen a White Paper on the best way to utilize features of both VMWare and EMC Symmetrix based SANs in a real-time or rapid batch based upgrade from SQL Server 2000/2005 to SQL Server 2008 with minimal downtime for application availability?