first u should create user in ur test database on login SQLAdmin

second : give permission to created user or addrolemember to db_owner.

that's all.....

use [M1_0].dbo.<SprocName>

You should use convert/cast in your insert command.

try this:

SELECT substring(field,CHARINDEX('/', field)+1,4) from table

Hi people

AJ Ahrens right and u can add to DTS - Execute Process Task without using VBScript...