Please clsoe this post as u have already posted one more for this.

Hi

Go to Sql server log and check for detailed error messages. Also do you find any stacks being generated by sql server in the logs.Also check for the queries which...

yes.

Open the enterprise manager>>Right Clik on ther server>>Go to Properties>>Security>>Here in authentication chose Sql Server and Windows

Well the logins which u have created are using windows authentification or sql server.

If they are using sql server authentification then u need to select mixed mode rather than windows...

Windos system log has this info "unable to do recovery for master database.Exiting"

I have got this procedure and it is working fine.

Create procedure

usp_ImportMultipleFiles @filepath varchar(500),

@pattern

varchar(100), @TableName varchar(128)

Well I can do that but I was trying to do it through bulk insert.

The problem is that this has to be done through a vb program where they will...

Well it is a varchar(200) column and the maximum length to be inserted is only 18.So that cannot be the error.

well a small addition to sushila query

<>0 and name not like 'dt%'

It is giving error....

Server: Msg 4866, Level 17, State 66, Line 1

Bulk Insert fails. Column is too long in the data file for row 1, column 15. Make sure the...

Well fine tab is delimeter but how do I specify it and also what about row terminator

BULK INSERT Test.dbo.AusDCVData

FROM 'C:\test.xls'

WITH

(

 FirstRow=2, 

 FieldTerminator=' '--What do I give here for tab

, RowTerminator=''-- what to use as...

Hi

Could you please post the stackdump generated.U will get it here

Stack Dump being sent to E:\Microsoft SQL Server\MSSQL\log\SQLDump0001.txt

Hi

Yes restarting the server should solve the problem.

Hi

cannot get anything in BOL. COuld you please explain a bit..

Hi

Can u please tell what is the error or problem u r facing while using kill @spid