Re: stored procedure
From: Anirban (tulu_paul_at_hotmail.com)
Date: 11/23/03
- Previous message: Sue Hoegemeier: "Re: Norton Antivirus Malicious Script Message"
- In reply to: Dejan Sarka: "Re: stored procedure"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 24 Nov 2003 00:34:46 +0530
Thanks Dejan Sarka
Siince I am a new person in this field I was expecting answer with the
code also.
Anyhow Thanks again,
Paul
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
message news:#FXAJ0ZsDHA.1996@TK2MSFTNGP12.phx.gbl...
> > 1. How can we write to a text file using stored procedure.(what is the
> > code)
>
> You can use xp_cmdshell and call osql.exe from there. Not an easy task.
You
> can use DTS as well - much,much easier.
>
> > 2. I wrote some stored procedure, and I donot want any other person to
> view
> > it. How to achive this?
>
> You can create procedures using the WITH ENCRYPTION option.
>
> > 3. Where does the stored procedure get stored (which direectory)?
>
> Like all SQL Server objects procedures are stored in databases. Databases
> consist of physical data and log files.
>
> --
> Dejan Sarka, SQL Server MVP
> Please reply only to the newsgroups.
>
>
- Previous message: Sue Hoegemeier: "Re: Norton Antivirus Malicious Script Message"
- In reply to: Dejan Sarka: "Re: stored procedure"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
