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.
| Author |
Topic |
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
 Posted - 2007-02-20 : 01:13:05
|
| this might sound dumb or impossible, but is there a way to run exec commands forcing them to not return results |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-20 : 01:18:58
|
| From where? Front end application or Query Analyzer or SSMS?Peter LarssonHelsingborg, Sweden |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-20 : 01:30:45
|
| What's the purpose?If you are executing Insert/update/delete commands with SET NOCOUNT ON, no output is returned anyway. If you are using SELECT inside EXEC and still don't want output to be returned, then it doesn't make sense. So what is that you want to do?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-20 : 02:28:34
|
divert the result to a tableinsert sometable exec somestoredprocedure
KH |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2007-02-20 : 04:38:56
|
| [code]SET PARSEONLY ON[/code]DavidMProduction is just another testing cycle |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2007-02-26 : 20:39:44
|
| sweet thanx |
|
|
|
|
|
|
exec without results