there's a combination of issues; You'll probably remember that if aany object starts with the letters "sp_", the query engine looks in the master database first....if not found, it looks...

sounds like even though your database is sql2005, the database compatibility is set to 80 and not 90, so you are still limited to SQL2000 based solutions.

couldn't find that extended proc on my SQL 2000; i believe it might be removed as part of a service pack, because i did find an article describing vulerabilities inolving...

the impact is very minimal; only if you replace a server does it require recreating logins/jobs/etc.

typically, you'd right click on my computer>>Properties>>Network Identification and give the computer a new name....

UPDATE statment? or do you mean ALTER statement? something like this would give you the statements to generate statments that had columns of type float to money, for example:

--select *...

not sure if any of this applies to you, but here goes.

For Reporting, because I don't want some report tying up my production database, I use log shipping to a...

incredible; 32+pages of Sergiy call everyone wrong-minded for even considering a business concept he doesn't understand/ chooses to ignore...because he wants to argue theory vs reality.

we all know there are...

it will use all virtual cores; the db system is limited to 4 physical cores on SQL standard, with no limit to the number of virtual cores.

the 4 CPU limit...

I might be missing something, but why not do it in a single set based operation?

INSERT INTO tAppUser(x,y,z)

SELECT x,y,z

FROM [Mercury Cvt Temp].dbo.tApplicationUser AS tAppUser

WHERE ....

the registered version of Winzip accepts command line parameters...which you could call from xp_cmdshell.

PKZIP/PKUNZIP is another program which can do the same thing. there once was a free verison of...

thanks Jeff...force of habit I guess.... I like to make code different from comments, so it's obvious what to copy/paste.

I changed it to syntax highlighting as best I could...certainly more...

hate to point out the obvious, but with only the tablename, sp_help lists the name of the index, and of course the column components of the indexes as well.

I had a...

Are you having trouble doing it? for me, it just a bunch of "Next" buttons in a row....the enterprise edition dummied itself down to the developer version, because the operating...

yeah this isn't all that easy...adn you can get bitten by the varchar 8000 length issue if the data you are combining gets much over 4000 chars...varchar(8000) + varchar(8000) ends...

sweet someone found something I wrote and it helped...i'm humbled