We do not have date fields in the table.

Do you mean something like this???

SELECTTOP 10 *

FROMdbo.table1

order by field1code desc

I just tried this but I am not sure if this is the correct one. field1code is being indexed (cluster)....

And also when I just complete some maintenance on the database, then click the database, I am getting the same error, same resolution.....

Yes. I am having this problem with BIGGER databases. I am not having any problems for under-10Gig databases. If the database size is morethan 10Gig then I am having the...

You could also use Transfer Database Object Transfer Task in DTS Package (in SQL 2000). I used the same today for a transferring 3 tables across databases & Servers.

I am running the following way for the scheduled jobs in SQL Server 6.5 so that they will create the outfiles, since there is no option in SQL 6.5 to...

Absolutely based on the SPACING and the client requirements.

I normally keep full backups for 1 week for moderate databases (in size), 3 days for huge databases. Anyway these backups would...

Excellent Insight Article.

Allen,

But in my case, we have applied SP3. But still its showing the following:

EM properties = 8.00.760(SP3)

SP_Server_Info = 8.00.534(SP2)

The OS is Windows 2000 Server SP2.

Something fishy...

For me also its giving different values. I tried to run teh profiler when I run the Enterprise Manager. Here is the following statements it executed. But most of the...

I am hainvg SQL Server 2000 on Windows 2000 Server.

Ravi,

You might have scheduled a weekly job & mentioned 4 in the options in the command. Hence SQL Server will keep 4 weeks of Backups. If you schedule a Daily...

Thank You. I am doing the same. But I thought I would take Monthly backup of .mdf and .ldf files.

Thanks for your suggestion.

I guess you can DUMP the transaction before kicking off the maintenance plan, then after the maintenance plan, you can check how much is the log. If its too big,...

Bruce: You might want to check the syntax and options for SQLMAINT.EXE in BOL.