How to find all identity columns in SQL Server

How to find identity column in SQL Server using query?How to find all identity columns in SQL Server? Read more →

My Top 4 sessions at PASS Data Community Summit 2021

Attending PASS Data Community SUMMIT 2021 Read more →

5 minutes in a DBA's head - Separating the Application and Database server

Interesting conversation with an app owner about separating the App server and DB server Read more →

How to use your DNA knowledge to increase your DBA skills

Make Blade Runner and SQL Server your next favourite combination Read more →

How to capture errors from SQLCMD

Question: I'm executing code using SQLCMD from a batch file . The code points to a sql file and there is also an output file. SQLCMD -E -S MYSERVER\INST1 -i "setup_job_entry.sql" -o "setup_job_entry.log" But I noticed that if the actual SQLCMD returns an error , for example , if I'm connecting to an server which doesn't exist this error message will appear in the output file - but there will not be an ERROR number , which would allow me to trap and return an appropriate message Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : SQL Server Network... Read more →