We use validation scripts that set up test data, run the methods, check the results and output the information to a table, then query the results table. It is useful...

"If you subscribe to this nonsense and actually read it..."

Errmm...it's the only bit I get a chance to read on a regular basis because it is small, concise and generally...

Good question. I always like the ones where I have never heard of the issue before.

It didn't go down too well at my office either.

I only asked for a new monitor, which they would have agreed on, but not at the price of small...

Art,

When you say using an alert on an error number, do you mean a SQL Agent alert, or another type? SQL Agents won't work because the SQL Server instance...

...and if I run a file I could do something very simple like net send so they get an immediate alert when it stops, as well as something to log...

Thanks for the advice but Unicenter seems like a big hammer to crack a small nut and beyond the pocket of our client just to monitor one instance of SQL...

My two pennies worth is don't detail exactly what the stored procedure does, just create a general description. If someone needs to know the exact details they can look at...

The exams for a new product don't normally come out until six months after its full release, so you are looking at about a year before the exams and the...

I forgot all about this one

Two things we found out

1. Small business server does not like using '(Local)' as a database name. Specify the...

How come one of the options was not 'Because it's really, really bad database design and its ugliness rating has exceeded the allowable margins'?

I would have voted for that one...

Hi,

My two pennys worth

I personally think the stored procedure should return the data in the required format for the code. We have lots of code of the type:

if isnull(rs("Field1")) then...

The question should have detailed which version of SQL Server it was being applied to, as there is a difference between the two if you are on 6.5.

From SQL BOL:

The...

Comletely agree with all the comments posted above but they did not answer the question of when to use stored procedures.

The answer is 'All the Time'

We get the error when we try to connect using Query Analyzer so I can't post the connection details for that one, but our app use the following:

cnADO.ConnectionString = "Provider...