Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to answer negative VFP attitude? Help...
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00427554
Message ID:
00431246
Views:
13
>>Oh please! The chances of someone figuring out the name of the SP and what
>>parameters to pass, and in what order is nearly impossible.
>
>Oh yeah?
>
>Try this:
>oSQL = CREATEOBJECT("SQLDMO.SQLServer")
>oSQL.LoginSecure = .T.
>oSQL.Connect("CHARLIESSERVER")
>oData = oSQL.Databases("CharliesVerySecureDatabase")
>FOR EACH oProc IN oData.StoredProcedures
>	?oProc.Name, oProc.Owner
>	?oProc.Script
>ENDFOR
>I just discovered the name, owner, and script of every sproc in your database.
CREATE PROCEDURE ThisOneIsReallySecure
WITH ENCRYPTION AS
SELECT "Try to read this one, Erik!"
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform