Many times during sql server development we need to search for a stored procedure containing a specific text. this helps in checking for dependencies for objects in stored procedures or sometimes we ...

Needs MS Word and MS SQL Server 2000. The application creates .doc files for each selected SQL Server object (Table/Stored Procedure), and writes varied information about the object to the .doc file. ...

[dbo]. [ImportDocumentLibraryCategoryAssoc] Invalid object name 'dbo.dlfp_DocumentCategoryAssoc' P The screenshot below is probably easier to read. Expected behavior In general, undefined objects are ...

In some organizations, the IT department wants all interaction with the server to be done through Stored Procedure. This adds a level of risk management and makes the DBAs feel better.