Web Scraper and Web Macros FAQs
Navigation
Home
All Pages
Categories
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
How can I keep a Package from timing out when executing a stored procedure?
Print
RSS
Modified: 2008/01/31 16:55 by
craig
- Categorized as:
Database Connections
,
Package
,
Performance Related
,
SQL
(5)
»
Web Scraper Hangs or says "SQL Server does not exist or access denied."
»
Manual Install
»
How can I keep a Package from timing out when executing a stored procedure?
[X]
»
How to upgrade to Web Scraper 5.5 or above?
»
The MSI Issue
»
Web Scraper Hangs or says "SQL Server does not exist or access denied."
»
Manual Install
»
How can I keep a Package from timing out when executing a stored procedure?
Execute the stored procedure in a command line task (Step Properties -> Advanced) using the following syntax:
SQLCMD -S.\PROVIDUSSTD -Q"EXEC DbName.dbo.StoredProcName" -Usa -Pvelocityscape
Create a Page
|
Administration
|
File Management
|
Login/Logout
|
Language Selection
|
Your Profile
|
Create Account