You may be right, but it is not a matter of trusting the person (I surely do).

The problem is that, if a virus (or any security issue) reaches is user/computer,...

First of all, thank you for your help.

When I said that DBA had granted sa, I meant that they domain accounts had. They know sa password because they may need...

You're right. I'll send it again. 😉

Lynn,

I think the option you talk about would be the most appropiate. I've working around with it, but I end in the same point. Here is the code I run...

I didn´t like it at the beginning... ;-P

The point is that all 1000 parameters (o 100, whatever) will admit NULL. They are optional. The sp is going to create reports...

Hi!

Since SQL Server stores everything in tables, you can query the catalog to get this.

Table syscomments (in the same database you want to count code lines) you'll find at least...