You'll need to modify your SSMS settings.

Go to Tools -> Options and in the left pane choose SQL Server Object Explorer -> Scripting.

In the scripting options go to the "Object...

Remember that with this option set to true on...

Follow the steps listed here to change the security settings. You'll need to stop and restart the replication agent jobs for the changes to take effect

I don't recommend relying on short-circuiting by the query optimizer - i.e. assuming that an "OR" or an "AND" condition is always going to be evaluated left to right. The...

Looks like you are replicating stored procedures (if I read the log properly) - do the stored procedures have SETUSER in them? Maybe if you don't replicate the particular...

From http://support.microsoft.com/kb/231403 - SETUSER permission is given only to members of the sysadmin role; this permission is not transferable.

I don't know why SETUSER is being invoked but it looks like...

Yep - if you RAISERROR then you don't need to explicitly return a value.

However if you return the error number explicitly in the inner SP from the catch block (using...

The information is in sysschedules table. You can get this information from the documentation about freq_subday_type and freq_subday_interval in http://msdn.microsoft.com/en-us/library/ms366342.aspx

Edit: ah already answered with a script that I'll save into...

You've got nested SPs. With the TRY...CATCH block and nested SPs one way to get things to work in your situation is to have the called SP return a status...

Can you post some sample code of where it isn't working for you? For e.g. how are you trying to access the output parameter, how are you calling this procedure,...

As far as I know - only the last error message is available in the TRY...CATCH block and there is no way to get the entire error message stack.

Good catch - re-looked at the original post again and realized that it was an output parameter the OP was talking about...

Which of the steps did you try? The ones that fail will be SQL 2005 specific 🙂

Bad jokes aside - on SQL 2000 the recommendations that involve sys.dm_exec_connections, sys.sql_modules, sys.dm_sql_referencing_entities...

Reo (10/6/2010)

---

SQL Server does not have option/feature to move existing table or indexe among filegroups. To moving an existing table to another filegroup you have to recreate table on new...

I'd recommend sys.sql_modules - something like

SELECT OBJECT_NAME(object_id) FROM sys.sql_modules WHERE charindex('spNameHere',definition)>0;

The text column in syscomments has a limit of nvarchar(4000) and SPs with definitions greater than that size will be...