Ya I had to code for that once... Since I had a application I did 2 searchs... The first search was only considering objects with one entry, then the second...

SysComments is a system table that holds all the scripts of all the objects of the database (sps, triggers, views...).  So this technic is really fast an effective to find...

Check this out.

http://support.microsoft.com/?id=280102

Seems like a nice comprosime... but I hope you don't have 120 columns on that table because that'd be a b**ch to code .

If you create a perm table and 2 users run the sp at the same time you'll get a error...

Still waiting to see that code...

Can you show use the sp code so that we can provide an alternate solution?

Needed :

- Table definitions with indexes and keys

- Sample data (really helpfull if you provide the insert statements too)

- Required output from that sample data

- The query you are...

I've never seen a way to have total security with dynamic sql.. that's why i don't use it among other things.

Same difference.  Nothing stops the user from doing anything he wants.

the statement can be split like...

Select * from dbo.SysObjects ; drop table products ; select...

Nothing forbids him of doing that...

Depends of the key.  If it's an identity then no.  If it's another field like a date, then it could slow the inserts but it could also really speed up...

Basically if you generate the statement like this :

Select * from dbo.Users where username = '" & txtUsers & "' and pass = " & txtPass & "'"

All the user as...

In such a case.  You use views to block access to base tables and grant access on them.

Then you code a query builder and secure the heck out of it...

I would really use that as a LAST RESORT.  In 2000+ sps created I only had to use dynamic sql once, and it was for admin tasks.

Well it's not a syntax error for sure.

Can you post the rest of the tables definition (you can use enterprise manager to genererate a script for you).?

Can you run this query...

Why can't you just use a regular statement and create one Sp per statement?