Accessing another database using a variable
I have a select like this: SELECT a.part_id, a.descript, b.location from PART_MASTER a, anotherdatabase.INVENTORY b where a.part_id = b.part_id Is it possible to use a @variable to identify the other database, rather than hard coding it? (I’ve tried @db2.INVENTORY b) but SQL SERVER 2000 doesn’t like that.
Answer Question
| October 10, 2008 4:22 PM
SELECT statement, SQL Server 2000, SQL Server database, Variables
I have a select like this: SELECT a.part_id, a.descript, b.location from PART_MASTER a, anotherdatabase.INVENTORY b where a.part_id = b.part_id Is it possible to use a @variable to identify the other database, rather than hard coding it? (I’ve tried @db2.INVENTORY b) but SQL SERVER 2000 doesn’t like that.
Answer Question
| October 10, 2008 4:22 PM
SELECT statement, SQL Server 2000, SQL Server database, Variables
MIgration to 64-bit Sql Server
What issues do I face with database file compatibility if I migrate from 32-bit SQL Server 2000 to 64-bit SQL Server 2005?
Answer Question
| October 9, 2008 12:38 PM
64-bit, SQL, SQL database replication, SQL Server 2000, SQL Server migration
What issues do I face with database file compatibility if I migrate from 32-bit SQL Server 2000 to 64-bit SQL Server 2005?
Answer Question
| October 9, 2008 12:38 PM
64-bit, SQL, SQL database replication, SQL Server 2000, SQL Server migration
Upgrading RAM on SQL Server 2000
We use Windows 2003 Server Enterprise Edition and SQL Server 2000 Enterprise Edition. We use the /3GB switch in the boot.ini in an attempt to use more memory, and we are considering upgrading to 8GB of total RAM on our server. Could this negatively impact us at all?
Answer Question
| October 2, 2008 5:14 PM
RAM, SQL Server 2000, Windows Server 2003
We use Windows 2003 Server Enterprise Edition and SQL Server 2000 Enterprise Edition. We use the /3GB switch in the boot.ini in an attempt to use more memory, and we are considering upgrading to 8GB of total RAM on our server. Could this negatively impact us at all?
Answer Question
| October 2, 2008 5:14 PM
RAM, SQL Server 2000, Windows Server 2003
SAP 4.6c migration from MS SQL 2000 to IBM iOS DB2 database
Hi I need to investigate the work load required to migrate SAP4.6C HR from a MS SQL2000 database to a Integrated DB2 IBM i OS Database? Is there tools available for this ? any information will be beneficial Thanx from a system i techie that know nothing about SAP!lol
Answer Question
| September 30, 2008 10:29 AM
DB2, IBM i, SAP development, SAP HR, SAP migration, SQL Server 2000
Hi I need to investigate the work load required to migrate SAP4.6C HR from a MS SQL2000 database to a Integrated DB2 IBM i OS Database? Is there tools available for this ? any information will be beneficial Thanx from a system i techie that know nothing about SAP!lol
Answer Question
| September 30, 2008 10:29 AM
DB2, IBM i, SAP development, SAP HR, SAP migration, SQL Server 2000
How can we use SQL 2000 or latest with Visual FoxPro
Hello Friends I want use SQL in visual foxprox. how can do it. I ready many website, but all answer not fully cleared. Please send me Solutions. My Computer (SQL Server 2005 and Coputer Name) name is SEMSVR. Waiting your reply.
Answer Question
| June 28, 2010 5:11 AM
FoxPro, SQL Server 2000, SQL Server 2005
Hello Friends I want use SQL in visual foxprox. how can do it. I ready many website, but all answer not fully cleared. Please send me Solutions. My Computer (SQL Server 2005 and Coputer Name) name is SEMSVR. Waiting your reply.
Answer Question
| June 28, 2010 5:11 AM
FoxPro, SQL Server 2000, SQL Server 2005
Truncating the transaction log for a SQL Server 2000 database
What is the best automated way to truncate the transaction log for a SQL Server 2000 database?
Answer Question
| September 25, 2008 7:05 PM
SQL Server 2000, SQL Server database, SQL transaction logs
What is the best automated way to truncate the transaction log for a SQL Server 2000 database?
Answer Question
| September 25, 2008 7:05 PM
SQL Server 2000, SQL Server database, SQL transaction logs
Transferring a database from Microsoft Access to SQL Server 2000
How would I transfer a database from Microsoft Access to SQL Server 2000?
Answer Question
| September 23, 2008 6:09 PM
Access Database, Microsoft Access, SQL Server 2000, SQL Server database
How would I transfer a database from Microsoft Access to SQL Server 2000?
Answer Question
| September 23, 2008 6:09 PM
Access Database, Microsoft Access, SQL Server 2000, SQL Server database
Is SQL Server Upgrade Advisor worth using?
We are undertaking a technical study/risk evaluation as to whether to upgrade a substantial SQL Server database from 2000 to 2005. Is the Upgrade Advisor tool of significant benefit it assisting us with the risk evaluation? Nobody in our company has used this tool as yet, so any advice will be gratefully accepted.
Answer Question
| September 24, 2008 3:49 PM
SQL Server 2000, SQL Server 2005, SQL Server Upgrade Advisor, SQL Server upgrades
We are undertaking a technical study/risk evaluation as to whether to upgrade a substantial SQL Server database from 2000 to 2005. Is the Upgrade Advisor tool of significant benefit it assisting us with the risk evaluation? Nobody in our company has used this tool as yet, so any advice will be gratefully accepted.
Answer Question
| September 24, 2008 3:49 PM
SQL Server 2000, SQL Server 2005, SQL Server Upgrade Advisor, SQL Server upgrades
Connecting sql server 2000 to 2 databases simultaneously
I have to create a report to move inventory from an old warehouse to a new one. Each has a separate instance of the database, so I have to get the part# and location from the old warehouse and match it with the new location for that part# in the new warehouse. Is there a [...]
Answer Question
| September 24, 2008 3:33 PM
SQL Server 2000, SQL Server database
I have to create a report to move inventory from an old warehouse to a new one. Each has a separate instance of the database, so I have to get the part# and location from the old warehouse and match it with the new location for that part# in the new warehouse. Is there a [...]
Answer Question
| September 24, 2008 3:33 PM
SQL Server 2000, SQL Server database
SQL2000 linked to SQL2005 doesn’t allow TRAN selects
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 returns the error: [...]
Answer Question
| September 30, 2008 1:53 PM
SQL Server 2000, SQL Server 2005, SQL Server errors, TRAN
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 returns the error: [...]
Answer Question
| September 30, 2008 1:53 PM
SQL Server 2000, SQL Server 2005, SQL Server errors, TRAN
Upgrading from SQL Server 2000 to SQL Server 2005
I have been offered a free upgrade to SQL Server 2005 Express Edition, but I am very pleased with my current version, SQL Server 2000. If I decide to upgrade, will I have any problems with our network? We use languages like C# and Visual Basic often.
Answer Question
| September 19, 2008 4:37 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades
I have been offered a free upgrade to SQL Server 2005 Express Edition, but I am very pleased with my current version, SQL Server 2000. If I decide to upgrade, will I have any problems with our network? We use languages like C# and Visual Basic often.
Answer Question
| September 19, 2008 4:37 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades
The specified module could not be found
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 [...]
Answer Question
| September 19, 2008 3:38 PM
SQL Database, SQL Server 2000, Windows Server 2003, Windows XP
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 [...]
Answer Question
| September 19, 2008 3:38 PM
SQL Database, SQL Server 2000, Windows Server 2003, Windows XP
For Save .doc file in Sql Server 2000
I want to Save Word File in SQl Server, how it is possible
Answer Question
| September 19, 2008 6:31 AM
Microsoft Word, SQL Server 2000, SQL Server import/export
I want to Save Word File in SQl Server, how it is possible
Answer Question
| September 19, 2008 6:31 AM
Microsoft Word, SQL Server 2000, SQL Server import/export
Improving I/O performance on SQL Server 2000
I have SQL Server 2000 SP4 running on an Intel Xeon 2.33 GHz CPU with a 2GB RAM server. We have a total of eight workstations connected to this server, and Performance Monitoring says that the Avg. Disk Queue Length is at about 20 when all users are working concurrently. My tempdb logs are at [...]
Answer Question
| September 19, 2008 7:17 PM
I/O errors, Performance monitoring, SQL Server 2000, SQL Server performance
I have SQL Server 2000 SP4 running on an Intel Xeon 2.33 GHz CPU with a 2GB RAM server. We have a total of eight workstations connected to this server, and Performance Monitoring says that the Avg. Disk Queue Length is at about 20 when all users are working concurrently. My tempdb logs are at [...]
Answer Question
| September 19, 2008 7:17 PM
I/O errors, Performance monitoring, SQL Server 2000, SQL Server performance
SQL Server 2000/2005 Transaction Logs
Quick Ques. Are transaction logs cummulative? If I have a database set to Full recovery mode; database being backed once a day and transaction logs being backed up hourly, if the database needs to be restored, can I just restore the last transaction log file? Will the last transaction log file contain ALL of the [...]
Answer Question
| September 17, 2008 3:20 PM
SQL Server 2000, SQL Server 2005, SQL Server transaction logs
Quick Ques. Are transaction logs cummulative? If I have a database set to Full recovery mode; database being backed once a day and transaction logs being backed up hourly, if the database needs to be restored, can I just restore the last transaction log file? Will the last transaction log file contain ALL of the [...]
Answer Question
| September 17, 2008 3:20 PM
SQL Server 2000, SQL Server 2005, SQL Server transaction logs
Manually migrating databases from SQL Server 2000 to SQL Server 2005
I am manually migrating a large number of databases from SQL Server 2000 to SQL Server 2005. What kind of issues should I expect, and do you have any readily available solutions?
Answer Question
| September 16, 2008 6:24 PM
SQL Server 2000, SQL Server 2005, SQL Server migration
I am manually migrating a large number of databases from SQL Server 2000 to SQL Server 2005. What kind of issues should I expect, and do you have any readily available solutions?
Answer Question
| September 16, 2008 6:24 PM
SQL Server 2000, SQL Server 2005, SQL Server migration
Installing SQL Server 2000 on Microsoft Windows XP
I am attempting to install SQL Server 2000 on Microsoft Windows XP, but I keep receiving this error message: “Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system.” What steps can I take to get rid of this message?
Answer Question
| September 16, 2008 6:02 PM
SQL Server 2000, SQL Server errors, SQL Server installation, Windows XP
I am attempting to install SQL Server 2000 on Microsoft Windows XP, but I keep receiving this error message: “Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system.” What steps can I take to get rid of this message?
Answer Question
| September 16, 2008 6:02 PM
SQL Server 2000, SQL Server errors, SQL Server installation, Windows XP
Common User Interface SQL Serve Management Console
Does anyone know a way to standardize the SQL Serve Management Console so that all of the DBAs will see the same list of servers as we used to have in the SQL 2000 Enterprise Manager?
Answer Question
| September 12, 2008 3:44 PM
DBA, SQL Server 2000, SQL Server Enterprise Manager, SQL Server Management Console
Does anyone know a way to standardize the SQL Serve Management Console so that all of the DBAs will see the same list of servers as we used to have in the SQL 2000 Enterprise Manager?
Answer Question
| September 12, 2008 3:44 PM
DBA, SQL Server 2000, SQL Server Enterprise Manager, SQL Server Management Console
Backing up a SQL Server 2005 database on SQL Server 2000 EE
I have created a large database in SQL Server 2005 Developers Edition, and I intend to put my backup on SQL Server 2000 Enterprise Edition. Is there an easy way to go about this procedure?
Answer Question
| September 18, 2008 5:42 PM
Backup & restore, SQL Server 2000, SQL Server 2005, SQL Server backup
I have created a large database in SQL Server 2005 Developers Edition, and I intend to put my backup on SQL Server 2000 Enterprise Edition. Is there an easy way to go about this procedure?
Answer Question
| September 18, 2008 5:42 PM
Backup & restore, SQL Server 2000, SQL Server 2005, SQL Server backup
Impact on TSM backups after an upgrade to SQL Server 2005
What would the impact be on TSM backups if I undertook a side by side upgrade of SQL Server 2000 SP4 to SQL Server 2005 SP2?
Answer Question
| September 12, 2008 5:24 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades, TSM, TSM Backup
What would the impact be on TSM backups if I undertook a side by side upgrade of SQL Server 2000 SP4 to SQL Server 2005 SP2?
Answer Question
| September 12, 2008 5:24 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades, TSM, TSM Backup
