I believe you can extract it from the GAC:

C:\Windows\assembly on my machine, and i see

pulling stuff out of the GAC is tricky, i did it in the past for...

like homebrew stated, it's easy to change the limits on the history:

right clicking on SQL Agent and go to Properties (in SSMS Object Explorer)

find the history tab.

Personally, I'd prefer to...

i googled for "payroll database examples"

and went for images related to the search;

this is the first one tha it saw that appealed to me, but it's really up to you...

once per batch.

you can get the count of records affected from the inserted table itself, if that's what you wanted to track:

SELECT COUNT(*) As RecordsAffected FROM INSERTED

i just built this same report for my job...small world, what with the new rules for not getting paid if a re-admit occurs within 30 days.

without the sample data Sean...

there's not multiple instances, right?

you know you used lower case -s and not uppercase -S? and the parameter flags are case sensitive

based on what you posted, this should be working

SQLCMD...

isn't that always the way it works?

i install all kinds of stuff locally, but never have time to dig deeper into the details...

until a fire comes along and...

so wierd;

i speak spanish, albiet not as a primary languange, but i had no trouble with the error messages, it's just the error says syntax near BEGI and not...

it took me longer to build your sample data from what you posted, than it was to create the solution.

help us help you!

if you post consumable data, we can help...

hada for me, the maintenance plan is outdated and not really good for production; it's fine for shops with no DBA, but I would strongly recommend replaicng it with the...

just a shot in the dark here, but this specific error:

Sintaxis incorrecta cerca de 'Begi'.

to me, that implies that a string, say a VARCHAR(50), had a command in it longer...

it's an issue of scope;

the error log is targeted for things that affect the server itself; stops and starts, hardware errors,dropped connections, etc all appear there.

From a SQL standpoint,...

i believe sp_addserver is used internally when you add a linked server.

having just replaced a server recently, this tidbit might be of some help.

we create a machine named APP-TEMP to...

that's still a logical decision; from a static code point of vew, you could check if any procedure had a cursor: that would imply that it is calling some code...

this query would be an order of magnitude faster (at least!) for getting row counts per table.

something like this is what you'd wnat to wrap with sp_msForEachdb:

...