I have one file processing application in which

developer read row by row from database (physical file path,file name)then process source file on some conditions.

after processing its generates a new value...

ya u r right sorry for that ...........

not a one update query ....there are 5 million update queries are fired against this table.

declare @name varchar(50)

declare @fileid varchar(50)

declare @pageid...

how can i use cast during balk insert from file option ....there are all available options are field terminator,row terminator.....

you are right.

but i am not extracting data from text or any type of file.

my dotnet application generate new records based on some criteria and it is always row by...

hi please make note

EDocsOrEmail_Review_Page_Soft = edocs are the same table

please replace all reference relatd to them.

thats why i am asking...........

so further i request for a new domain login for sql server

thanks everyone,.......

in my server logon as local system thats a problem.......

if i give network service and give my user name and password it is fine.

but for this login(i hv created sql...

hi,

if I use sa or windows authentication all is fine but

i have created one sql server login csvimport and through this sql login i want to import the csv file.

for...

hi,

i have attach error log with this mail.

but all error log says that i have lost msdblog.ldf

i have tried but can not got logfile for msdb in my default installtion...

actually cause is i lost my msdblog.ldf and that's problem, but now i have no any backup for msdb database.

any solution to rebuild or recover from this...

When i click on management tabs the error says and i cannot access error log.

also there are no MSDBLog.ldf file present.

TITLE: Microsoft SQL Server Management Studio

------------------------------

An exception occurred while executing...

late i have found another

EXEC master.dbo.xp_cmdshell 'wmic LOGICALDISK LIST BRIEF'

hi,

I think there are no any system views to get total disk space.

but using fsutil and XP_CMDSHELL you can as describe in below link

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=92571

yes...i can connect..

hi it is default instance.....not a named.

i am connecting through dot net application using a sql server authenticated user.

user has all the rights as 'sa'.