Hi members is there away i can code this code into various variables that are dynamic in nature example
declaring the server, declaring the user name so that in case the computer name is changed, the system automatically reads the current computer and user name
2.i also get a problem when trying to save this stored procedure ie it produces error 7405 iam using sqlserver 2000
insert into testtbl(phone,address,city)
SELECT phone,address,city
FROM OPENROWSET('MSDASQL',
'DRIVER={SQL Server};SERVER=kabojja6;UID=makumbi;PWD=',
pubs.dbo.authors) AS a
ORDER BY a.au_lname, a.au_fname
declaring the server, declaring the user name so that in case the computer name is changed, the system automatically reads the current computer and user name
2.i also get a problem when trying to save this stored procedure ie it produces error 7405 iam using sqlserver 2000
insert into testtbl(phone,address,city)
SELECT phone,address,city
FROM OPENROWSET('MSDASQL',
'DRIVER={SQL Server};SERVER=kabojja6;UID=makumbi;PWD=',
pubs.dbo.authors) AS a
ORDER BY a.au_lname, a.au_fname