Hi Jason thanks for that.

I originally tried editing in SQLServer Management Studio (SMS) and a dodgy application, which didn't allow editing and created the post. That was misleading. I've...

Yes, I meant logins with SIDs. I've had trouble with this before where the logins came across but not the SIDs and I had to re do each one.

That did...

found the problem, it was the data, textcopy.exe must only allow 58 characters in it's file name.

code:

if datalength(@fullname)>58

begin

set @fullname = replace(@fullname,' - ','-')

set @fullname = substring(@fullname,1,58)

print @fullname

end

Thanks... me

here it is:

declare @fullname  varchar(100),

@runpath varchar(100), -- textCopy Location

 @srvr varchar(50), -- server TO LOAD

 @db varchar(50), -- DATABASE TO LOAD

 @usr varchar(50), -- login USER

 @pwd varchar(50), -- login password

 @tbl varchar(50), -- TABLE...

It seems the user is the owner of the DB objects, if logged in as that user I have owner permissions. i.e. the script does not grant permissions to the user...

thanks GregLyon for the crosstab. I've been looking everywhere to try and understand crosstab. I found yours worked well and I was able to modify for my purpose.

Thanks again

Bruce

thanks, but setting options wont allow me to restrict some dbo's and allow others access. 

I'm trying to find out about encryption.

Bruce

thanks

...oops

UNION ALL operator

thanks

I have designed my db and have been given this other thing to get the data from. I knew there must be a better solution, it's good. I've never seen...

all I get is "The command completed successfully."

this is the sp:

CREATE PROCEDURE dbo.uspNetUser

@user varchar(50)

AS

set @user = 'net user ' + @user + ' /domain domainname'

set nocount on

exec master..xp_cmdshell @user

set nocount...

I'll have to find out how to use net user.

Thanks.

Bruce

Thanks

I'll do that Monday. After posting the questions Friday I had some success exporting one table at a time using the upsizing wizard in Access.

Bruce

Thanks Troy. I'll keep working with the execute method.

Bruce

No, I'm scripting the whole database to create a new one. I don't use the Insert, Delete relationship. I find I have to manually change all table relationships.

Bruce