Thanks for the help! The brackets around the ? fixed my problem. I think the other issue was not that the name was long, but that there was a dash...

We are using approles for all updates, inserts, and deletes. The issues we run into involved using things like a gridview. We haven't found a way to set the approle...

Great - thanks for the help. I'll try this.

That worked great.....unfortunately I am being told it needs to show the week beginning date - it always has to show a Monday (even if run on Tuesday or Wednesday)....

Would it make a difference if the databases on this server were on compatibility level 80?

Here is the actual code (from an execute SQL task in SSIS):

BEGIN TRAN

UPDATE ASSET_EQUIPMENT

SET [UPDTTS] = B.UPDTTS

,[Company_Nbr] = B.Company_Nbr

...

I did follow the instructions and everything looks okay. Our failover tests have been with very little activity. This is an Active/Active cluster with multiple instances of SQL installed. My...

I have tried the install that way. I don't know why it isn't working. Now, though, SQL is already installed with an admin account and I cannot change it. Has...