Never mind fixed it.

Thanks y'all

Pro2003

Hi all,

My problem, probably not regarding the topic here, but its related. I have a SQL Server application thats running off Sql Server 2000. While some users can log in...

Thats true, but as far as I know, I couldnt see any decent documentation on what to study, to prepare for the exam. Lots of people have told me that...

Congratulations,

I am preparing on exam 70-228, I am using MCDBA Two in One.

Any one have any better book in mind.

Thanks

Thanks all, this is really a great source of information.

1.As far as what you will call me in 2004,it will be pro2003 always saying when I joined this forum.

2....

This explains a lot. Thanks mccork.

I tired doign this

>bcp <DBName>.<TableName> in <FilePath>- S<ServerName> -U<UserName> -P<Password>

It came back with this error:

SQLState = S1000, NativeError = 0

Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP...

I tried to use the sp_textcopy and textcopy.exe utility but it doesnt let me insert a new row, it only works with a where clause and I want to insert...

I think I have some idea now. I will try all the approaches (To see which one works for me).

I would say that we are storing huge binary files...

Indexes effecting the save and edit times does make sense. As far the Application its self is concerned we have made all possible efforts to speed up the process of...

Thanks for your help every one, I have applied what you all wrote and it seems to be working. Just one more question:

I was using SQL Profiler based on a...

Thanks for your help every one. and good luck to you, garutyunyan, as well.

Thanks,

I will try that right now.

We are using crystal 8.5.

I am sorry, I forgot to mention that the same reports also work fine with SQL Server 2000/7.0. But not with MSDE 1.0.

I have not...

I already have, I have even talked to them about this, they were not sure of how to deal with MSDE as they were not familiar with it.

They did try...