When making a connection to an OLAP data source and specifying an IP address for the Data Source property in an ADO or ADO*MD connection string, the following error occurs: Microsoft(r) OLE DB Provider for OLAP Services error ‘80004005’ Cannot connect to cube file, ‘IP address’ , file may be in

(Marcin Policht) In the arsenal of DTS Designer Tasks, the one that leads in terms of versatility (and complexity) is the Data Driven Query Task. Its most distinctive feature, distancing it from other tasks, is its ability to not only handle inserts of rows during transformation, but also process an

(Haidong Ji) In a nutshell, Entegra is a SQL Server auditing tool without triggers. If you have sensitive data, such as personnel information, salary data, etc, and you want to keep an audit trail of changes to those data (DML statements, such as INSERT, UPDATE, and DELETE), in many cases, you will

(Robert Westervelt) As a Yukon beta user, which features have you found to be exciting? Randy Dyess: Security has become more of a focus with this version. They have given the DBA the ability to tie in the SQL Server password with the Windows password policies. It gives the DBA a little more cont

(Jesus Rodriguez) The new version of Microsoft SQL Server “Yukon” comes together with a set of technologies capable of enlarging the horizon for database applications. One of the most remarkable technologies is the Service Broker that makes it possible to build database-intensive distributed applica

(Scott Bekker) Microsoft officials said on Wednesday that the next version of SQL Server, code-named “Yukon,” and the next version of Visual Studio, code-named “Whidbey,” will be delayed until the first half of 2005.

(Leo Peysakhovich) One day I became tired of doing a manual procedure to check every morning to see if nightly backup, data transfer, and other jobs have failed. I decided to develop code that will automatically verify if jobs have failed and email the results to me. (R)

(Ameet Phadnis) Ever wish you had a tool/robot that would allow you to generate your stored procedures and middle tier functions/classes for you and save you lot of time in coding? Most developers do get tired of coding with the same approach over and over. This article demonstrates how you can buil

(Valko Yotov) This article explains how to control application access by validating the user’s login and password against a SQL 2000 database. Once validated, the user gets a one time pad Access Code generated by SQL 2000 server, which is different and unique for every login – Access Code changes on

If a SQL Server query returns a negative zero, and the client application binds the results as a SQL_C_DOUBLE, the following error is reported to the client: [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification