Thanks "mkeast",

This example works ok.

To supress the message from DBCC use:

DBCC <<any>>  WITH NO_INFOMSGS

 

Regards.

 

Thanks Brian,

I should wish a solution for this case, but at least I can explain to analysts the reason that isn't work in our developer environment.

Im my production environment the distributed...

Hi,

Try this:

create view vw_View_SP

as

select *

from openrowset('SQLOLEDB','mySERVER';'SQLUser';'password',

  'myDataBase.dbo.usp_MyStoredProc @param=1')

In my case this work fine.

Regards

Andrew

I agree with you but in some cases the cursor is needed.

I try to make anything without a cursor but ... UNHAPPLY ... sometimes ... it is...

Thansk Aaron and Willian

Its just what I looking for. I will test the both. We are right, I need a way of turn a list of values into a table of...

Hi Jennifer,

I has the some trouble yesterday. I try use db_name() in all forms but allways return the same thing, the database the stored procedure is in.

I solve this passing the...

Great article,

     Some times developers just think “my SPs are full functional", but, in most case, no attempt for performance or "locks". When deadlocks occur they just say "my...

Thanks Allen,

I agree with you but my work is in government organization and there are more than 2000 users and several SPs running with this method. It's amazing since many tables should be change triggers...