| Author |
 Topic Search  Topic Options
|
Mart 
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 05 January 2005 at 4:56pm |
|
Thats how you should run it, not as a procedure... let me try it out on my local server in query analyser debug mode
|
 |
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 January 2005 at 5:02pm |
|
Looks good for me, try doing a Response.WRite(strSQL) to check you copied it correctly
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 January 2005 at 5:12pm |
|
weird, the page wont load now,
just hangs al to gether, but a friend said it works on hers.. weird
the whole domain is hanging, even when not in the folder
http://support.emagine-hosts.com/tv/msSQL_server_setup.asp
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 January 2005 at 5:20pm |
managed to get an out put,.
Declare
@prc varchar(150) While (Select Count(*) from sysobjects where name
Like 'BTSPTemp%' and xtype = 'P') > 0 Begin Set @prc = (Select 1
[name] from sysobjects where name LIKE 'BTSPTemp%' and xtype='P') Set
@prc = 'Drop Procedure ' + @prc Exec(@prc) END
|
BTSPTemp is the prefix of the SP's still just hangs
Edited by dj air - 05 January 2005 at 5:21pm
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 January 2005 at 5:32pm |
|
you kept the % in, right?
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 January 2005 at 5:33pm |
|
If you put the prefix name in incorrectly (i.e. no procedures begin
with it in the current database) it will effectively be an eternal loop
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 January 2005 at 6:11pm |
|
cheers,
ill check to make sure the procedures are existing.
also regarding "
you kept the % in, right?"
the above statement is what i have as the query
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 January 2005 at 7:12pm |
|
the procedures are on the server, and with the same prefix as above.
|
|
