That would be a problem only using dynamic sql. And the users would need that have explicit permissions on the base tables to be able to do any damage....

That would take a combinaisonn of having all users be dbo and also using some sort of dynamic sql.  2 of the worst practices combined with a malicious user.  You...

Please do not cross-post. It's easier to follow only one thread.  Finish this discusison here pls :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=323833

This is why he asks you to backup and restore the system databases first.  This is where all that info is saved.

Me too but I can only work with the queries I'm presented with!!!

Well not quite but I got other things to do ATM .

Just pass the column names in parameter.  I mean you must know 'em somehow since you create the temp table??.

Also you can get the objectid using object_id('tempdb..#ShortTableNameWithoutGarbageCharactersToIdentifyItFromOneSessionToTheOther')

That way you can...

I never had to report an error to microsoft.  Search on MS site.. you should find a way to do it.  Other  than calling Bill directly

Happy to help.  keep us posted on this pls.

I see said the blin man.. I guess there are always exception even for set based processing on sql server .

It adds 2.7 days to the current datetime.

The best practice is to use the dataadd function but there are exceptions to that .

And I think we got a few of those around here .

That should give you enough time to take a cofffee break .

Don't bother dropping it????

So what happens if all your application stopped using the lines :

MyCn.Close

SET MyCn = Nothing.

Would you still consider this a good pratice

Please post some sample data and the required output from that data.  We won't be able to help without that!

I might solve the compile error.  But it would also change the logic of the case statement.  I'm not sure it could work for him at the moment, and for...