Need Help on this Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Need Help on this Error

Author

Topic

sudha12345
Starting Member

47 Posts

Posted - 2009-04-09 : 05:24:43

i am inserting data into Temp_Asset of MedNetOnline DataBase by taking data from Asset table from the DataBase HMSS_HOLD

while Executing i am Getting the Error

Msg 208, Level 16, State 1, Procedure Process_insert_Temptables_HoldingDb_sp, Line 22
Invalid object name 'HMSS_HOLD.Asset'.

The Server Details are
DataBase Configuarations are for DataBase HMSS_HOLD are

Computer Name :D-181485
user : MedNet

DataBase Configuarations are for DataBase MedNetOnline are

Computer Name :D-181485
user : MedNet

The Server IP is 10.150.135.132

The Code is As Follws

USE [MedNetOnline]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

create Procedure [MEDNET].[insert_Temptables_HoldingDb]
@intError int OUT
as
BEGIN

SET NOCOUNT ON

SET @intError = 0

if @inerror = 0

BEGIN

insert into MedNetOnline.Mednetload.temp_asset (CUSTOMERID,SERVERID,ASSETID,LOGICALID,
LOCATIONTIME,ASSETLOCATIONID,ASSETTYPEID,DATECREATED,LASTUPDATED,UPGRADEINPROGRESS,
SWRELEASEUPGRADEID,SWRELEASEID,IPADDRESS)

(select CUSTOMERID,SERVERID,ASSETID,LOGICALID,LOCATIONTIME,ASSETLOCATIONID,
ASSETTYPEID,DATECREATED,LASTUPDATED,UPGRADEINPROGRESS,
SWRELEASEUPGRADEID,SWRELEASEID,IPADDRESS from HMSS_HOLD.db0.Asset)

END

ELSE
BEGIN
print 'Error While inserting'
END

SET NOCOUNT OFF

END

Sudhakar

ddramireddy
Yak Posting Veteran

81 Posts

Posted - 2009-04-09 : 05:48:36

quote:
Originally posted by sudha12345
SWRELEASEUPGRADEID,SWRELEASEID,IPADDRESS from HMSS_HOLD.db0.Asset)

Sudhakar

I think its due to a typo. i think its dbo, you typed db0.
thats y its giving error.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources