The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
54 views

Backup databases from MS SQL Server 2008 Express database thru batch script

I need batch script to backup selected databases from Microsoft SQL 2008 Express Edition. Unfortunately MS SQL Server 2008 Express edition lacks of visual database backup tools called Maintenance in ...
1
vote
1answer
347 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
1k 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
105 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
111 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 ...