January 24, 2002 at 8:20 am
Hi All,
What I need to do is that within a VB application I
am calling the scptxfr.exe to get the structure of the database. Problem is
that when I manually create the script using generate sql scripts in
enterprise manager my VB application that calls the script runs smoothly. However when I use scptxfr.exe to create the database strucuture I am getting the grant and sysusers objects which I think creating a problem.
Can someone tell me how I could solve this problem? I hope I explained my problem clearly.
Thanking you in advance!
January 24, 2002 at 6:08 pm
Are you saying you don't want the permissions and users? If so, I don't see a switch with scptxfr.exe which allows you to choose. In this case, going with DMO is probably your best option.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply