Skip to main content

Get free technical eBooks on SQL Server 2017 from Microsoft

Build your Microsoft SQL Server expertise with technical deep dives for your database journey. Free PDF eBooks from Microsoft SQL Server eBook series Get the technical resources and documentation you need to explore SQL Server 2017 – a comprehensive, mission-critical database for demanding workloads. With this series of technical eBooks on SQL Server, you’ll learn […]

ANSWER: UPDATE failed because the following SET options have incorrect settings: ‘ANSI_NULLS, QUOTED_IDENTIFIER’

I came across an interesting problem last night – a stored procedure that had been created years ago was suddenly coming up with this error message: UPDATE failed because the following SET options have incorrect settings: ‘ANSI_NULLS, QUOTED_IDENTIFIER’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or […]

How to Connect to a SQL Server Compact Edition Database with Management Studio

How to Connect to a SQL Server Compact Edition Database with Management Studio

Open a new connection by choosing File menu -> Connect Object Explorer in SQL Server Management Studio. Change the Server Type to SQL Server Compact Edition. For Database file: put the full path to an existing SQL Server Compact Edition .sdf file; click the drop-down button, and select New Database or Browse to locate a […]

Capturing STDERR output from SQLCMD.exe

Today while working with a .bat file full of SQLCMDs with really verbose output, I wanted just to capture error messages that were being sent to STDERR without changing the .sql files. I know how to capture/redirect handles in a variety of programming languages, but I haven’t tried to do this in a windows command […]

Optimising SQL Server 2005 TempDB

Microsoft’s whitepaper on Optimising TempDB in SQL Server 2005 contains a lot of useful information for anyone trying to push the performance of SQL Server 2005. Along with the internal improvements to tempdb, there are a number of things a database administrator should do as part of any installation: Increase the number of data files […]

Error: SQL Server Replication Requires The Actual Server Name

If while trying to setup a new subscription for SQL Server 2005 Replication using Management Studio you receive this error: TITLE: New Subscription Wizard —————————— Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic […]

SQL Server 2005 Goes Gold!

Microsoft has quietly kicked out the final version of SQL Server 2005 and Visual Studio 2005 to MSDN subscribers ahead of the Launch Tour 2005. The .Net 2.0 Framework has also been released, which you will need to install/use either of these great things. If you’ve been keeping track of SQL Server 2005’s development, you’d […]

PromptSQL Intellisense for SQL Server user and system objects

PromptSQL Intellisense for SQL Server user and system objects

I don’t know how long I’ve been waiting for this, but someone has finally built an Intellisense tool for SQL Server Management Studio & Query Analyzer. If you’ve been using Visual Studio.Net 2003 or 2005, you’ll know how useful Intellisense is in other programming languages (it’s like auto-complete in Word). I don’t know why it’s […]