• Planning to move data on new databse server?

    Well i m working in MNC As a Network admin actually we have one server having data & application so both our application and database on same server & now we are facing some problem on it so we plan to seperate database server & application if any body has a plan or he/she know how move our...

    Ravijoshi2020 pointsBadges:
  • Encryption Form SQL Server 2000

    I want to transfer data from one database to another database both the databases are on sqlserver 2000 i want to transfer the data in encrytion form how do i do it ..... Regards, Sahil

    Maruf245 pointsBadges:
  • SQL 2000 to Yukon Migration

    Posted on behalf of Kilaru: We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it...

    Margaret Rouse1,240 pointsBadges:
  • sql server 2000

    i am learnin sql server 2000 by ownself tell me the wright way how i can learn after this i shall go for oracle

    Agnihotri0 pointsBadges:
  • OPEN .DTS WITH WRONG APPLICATION

    JUST OPEN .DTS FILE OF THE SQL SERVER 2000 WITH NOTEPAD APPLICATION, AND THE .DTS LOGO HAS BEEN CHANGED TO NTOEPAD LOGO, IS IT POSSIBLE TO CHANGE BACK TO .DTS LOGO? THANKS.

    Just5 pointsBadges:
  • Read Only access to a SQL Database? Best way?

    We're trying to prevent hacks on our site. We've been down several times and the idea came up that we could prevent the SQL Injections by making an account for just the public-facing side of the site that has Read Only set for it. This is a Microsoft SQL 2000 server BTW. Our hosting company...

    Kwoodall10 pointsBadges:
  • sql server reporting server

    I have seperate application server for ASP.NET(2.0) and Database server for Sql RS 2000, when i try calling reporting service webservice to generate excel and allow to download to the web user, it gives an error as "401 as unauthorised", can anybody has a solution for this Regards, Prathesh

    Prathesh5 pointsBadges:
  • 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

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

    SQL Server Ask the Experts2,585 pointsBadges:
  • i want to change the true bits to false and vice versa

    i have a table where i have true and false bits..i need to replace the true bits to false and vise versa

    Sam535 pointsBadges:
  • HOw do I restore a database from a backup in MS SQL Server 2000

    I have no knowledge of MS SQL Server. Have software (BOOMI) that uses a database in this. I found a folder where the database is being backed up. i.e. there is a *.BAK file and hourly logs *.TRN. I need to update the boomi software and they say I need to make a back up of the database. If this is...

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

    deal11deal110 pointsBadges:
  • 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

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

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

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

    Yoyo5 pointsBadges:
  • Mobile phone notifications

    Hi How 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.

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

    SQL Server Ask the Experts2,585 pointsBadges:
  • DTS schedule package

    How can I see the scheduled run time of an existing DTS package?

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

    MarkT35 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