• Migrate FROM SQL2005 Ent. TO SQL2005 Standard

    We recently installed and have been running SQL 2005 Ent. because that is what we planned to use. During the 180 day window our needs have changed and we purchased Standard edition rather than Enterprise. Now we need to migrate from Enterprise to Standard. My question is what is the best way to do...

    Jtncat5 pointsBadges:
  • indexes on a large table

    hello, i got a 5milion rows on a single table, my database is sql2005 and my select is : SELECT top * FROM tbl1 WHERE ip_from <= 3515134258 and ip_to >= 3515134258 the 3515134258 is on a sample but the format is similar: SELECT top 1 * FROM tbl1 WHERE ip_from <= [value] and ip_to >=...

    Bbbttt15 pointsBadges:
  • SQL 2005 trial version update

    I installed SQL 2005 trial version on a production server and the 6 months are almost up. I would like to go to SQL 2008 since I can get a very good deal for it. What options do I have? Can I just upgrade over the trial version or I need to uninstall 2005 and reinstall 2008. The 2005 is a trial for...

    Alan Dala30 pointsBadges:
  • Accessing an SQL 2005 Synonym with ODBC

    Is there a way to link to a synonym in SQL 2005 using ODBC and MS Access?

    Randym1,740 pointsBadges:
  • SQL 2005 and Security Account Delegation

    I read this feature for SQL2000 SP3 but I wonder if this is still valid for SQL2005 or, if it has changed which is the new feature that enables to retain the authentication credentials of the original client.

    alessandro.panzetta9,725 pointsBadges:
  • How to create a temporary table in sql 2005 via SSIS

    I need to load a flat file into a temporary table. So I need to know how to step by step how to in SSIS "Data Flow Task" create a temporary table, load one col from the flat file to the temporary table along with the date it was loaded. I will then use the temporary table to delete from another...

    NewBee7105 pointsBadges:
  • clustered sql 2000 to sql 2005 upgrade

    What can I expect when upgrading a clustered SQL 2000 box to SQL 2005?

    Ajf10 pointsBadges:
  • SQL 2000 and 2005 Offline Table Reindex Determination

    Hello, I have prcessed SQL 2000 offline reindexes in the past for specific tables when there was scheduled downtime, but I was wondering if there is a tool or script that I can run for a specifc SQL database to determine which tables in the database would need to be reindexed. I do not want to...

    Bankerdba5 pointsBadges:
  • PHP or HTML

    I need to create a database that allows a user to query info. on a project,name, proj number, contacts, contact #, etc. We are using SQL 2005. The office manager will enter info. about each project into an access form. Then, from the HTML page a user can f search by project name or number to list...

    Caddman35 pointsBadges:
  • I need to move a sql 7.0 database to a different server running sql 2005.

    What would be the best way to do that and will the jobs and DTS jobs come with the database? If not how can I move them also. Thanks for any suggestions.

    Bubbanm90 pointsBadges:
  • Move/Copy System DB’s to new server in SQL 2005

    Trying to move system DB's to brand new server (really virtualized server). Server names are different. Any suggestions would be appreciated.

    Seandon5 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