I also agree with Gail. I would look at how you are making changes on a fundamental level. Create yourself a deployment document with steps and check lists....

Look at User Defined Data Types in Books Online. You can create a data type of your choice and give it a check constraint and default value in a...

The main impact will be if you run any other services, applications, etc on this machine. As now their thread priority will be dropped and you will see poorer...

You may have an issue with your VPN setup. Kind of hard to tell without knowing more about your setup. Can you ping your test server, telnet, or...

Yes it is possible in VMWare Server (and I assume as well in Microsoft's tech as well) as I have set this up in a lab. I do not however...

On the first item do you need the decimal data still there? For example if the field contains data like 123.45 do you need 123 or 12345? If...

Don't make it a subquery. There is no need. Just select the max value for the colum in a standard select and insert the variable value for...

You could also try...

INSERT INTO Items ([PartNum], [ItemOrder])

SELECT @Part_Num, MAX(ItemOrder)

FROM TableX

WHERE TableX.Part_Num = @Part_Num

You wont find any stock components in 2005 to write image files out directly using T-SQL. My suggestion would be .NET code or use of SSIS. SSIS has...

Depending on the quantity of data you may want to look at SSIS. You can read the source data and use a multicast component to create multiple feeds of...

Thank you. Seems to work well.

Thanks. This seems to work well with the small test data I have setup.

If you are testing this across two machine then likely the issue is not service packs. Its probably a difference in hardware, install settings, configuration etc. That being...

One option is that you can send error rows to a seperate output flow. So send them to another task like writing them to an error table or file....

Decided to do a quick search and found an arcticle referencing this code. Seems to work on my 2K5 cluster.

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') ActiveNode