The build you're on should include the fix for the connect item I linked to. You may have run into a new bug. If you can reproduce it submit a...

darren.franklin (7/13/2012)

---

In my organisation we have three main SQL 2005 servers: Development, UAT , Production (all standard editions).

We use versioning software to add schema changes made in development to UAT...

Just to confirm, both SQL Servers, the old and new, are in the domain correct?

If so, please run both of these from a cmd shell prompt on one of the...

which one, or both?

I suspect you're running into an issue where there is a registered SPN for the new server. What is the SQL Server service running as on the new server? Is...

Excellent, that was what I was hoping.

Renamed 3 more accounts today.

Last week,...

How is it going?

Sure, delete the SPN Kerberos is issuing tickets on.

Why would you want to do this by the way? Kerberos is preferred over NTLM as its viewed as more secure and...

Per this article each user connection to SQL Server 2005 uses Approximately (3 * network_packet_size + 94 KB).

I say 200 idle connections is nothing for a machine with those specs,...

I rarely recommend it, but in this case I would try bouncing the server.

Not sure what you're saying here.

But, my question is, if a server is...

Script Task Examples

Script Component Examples

That's great! I still kind of want to know if Joe Wu's post on ALTER LOGIN checks out or not 😉

Absolutely it makes a difference. Not all cloud solutions are created equal. With SQL Database on Windows Azure you get database redundancy as part of the platform.

In terms of database...

It depends on the cloud platform. Are you talking about Windows Azure w/ SQL Database, or one of the others?