I can not see import/export wizard in the express edition by right clicking on tasks at the database level. Can you let me know where can I find import/export wizard...

Thank you so much.

Hi, thanks for both of you on ur help. Infact I have built my query in the way sqlbill has suggested.

But I am into another issue. Some times my text...

Hi Jason,

It worked really good.

Thanks.

sorry guys this is an incomplete post.

sorry guys this is an incomplete post.

HEre is what I am doing.

So far I tried to restore the database from enterprise manager.

Now started restoring it from query analyzer.

The first step is restoring the fulllback taken on...

backupdiskfile:penMedia:Backup device d:\MSSQL\BACKUP\database1_00_08

Actually I am trying to restore the database backup from folder E.But the the restoration process is trying to restore backupdiskfile from...

No, I am trying to do the following.

First restoring the fullback taken on 11/21/2006 and then trying to apply the differential backups of the backup taken on 11/1/2006 starting from...

I am restoring the full backupbackup that was taken on 11/21/2006 and then trying to apply the differential backup of 11/1/2006.

I am getting the following message.

Cannot apply the backup on...

It worked like a dream.

Thanks for saving my day.

I am using sql server 2000 not sql server 2005.

Thanks.

SELECT prod_id,COUNT(booked_date),COUNT(delivered_Date),COUNT(booked_date)-COUNT(delivered_Date) FROM products

GROUP BY prod_id

I am using the above query and its giving the correct result. But I am thinking if there a better way to get the  above...

even if i try with . ( a period) i am getting the same error.

Thanks.

my server name is newdb and the service is mssql$newdb and I am trying to add the new instance as newdb in my enterprise manager.

Thanks for ur help.