I've noticed that SQL Server 2000 seems to truncate parameter values when the value exceeds the parameter's data length—but I don't get an error. For example, if I run the following code...
I need some help with the SQL-DMO library. I'm developing a SQL-DMO application in which I need to verify the syntax of a SQL DDL query much the same way that Query Analyzer verifies syntax when you create stored...
One of my users has requested that I change the way I display the cost elements associated with a particular booking. Instead of merely listing the cost elements, this user would like me to produce a table that, in...
When I use the TaskPad in Enterprise Manager to check a database's allocated, used, and free space (as reported on the General tab), the values I see don't match the values I get when I use the sp_HelpDB and sp...
I have a string column in a Fact table that I want to show up in my MDX queries. Although I'd normally use member properties for this functionality, because of a data warehousing consideration, I can't go that route...
