Comments
Sort by recent activity
Brilliant - thanks for the help [image] / comments
Brilliant - thanks for the help
basilisk> Thanks for your super speedy reply!
I've just re-checked the SP it's bailing out on... no usage of any special 'xp_cmd' style procs or functions.
However, I think I've found the issue, I'm guessing it is related to a JOIN to a server that I can't access.
Crisis averted - time to track down the DBA...
Once again, thanks [image] / comments
basilisk> Thanks for your super speedy reply!
I've just re-checked the SP it's bailing out on... no usage of any special 'xp_cmd' style procs or functions.
However, I think I've found the issue, I'...
Howdy,
I think I'm having the same issue... [image]
I'm connecting to a sql2000 db via SSMS 2005 as a user who is dbo.owner.
It seems to hang at the "SELECT text,ctext,encrypted,number from [DB_NAME].dbo.syscomments c WHERE id=<blah>" point.
Running the query manually works, it pulls a "create" script for a SP.
Cheers,
Mike.
ps... your tools kick ass! / comments
Howdy,
I think I'm having the same issue...
I'm connecting to a sql2000 db via SSMS 2005 as a user who is dbo.owner.
It seems to hang at the "SELECT text,ctext,encrypted,number from [DB_NAME].dbo.s...