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

permissions due to a service pack:

http://support.microsoft.com/kb/328151

You need to have admin rights, and this switch must be called in order to restore debug rights:

Exec sp_sdidebug 'legacy_on'

HTH; i ran into the...

also search for the Split() function in the scripts...there are several, and some return a table with multiple columns (ELEMENT,ELEMENTID), some just return a single column, etc. the split a...

could it be a permissions issue? you might have SELECT permission in the master database, but NOT dbowner (so that you can CREATE VIEW) in the other database? what user...

to use the in function on a string, you'll need to grab one of the many SPLIT functions that are in the script contributions here.

otherwise, you really would want...