Recent IT Questions

1 - 20 of 75
<<PREVIOUS 1|2|3|4 NEXT>>

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


1 - 20 of 75
<<PREVIOUS 1|2|3|4 NEXT>>