yes.

But wat type of design u suggest.

can u suggest me wat problems i may face if i use this method

can u help me by telling what type of problems i may face by choosing any of this method

CLR functions

dynamic functions

can any one help me out to choose with method will be suitable for multiple databases.

1. Dynamic sp

or

2.clr functions.

what problems will i face if i follow this method

Finally i got the answer

-- [USP_TEST] '2,3,4,17','Validated_Data','Validated_Data','BPO','222'

alter proc [USP_TEST]

(

@StateId nvarchar(100),

@h nvarchar(100),

@E nvarchar(100),

@d nvarchar(100),

@id nvarchar(10)

)

as

begin

declare @sql nvarchar(4000)

declare @sql1 nvarchar(1000)

declare @sql2...

hi

Lynn Pettis

Can u give example script of stored procedure which i can use instead of the dynamic functions.

how to use a single user defined functions in multiple databases

Alter proc [dbo].[testSp]

@DbName nvarchar(100),

@table nvarchar(100)

as

begin

declare @ValidCount as nvarchar

declare @res as nvarchar(2000)

Declare @out as nvarchar(200)

Declare @a as nvarchar(200)

declare @return_value as nvarchar(200)

print @a

-- set @ValidCount= exec [test] 'BPO', 'validated_data',output

select dealer_name ,exec @out=[test]'BPO',v.validated_data,dealer_name,@out...

can u send me an example and one more thing is i have to pass a field name from the original store procedure

to the called store procedure

Alter proc [dbo].[testSp]

@DbName nvarchar(100),

@table nvarchar(100)

as

begin

declare @ValidCount as nvarchar

declare @res as nvarchar(2000)

Declare @out as nvarchar(200)

Declare @a as nvarchar(200)

declare @return_value as nvarchar(200)

print @a

-- set @ValidCount= exec [test] 'BPO', 'validated_data',output

select dealer_name ,exec...

yes structure is same for all customers

i have heard using indexes have lot of problems . is it so...........

yes each customer will have different tables.But only 50 customers table will be there in that database .

After that a new database will be created

The database creation depends on no. of customers.

Eg: 50 customers will have same database after 50 dynamically will create a new database .

here all the 50 customers will have different...

Lot of customers are involving in our project. if i maintain a single database load will be more .So we have chosen multiple database creation based on customers use.Now...