Hi,

I am not sure about revert back may be there is any way to regenerate datafile using log, but for log you can detach database then rename log file and...

Tyr this....

select a.namapoli, a.jumpoli, a.namainstansi, a.kodeperusahaan, a.karcis, b.tindakan, c.alkes

from

(SELECT

rj_poliklinik.nmpoli as namapoli,count (rj_reg.kdpoli) as jumpoli,rj_reg.kdperusahaan as kodeperusahaan,

instansi.nminstansi as namainstansi,sum (rj_transdt.komptr1) as karcis

FROM rj_reg

JOIN rj_transdt on rj_reg.noreg = rj_transdt.noreg

JOIN rj_poliklinik on rj_reg.kdpoli...

Lowell (6/26/2013)

---

i would do a backup and restore as -a-new-database name so both sources are on a single instance, and then review the differences for either specific insert/update/delete, or a...

Thanks Dear,

Can u suggest me fastest way to do this coz i have too low down time(approx 1 Hr) and...

Thanks dineshvishe.

Got it on configuration 🙂

Ed Wagner (5/30/2013)

---

Is the delete statement going to become part of a daily maintenance job on the table or is this a one-time task?

If you're creating a daily maintenance, what...

Ed Wagner,

Thanks for reply.

Data type of reporttime is datetime and i already use nonclustered index on it. I am using cast to convert it on date from datetime.

Thanks for reply,

Actually its most frequently used table and mostly inserts are happend.

we got 1,00,000 data on daily basis it alway contain at least 50,00,000 records.

Is there any way...

Thanks Jack. . .

Hi m.rajesh

Go to Control panel>>User Accounts

and to see permission on D drive >>right click on d:>>property>>security>>Click on user and see the permission.

I don't think there...

agreed with Abu Dina, Please check in Administrative Tools>>services>> Sql server>> Property >> logon

Then check which user is used and see the permissions.

Hi avdhut.k,

Please replace AND with OR and your query will work 🙂

hi eddy,

i don't think that Windows Domain security restrict to drop sql server user.

Its a dumb thought but can u please refresh server and see that user is exist...

Hi eddy,

Please Use sp_msloginmappings and check test user detail and then delete from that database.

or post details for test user.