You'll want to run a server side trace to capture this information. You can build such a trace using SQL Profiler and then get the T-SQL to create and execute...

You can connect if you have a Windows account with the correct permissions (and that's the account you start up SSMS with). So you can manage SSIS from SSMS, you...

Yes, you can connect to SSIS from SSMS. However, you must do so using a Windows account. SQL Server logins don't work. Hence the reason you can't change the login...

If all you're doing is the reporting, there's probably no noticeable impact. The DDL trigger can be used to rollback the schema change (prevent it from happening), and that can...

It is important to point out, since I saw a reference to web applications, that SQL injection is not just limited to web applications. Any time you take unsanitized input...

blandry (6/6/2008)

---

I have never forgotten a guy I worked for who used to ask a good question - Is he/she an "expert" or "eckspurt" - the latter being someone with...

Sort of related...

When I was an electrical engineering major, I asked, "Why does it work that way?" I was specifically referring to getting complex numbers when doing circuit analysis. I...

Matt Miller (6/5/2008)

---

True...except for the Schema Change History report. That's one you apparently need to access from the SERVER name. So - same procedure - just right-click on...

You need to run the setup, just as if it were the first instance. The setup doesn't differ. Make sure you've got a LUN in a group separate from the...

Alter the table to add the new column SURVEY_JOB_CODE.

Execute an update statement which converts the data from SURVEY_JOB_TITLE (or do a lookup using a JOIN, if that's necessary) and put...

If you're using SSMS, right-click on the database itself. That'll bring up a pop-up menu which has a Reports option....

*shameless self promotion* For the question you asked here? The book in my sig. I wrote the chapter on DDL...

Reboot is usually required.

However, the other questions you ask is a bit harder to answer. Do you have enough physical RAM to support a 4th instance? Keep in mind that...

Been there, done that, albeit unknowingly. I used to have to send out contract updates when I was in the USAF. Had to send 'em out to folks all over...

Lynn Pettis (6/5/2008)

---

I'm sure that there are many out there that would disagree with you about having to know/write CLR sprocs before being considered an expert at SQL Server 2005....