Query to determine which DTS have sa hardcoded

#1

I am looking for a query I can run that will tell me which DTS packages have
sa and password hardcoded into them. I'm not sure what systems tables to
look at. Does anybody know?

All ideas are appreciated!

Thanks,
Mitch

#2

you wont find anything in a table, you could use the Package SQLDMO Object
to iterate through the objects in the package in a script

"Mitch" <Mitch (AT) discussions (DOT) microsoft.com> wrote

Quote:

I am looking for a query I can run that will tell me which DTS packages
have
sa and password hardcoded into them. I'm not sure what systems tables to
look at. Does anybody know?

All ideas are appreciated!

Thanks,
Mitch

#3

And how do I start that?

"David J. Cartwright" wrote:

Quote:

you wont find anything in a table, you could use the Package SQLDMO Object
to iterate through the objects in the package in a script

"Mitch" <Mitch (AT) discussions (DOT) microsoft.com> wrote in message
news:0D28F43E-B519-435F-95D4-F64667A6B31F (AT) microsoft (DOT) com...
I am looking for a query I can run that will tell me which DTS packages
have
sa and password hardcoded into them. I'm not sure what systems tables to
look at. Does anybody know?

All ideas are appreciated!

Thanks,
Mitch

#4

what do you mean by start ? as in execute or start building the solution ?

http://msdn.microsoft.com/library/de...thobj_0zlg.asp

"Mitch" <Mitch (AT) discussions (DOT) microsoft.com> wrote

Quote:

And how do I start that?

"David J. Cartwright" wrote:

you wont find anything in a table, you could use the Package SQLDMO
Object
to iterate through the objects in the package in a script

"Mitch" <Mitch (AT) discussions (DOT) microsoft.com> wrote in message
news:0D28F43E-B519-435F-95D4-F64667A6B31F (AT) microsoft (DOT) com...
I am looking for a query I can run that will tell me which DTS packages
have
sa and password hardcoded into them. I'm not sure what systems tables
to
look at. Does anybody know?

All ideas are appreciated!

Thanks,
Mitch

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Query to determine which DTS have sa hardcoded

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Query to determine which DTS have sa hardcoded - 09-15-2005 , 10:26 AM

Re: Query to determine which DTS have sa hardcoded - 09-15-2005 , 11:10 AM

Re: Query to determine which DTS have sa hardcoded - 09-15-2005 , 11:26 AM

Re: Query to determine which DTS have sa hardcoded - 09-15-2005 , 11:31 AM