sp_helptext 'StorProcName' will do the trick as well
Audit is only available in SQL Server 2008 Enterprise, so as long as all your servers are running Enterprise version you should be able to utilize...
Use Windows authentication and your problem should go away. As with SQL Server users, they have to be recreated after database is failed over to the...
Simple way to solve your problem is to use CTE (if you are on 2005 and up of course), here is an example:;with MasterRef(Id, IdXref ,MasterParent) As...
Separate names with a comma.
