Activity overview
Latest activity by basilisk
Ok, I think I narrowed it down.
I get this error message when (and only when) the stored procedure has the exec master..xp_cmdshell command. There's no way around it in my setup, but at least it might help other people. / comments
Ok, I think I narrowed it down.
I get this error message when (and only when) the stored procedure has the exec master..xp_cmdshell command. There's no way around it in my setup, but at least it mi...
I found the object in question, but it looks like it moves on right before crashing - the last statement in the profiler is
SELECT text,ctext,encrypted,number from [DB_NAME].dbo.syscomments c WHERE id=<blah>. Anyway, I was able to execute all of the statments from the profiler by hand just fine. Still looking...
B / comments
I found the object in question, but it looks like it moves on right before crashing - the last statement in the profiler is
SELECT text,ctext,encrypted,number from [DB_NAME].dbo.syscomments c WHER...
Find invalid objects - insufficient permissions?
Hi all,
I found a very strange issue with the latest build of SQL Prompt (5.1.4.11) - when running a "Find invalid objects" operation on a medium-sized database it gets stuck roughly at 25% (46 out...