Hallo Frank,

I gratuliere dir und deiner Frau an ihr neues Kind!  Es wird ganz schoen, eine kleine Tochter im Haus zu haben.  Viel Glueck!

Ron

"I congratulate you and your wife on...

These questions are very easy.  You should be able to expect a jr level person to answer most of them.  An inability to answer them when they are applying for...

In the case of a web app, if you are using MTS, you would check the security there.  I don't think MTS is in widespread use, but this is one...

A great way to also the filename is to store it as a global variable, and then use an Active X task in the data pump to import that variable...

Just one comment on technique here:

You can return a recordset using the Execute SQL step by retrieving it into a global variable.  (SQL2K+)  You can also return and manipulate a...

At first, I didn't realize you were using one of the system stored procedures.  The @@rowcount is most likely not working here because there are a lot of procedures going on...

You need to provide the code for the SP and the TSQL then, because the @@rowcount is a very basic function, and I've never seen it fail when used correctly.

Are you by any chance running the SET NOCOUNT ON command anywhere against the connection?  It doesn't just have to be in the SP.

Are you using a middle tier object and ADO?  If so, you can use the RecordsAffected option.  It is important that no SP on the connection uses the SET NOCOUNT...

An AKO account is an army mail/access account, and so yes, I can access https//.....mil addresses.

Thanks.  I have an AKO account (Major, US Army Reserve), so if your report is on a public military site (ie one available to the general military public) I would...

I've often used temp tables to first construct the initial parameter set, then execute an SP which joins to the temp table.   Your looking at at least two SPs, and...

If it were only for me, the Excel solution is exactly what I would do.  I'm trying to make an internal customer happy, however, so I'm searching out alternatives.  Thanks for...

Yea, actually I knew they were on the same server, or else you would would have had to have had the server name as the first part of the name.

There's...

I think the issue is the update is to a different database.  The cross checking may be enabled, which would cause the permissions to be checked for the second database. ...