Activity overview
Latest activity by joltcoderold
On the Server: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Client Info: Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6000.16386 (vista_rtm.061101-2205)
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.6000.16386
Microsoft .NET Framework 2.0.50727.312
Operating System 6.0.6000
I'm not an Admin on this particular server and so the information that I have is sparse at best... (It's a little after 3am here so I cannot get answers from the team that maintains this server at the moment) The SQL Compare menu option is disabled. As more information comes to me... I'll share.
Are dbo permissions required for SQL Prompt to function properly? / comments
On the Server: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service...
Unhandled exception... "Unable to cast..."
"Unable to cast object of type 'System.DBNull' to type 'System.String'."
I can repro this on every database that I initially connect to or "refresh" the cache manually. The exception prevents *any*...
I noticed that my Red-Gate tools were loading the DevExpress binaries from the GAC and not from the application directory. Both assembly copies were version 6.3.1.0; I'm not sure if and why there is a difference internally between the DevExpress assemblies loaded in the GAC and those installed with Red-Gate products but once I removed the 6.3.1.0 assemblies from the GAC all of the applications in the Red-Gate suite that were having problems work perfectly.
Please note that this is by design as the .NET Framework will search the GAC for an assembly (By strong name and version) and if it located it will be used... if it isn't located in the GAC; the framework will begin probing (as defined at http://msdn2.microsoft.com/en-us/library/yx7xezcf.aspx) and will locate the correct assembly in the app or probing path.
I've never seen this cause a problem in the past as one would assume that two binaries with the same strong name and version should be identical... but I didn't dig any deeper.
hth,
bR / comments
I noticed that my Red-Gate tools were loading the DevExpress binaries from the GAC and not from the application directory. Both assembly copies were version 6.3.1.0; I'm not sure if and why there i...