471,305 Members | 1,214 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,305 software developers and data experts.

Problems running a SP in VB.NET

I have created a stored proceedure in Query Analyser and saved it to my SQL
Sevr2K DB. The SP deletes and recreates a table then inserts rows to it based
on parameters sent to it when it is called. SP works fine when called from
QA. When called from VB it does not delete and recreate the table but does
insert the rows of data.

Am I missing something, perhaps a permission setting?

--
Regards,

William

Jul 21 '05 #1
0 905

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Ed | last post: by
2 posts views Thread by Ellen Graves | last post: by
2 posts views Thread by Tim V. | last post: by
8 posts views Thread by Michael C | last post: by
4 posts views Thread by louise raisbeck | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.