That's what temp tables are for ... 

If you have that many regular tables that you use for intermediate processing and you leave them all hanging around, why not just create...

I don't know of any reason to try to manually manage tables yourself directly in tempdb.  If your guru gives you a reason, I'd love to hear it

Ahhh, SSIS on 2005.  I haven't had a chance to do anything with it yet myself, but I ran across a demo webcast on MSDN:

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050512SQLServerDF/manifest.xml

I don't think there are any performance advantages.  Any performance advantages will come from proper table structure and indexing.  Personally I would advise against explcitly creating your own tables in...

SQL effectively ignores extraneous padding at the end of character types when comparing them.  What's the code you're using and your platform?

I don't know of any free tools.

Take a look at the documentation   If you specify NULL as password2 for the Master Key, it ties data encrypted with it to...

Extended stored procedures live in the master database.  The script to install the functions should be installing them to the master database as well.  Did the install script you downloaded...

And why did you give a malicious user a login to your server exactly?

I think General Patton said:  "Fixed fortifications are a monument man's stupidity."  Same could be said for "generic" database applications.

Two comments about the sp_OACreate method -

1) VBScript doesn't support many regex features that are standard in Perl (lookbehind, atomic grouping, possessive quantifiers, \A, \Z, etc.) 

2) sp_OACreate can cause...

Here's a suggestion:

- Get the DBA Toolkit at http://www.sqlservercentral.com/columnists/mcoles/sql2000dbatoolkitpart2.asp

- You can validate email addresses based on a regular expression similar to the following:

SELECT dbo.fn_regex_match ('^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$',...

You got my vote   In that Celko quote, I think he was specifically referring to a Primary Key.

No problem.  Just remember, reusable doesn't necessarily equal stored procedures.  If you're building a 3-tier or n-tier app, you can use parameterized queries to great effect in the middle tier(s).

Good...

You could execute all of your 91 queries from a single Stored Procedure...