• Migrate MySQL database to SQL 2005

    We are looking to migrate from MySQL to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

    Karl Gechlik9,860 pointsBadges:
  • Recovering lost data from SQL Server 2005

    Running SQL Server 2005. I found that I had lost about 2000 records the Assets table and more records in the associated tables Timeassets and AssetBillingrates.  Each of the tables uses an Id field as the Primary Key. I was able to identify the key records that had been lost and tried inserting...

    BClawson10 pointsBadges:
  • Trigger Use in SQL Server 2005

    I have a Sequel Server 2005 database with a Table called Main Call Issue. I want to update the DateTimeModifed field to be the Current System date without changing my original DateTimeAdded field when the record was added to the database. I know a Trigger will work here. Where do I place the...

    Jjc98105 pointsBadges:
  • SQL Server 2005 database conversion

    Hi, we plan to migrate SQL Server 2005 from SQL Server 2000. We have a database with average size of 12GB. Can any one please let me know how to convert our database from SQL 2000 to SQL 2005.Thanks in advance.

    Anto5 pointsBadges:
  • Slow outer JOIN after delete rows

    Hi, I've tried this on two installations of SQL Server 2005 service pack 2. If I delete rows of a table, an outer join on the empty table is extremely slow...if I truncate it's ok, if I delete with the tablock hint it's ok. Any ideas why? The code to reproduce this follows, the outer join takes...

    dpaproskijr5 pointsBadges:
  • Update a Date_Time Field

    I'm trying to update a DATE_TIME field to a NULL value. When I run the script below I get an error. Any ideas on what I'm missing? UPDATE Orders SET CONFIRMATION_DATE_TIME = ' ' WHERE ST_ID = 102690 ERROR: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value 'Ê' to a column...

    DJandLO130 pointsBadges:
  • Restoring Database

    I accidentally deleted contents of a table and is now trying to recover the deleted rows.  I do not have a backup (how stupid of me).  I do have a .mdf file, however I believe i copied that file while SQL Server 2005 was running.  Is there anyway to recover this deleted data?

    Tyecom5 pointsBadges:
  • Restoring a deleted table in SQL Server 2005

    How do I restore a deleted table in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 pointsBadges:
  • Stored Procedures in SQL Server 2005

    Will you please explain me about Stored Procedures in SQL Server 2005?

    Rajanarina110 pointsBadges:
  • SQL Server

    What is a tempDB in SQL Server?

    Sai5 pointsBadges:
  • MS SQL SERVER (BKUPEXEC) Services wont start

    Hi ALL, Background: Windows 2003 Server returned the error missing or corrupted file after the server was found OFF due to possible power problems (Server is on a UPS). Ran a CHKDSK on the server and it fixed the missing or corrupted file problem and server now up and running. Is seems that my SQL...

    Ahmyown30 pointsBadges:
  • Transfering table data from one database to another

    I am using SQL Server 2005 i m inserting some data from one database to another. both Servers are resided on different machine.

    Pankaja5 pointsBadges:
  • Duplicate SQL Server 2005 database

    What is the best way to duplicate a SQL Server 2005 database to another server as a standby machine? Can I do this with another installation and some scripting? I have a separate box with SQL 2005 already installed. Can I backup and restore from one machine to the other using scripts and no human...

    ITKE351,865 pointsBadges:
  • Avoid duplicate entry in database through Visual Basic 2005

    I have made a program in VB 2005 with SQL 2005 as back end. In the data base there are three fields which are unique id of a person. I want to display "Already Exist" message box when I enter an already existing id. matching all three fields and not allow duplicate entry.

    Sukas10 pointsBadges:
  • Sql server 2005 – query

    How to write SQL query to calculate second highest salary in Emp Table using "Top" Keyword

    DotNetj5 pointsBadges:
  • MS Project Server errors

    I have MS Project server 2007 (S1), Project pro (2007), SharePoint Server 2007 (language pack [Turkish] installed on Server 2003 with MS SQL Server 2005. I have only one farm. I can see when I create a project on server and client side. however whenever I want to see preview of a task, it gives an...

    Mahirkarabacak15 pointsBadges:
  • Calling a SQL Server 05 Stored Procedure from Oracle

    Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!

    Nikkipom795 pointsBadges:
  • How can we use SQL 2000 or latest with Visual FoxPro

    Hello Friends I want use SQL in visual foxprox. How can I do it? I ready many website, but all answer not fully cleared. Please send me solutions. My Computer (SQL Server 2005 and Coputer Name) name is SEMSVR. Waiting your reply.

    Abhiindia15 pointsBadges:
  • Adding a password to a SQL Server 2005 database

    We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

    SQL Server Ask the Experts2,585 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