query erro musite 2.5

[maresia]

USE [webSite]
GO

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

declare @memb___id varchar(10);
declare c cursor for select memb___id FROM MEMB_INFO
open c
FETCH NEXT FROM c INTO @memb___id
WHILE @@FETCH_STATUS = 0
BEGIN
IF NOT EXISTS (SELECT 1 FROM webSite.dbo.webCash WHERE username=@memb___id)
INSERT INTO webSite.dbo.webCash (username, amount) VALUES (@memb___id, 0)
FETCH NEXT FROM c INTO @memb___id
END
CLOSE c
DEALLOCATE c

declare c cursor for select memb___id FROM MEMB_INFO
open c
FETCH NEXT FROM c INTO @memb___id
WHILE @@FETCH_STATUS = 0
BEGIN
IF NOT EXISTS (SELECT 1 FROM webSite.dbo.webVips WHERE username=@memb___id)
INSERT INTO webSite.dbo.webVips (username, type, dateBegin, dateEnd) VALUES (@memb___id, 0, '0','0')
FETCH NEXT FROM c INTO @memb___id
END
CLOSE c
DEALLOCATE c


----------
Não entendo muito mas está query está com erro,query serve para que?
DB xteam S4

Msg 208, Level 16, State 1, Line 3
Nome de objeto 'MEMB_INFO' inválido.

[xiscoss]

Altere USE [webSite] para USE [MuOnline] e teste.

[maresia]

então a query é para ser usada em [webSite], faz parte da webSite_COMPLETE da musite

[xiscoss]

Mas a parte que usa a webSite ta especificada na query, a do MuOnline não.

USE [webSite]
GO

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

declare @memb___id varchar(10);
declare c cursor for select memb___id FROM MuOnline.dbo.MEMB_INFO
open c
FETCH NEXT FROM c INTO @memb___id
WHILE @@FETCH_STATUS = 0
BEGIN
IF NOT EXISTS (SELECT 1 FROM webSite.dbo.webCash WHERE username=@memb___id)
INSERT INTO webSite.dbo.webCash (username, amount) VALUES (@memb___id, 0)
FETCH NEXT FROM c INTO @memb___id
END
CLOSE c
DEALLOCATE c

declare c cursor for select memb___id FROM MuOnline.dbo.MEMB_INFO
open c
FETCH NEXT FROM c INTO @memb___id
WHILE @@FETCH_STATUS = 0
BEGIN
IF NOT EXISTS (SELECT 1 FROM webSite.dbo.webVips WHERE username=@memb___id)
INSERT INTO webSite.dbo.webVips (username, type, dateBegin, dateEnd) VALUES (@memb___id, 0, '0','0')
FETCH NEXT FROM c INTO @memb___id
END
CLOSE c
DEALLOCATE c