Thanx boss, It worked...

You r genious..

Best of luck:

Noman

Thanx for ur prompt reply.. actually i want only first row. there is no PK. the data looks like:

100 0.0 98.0555555555555

100 1.0 1.0

103 1.0 98.0555555555555

Check the free disk space, there should be a reasonable free space on the publication Server.

What are Integeration Services, Please guide me how and from where I can install these services.

Tell me if there is any bad effect on the Database users and response.

Thanx.

Thanx, but I want to use the servername as the default value in my table. but when i used this statement 'select @@servername ' as a default value, it shows...

you can use Log Files to moniter the job's activity and steps as well.

May this will help you.

You should take the .mdf file of your DB and then Attach it with new Database name rather taking and restoring the backups.

It is much more faster than restore the...

Thanks but i have tried but it failed and show the message like:

there are some users logg on with that database..

but i know there is no user using that...

Thanx Greg!!

I got it in BOL, and found very usefull information and exactly that i want.

Thanx again.

hi, It depends on the situation. If you have static DB structure then you should go for simple pull Merge Agents. with daily replication.

If you have frequent changes in your...

Thanx for your considerations, actually we have three distributed databases and we have frequent updations in the db schema after a week.

and we have merge replication as well. you means...

Thanx for consideration,

Yes we are using most of our reports in the form of SP, but not all.

Indexing on some tables not on all.

specs of our dedicated server are.....

yes u can use convert function or u can use ltrim() as well to ur desired date result as u want.