Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Yaniv72

  1. Yaniv72

    BCP utility - get the column's name in the text file

    Hi all, i have created a text file by exporting the data to the text file using bcp utility.i found that i havent got the field/column names in the text file.is there anyway i can export the column names to the file. I'm using a .fmt file for the export. Thanks, Yaniv
  2. Yaniv72

    A migration question

    Hi, Please read the section 'Upgrading Databases from SQL Server 6.5 (Upgrade Wizard)' in the Books Online of SQL 2000. You will find all the information there. I made the upgrade,few years ago, from 6.5 to 7.0 and it's not a big deal. As far as i can see you know what to do (steps 1 -> 4) Good...
  3. Yaniv72

    Get username & password?

    Hi, You need to write code using the SQL-DMO API. Yaniv
  4. Yaniv72

    A migration question

    Hi, On the Sql Server 2000 there is a tool called: 'Microsoft Sql Server - switch -> Sql server upgrade wizard' Use it. Yanuv
  5. Yaniv72

    @@IDENTITY versus IDENT_CURRENT()

    Hi, You can also use the SCOPE_IDENTITY( ). Please check it in the BOL. Yaniv
See more

Part and Inventory Search

Back
Top