sebagai catatan :
Proses ini harusnya tidak perlu di applikasi. Kalo pake sql server 2005
versi standard ada maintenace wizardnya.
reindex, rebuild statistik dan shrink database ada di sana semua
________________________________
From: Anez Story <anez_st...@yahoo.com>
To: programmer-vb@yahoogroups.com
Sent: Thu, June 17, 2010 2:26:04 PM
Subject: Re: [programmer-vb] Compact Sql Server 2005
uda selesai kok mas masalahnya.. hehe
cuma kurang codingnya saja..hehe
terima kasih atas tanggapannya. .
________________________________
From: Ida Bagus Putu Marwana <bimp.marwana@ gmail.com>
To: programmer-vb@ yahoogroups. com
Sent: Thu, June 17, 2010 12:03:41 AM
Subject: Re: [programmer- vb] Compact Sql Server 2005
pada post sebelumnya kan katanya muncul pesan error...
nah coba posting disini perintah yang dipake sehingga muncul pesan seperti itu.
dengan begitu kita bisa lebih spesifik bantunya...
Sent from Mozilla Thunderbird 3
Regards,
Bimp
On 6/17/10 1:31 PM, Anez Story wrote:
>
>Dear bimp,
>
>> maaf,saya justru bertanya syntax vb 6 untuk compact
> database sql server 2005..
>> jadi untuk melakukan compact database di lakukan melalui
> aplikasi vb 6..
>> mohon pencerahan nya..
>
>> On Thu Jun 17th, 2010 12:17 AM EDT Ida Bagus Putu Marwana
> wrote:
>
>> > coba di copykan kesini syntaxnya deh mungkin bisa
> lebih gampang untuk
>> >ngebantu...
>> >
>> >/Sent from my Mozilla Thunderbird 3/
>> >Regards,
>> >
>> >
>> >
>> >Bimp
>> >
>> >On 6/17/10 11:11 AM, Anez Story wrote:
>> >>
>> >>
>> >> *From:* Anez Story <anez_st...@yahoo. com>
>> >> *To:* programmer-vb@ yahoogroups. com
>> >> *Sent:* Wed, June 16, 2010 8:09:59 PM
>> >> *Subject:* Re: [programmer- vb] Compact Sql Server
> 2005
>> >>
>> >> dear johan max,
>> >>
>> >> iya ada. pesan nya :
>> >> compile error :
>> >> sub or function not defined
>> >>
>> >> kalau saya coba jalankan di query analyzer di sql
> server 2005
>> >> sukses..tapi kok saya coba jalankan di vb 6 ga
> bisa..
>> >>
>> >>
>> >>
> ------------ --------- --------- --------- --------- --------- -
>> >> *From:* johan max <johans...@yahoo. com>
>> >> *To:* programmer-vb@ yahoogroups. com
>> >> *Sent:* Wed, June 16, 2010 7:45:57 PM
>> >> *Subject:* Re: [programmer- vb] Compact Sql Server
> 2005
>> >>
>> >> Ada pesan kesalahan ?
>> >>
>> >>
>> >>
> ------------ --------- --------- --------- --------- --------- -
>> >> *From:* Anez Story <anez_st...@yahoo. com>
>> >> *To:* programmer-vb@ yahoogroups. com
>> >> *Sent:* Thu, June 17, 2010 8:02:26 AM
>> >> *Subject:* Re: [programmer- vb] Compact Sql
> Server 2005
>> >>
>> >> dear johan max,
>> >>
>> >> terima kasih atas tanggapan nya..
>> >> saya sudah coba jalanin lewat vb 6 kok ga bs ya?
>> >> mohon pencerahan nya..
>> >>
>> >>
>> >>
>> >>
> ------------ --------- --------- --------- --------- --------- -
>> >> *From:* johan max <johans...@yahoo. com>
>> >> *To:* programmer-vb@ yahoogroups. com
>> >> *Sent:* Wed, June 16, 2010 12:20:55 PM
>> >> *Subject:* Re: [programmer- vb] Compact Sql
> Server 2005
>> >>
>> >>
>> >> DBCC SHRINKDATABASE( NAMADATABASE) ,.
>> >> harus dba atau sysadmin atau storageadmin
>> >>
>> >>
> ------------ --------- --------- --------- --------- --------- -
>> >> *From:* Anez Story <anez_st...@yahoo. com>
>> >> *To:* Programmer VB <programmer-vb@
> yahoogroups. com>
>> >> *Sent:* Wed, June 16, 2010 10:17:36 AM
>> >> *Subject:* [programmer- vb] Compact Sql Server
> 2005
>> >>
>> >> dear all,
>> >>
>> >> ada yang tau cara compact database sql server
> 2005 melalui coding vb 6?
>> >> thanks
>> >>
>> >> best regrads,
>> >>
>> >> story
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>
>
