We've had issues here with people using rules and missing newsletters, or duping them. I only use rules for moving things that I know I get to later, like newsletters.

I...

update a

set leasenumber = c.

from machineaudit a

inner join machinename b

on a.computername = b.machinename

inner join leaseinfoimport c

...

We'd like to see you do some of the work here. Why do you need to drop things in a temp table? If there are no records, then you can...

You want the 5 rows prior to this line?

SELECT top 5 [pkid]

,[log_content]

FROM [Handheld_Logs].[dbo].[sample_log]

where [pkid] + 5 > ( SELECT [pkid]

...

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