i am local and database and .net application both resides on single machine.

Sql Server Browser is running.

I have created a sql server user and granted all the roles and permission...

yes i am alowing remote connections and tcp and named pipes both are enabled

I think locking is not possible for any case because each user just say

user1 has 1 to 100k records to insert and same for update

user 2 has 101k to 200k...

same index are created on table for both cases.

detailed explanation:

nine Users each has one db like db1 for user1/db2 for user2/.../db9 for user9

All Using DIFFERENT Database on same instance

user1 connects to db1 and insert a record.....again insert one...

generally i have resided to perform all dml through procedure.

please make a note something about my business process:

it has 10 millions objects and have 10 users to process it.

each users...

mostly i want to create a dynamic partition on basis of new value insert into a partitcular table

when a new value is inserted into a table then trigger fires and...

Ok.thanks.

you are on right track.

I should go or search for table partitioning or ssis.

thanks for reply.

My application continues update table for every records.

and if i will keep central server then all users are connected directly to this table.

and creates a lots of load...

Thanks for reply.

I have find the solution from log and i have to create a folder FTData at directory of

data folder mentioned at log.

any way Thanks.

No,all other components are updated successfully.

status for all other then this is 'success'

sorry.......I have mistake.

actually i have two servers one have 8 GB and another one at 16 GB RAM.

so,please forgot...

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790:...

Hi I am using SQL Sever 2005 SP 2

with 32 bit with windows server 2003 (data edition).

Hi I am using SQL Sever 2005 SP 2

with 32 bit with windows server 2003 (data edition).