The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
251 views

Suggestions for Scheduled Tasks to call OSQL without hard-coding cleartext password

Can anyone think of any techniques where i can have a Windows scheduled task run OSQL, but not have to pass the clear-text password with cleartext password being in the clear? E.g.: >osql -U iboyd ...
2
votes
1answer
968 views

Sql Server 2008 - Use OSQL utility to shrink files and then log result

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 ...
1
vote
5answers
101 views

SQL commands when SQL only exists on network

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. ...
0
votes
2answers
1k views

Granting rights to the sa account using osql

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 osql -S .\INSTANCENAME -E use master ...
0
votes
1answer
102 views

SQL Server queries take forever to enumerate the dataset?

I've got an interesting sounding problem with SQL queries run from a particular machine. This machine is a VM running Windows Server 2003, and it has SQL Server Express 2005 on it. The VM was ...