Unfortunately, I'm not sure what context you are talking about. There is the ability to connect to SSIS from SSMS, but that is limited, and I am using Windows...

SSIS is not instance aware, meaning you don't have multiple instances of SSIS on a server. One instance of SSIS is used by multiple instances of the SQL Server...

First, we can't help you optimize somethig we haven't seen (ie the query). Second it would also be necessary to see the DDL of the tables, have some sample...

SQL Server databases aren't like Access databases. The .mdf and .ldf files have to be connected to an instance of SQL Server database engine. Given that, anyone with...

I don't think the question was poorly worded. The question was, in my opinion, written to make you think, what are the possible answers? How many ways can...

Of course, first thing you have to do is define maturity.

😉

Per BOL, DBCC INDEXDEFRAG is fully logged, so changing to BULK LOGGED is still the same as FULL RECOVERY for this operation.

You may need to run the transaction logs more...

Grant Fritchey (3/19/2008)

---

Whoa! Hold on. Revelation! People who come out of college are mature adults? Hmmm... To ask this in the proper SSC manner, you have a test that proves...

The question was vague, make some assumptions. Again, how would YOU invoke the application role to accomplish testing of the role? How many ways can you invoke the...

Yes, you invoke the approle is vague, but purposeful. Put yourself in the position asked. If you are testing an application role, how would you invoke it? ...

Joshua - Read the whole question. It clearly states that you invoke the approle. How do you do that? You use sp_setapprole, therefore you are setting everything...

I did, and here is the question again with emphasis added.

"You are testing an application role in SQL Server 2005. You connect with SSMS, invoke the role, and then execute...

Joshua Perry (3/19/2008)

---

The answer is absolutely wrong. You can't use sp_unsetapprole because the cookie was never set using sp_setapprole. If you activate the app role before setting the...

Consulting? Involves a level of self-confidence and self-promotion that escapes me. I do some, for non-profits, for free. They love that they can write me off at...

The DBCC INDEXDEFRAG command is fully logged. There are several things you could do. The first question, however, is what is the current recovery model of the database?...