I did that once for improving SQL Queue Reader Agent on sp_replsqlqgetrows, and they did incorporate changes on SP3 for SQL 2000, but do really know how much time it...

Yes I’m aware of the risk… but since SQL 2000 to 2005 only work it out for the best. Must be a way to do the same in SQL 2008,...

Doing your suggestion, i can't move to step 5, because it didn’t change the original procedure and therefore when the system calls the sp, my changes would not be there…

But...

amandix (3/22/2010)

---

Try this one:

create proc sp_sample

@parameter1 char(4),

@parameter2 int = 0

as

set nocount on

declare @retcode int

begin tran

exec @retcode = master..xp_cmdshell 'ping -n 1 apmobil2'

if @retcode <>0 or @@error <> 0

goto...

Try this one:

create proc sp_sample

@parameter1 char(4),

@parameter2 int = 0

as

set nocount on

declare @retcode int

begin tran

exec @retcode = master..xp_cmdshell 'ping -n 1 apmobil2'

if @retcode <>0 or @@error <> 0

goto FAILURE

commit...

Thanks.

Here follows step by step (SQL 2005 solution):

1. Copy the mdf and ldf of mssqsystemresource and rename both with copy in the end “mssqsystemresource_copy.mdf” and “mssqsystemresource_copy.ldf”

2. Attach this new...

I have increased code for doing so many thinks... but it's not the point.

The question is: is it possible to do it in SQL 2008, like it was in SQL...

OK, now i have to explain why...

I usually install on SQL Server systems Transactional Replication on databases. This is not for hack SQL Server!

Sample: there is a system stored stored...

OK, now i have to explain why...

I usually install on SQL Server systems Transactional Replication on databases. This is not for hack SQL Server!

Sample: there is a system stored stored...