Backup on a mapped drive failing with Error 3201? The SQL Server service does not see the drive you mapped in Windows. Here is why, and what to do.
SQL SERVER – Marking Filegroup as ReadOnly with SQL Server
Readers asked how to mark a filegroup as ReadOnly. Here is a T-SQL script that creates a test database, adds a filegroup and marks it ReadOnly.
SQL SERVER – Interesting Observation with Currency Symbols
Did you know currency symbols like $ and £ are treated as money values in SQL Server? SELECT $ returns 0.00, and you can even use them in math.
SQL SERVER – SCRIPT – SQL Listening on Dynamic Port?
How do you know if SQL Server is listening on a fixed or dynamic port? Here is a script that reads the TcpDynamicPorts registry value for your instance.
SQL SERVER – Interesting Function AGENT_DATETIME
AGENT_DATETIME in msdb converts integer date and time values in YYYYMMDD and HHMMSS format into a datetime. Here is how it works, with examples.
SQL SERVER – The Basics of the File System Task, Part 1 – Notes from the Field #071
Andy Leonard explains the basics of the SSIS File System Task, a handy tool when loading data to and from flat files. This is part 1 of the series.
SQL SERVER – Error – Msg 6401, Level 16: Cannot roll back Transaction
Is there such a thing as nested transactions in SQL Server? A simple demo shows why rolling back a named inner transaction fails with Msg 6401.