I am looking for suggestions on an alternative product for comparing SQL schema and data with Microsoft SQL server (2012). Up to this point in time our company has used Red Gate SQL Compare and SQL ...

I'm working on a client site where they've provided a SQL Server 2005 database. We've implemented a "simple" search that allows users to run keyword searches. The tables are heavily normalized with ...

Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...

I'm down on SQL Server Management Studio right now. I basically just spent a day trying to swap out the evaluation version of SQL Server 2008 R2 with the Express version, and SSMS just wouldn't ...

SQL Server 2012, which will launch some time in the first few months of 2012, has a lot of moving parts. Exactly how is Microsoft going to bundle up its various capabilities? We know a bit about the ...