Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

problems with sp_msforeachdb

Status
Not open for further replies.
equus2

equus2

Programmer
Mar 5, 2008
36
US
Hi,

When I try to run sp_msforeachdb on SQL Server 2005 (to call scptxfr.exe for each database on a server), it locks up completely and never finishes my scripting.

I don't think the problem is with scptxfr.exe per se, because I don't have a problem when running this in general, just when I put it in the sp_msforeachdb loop.

Has anyone else had this problem?

Thanks
 
Status
Not open for further replies.

Similar threads

gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
2K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
960
gmmastros
gmmastros
TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
753
gmmastros
gmmastros
Billz66
  • Locked
  • Question
need to udate table entry with number containing a *
Replies
11
Views
469
Chris Miller
Chris Miller
niall5098
  • Locked
  • Question
Create plan guide with date time parameters
Replies
3
Views
298
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top