0
votes
1answer
231 views

SharePoint Sites go into read-only when SQL Server Backup is running

I have SharePoint 2007. When the database backups run using SQLCMD, SharePoint sites go into read-only. Users can't add anything to the sites and the buttons are grayed out. On the backend the ...
4
votes
3answers
8k views

Is there a way to run sqlcmd to get query output without showing the number of rows affected?

I am running a simple query in SQL Server 2005 and want it to export to a file via sqlcmd. I was hoping to get the results in a csv format without the headers and the query metadata (how many rows ...
2
votes
2answers
810 views

How can I type a \ in the sqlcmd editor?

According to this kb article on what to do if your user database is gone, it recommends the following three actions sqlcmd –E -S InstanceName –d master 1> ALTER LOGIN SQLLogin WITH ...