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

I look mostly at how you get along with others and how you fit it. We can teach you technical skills and how to communicate, but we can't teach you...

Hold up your thumb, point it at a ruler and guess 🙂

Seriously, there's good advice above, but for a new system, it could vary wildly. It the app is successful...