The default trace might help, but not sure if this is recorded.

A 1GB increase isn't much. If it is, you might have other issues. You should also always have...

Please don't cross post.

surface area config.

It's not the worst thing if you enable this, but it can be a security hole. If you know the CSV format, why not use a SSIS package? You can...

Ahhh, I miss digging through code somedays 😉

You might use a CASE in here for your logic.

If charindex() returns > 0, then there is a semi colon in there (if you are checking). Then you can use...

Server (instance) properties or sp_configure under T-SQL, or use the Surface Area Config tool.

Roy, when you say promote and merge into the mainline, you really mean two developers communicating, correct? Someone has to physically look at the patch that occurred, and then type...

First, stop using the CTP. It's not supported and RTM has been released. Move to that. Likely it's a VS2008 conflict somewhere, which is why I'd say move to...

Not sure what those are. Typically there are LocalSystem, LocalService, and NetworkService as the accounts.

I agree with Nicholas, I'd set up domain accounts, no rights, and let SQL use them...

I'd check on what Grant suggested.

Also, is this a data problem in any way or just differences in the way that the code is being interpreted?

SQL Server connections are through a port/IP combination, essentially a socket. If you have 3 servers all on default settings, and 1 public IP, you cannot connect through 1433 to...

Dashes throw things off, only slamming everything together requires everyone to assume the same thing. I know, I know, it's annoying, but the rest of the world is different from...

There's no reason this won't work on a cluster, put everything on both sides and it should be fine.

Unless someone is nervous about it, and I understand that. If you...

Either an output parameter, or a return value, or you could return a one row, one column result.

In any case, I'd recommend OUTPUT parameters as well.

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/