I don't know of any software like this for end -users. Many packages will export to Word or HTML, so maybe you can keep a copy in one of those...

The only way to do this that I think of right now is with Dynamic SQL, which I don't recommend.

I'd just build in the time it takes to make the...

You must be adding data to the mdf, as mentioned above. That's why it grows. To stop it from growing, stop adding data.

You should have an idea of growth and...

I'd use Sergiy's method, but if you don't want nulls, use

if @x is not null

instead. It's cleaner.

Are you connecting with TCP/IP? It's possible that SQL was installed without TCPIP. You can check the beginning of the SQL Server error log to see which IPs it's listening...

The proxy needs to know to forward port 1500 to the outside IP. I believe by default this is not the case with most proxy servers.

Be sure their firewall also...

It will never happen. When will we eliminate shoplifting? Never. As long as we want the richness and flexibility, there will be issues.

What we can do is do a better...

Do you mean you have a Word document you want linked with a record?

You can store the Word file in an image column in SQL Server, but you'd need to...

Start as in run or start as in learn how to build them?

Usually they are scheduled as SQL Agent jobs for running them.

For learning, search Integration Services on this site...

I'm not sure what you mean the same ID is different data types?

That alone could cause issues. Why not make separate stored procs for each database? It's not much work...

You call it like you would a stored procedure. It returns values to your datareader.

http://support.microsoft.com/kb/329497

I vote for Grant's. That's beautiful.

I can only guess that it gets a schema lock on the trigger, tries to get one on the table, but another process has gotten a lock on the table,...

Can you pull it back in a SELECT statement?

Meaning if I give you a sponsor ID, can you not just query for the sponsor name?

It doesn't appear obvious why you...

How is it configured? I assume you have PAE set up and SQL set for a specific amount of memory?

Which counters are you checking to get your numbers.