Comments
Sort by recent activity
At this time, we only have the dbo schema in place / comments
At this time, we only have the dbo schema in place
cut & pasted from the proc: update xref.dbo.SymbolPopulationControl
version = 2.4.0
I sent explicit examples with screen shots to Ben Pinchen. / comments
cut & pasted from the proc: update xref.dbo.SymbolPopulationControl
version = 2.4.0
I sent explicit examples with screen shots to Ben Pinchen.
Yes. / comments
Yes.
I've done some testing, and I don't think my issue is permission - I belong to a Windows group that has DBO on all dbs on the particular server.
Thinking that maybe the issue is comments or white space I copied a proc removing all the indentation and comments that are not at the end of lines. Hoping that it would help the parser. It did not. The tool did not find an update command that is left justified.
The error messages that I am receiving aren't giving me any clues either. The objects that cannot be resolved because they're in an unknown db aren't directly called by the proc. I've changed the option setting to only include 1 level of objects used by the selected object and it's still not finding my update table statement. / comments
I've done some testing, and I don't think my issue is permission - I belong to a Windows group that has DBO on all dbs on the particular server.
Thinking that maybe the issue is comments or white s...
The stored procedure is in database FOO. It depends on tables in database FOO. The dependency is not being found through the tool (automatically or otherwise). I cannot right click the stored procedure and choose to add objects that are depended on, because it is not there. It's as though the procedure is not being parsed properly. I have tried removing all white space from the procedure to help the parser, no luck. It does not happen to every stored procedure. But the few I've tested with have had the same behavior trial after trial. / comments
The stored procedure is in database FOO. It depends on tables in database FOO. The dependency is not being found through the tool (automatically or otherwise). I cannot right click the stored proce...