Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Store Procedures
Message
From
15/11/2006 12:35:49
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Store Procedures
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01169951
Message ID:
01169951
Views:
63
Hello

I have a question.

If I have something like this.

CREATE PROCEDURE dbo.prueba151106
@base varchar(20)
AS
select * from [CPSI-SERVER].[@base].[dbo].[certificados]
GO

SQL say " The name of the objet '@base.dbo.certificados' is no valid. "

How can I do to that the store procedure can recive the name of the database
Next
Reply
Map
View

Click here to load this message in the networking platform