source for scptxfr.exe utility

Paul Bruno

unread,

Feb 21, 2002, 10:44:00 AM2/21/02

to

Does anybody know where I can get the source, or samples of the source
used in the SQL server scptxfr.exe utility?

I need that functionality, but do not want to have this utility on the
box. I need to prevent users' curiosity and running the tool causing
high cpu.

Paul Bruno

Narayana Vyas Kondreddi

unread,

Feb 21, 2002, 11:18:16 AM2/21/02

to

Paul, you can do the same using SQL DMO scripting features. You can find SQL
DMO documentation in BOL and in MSDN.
--
HTH,
Vyas, MVP (SQL Server)
Check out my SQL Server website @
http://vyaskn.tripod.com/

"Paul Bruno" <getw...@sprynet.com> wrote in message
news:f48da4f5.02022...@posting.google.com...

lindawie

unread,

Feb 21, 2002, 1:48:49 PM2/21/02

to

Paul,

You can also use the freeware utility ObjectScriptr to generate ddl.

Download it from http://rac4sql.home.attbi.com.

Linda

"Paul Bruno" <getw...@sprynet.com> wrote in message
news:f48da4f5.02022...@posting.google.com...

oj

unread,

Feb 21, 2002, 1:55:42 PM2/21/02

to

linda,

heheheh...there is an updated version of ObjectScriptr. have you downloaded
that one.

--
-oj
http://rac4sql.home.attbi.com

paul bruno

unread,

Feb 21, 2002, 2:41:14 PM2/21/02

to

Thanks Linda, but this won't work for me.
I need to do all this programatically from remote client application. I
have a console application/server process that will be invoked remotely
and call's scptxfr.exe dumping the db to a file, run a hash to get a
32bit crc, then compare the crc with some baseline crc's that we have
established.
Basically monitoring any and all database changes [less the actual data
of course].

I need to get the actual c/c++ code that MS is using in the scptxfr.exe
source and write that into my application, hence avoiding the need to
use scptxfr.exe or any other MS or 3rd party tools.

Paul Bruno

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

paul bruno

unread,

Feb 21, 2002, 2:45:09 PM2/21/02

to

Thanks Narayana, I'll take a look at that.

oj

unread,

Feb 21, 2002, 2:55:44 PM2/21/02

to

paul,

i wrote a little sproc the other for Floyd in .server group. see if you can
use it.

--
-oj
http://rac4sql.home.attbi.com

"paul bruno" <getw...@sprynet.com> wrote in message
news:e90O6#wuBHA.2020@tkmsftngp02...

paul bruno

unread,

Feb 21, 2002, 3:45:16 PM2/21/02

to

I found the thread. Thank you.

Paul Bruno

unread,

Feb 22, 2002, 1:00:29 PM2/22/02

to

Oj,
I haven't done any programming with stored procedures, can I put this
code in a .sql file and run it via ISQL or something? Would it need
changes?

Can you recommend some doc's or an informational, not_to_large book
that might be of help to me?

Thanks,
Paul Bruno

paul bruno <getw...@sprynet.com> wrote in message news:<#U7JsixuBHA.2644@tkmsftngp05>...

oj

unread,

Feb 22, 2002, 1:17:15 PM2/22/02

to

paul,

yes, you can extract the core code and put it in a .sql file and run it with
isql/osql -i.

one thing to be aware of is that, as a stored procedure, you can pass
parameters to it. as a script, you have to define the parameters upfront.

here is a basic sample of what a script looks like...

declare @sdb sysname,
@tdb sysname

select @sdb='northwind', @tdb='pubs'

exec('select orderid
from [' + @sdb + ']..orders
union select titleid
from [' + @tdb + ']..authors')

oh, vyas has some info on sqlbooks @ http://vyaskn.tripod.com

hth.
--
-oj
http://rac4sql.home.attbi.com

"Paul Bruno" <getw...@sprynet.com> wrote in message
news:f48da4f5.02022...@posting.google.com...

Narayana Vyas Kondreddi

unread,

Feb 22, 2002, 2:52:42 PM2/22/02

to

Yeah :) Here's the link to books: http://vyaskn.tripod.com/sqlbooks.htm

--
HTH,
Vyas, MVP (SQL Server)
Check out my SQL Server website @
http://vyaskn.tripod.com/

"oj" <nospam...@home.com> wrote in message
news:#FDc908uBHA.1684@tkmsftngp04...