• 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 way to join tables from...

    CO Bill120 pointsBadges:
  • 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...

    ChrisThompson5 pointsBadges:
  • Transferring a database from Microsoft Access to SQL Server 2000

    How would I transfer a database from Microsoft Access to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL 2000 Reporting Services – Using embedded code to guide user on input parameters?

    I'm working on a report which has these input parameters: StartDate (textbox, data type is datetime) EndDate (textbox, data type is datetime) AccountNumber (dropdown, data type is string) I need to set up logic where if the user viewing the report has input only date values, they'll be prompted to...

    Darth Continent35 pointsBadges:
  • Replication Logreader error. SQL Server 2000

    Hi I am using SQL Server 2000 replication , I have separate publisher,distributor and subscriber servers running on SANs. I get below error and synchronization gets struck, becuase log reader could not read data from the publisher db. Could you give me a quick fix for this error....

    Krajdba10 pointsBadges:
  • AR server

    we r using the AR server 7.0 the backend database is sql 2000 under window platform, so now if I need to change the database table format to CLOB then, any one could tell me what is the format of changing the database format, I mean the table format to In-row and Out-row method. Could any one...

    Jiji5 pointsBadges:
  • Unable to Restore Backup in SQL Server 2005

    I am unable to RESTORE Backup through code in SQL Server 2005 from VB.Net, even though that code is running fine in SQL Server 2000. The code is: "restore database [" + databasename + "] from disk ='" + Me.lblSource.Text + "' with move '" & dfile & "' to '" + Me.lbldatafile.Text + "'," & _...

    SQL Server Ask the Experts2,585 pointsBadges:
  • For Save .doc file in Sql Server 2000

    I want to Save Word File in SQl Server, how it is possible

    Karankhandelwal5 pointsBadges:
  • 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.

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    Kc54555 pointsBadges:
  • 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 500MB...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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...

    JCDBA20 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    Jerry25 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server Upgrade and Server Move

    I have an old Windows 2000 server running SQL 2000 and need to retire the server and move my SQL databases to a new server. The new server is a fresh install of Windows Server 2003 and SQL Server 2005. I am having a hard time finding a procedure for this complex conversion. Is this something that...

    RussGunther5 pointsBadges:
  • Running a stored procedure in SQL Query Analyzer or as part of a SQL job

    I have been trying to run a stored procedure in SQL Query Analyzer and as a step in a SQL job. If I run it in Query Analyzer, it takes less than a minute, but it takes considerably longer if it is run as a step. I use SQL Server 2000. Why would there be so big a difference?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error accessing Oracle data using SQL job

    I have a DTS package that use the MS OLE DB provider for Oracle. The DTS package executes stand alone; but when placed in a schedule job, it won't run. This was working; but quit after I had detached some databases to copy them. After re-attaching them, the jobs would no longer run. I have logged...

    Randym1,740 pointsBadges:
  • query of query errors

    I have a runtime query of a query error as below. java.lang.String cannot be cast to java.util.Date But the output format is correct and is in date. This application was developed in coldfusion 6.1 and sqlserver2000. But now we get this error when it was migrated to coldfusion 8 and sql server...

    Vidukarth25 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following