Are you running on SQL Server 2005 or SQL Server 2000?

Looks like you are missing something, not sure what. I haven't created any tables to allow me to test, so here is something for you to test:

ALTER PROCEDURE ...

Can't do a thing without seeing your code.

😎

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