my screenshot is from a Win7 machine that had the SQL 2012 Developer Edition, with the full suite of SQL + SSAS/SSIS/SSRS installed.

no extra SDK's or anything, AFAIK.

i'd think you...

changing the collation of the database is only a tiny 1% piece of the puzzle.

every varchar/char/nvarchar/nchar/text column in the database has it's own collation, that is not affected just because...

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...