Use the create code and change to be "drop table xxx"

Remove all the column stuff

The beta exams are scheduled for Nov/early Dec. From my own publishing experience, this would mean that the live exams should release in Jan/Feb and at that time everyone will...

you could use a modulus 24 if need be with the math to "round" it back down, but you'd need to handle the math for the carry yourself as well.

Use...

I think I agree with Vinny

Do you mean different privleges "granted" for theses functions? Rights are setup by the administrator, not based on code in a function

Try these:

http://www.databasejournal.com/features/mssql/article.php/3489111

http://www.sqlservercentral.com/columnists/ckempster/sendingalertsviaacustomsmtpprocedure.asp

Peter's answers look good. As far as the heap. If memory serves, the pages are linked in extents and each extent that contained data would need to be scanned. These...

I've seen similar items with Excel. You might try a drop table/ create table (exec sql task) at the beginning of the package. I used to use two tasks and...

A sniffer would help here, need the network guys to set it up and that would help you backtrack. We had to do that one time at JD Edwards and...

Mike,

Thanks and I will. I heard from her Dad this weekend and she was still in the hospital for the time being, but I'll drop a few notes here and...

Sorry, the URL is the picture, but here it is:

http://www.rylishope.org

Keep thy enemy closer

As long as the ground beneath my house doesn't melt from the heat, I'm ok

My house a little outdated and not sure how...

, not sure about the next part. It's proving harder to get into words than I thought. And no cursing involved, that's the "Interview"...

Thanks for the criticism.

My point on the "put up with" comment was that I have seen many people that were not team players and were a pain, but they...