Thanks jshailendra.

I have been running with this in production for about 6 months now without issue.

Jack,

I haven't worked that out yet. I'm fortunate to not have to deal with that issue yet. I did find an article that looks like it might provide a solution...

Isn't the term is Accidental DBA and not volunteer DBA?

@CornholioDBA

Sorry for the delay. I've been out of town all last week.

Yes, this will handle even very large stored procedures. The only thing you need to watch for...

Thanks Greg. It great to find these predesigned solutions.

One question though. Is the "Fast Track" optimized for only data warehouses? We do have a lot of OLTP too.

Roy,

Thank you! Very cool site.

Thanks Lynn, Greg, & Steve. I think I see the error of may ways now. Let me define this a little more.

It is a single cluster environment (1 active, 1...

Ok Lynn, how about this:

If you had $200K to spend on hardware, including storage, for an SQL server setup what would it be?

Hi Lynn,

I guess I should have clarified a little more. The stuff you mentioned is what I am looking for. Should I go with a NAS or SAN, how many...

Thanks for posting that. I noticed the same thing but thought I had missed something.

Any idea what the alternative is? I expect using SUBSTRING.

Sorry, Can you give a little more detail?

I think what your saying is to create a database role in each DB and give that role the permissions that I want...

ODBCad32

Very cool. Thanks. This will save me time when setting up users ODBC.

In the way that I have used ODBC with Access is that I created an ODBC for each database that I wanted to connect to. When you create and ODBC...

Very Cool!! I had no idea. Below is an example I found in the Books Online.

-----------------------------------------------------------------------------------

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/03a80e63-6f37-4b49-bf13-dc35cfe46c44.htm

B. Creating a log table with event data in a DDL trigger

The following example creates...

Hi textman,

I am assuming you mean to EXECUTE a stored procedure. There is also the ability to view only the stored procedure.

Below is what I use to allow a user...