While trying to use SQLCMD to produce an app.config file, I encountered problems with the output being truncated. The script was similar to: DECLARE @appconfig XML SET @appconfig = ‘<configuration></configuration>’ … Insert configuration nodes — Output the config SELECT @appconfig as ApplicationConfiguration The default options for SQLCMD produced output like: ApplicationConfiguration ————————- <configuration><connecti (the value […]
You are browsing archives for
Tag: SQLCMD
What with this database called [$(DatabaseName)] ?
I just handed a work mate an output script from DataDude, which he ran in Management Studio. Instead of producing the expected database he ended up with one called $(DatabaseName) Remember database pro uses SQLCMD to deploy databases If you use Management Studio to run an output script, you’ll need to swap into SQLCMD mode […]
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 […]
What I’m Reading – 10 Jan 2006
A quick list of things I am / have been reading in the last week. Metadata tool and whitepaper for BI components SQL 2005 Metadata Samples Toolkit and whitepaper now available SQL Server 2005 Business Intelligence Metadata Whitepaper SQL Server 2005 Business Intelligence Metadata Samples Toolkit Indexes: An Overview and Maintenance for Performance Recovery Planning […]