Question : I am trying to monitor the SQL Server instances on standalone server / cluster server. I would like […]
Tag: sqlcmd
How to print results in SQLcmd window
Question : I’tm trying to show in SQLcmd window the results of these queries: SELECT SYSDATETIME() AS “date”; PRINT ‘EXTRAÍDO […]
Restoring SQL Server Database Command Line Error
Question : I have a restore database script in a SQL file, and I’m trying to restore a backup generated […]
SQLCMD external editor
Question : I have set the environment variable SQLCMDEDITOR=gvim to invoke an vim with the ED command of SQLCMD. From […]
Named Pipe Provider Error code 40 [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
SQLCMD Returning Named Pipe Error [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
How to find a list of local MS SQL Servers?
Question : I looked at How can I determine installed SQL Server instances and their versions? already but CMD returns […]
Disabling variable substitution inside SQLCMD script when using :r syntax
Question : I am using SQLCMD to deploy a set of scripted Agent jobs. I am running these with a […]
How to report stats on restore via sqlcmd?
Question : I’ve inherited a batch file script that calls sqlcmd with parameters. One of the parameters is the path […]
Network issues with sql server
Question : There are two servers on co-location. First is Windows Server Standard 2008 R2 SP1. Second is Windows Server […]