SqlServer 08: Query to list all databases in an instance?
How do I list all the databases for a given sql server 08 instance using sqlcmd? ...
sqlcmd
Does the use of AJAX increase memory usage of PHP??
Hello all, I think the answer to this question is no but I do not have anymore leads of the problem I am trying to figure out. I initially had a single script that did some database queries via SQLCMD. I have now decided to initiate this script via AJAX and wait for the response. But I get a fatal error of: Fatal error: Allowed memory...
BCP Command gives different output in SQL Server 2005 compared to 2008?
Hello all, I have executed two identical bcp commands on two different setups with the same data. Machine A = Windows Vista machine which is running SQL Server 2008 Machine B = Windows Server 2003 machine running SQL Server 2005 The output text file of the bcp command is different! For a start, Machine B does not add column names to ...
Run sqlcmd without having SQL Server installed
I'm working on a Java program that is calling sqlcmd. It works perfectly on a computer with SQL server installed, but not at all on a computer that doesn't. I want to include the necessary exe and dll files to run this command in my jar. Anyone know which ones I need? I already included batchparser90.dll, sqlcmd.exe, and sqlcmd.dll. ...
sqlcmd from command-line with sql authentication
SQLCMD uses windows authentication by default. According to the MSDN documentation, you can change it by adding a -U parameter to the command and then the user name. The problem is with the password. Is there any way to access the sql server if the password is blank? sqlcmd -U admin password: Whenever I try this and just press ente...
sqlcmd: how to supress hyphens
How can I supress hyphens (------------) from the results set of this sqlcmd-command: C:\temp>sqlcmd -d AdventureWorks -s ";" -Q "SET NOCOUNT ON SELECT top 5 FirstName, LastName FROM Person.Contact;" FirstName ;LastName --------------------------------------------------;--------------------------...
How to append to a log file in powershell?
Hi there, I am doing some parallel SQL Server 2005 database restores in powershell. The way I have done it is to use cmd.exe and start so that powershell doesn't wait for it to complete. What I need to do is to pipe the output into a log file with append. If I use Add-Content, then powershell waits, which is not what I want. My code sn...
SQLCMD Syntax error when running script that runs fine in management studio
When I run the this select '$(''test'')' in SQL Management Studio 2008 it returns $('test') When I run sqlcmd -S SERVER -E -d DATABASE -q "select $(''test'')" on the command line it returns Sqlcmd: Error: Syntax error at line 1 near command '''. If I remove the dollar sign it works. Is the "$" a special character? Is this a sqlcmd ...
Which user account is running SQLCMD in T-SQL Script without -U and -P option?
I am using sqlcmd in a T-SQl script to write a text file to a network location. However SQLCMD is failing to write to that location due to access permission to the network folder. SP is being run under my user account which has access to the network folder. Could you please help me under which account sqlcmd will run if I do not specify...
How to export more than 1MB in XML format using sqlcmd and without an input file?
Hello, In SQL Server 2008, I want to export the result of a stored procedure to a file using sqlcmd utility. Now the end of my stored procedure is a select statement with a "for xml path.." clause at the end. I read on BOL that if I don't want my output truncated when reaching 1MB file size, I have to use this :XML ON command, but it s...
Specify rowterminator when creating a file with SQLCMD
How do you specify the the row terminator when outputting query results using sqlcmd? bcp is not an option. sqlcmd -E -s" " -Q "Select * From SomeTable" -o C:\Output.txt -W What is the default row terminator? ...
Restoring dev db from production: Running a set of SQL scripts based on a list stored in a table?
I need to restore a backup from a production database and then automatically reapply SQL scripts (e.g. ALTER TABLE, INSERT, etc) to bring that db schema back to what was under development. There will be lots of scripts, from a handful of different developers. They won't all be in the same directory. My current plan is to list the scri...
SQLCMD Mode - Incorrect Syntax?
Trying to use: :On Error exit :r D:\opt\db_objects\REPORTS\dbo.sp_ReportCountLORUsers.sql ...and I get: Msg 102, Level 15, State 1, Line 5 Incorrect syntax near 'U'. ** An error was encountered during execution of batch. Exiting. What am I missing? ...
build SQL query string using user input
i have to make a string by using the values which the user selects on the webpage suppose i need to display files for multiple machines with differnt search criteria.. i currently use this code: DataTable dt = new DataTable(); SqlConnection connection = new SqlConnection(); connection.ConnectionString = ConfigurationMa...
SQLCMD Restore works in Management Studio but not from DOS prompt
Any idea why my Restore command works fine when run in Management Studio 2008 but not when run from the dos prompt? Shown below is the error when running from the dos prompt. C:\>SQLCMD -s local\SQL2008 -d master -Q "RESTORE DATABASE [Sample.Db] FROM DISK = N'C:\Sample.Db.bak' WITH FILE = 1, MOVE N'Sample.Db' TO N'C:\Program Files\M...
How to write or append to text file using sql?
Hello, i need to call sqlcmd from stored procedure to export table to text file? ...
Is SQLDataReader slower than using the command line utility sqlcmd?
I was recently advocating to a colleague that we replace some C# code that uses the sqlcmd command line utility with a SqlDataReader. The old code uses: System.Diagnostics.ProcessStartInfo procStartInfo = new System.Diagnostics.ProcessStartInfo("cmd", "/c " + sqlCmd); wher sqlCmd is something like "sqlcmd -S " + serverName + " -y 0 -h-...
How do I INSERT binary data from a local file with SQLCMD?
I need to insert binary data from a file into a varbinary(max) column in SQL Server as a part of my deployment script. The file is on the local machine, SQL Server is on the remote. Here is the data table definition CREATE TABLE [dbo].[Config] ( [ID] INT IDENTITY (1, 1) NOT NULL, [Name] NVARCHAR (50) NOT NULL, ...
Dynamically read files in VS DBPro (using SQLCMD)
Hi, I'm using VS2008 DBPro. In my PostDeploy file I have many lines like this one :r .\Data\Test\Classifiers.CodeType.data.sql :r .\Data\Test\Classifiers.Currency.data.sql :r .\Data\Test\Classifiers.LOB.data.sql What I would like is to create a variable ProjectName so I could easely deploy different project data. Something like this ...
how to include a ":" as a parameter in powershell?
hi i have a simple powershell script, like this sqlcmd -S. -E -Q 'select ''$(x)''' -v x="c:a" but i always got the error message Sqlcmd: ':a': Invalid argument. Enter '-?' for help. i figured out that it is the ":" in the argument caused the problem, but i do not know how to escape it. thanks, David ...