I guess i haven't figured out what kind of access you are trying to grant to others. That really hasn't been mentioned, or else i just have missed it.

I...

Joshua Perry (3/19/2008)

---

You can scale out with a cluster, but you need to think about the bigger picture. Picture a four node cluster with all the nodes active, each...

GSquared,

Good example of how CTE's can help make some code easier to read and/or maintain.

😎

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...