I was able to get it to work. Thanks to everyone who replied with ideas.

this is the final code to generate the report:

DECLARE @curDate datetime

DECLARE @PriorMonthStart datetime

DECLARE @PriorMonthEnd datetime

DECLARE @sqlcmd...

Thanks for the reply Hall of Famer!

The data type of column LoginDate is smalldatetime

Yes, there are qualifying rows in the table. I have confirmed that (more than once 🙂

You could...

... to review the situation:

If I remove the WHERE clause from the Select stmt, it generates a report - even when I run it in SQLCMD.

Does SQLCMD not like something...

Thank you, patel_mayur.

Print @sqlcmd; shows ....

sqlcmd -Q "SELECT ServerName as Server, LoginName as FailedLogin, ClientName as ComputerName, LoginDate FROM DBA.dbo.AuditDatabaseLogins WHERE AuditType = 'Login Failed'

AND...

Your idea worked perfectly, bteraberry. Thank you.

Now I have a different issue but I will start a new thread for that.

John

Thanks bteraberry. you are so right. I will try your idea tomorrow and reply with the results.

John

Thanks, vstitte for confrming. Here goes .....

John

Thanks Kenneth.

I rebooted a few times (after doing various things) but the sbevent.rll was always locked.

I used this wonderful tool named 'Process Explorer' to find which service/process has the file...

Perfect, Ten Centuries. This is exactly what I needed! We do have to keep those auditors happy 🙂

Thanks very much. John

Thanks so much for taking the time to reply, everyone.

Jetro, I tried your code and had several errors, had to move on.

Edward, I will try the web page you recommended...

Jeff,

I will (manually is ok) copy the resultset into an Excel sheet.

Tracking database sizes first day of each month.

Ideally need the sizes (Qty) to be in separate columns.

Thanks, John

Now that looks promising.

Thanks CozyRoc.

Anyone?

hehe. When someone in Tennessee asks me "what part of texas are your from?" I usually reply "the God-forsaken part". 🙂 I'm from west Texas - Lubbock and Midland-Odessa. The...

Thanks, Tim. I'm happy to hear the FTP Task is fairly reliable.

I have good news. I first created a new package on the same server that the other package was...