hi Sumit

Well there are lots of stacks being generated.I'm pasting here one of the stacks generated

=====================================================================         

       BugCheck Dump                                                          

=====================================================================         

This file is generated by Microsoft SQL Server 8.00.2039                      ...

Hi

Here U need to check one thing are they all using the sa account to get connected to SQL server thru EM or what??If they are using the sa account...

hi

Should we have fixed growth for the transaction file also.

hi

hi

First of all you need to check if you have restriced the filegrowth for the database or not.If you have restricted the size then you need to add another file...

hi

Well I don't have idea about ur previous post but if you add another file that is ndf to the database by default it will be added to the default...

HI

Well tx a lot for those responses. i created an index on a varchar(1000) column and it was created but with a warning.After this I was able to insert data...

So you want to say that if the column on which I'm creating the index has a length of char(1000) then I cannot create an index on this.

Hi

Could anyone please let me know the cause of this error and how to exactly trap it.

Hi

Some dlls had also got corrupted and due to this backup was also not working. So we had reinstalled the sql server.

But still there is one problem.

The could Not Open...

Hi

No this does not applies to my case.We do not have text and image data..

Hi

• SP3a
• Windows 2000 with service pack 4

How do I get the stack..

There are no hardware errors in the system log.

Any help on this..I'm stuck.

Hi

That was fake data but still I have removed it.

Hi

But I have to get all the data from one table only.Now the scenario is like I have one name_id field and on this there can be 10 cards...