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....
Answer Question
| May 16 2008 2:29 PM GMT
| asked by
Krajdba
SQL Server replication, SQL Server 2000
Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
View Answer
| May 14 2008 3:24 AM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, Enterprise Manager, Indexes
row_number in sql 2000
how to find out the row_number in sql 2000 like using row_number() function in sql 2005
View Answer
| May 8 2008 10:51 PM GMT
| asked by
Rl
ROW_NUMBER, SQL Query, SQL Server 2000
How to Schedule jobs in DTS in sql server 2000
I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it
View Answer
| May 7 2008 5:14 AM GMT
| asked by
SRI HARSHA
SQL Server Agent, DTS, SQL Server 2000
DB size
Hi, I am using a software which is using SQL DB. Each time there is an error (one of the tasks fails) the DB grows. I would say over 1G per day! Currently I have DBs which are 45G and I am running out of space.Anyone has any idea how to shrink the DBs or do something to reduce the size.The LDFs...
View Answer
| May 2 2008 3:30 PM GMT
| asked by
Ellie
SQL Server 2000, SQL Server performance tuning, SQL Server logs
Suspect DB
Hi, I am using sql server 2000 and recently found 2 of the DBs are marked as Suspect and I don't have access to them any more.Would you please help me with this?Thanks,Ellie
View Answer
| May 2 2008 3:24 PM GMT
| asked by
Ellie
SQL Server security, SQL Server 2000, Suspect database
Can’t Install SQL Server 2000 on Window XP SP2
I try to install SQL Server 2000 on Window XP SP2, but there is an error message mean "OS not support.". What should I do? How can I install SQL Server 2000 on Window XP SP2? Please, give me the best and detail answer. Thanks.
View Answer
| May 2 2008 4:29 AM GMT
| asked by
Yoyo
SQL Server 2000, SQL Server errors, Windows XP
update query fails as table gets locked by select query (sql blocking issue).
I have a perl script which updates some table records in sqlserver 2000, the flow is like below:* A select query This select query selects IDs(with other records too)* An update query This update query updates a bit column from 0 to 1 for the IDs retrieved from above select query.The problem I...
View Answer
| May 1 2008 9:32 PM GMT
| asked by
Shashanksingh19
Perl, SQL Server 2000
DTS schedule package
How can I see the scheduled run time of an existing DTS package?
View Answer
| Apr 30 2008 7:09 PM GMT
| asked by
Hoverman
SQL Server 2000, DTS, Data Transformation Services
Looking for best approach to upgrade SQL Server 2000 databases to SQL Server 2005
I will be upgrading a number of SQL Server 2000 databases to SQL Server 2005 and was wondering what database objects I have to worry about? I believe to run Data Transformation Services (DTS)in 2005, I will have to have legacy installed. Is that correct? Other than that, should there be any...
View Answer
| Apr 30 2008 5:51 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server upgrade, DTS, SQL Server 2005
Mobile phone notifications
HiHow to setup mobile notifications on jobs using SQL Server 2000. Aim is when a job fails I should receive SMS notification on my mobile phone.Please show me web sites on this topic.Please help.Thanks & Regards-Rajesh.
View Answer
| Apr 30 2008 11:37 AM GMT
| asked by
Krajdba
SQL Server 2000, SQL Server alerts
full-text replication SQL Server 2000
I'm having problems replicating a table that has 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...
View Answer
| Apr 21 2008 6:14 PM GMT
| asked by
MarkT
Full-text databases, SQL Server 2000, SQL Server replication
How to work with Visual Basics 6.0 and SQL Server 2000
I am designing a system with Visual Basics 6.0 as the user interface and SQL Server 2000 as the backend. How can I add data to the database through Visual Basics? How about deleting data in the tables?
View Answer
| Apr 18 2008 1:17 PM GMT
| asked by
SQL Server Ask the Experts
Visual Basic, SQL Server 2000, SQL Server integration/interoperability
Looking to resolve SQL Server performance problems caused by using many temporary tables
I need your advice on the SQL Server performance tuning.The Problem: We use a lot of temporary tables in our application, which is causing a lot of SQL Server performance problems. I read about the following solution on some site."RamDisk presents a powerful solution to this problem by providing up...
View Answer
| Apr 10 2008 2:23 AM GMT
| asked by
SQL Server Ask the Experts
SQL Server performance tuning, Disk storage, SQL Server 2000
How to set up a threshold on a SQL Server 2000 Agent backup job?
I would like advice on setting up a threshold if a SQL Server 2000 Agent backup job (nightly) is running after a certain time (7 a.m. PST), I would like to cancel it.
View Answer
| Apr 4 2008 2:03 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server backup, SQL Server Agent, SQL Server 2000
Upgrade to SQL Server 2005 resulted in 100% CPU utilization and application timeout error
My server is DL580 running on Intel Xeon Dual core Dual CPU. I have recently migrated from SQL Server 2000 to SQL Server 2005. The server is dying and showing 100% CPU utilization and applications are getting Server Timeout expired error. What can I do?
View Answer
| Apr 4 2008 1:46 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server upgrade, SQL error messages, SQL Server performance
After Unicode, SAP release strategy sequence changed
Help, please!We recently did a Unicode conversion (SAP 4.7 from SQL 2000 to 2005, and from 32 bit O/S to 64 bit also). We now find that even though in config the release strategy has the correct sequence, when the approver views the screen (via workflow or even ME52N) to a Purchase Requisition, the...
Answer Question
| Apr 3 2008 4:03 PM GMT
| asked by
Jahmusical
SAP, Unicode, Release strategy sequence
jobs runing on the server
hi every 1,i am having a real tough time to figure this one out .i need to find out what jobs are schedule in the server that sends data out to ever .we are doing the migration from 2000 to 2005 and need to know which jobs send data to the another server .i looked at the sysjobs_view , it tells...
View Answer
| Mar 31 2008 3:08 AM GMT
| asked by
Deal11deal1
SQL Server administration, SQL Server migration, SQL Server 2000
Converting from 2000 to 2005
I was given an existing application/database with stored procedures to work on. The existing database is in 2000 however the manager would like it converted to 2005 (she thought it already was a 2005 database). My system is only configured for 2005 so my analysis tools are not working on the...
View Answer
| Mar 27 2008 6:24 PM GMT
| asked by
GUI Girl
SQL, SQL Server 2000, SQL Server migration
unable to modify field in SQL Server 2005
I have a database that was working perfectly on SQL 2000. We moved the data to SQL 2005. Now when our program accessing the SQL 2005 Server we get "Field 'optional' cannot modify." The Field optional is a bit field. The program is able to modify other tables in the database. It just won't...
View Answer
| Mar 26 2008 7:43 AM GMT
| asked by
Only1rb
SQL Server migration, SQL Server errors, SQL Server 2000
