Grant Fritchey (12/28/2009)

---

50' is pretty good. Our driveway is over 200 yards long, so I don't have a blower, we have to have a guy plow it or we can't...

Agree there. Being a fan has nothing to do with thinking. The whole idea of rooting for someone else in a sporting event is kind of silly.

I started T-ball as...

I got my son away from Half Life 2 on the Orange...

What's your connection string?

Thanks for the votes. I've pinged MS, and been patient waiting for the one year anniversary of SP3 to roll by, but no responses. My guess is most of MS...

I've removed the drop table from the question. It was to do the cleanup in testing, but I agree that it confuses the issue.

You can't use mirroring and have read/write at both ends. Only replication will allow this.

I'm not sure if bidirectional transactional replication will work for multiple branches. It can definitely restrict...

information_schema.columns

Has data type, and lengths. Need to limit by column and table.

The CUs aren't regression tested, and do sometimes introduce issues. SPs include the CUs, plus potential internal fixes for things that were in a customer specific hot fix, or might...

There isn't a good way to do this. The export wizard will help, but you'll need to write scripts that would still find the client data based on criteria.

The easiest...

Selecting the execute permission in SSMS is the same as executing the GRANT in T-SQL. You should be fine.

The permissions are in the role, not the stored procedure.

The snow's up here in Colorado! We had a white Christmas with my oldest and wife going skiing 🙂

AFAIK, you cannot commit that transaction. How would the server know if all work has been done for the transaction? Another connection can't necessarily know that, so the only thing...

That should be fine, though a couple notes.

1. Should be OK, you didn't add the dbo role to this role, correct?

2. You add permissions to the role, you don't...

There is also Shared Scalable Databases (http://msdn.microsoft.com/en-us/library/ms345584%28SQL.90%29.aspx)

Or you can replicate read only data to other servers and have one central write server. As John mentioned, there is no load balancing...