TAG /Software Development

DEVELOPMENT: good software development practices

Jun 08, 2009

Here’s a list of 5 Good Programming Habits we picked up from Amy Bennett in her article at IT World: The best trick I have is to type the sequences/use cases like a story before I write any code. The outline I create is read over and over, tweaking as I go.” (Dan Douglas) Solve […]

READ MORE

DEVELOPMENT: Cannot obtain the schema rowset “DBSCHEMA_TABLES_INFO” for OLE DB provider “SQLNCLI” for linked server

May 08, 2009

Running a query from SQL Server 2008 over a linked server connection to a SQL Server 2000 server causes the following error: OLE DB provider “SQLNCLI10″ for linked server “mylinkedserver” returned message “Unspecified error”. OLE DB provider “SQLNCLI10″ for linked server “mylinkedserver” returned message “The stored procedure required to complete this operation could notbe found […]

READ MORE

DEVELOPMENT: issue with DateTime datatype in SQL Server Reporting Services

Nov 02, 2008

We recently upgraded a client’s SQL Server 2000 business intelligence reports to SQL Server 2005, and from a Visual Studio .net 1.1 software development environment to Visual Studio 2005. It should be a simple transition we thought, which it was… apart from some anomalies around the datetime parameters in SQL Server 2005 Reporting Services. There […]

READ MORE