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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Bazzer

    DTS, Limit on Globalvariables in wizard?

    Hi, I wanted to create a package with multiple steps which required the same values as arguments to various stored procedures. However, I found that once I tried to use more than three global variables (I wanted to use five), the wizard wouldn't accept query. e.g. sp_mystoredprocedure...
  2. Bazzer

    linked server with the as/400

    Hi Mussa, The command I used to view the name of the SQL package on the AS/400 is &quot;WRKRDBDIRE&quot; (Work with Reational Database Directory Entry) which gives on our system 'RUMBA400', as we use WALLDATA's Rumba package to access the AS/400's. The string <AS/400...
  3. Bazzer

    linked server with the as/400

    My solution to this issue: 1. Set up an ODBC DSN using Walldata's Rumba AS/400 Optimized Server (32bit) driver. 2. Define a linked server on the MSSQL using the OLE-DB provider for ODBC and only enter the name of the DSN defined in step 1 against 'Data Source'. Leaving 'Provider String'...
  4. Bazzer

    correct UPDATE statement

    Hi Nanda, Try this: update test_1 set Score = B.Score, Reason_cd_1 = B.Reason_cd_1, Reason_cd_2 = B.Reason_cd_2, Reason_cd_3 = B.Reason_cd_3, Reason_cd_4 = B.Reason_cd_4, Reason_cd_5 = B.Reason_cd_5 From test_1 A, Test_2 B where A.program_num = B.program_num and A.test_yr =...
  5. Bazzer

    SQL Server Backup on network

    Hi Lynds Another option is to use a UNC, i.e. in the Enterprise Manager go to the Backup icon and add a new backup device by defining for example the file name : \\myserver\myshare$\mybackup.bak One point to remember is that the backup is controlled by the SQL server service and for this or...
  6. Bazzer

    Moving SQL Server to another Domain

    Hi Ian, Actually moving a host server from one domain to another is quite simple and does not affect the SQL server and databases. What may be affected are the remote connections. In order to answer that aspect of the question requires more information. Are you running on standalone servers...

Part and Inventory Search

Back
Top