I’m having problems replicating a table that is full text enabled using SQL Server 2000 sp4. When I start the distribution agent I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table ‘dbo.proposals’ because it is not full-text indexed. I have run sp_fulltext_database ‘enable’ on the subscriber. What do I need [...]
Answer Question | August 4, 2008 6:13 PM
SQL Server 2000, SQL Server errors, SQL Server replication, Systems Channel
Is there any limitation on the numbers of databases per instance that can run in either SQL Server 2000 or SQL Server 2005?
Answer Question | August 4, 2008 2:26 PM
SQL Database, SQL Server 2000, SQL Server 2005
Hi, I am pretty new to the SQL Server DB. We are working on a project where in the db is migrated from SQL Server 2000 to SQL Server 2005. I was told that the migrated databases will consume more disk space on SQL Server 2005. Is that true? If so, what is the reason [...]
Answer Question | July 29, 2008 6:36 PM
SQL Server 2000, SQL Server 2005, SQL Server migration
How do I create a user in SQL Server 2000?
Answer Question | July 28, 2008 7:12 PM
SQL Server 2000, Users
Hi I’m trying to create a stored procedure to send mail, and 1 line in my SP states: EXEC @hr = sp_OACreate ‘CDONTS.NewMail’, @MailID OUT But I get an error that sp_OACreate is missing. How it happened I don’t know. But how do I fix the problem? Is it possible to recreate sp_OACreate manually? (Note [...]
Answer Question | July 23, 2008 11:24 AM
sp_OACreate, SQL Server 2000, SQL Server errors, SQL stored procedures, Stored Procedures, Windows XP
When attempting to install the client tools for SQL Server 2000 onto an XP desktop, I get an error stating that “A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.” Rebooting only leads to the same error, and I have tried a different PC [...]
Answer Question | July 22, 2008 8:10 PM
SQL Server 2000, SQL Server errors, SQL Server installation, Windows XP
We have SQL Server 2000 SP3 running on Windows 2003 Server. Every week, after running our optimization and integrity checks on Sunday, we get this error: Time out occurred while waiting for buffer latch type 2… This happens several hours into the day every Monday. Would upgrading to SQL Server 2000 SP4 resolve this issue?
Answer Question | July 31, 2008 7:58 PM
SQL Server 2000, SQL Server 2000 SP3, SQL Server 2000 SP4, SQL Server errors, SQL Server upgrades
I am seeing this error weekly in the sql server log with associated performance hit: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch. Has anyone resolved this error?
Answer Question | November 4, 2008 9:02 PM
SQL Server 2000, SQL Server errors, SQL Server logs, SQL Server performance
I have been tasked to set up access from a remote site to a SQL Server 2000 database. The user interface was programmed in .NET. This database will sit outside our firewall and will be protected by its own firewall. The application currently uses an ODBC connection to the database. Do you have any suggestions [...]
Answer Question | July 17, 2008 8:23 PM
.NET, Remote access, SQL Server 2000, SQL Server database
How might I backup a SQL Server 2000 database through VB.NET 2005?
Answer Question | July 16, 2008 6:53 PM
Backup, SQL Server 2000, VB .NET, VB.NET 2005
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 [...]
Answer Question | September 9, 2008 2:52 PM
SQL Query Analyzer, SQL Server 2000, Stored Procedures
I am using SQL Server 2000 SP4 on Windows 2003 Server, and I am having a problem with my queries. One of them was running fine a couple of weeks ago, but all of a sudden it is taking considerably longer to process than it used to. How might I resolve an issue like this [...]
Answer Question | July 10, 2008 6:04 PM
Query, SQL Server 2000, Windows Server 2003
When I insert data into a table using OPENROWSET in SQL Server 2000, the data in the table comes up as “2.00804e+007” and “6.02303e+007”. Why might this be?
Answer Question | July 14, 2008 5:56 PM
Functions, SQL Server 2000, tables
i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??
Answer Question | July 8, 2008 5:55 PM
Software maintenance, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB, Visual Basic 6
I have two identical SQL Server 2000 Enterprise Editions running on Windows 2003 Enterprise servers. They both have 8GB of RAM with /PAW and /3GB switches configured. The max server memory is set to 7GB on both. On one of the servers, the available physical memory under Task Manager Is always showing 3GB free, yet [...]
Answer Question | July 4, 2008 6:16 PM
Memory, SQL Server 2000, SQL Server performance
I have a server with SQL Server 2000 SP4 and Windows Server 2003 Standard Edition SP1 that runs SAP Business One. The server’s specs are: ML350G5 XEON 2.0DC 4GB RAM 6 UNITS SAS 72GB C:=>Raid 1+0, D:=>DATA Files, E:LOG files, F:TempDB files Swith Hub: 3COM 2924 SFP plus 3COM 4210 Cable: CAT5E I have two [...]
Answer Question | July 4, 2008 6:13 PM
SAP Business One, SQL Server 2000, SQL Server performance, Windows Server 2003
I am using SQL Server 2000, and I backup and restore my LIVE database to a new backup server every night. Do you have any ideas as to why my restored database runs slow when compared to the LIVE database? Do I need to rebuilding indexes? Is there any way of backing up indexes as [...]
Answer Question | July 4, 2008 3:52 PM
Database backup and recovery, Indexes, LIVE database, SQL Server 2000
Is there a quick way to find the total size of each database on SQL Server 2000 and SQL Server 2005? I have tried running “sp_spaceused”, but I do not want to run it manually for each database. Do you have any ideas?
Answer Question | July 1, 2008 8:09 PM
Database, SQL Server 2000, 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 + “‘,” [...]
Answer Question | September 20, 2008 7:35 PM
SQL Server 2000, SQL Server 2005, SQL Server backup, VB.NET
If SQL Server 2000 and SQL Server 2005 run on the same server, how can your code differentiate which database to use? Can you give the new instance of SQL a different name?
Answer Question | July 2, 2008 7:28 PM
SQL Database, SQL Server 2000, SQL Server 2005