Thanks for the reply. it work g8.

l0n3i200n

Thought so ... just wanted to be proofed wrong. Thanks for the reply thou.

G8 news

The latest service pack for sql 2005 now includes the drop statement option in the scripting wizard as a switch. I used it and it works like a...

Hi

I've just upgraded my sqlexpress version to SP2. It still doesn't include the drop statement. Do I need to set something to make it insert it or is my luck...

I sure am looking 4ward to it. Thanks for all the replies and advice.

Hi Sophie

I did notice the descriptions. I would think MS did remove the drop for safety reasons. ( or it can just be a plain bug ).  I'm running SP...

Thanks Grasshopper

This could come in very hand.

You could "borrow" the some of the rpt reports on SQL 2005. Should be somewhere in the SQL directory.

Hi Peter

It is possible to use the out parameter in a try catch block. Move the try catch into your stored proc. This will then everytime return the out parameter...

Gee I get the Noddi Badge for answering my very own question !!

The resolution is to specify an actual column name for the maximum...

Declaring a table allow you to do normal stuff on it and have a type specific column - you then don't end up with foat when sql can't do correct...

Hi M_shah

You could try to change the registry entry for the driver you are using, by default it is set to 8. Make it a bigger amount like 1000. I'm...