Home / server / Questions

Questions[osql](server)

Martin Hope
contactmatt
Asked: 2011-04-15 12:25:56 +0800 CST
  • 3

I'm running batch processes via a batch file and I want SQL server to log the reslt when I execute my DBCC SHRINKFILE command from my batch file. Is there anyway to do this?

Example: - Run.bat

rem Shrink transaction log and log the result

"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\osql.exe" -E -Q "Use [Database] DBCC SHRINKFILE(Database_log, 50)"
sql-server sql-server-2008 utility osql
Martin Hope
chama
Asked: 2010-02-19 07:19:50 +0800 CST
  • 1

I'm trying to find a list of all sql servers on the network using the osql -L command in the command prompt. This command only works when SQLServer is installed on the computer that I'm working on. Is there any way to run this command when SQLServer is not installed on that particular computer, but is installed somewhere on the network?

Thank you!

EDIT: I'm writing a program in java, so the easy enumerations that you can do in the .NET framework won't work for me.

sql-server command-line-interface osql
Martin Hope
Jan Jongboom
Asked: 2009-08-19 01:29:11 +0800 CST
  • 0

I'm installing sql instances through script, and after creating a certain instance, I cannot get the sa account to be enabled through osql.

What I've tried

  1. osql -S .\INSTANCENAME -E
    use master
    ALTER LOGIN sa ENABLE
    GO

    • Using SSMS to enable the account (by logging in using Windows Auth., 'New query', and exactly the same query as in 1.)

    • Suggestions in this issue

No. 2. is actually working; and the account is enabled instantly. No 1 is not working, not even with the suggestions provided in 3., I have restarted the SQL services after executing the commands in osql.

Additional info
Windows 2003 Server, Microsoft SQL Server 2005 Enterprise, No password policies apply to the account.

sql-server osql