• SQL 2005 SSIS Package to load table from positional flat file

    I have a positional flat file which I need to load contents into a SQL table. I've created an SSIS package and will need to call a VB script to parse the file but since I'm new at VB and SQL I need some assistance creating the VB script. There are 4 fields in the table I need to populate. The first...

    Dacker5 pointsBadges:
  • SQL Server 2005 Select Multiple views or Tables

    in SQL 2000 it was easy to cntl-right-click and select multiple views, stored procedures or tables and generate one script which could be changed (using SQL Analyzer) to create new objects (search and replace text) with different names. This was a big time saver but I don't know how to do that in...

    SapwizSAP5 pointsBadges:
  • Reporting and Mirrored SQL2005 DB

    Can i access the sql2005 mirrored db via crystal reports for reporting

    Civmailman15 pointsBadges:
  • Virtual machine setup – SQL 2005

    I’m setting up a virtual machine -- SQL 2005 install -- and I want to make a separate drive for the logs and one for the data, but as this is a virtual environment using the same mirrored physical disk, is that advisable?

    BladeMarvel35 pointsBadges:
  • How to move the msdb database to sql 2005

    I have a server running sql 7.0 and I need to move the msdb database to another server running sql 2005. When I try to restore the db from a backup I'm getting a compatability error message. Any suggestions greatly appreciated.

    Bubbanm90 pointsBadges:
  • Address segregation in SQL 2005

    I am working in SQL 2005 and would like to parse an address filed such as "1234 N CLARK ST APT 111 " into seperate fileds like House Number/Street Name/Street Type ie LN ,ST, or Cir/Apartment Number

    Dkrueger40 pointsBadges:
  • SSL on SQL 2005 Express

    Hi, I am attempting to encrypt the connection string to/from my database server. I cannot seem to find guidance on where [what directory] to place the CA certificate. I am working with a Windows Form application that call to the data store. Any assistance will be appreciated.

    ETCGMan40 pointsBadges:
  • How to write Bcp command to insert data in to a table

    Hi, I have a file which contains the data 2:23:3#1:2:4#2:3:5 i have to insert the data in to the table in multiple rows from a single file as #--indicates to be inserted in next row : --indicates next column column1 column2 column3 2 23 3 1 2 4 2 3 5 I need to use BCP. Can any one let me know how...

    GIG240 pointsBadges:
  • SQL SERVEUR 2005 SISS AND WHERE statement

    I create a SSIS to transfer the date from AS/400 TO SQL Server 2005, and it's work fine. when I go to modify it and I add a where statement to choose only the year 2008, I received the following error code 0x80131937

    Sqlbeg5 pointsBadges:
  • Limit admin access to a single database SQL2005

    I want to set up an account similar to sa but limit the rights to a particular db.

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

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