Activity overview
Latest activity by iposner
Support for Rational Team Concert
I have a client that uses Rational Team Concert for source control. I note that the marketing material states that SQL Source Control can work with any source control system that supports a command...
The culture specific comparisons in .NET have nothing to do with the SQL Server default language. In the reported bug scenario, the user sesson on the workstation was UK english, but the default language for the connection was British English. When the SQL Server default language for the connection was changed to English (US), everything worked.
Most people don't realise it - regardless of the local workstation settings, they connect to SQL Server using the default English (US) language, so don't experience the problem. / comments
The culture specific comparisons in .NET have nothing to do with the SQL Server default language. In the reported bug scenario, the user sesson on the workstation was UK english, but the default la...
Error: The conversion of char data type to smalldatetime...
"The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value."
SQL 2005, British English connection using SQL Data Compare 7.1.0.245.
Changing my def...
I think the answer given is very shoddy. If there is a problem with sp_rename not changing the syscomments definition, then it should be escalated to Microsoft to provide a fix.
I'm sure they will listen far more attentively to a major toolset vendor than to individuals.
Having said that, it is not beyond the capability of red gate to provide a cross-checking routine and modify scripts appropriately / comments
I think the answer given is very shoddy. If there is a problem with sp_rename not changing the syscomments definition, then it should be escalated to Microsoft to provide a fix.
I'm sure they will ...