Sql Server Stored Proc Doubt

[littlemoon]

okate stored procedure lo can we make 2 - 3 server connections and update values as well?

scenario enti ante we have 3 different websites andulo oka value we want to update only user clicks on it.nenu dev ki already sp rasanu but staging and production values kuda pass avali..
if dev server use chesthe apudu andulo value update avali ala and rest shouldnt be updated
staging use chesthu unte dani lo value update avali.. @servername ani parameter pass chesi emaina join laga rayala?

illa undhi sp..

ALTER Procedure [dbo].[spPerson]
(
@PersonID int,
@Isvalue bit,
@Type bit
)
AS
DECLARE @IsRecordExists int

IF(@Type = 0)
BEGIN
select isValue from [devserver].[databasename].[dbo].[tablename]
where personID=@PersonID
END
ELSE
BEGIN
select @IsRecordExists = Count(*) from [devserver].[databasename].[dbo].[tablename]
where personID=@PersonID
IF(@IsRecordExists > 0)
BEGIN
update [devserver].[databasename].[dbo].[tablename]
set isValue=@IsValue
where personID=@PersonID
END
END


so na question devserver value badulu stgserver or prodserver values kuda update aye atu when user is in those websites
and servers have same table name and DB's

[JUJUBI_JULABI]

fully qualified domain names use cheyyi ....

[littlemoon]

[quote name='JUJUBI_JULABI' timestamp='1346251072' post='1302399325']
fully qualified domain names use cheyyi ....
[/quote]

sql server nunchi kada ravlsindi data value domain name endku mention chestham? server name mention chesthe saripodha? and already linked server connection undhi.. so separate sp's raste i am able to get kani okate dantlo ani servers ela mention chesedhi ardham kavatledhu..

[Darling999]

aah server names kosam oka global varibale declare cheyyachu kada, that might work i am not sure..

[JUJUBI_JULABI]

[quote name='littlemoon' timestamp='1346251263' post='1302399351']
sql server nunchi kada ravlsindi data value domain name endku mention chestham? server name mention chesthe saripodha? and already linked server connection undhi.. so separate sp's raste i am able to get kani okate dantlo ani servers ela mention chesedhi ardham kavatledhu..
[/quote]
linked server ga setup ayyi nappudu ... u can query any server from any window .. just use fully qualified name ..

[littlemoon]

I will try then..

[anbe__shivam]

MKTR ki PM pettu... Tanu sql anukunta

[Darling999]

calling galigannarao

[galigannarao]

nuvvu devki sp raste kanuka ade spni test and prodlo create chesukoni. aa websitesnundi call cheste ayipoddiga ee talanoppi anta enduku

[Darling999]

[quote name='galigannarao' timestamp='1346253490' post='1302399650']
nuvvu devki sp raste kanuka ade spni test and prodlo create chesukoni. aa websitesnundi call cheste ayipoddiga ee talanoppi anta enduku
[/quote]
Intey naa..[img]http://img59.imageshack.us/img59/8545/raghubabu.gif [/img]... nenu edo ankuni kangaru padtunna ..

[galigannarao]

[quote name='DARLING...' timestamp='1346253577' post='1302399660']
Intey naa..... nenu edo ankuni kangaru padtunna ..
[/quote]chusukondayya. edanna simplega alosinchali kani complex chesukokudadu.

[littlemoon]

[quote name='galigannarao' timestamp='1346253490' post='1302399650']
nuvvu devki sp raste kanuka ade spni test and prodlo create chesukoni. aa websitesnundi call cheste ayipoddiga ee talanoppi anta enduku
[/quote]

namasthe gannarao.

e 3 servers oka main server connect ayi unayi andulo rasanu e sp and seprate sp's rasthe ala kadhu okate sp lo kavali ani annaru .. anduke asking..

@servername dev ani parameter laga pass cheyacha?

[pikki]

[quote name='galigannarao' timestamp='1346253490' post='1302399650']
nuvvu devki sp raste kanuka ade spni test and prodlo create chesukoni. aa websitesnundi call cheste ayipoddiga ee talanoppi anta enduku
[/quote]

[galigannarao]

[quote name='littlemoon' timestamp='1346254685' post='1302399789']
namasthe gannarao.

e 3 servers oka main server connect ayi unayi andulo rasanu e sp and seprate sp's rasthe ala kadhu okate sp lo kavali ani annaru .. anduke asking..

@servername dev ani parameter laga pass cheyacha?
[/quote]
simple ga cheppalante ya cheyachu. mari bandaga ante @servename parameter ichi based on server name if condition rasukoni fully qualified queryni run cheyyadame

[littlemoon]

[quote name='galigannarao' timestamp='1346255180' post='1302399849']
simple ga cheppalante ya cheyachu. mari bandaga ante @servename parameter ichi based on server name if condition rasukoni fully qualified queryni run cheyyadame
[/quote]

hmmm.. yh inka adhe cheyali.. simple ga aye danki ento illa.. thanks gannarao..