Search results for query: *

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...

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...

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'...

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 =...

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...

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...