Cool. Thanks. I'll have to try that when I have some spare time.
>>Will that create the stored procedure on the back-end? Or will I have to load this text file every time I wish to execute a certain stored procedure?
>>
>
>No.. it stays there.. you are sending T-SQL to the back end...
>
>CREATE PROCEDURE sp_mynewproc AS
>SELECT Firstname, LastName, Address FROM Customer
>
>BOb
>
>
>
>>>>Hi John,
>>>>
>>>>OK, now I understand what you're saying, and yes, you've got a huge point. Never quite thought of it that way before. Now then, let me ask you this, because I haven't had the time to try it out: Can I programmatically create these stored procedures somehow? Or will I actually have to show up at a client site? (I hate wearing a suit and tie... <s>)
>>>
>>>You can create a txt file and send it to the back end as a SPT I belive. If not, the text file can be loaded into SQL Analyzer and run.
>>>
>>>BOb
Travis Vandersypen