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.

I think you're going to have issues with this view. I'd really look at tackling this another way, maybe breaking the information down, using a stored procedure to get parts...

I'm not sure what you mean? If you update the view, it updates the table. The view is just a window into the table, there is nothing in the view...

It's a security issue. Is this a job that's running on your workstation? Or is a remote server? Don't forget that pathing on the server is absolute to the server,...

It's always fun.

Who cares what they want. Change the label and color, and they're fine.

Heck, I could probably remove the scale, just put some indicators and lines for "relative" positioning...

One of the icons in Management Studio will do the scripting. Hover over them

Ah, no a Realist. Build a nice Fisher Price interface, similar to this one - http://www.fisher-price.com/img/product_shots/L3480_d_1.jpg, big buttons, lots of color, things moving, and you'll get a manager's attention everytime

:w00t::D