Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 sqlcmd syntax

Author  Topic 

Mondeo
Constraint Violating Yak Guru

287 Posts

Posted - 2007-07-20 : 08:58:20
How can I use sqlcmd to execute a simple stored procedure, I dont need to pass parameters in or out, its just for backups.

Thanks

spejbl
Starting Member

28 Posts

Posted - 2007-07-20 : 09:12:38
[code]SQLCMD.EXE -S ServerName -E -d DatabaseName -Q "EXEC dbo.proc_name"[/code]

--
Tom
Microsoft KB articles monitoring | Apple KB articles monitoring
Go to Top of Page

Mondeo
Constraint Violating Yak Guru

287 Posts

Posted - 2007-07-20 : 09:25:48
Thanks, works great!
Go to Top of Page
   

- Advertisement -