You are here:
| Expert | Average Ratings | Expertise |
|---|---|---|
David VaughnU.S.
Available
|
Performance tuning; T-SQL syntax; | |
Jwalant Natvarlal SonejiIndia
Available
|
From general queries about SQL Severs both 2000 and 2005 to advanced features like Integration Services and Reporting Services. |
I was suggesting to use SQL Authentication for testuser. My main goal is to try various things one at a time to help point us in the right direction. For example, if testuser could run the SQLCMD commands
Are you sure that when you run the SQLCMD command(s) you are logged in as the same user who is connecting to the server via Management Studio? (Most likely, the Authentication selection in the dropdown
OK.. let me know the results of looking at the SQL logs and the event viewer. Also the results of running sqlcmd -S Encoding -E -i D:\Backup\dbbackup.sql from a command prompt. Also, try running
hmmmm... I don't use SQL Express so I'm only guessing that it has the same logging features as "real" SQL, but the first thing I would do is check the SQL Logs and the server's Event Viewer for error messages
You will, by following the directions on that link, be creating a brand new stored procedure. master is a database which is present in all SQL Server installations. Generally, it is not to be messed

©2010 About.com, a part of The New York Times Company. All rights reserved.