Re-indexing through clocks changing

I was planning to re-index my database (225GB) this coming weekend however I
have just realised that it will be running through the server clock changing
(advancing 1 hour). Will this have any adverse effect on the procedure?
GavNo problem. The only thing to be careful with is when you go back in time,
and you have transactions occurring during that time, you can find yourself
in a position where you cannot do point in time restore for transaction that
occurred during that hour.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Gavin Metcalfe" <gavin.metcalfe@.btinternet.com> wrote in message
news:c3n37r$l3p$1@.hercules.btinternet.com...
> I was planning to re-index my database (225GB) this coming weekend however
I
> have just realised that it will be running through the server clock
changing
> (advancing 1 hour). Will this have any adverse effect on the procedure?
> Gav
>

re-index takes twoce as long on 2005..

Hi
I run a reindex of a 130GB dabase on SQL 2000 and it takes almost exactly 4
hours. IF I run exactly the same command on a 2005 box against a restore of
exactly the same database, it takes almost exactly 8 hours.
am I missing someting here? does a re-ind on 2005 work differently than on
2000? is it doing something twice that I havent asked it to, and that it must
be doing by default?
Any help would be appreciated.
ta
Hi,
Can you see if you have enough room in LDF file while doing the reindex in
SQL 2005. Otherwise the autogrow will happen
and slow down the reindex command...
Thanks
Hari
"Methodology" <Methodology@.discussions.microsoft.com> wrote in message
news:285AE110-BFF1-4CAF-88A6-616C2D8491C9@.microsoft.com...
> Hi
> I run a reindex of a 130GB dabase on SQL 2000 and it takes almost exactly
> 4
> hours. IF I run exactly the same command on a 2005 box against a restore
> of
> exactly the same database, it takes almost exactly 8 hours.
> am I missing someting here? does a re-ind on 2005 work differently than on
> 2000? is it doing something twice that I havent asked it to, and that it
> must
> be doing by default?
> Any help would be appreciated.
> ta
|||Ive tried 'alter index x rebuild' instead of 'dbcc dbreindex' and its
slightly more thsan an hour quicker on my largest table...I think therefore
problem solved.
ta
"Hari Prasad" wrote:

> Hi,
> Can you see if you have enough room in LDF file while doing the reindex in
> SQL 2005. Otherwise the autogrow will happen
> and slow down the reindex command...
> Thanks
> Hari
> "Methodology" <Methodology@.discussions.microsoft.com> wrote in message
> news:285AE110-BFF1-4CAF-88A6-616C2D8491C9@.microsoft.com...
>
>
|||They use exactly the same code. Is the hardware the same between 2000 and
2005, specifically number of CPUs and IO bandwidth?
Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
"Methodology" <Methodology@.discussions.microsoft.com> wrote in message
news:F3B117CE-C3AF-4FCB-A328-A7FC66B7344B@.microsoft.com...[vbcol=seagreen]
> Ive tried 'alter index x rebuild' instead of 'dbcc dbreindex' and its
> slightly more thsan an hour quicker on my largest table...I think
> therefore
> problem solved.
> ta
> "Hari Prasad" wrote:

Re-Index SQL Server Express User Instance?

Is there a way to re-index a SQL Server Express User Instance? If I try to open the .mdf while the website is still running, I get a message stating that the file is in use. If I shut down the web service and open the .mdf, then restart the website, then the website cannot access the .mdf while I have it open in VStudio (reminds me a lot of Access).

In the past I tried to open a user instance with SQL Server Management Studio, but then it goofed up my user-instance...so I am hesitant to try that again. Is there any way to re-index?

Thanks!

Backup and restore and adjust Web.Config, then ALTER Table drop INDEX and REINDEX, the reason is currently your User Instance is behaving like a separate instance of SQL Server and that is not valid. Hope this helps.

http://forums.asp.net/thread/1454694.aspx

Re-Index Script

I would like to re-index two tables (t1 and t2) if the logical scan
fragmentation is greater 80% on these tables.
Please help me create a t-sql script to create this task.
Thank You,Have a look at the samples in BooksOnLine under DBCC SHOWCONTIG.
Andrew J. Kelly SQL MVP
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:E1AF96CD-2AC5-4BDB-AF79-43CAD668A773@.microsoft.com...
>I would like to re-index two tables (t1 and t2) if the logical scan
> fragmentation is greater 80% on these tables.
> Please help me create a t-sql script to create this task.
> Thank You,
>|||DBCC Showcontig will give you the information on how fragmented etc. is your
table.
You can use DBCC Reindex to Reindex your tables(TABLES WILL BE OFFLINE).
You can also use DBCC Defrag to defrag your tables(It's an online process).
Also, it'll grow your logfile like anything if your tables are huge. So,
Beware.

reindex one database with fatest way

Dear all,
How to re-index in one database with fastest way (not per-table) ?
Regards,
Koronx
SQL Hobbistphysically, how would you imagine that? Index is strictly related to table
so reindexing also has to be done per table.
Peter
"Kornx Koronx" <KornxKoronx@.discussions.microsoft.com> wrote in message
news:1A8C4AA7-85BF-4C5F-8B64-FAF0E98B2E28@.microsoft.com...
> Dear all,
> How to re-index in one database with fastest way (not per-table) ?
> Regards,
> Koronx
> SQL Hobbist

re-Index advice

We periodically rebuild our indexes when we notice defragmentation of
indexes however after rebuilding the indexes we do not recompile the
stored procedure. My experience has been that after rebuiling the
indexes we ususlly notice a performance gain right away however I was
wondering if it is also necessary to recompile all our stored
procedures after the indexes are rebuilt. What is the best practise?
ThanksWhen you reindex an index it will by default update the stats which
invalidate the plans for anything that references them. That in turn will
force the recompile of the plan the next time it is used. So in short you do
not need to recompile after an index rebuild as it is already done for you.
--
Andrew J. Kelly SQL MVP
"shub" <shubtech@.gmail.com> wrote in message
news:1154619914.120880.28460@.b28g2000cwb.googlegroups.com...
> We periodically rebuild our indexes when we notice defragmentation of
> indexes however after rebuilding the indexes we do not recompile the
> stored procedure. My experience has been that after rebuiling the
> indexes we ususlly notice a performance gain right away however I was
> wondering if it is also necessary to recompile all our stored
> procedures after the indexes are rebuilt. What is the best practise?
> Thanks
>|||shub wrote:
> We periodically rebuild our indexes when we notice defragmentation of
> indexes however after rebuilding the indexes we do not recompile the
> stored procedure. My experience has been that after rebuiling the
> indexes we ususlly notice a performance gain right away however I was
> wondering if it is also necessary to recompile all our stored
> procedures after the indexes are rebuilt. What is the best practise?
> Thanks
>
Defragging the indexes shouldn't require recompiling anything, unless
the indexes were so badly fragmented that the optimize was ignoring them
and using a sub-optimal execution plan. I personally have never had to
do this.
You don't say how you "notice" fragmentation, but you might consider an
automated approach that runs nightly or weekly. See my site for one
possible method:
http://realsqlguy.com/twiki/bin/view/RealSQLGuy/DefragIndexesAsNeeded
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks Andrew that makes sense. What would be the best way to check to
make sure that the stored proc's are indeed getting recompiled?
Thanks
shub wrote:
> We periodically rebuild our indexes when we notice defragmentation of
> indexes however after rebuilding the indexes we do not recompile the
> stored procedure. My experience has been that after rebuiling the
> indexes we ususlly notice a performance gain right away however I was
> wondering if it is also necessary to recompile all our stored
> procedures after the indexes are rebuilt. What is the best practise?
> Thanks|||Well it is not something one generally has to check on. If you know the
stats are getting updated (you can see with DBCC SHOWSTTISTICS) then you can
count on any plans that reference those stats to get recompiled the next
time they are run. This is true in all cases unless you have used the KEEP
PLAN or KEEP FIXED PLAN hints in the query.
--
Andrew J. Kelly SQL MVP
"shub" <shubtech@.gmail.com> wrote in message
news:1154694889.877119.181210@.p79g2000cwp.googlegroups.com...
> Thanks Andrew that makes sense. What would be the best way to check to
> make sure that the stored proc's are indeed getting recompiled?
> Thanks
>
> shub wrote:
>> We periodically rebuild our indexes when we notice defragmentation of
>> indexes however after rebuilding the indexes we do not recompile the
>> stored procedure. My experience has been that after rebuiling the
>> indexes we ususlly notice a performance gain right away however I was
>> wondering if it is also necessary to recompile all our stored
>> procedures after the indexes are rebuilt. What is the best practise?
>> Thanks
>

re-Index advice

We periodically rebuild our indexes when we notice defragmentation of
indexes however after rebuilding the indexes we do not recompile the
stored procedure. My experience has been that after rebuiling the
indexes we ususlly notice a performance gain right away however I was
wondering if it is also necessary to recompile all our stored
procedures after the indexes are rebuilt. What is the best practise?
ThanksWhen you reindex an index it will by default update the stats which
invalidate the plans for anything that references them. That in turn will
force the recompile of the plan the next time it is used. So in short you do
not need to recompile after an index rebuild as it is already done for you.
Andrew J. Kelly SQL MVP
"shub" <shubtech@.gmail.com> wrote in message
news:1154619914.120880.28460@.b28g2000cwb.googlegroups.com...
> We periodically rebuild our indexes when we notice defragmentation of
> indexes however after rebuilding the indexes we do not recompile the
> stored procedure. My experience has been that after rebuiling the
> indexes we ususlly notice a performance gain right away however I was
> wondering if it is also necessary to recompile all our stored
> procedures after the indexes are rebuilt. What is the best practise?
> Thanks
>|||shub wrote:
> We periodically rebuild our indexes when we notice defragmentation of
> indexes however after rebuilding the indexes we do not recompile the
> stored procedure. My experience has been that after rebuiling the
> indexes we ususlly notice a performance gain right away however I was
> wondering if it is also necessary to recompile all our stored
> procedures after the indexes are rebuilt. What is the best practise?
> Thanks
>
Defragging the indexes shouldn't require recompiling anything, unless
the indexes were so badly fragmented that the optimize was ignoring them
and using a sub-optimal execution plan. I personally have never had to
do this.
You don't say how you "notice" fragmentation, but you might consider an
automated approach that runs nightly or weekly. See my site for one
possible method:
http://realsqlguy.com/twiki/bin/vie...IndexesAsNeeded
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks Andrew that makes sense. What would be the best way to check to
make sure that the stored proc's are indeed getting recompiled?
Thanks
shub wrote:
> We periodically rebuild our indexes when we notice defragmentation of
> indexes however after rebuilding the indexes we do not recompile the
> stored procedure. My experience has been that after rebuiling the
> indexes we ususlly notice a performance gain right away however I was
> wondering if it is also necessary to recompile all our stored
> procedures after the indexes are rebuilt. What is the best practise?
> Thanks|||Well it is not something one generally has to check on. If you know the
stats are getting updated (you can see with DBCC SHOWSTTISTICS) then you can
count on any plans that reference those stats to get recompiled the next
time they are run. This is true in all cases unless you have used the KEEP
PLAN or KEEP FIXED PLAN hints in the query.
Andrew J. Kelly SQL MVP
"shub" <shubtech@.gmail.com> wrote in message
news:1154694889.877119.181210@.p79g2000cwp.googlegroups.com...
> Thanks Andrew that makes sense. What would be the best way to check to
> make sure that the stored proc's are indeed getting recompiled?
> Thanks
>
> shub wrote:
>

re-index

How do you re-index in SQL 2000? Thanks.Take a look at dbcc dbreindex on Books Online.
Ben Nevarez, MCDBA, OCP
Database Administrator
"00KobeBrian" wrote:
> How do you re-index in SQL 2000? Thanks.
>
>|||Hi,
Check following two articles:
http://msdn2.microsoft.com/en-us/library/ms181671.aspx
http://msdn2.microsoft.com/en-us/library/ms188388.aspx
They apply to SQL 2000 as well.
Thanks.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>Thread-Topic: re-index
>>thread-index: AcacAMlXlL8ktvHYQViANEhvVtN9nA==>>X-WBNR-Posting-Host: 66.174.79.241
>>From: =?Utf-8?B?QmVuIE5ldmFyZXo=?= <bnevarez@.sjm.com>
>>References: <OF8reV$mGHA.4964@.TK2MSFTNGP04.phx.gbl>
>>Subject: RE: re-index
>>Date: Thu, 29 Jun 2006 21:51:01 -0700
>>Lines: 13
>>Message-ID: <DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
>>MIME-Version: 1.0
>>Content-Type: text/plain;
>> charset="Utf-8"
>>Content-Transfer-Encoding: 7bit
>>X-Newsreader: Microsoft CDO for Windows 2000
>>Content-Class: urn:content-classes:message
>>Importance: normal
>>Priority: normal
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>>Newsgroups: microsoft.public.sqlserver.server
>>Path: TK2MSFTNGXA01.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:436825
>>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>
>>Take a look at dbcc dbreindex on Books Online.
>>Ben Nevarez, MCDBA, OCP
>>Database Administrator
>>
>>"00KobeBrian" wrote:
>> How do you re-index in SQL 2000? Thanks.
>>
>>|||Hi Vincent,
Looks like alter index does not apply to SQL Server 2000.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Vincent Xu [MSFT]" wrote:
> Hi,
> Check following two articles:
> http://msdn2.microsoft.com/en-us/library/ms181671.aspx
> http://msdn2.microsoft.com/en-us/library/ms188388.aspx
> They apply to SQL 2000 as well.
> Thanks.
>
> Best regards,
> Vincent Xu
> Microsoft Online Partner Support
> ======================================================> Get Secure! - www.microsoft.com/security
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties,and confers no rights.
> ======================================================>
> --
> >>Thread-Topic: re-index
> >>thread-index: AcacAMlXlL8ktvHYQViANEhvVtN9nA==> >>X-WBNR-Posting-Host: 66.174.79.241
> >>From: =?Utf-8?B?QmVuIE5ldmFyZXo=?= <bnevarez@.sjm.com>
> >>References: <OF8reV$mGHA.4964@.TK2MSFTNGP04.phx.gbl>
> >>Subject: RE: re-index
> >>Date: Thu, 29 Jun 2006 21:51:01 -0700
> >>Lines: 13
> >>Message-ID: <DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
> >>MIME-Version: 1.0
> >>Content-Type: text/plain;
> >> charset="Utf-8"
> >>Content-Transfer-Encoding: 7bit
> >>X-Newsreader: Microsoft CDO for Windows 2000
> >>Content-Class: urn:content-classes:message
> >>Importance: normal
> >>Priority: normal
> >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> >>Newsgroups: microsoft.public.sqlserver.server
> >>Path: TK2MSFTNGXA01.phx.gbl
> >>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:436825
> >>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> >>X-Tomcat-NG: microsoft.public.sqlserver.server
> >>
> >>
> >>Take a look at dbcc dbreindex on Books Online.
> >>
> >>Ben Nevarez, MCDBA, OCP
> >>Database Administrator
> >>
> >>
> >>"00KobeBrian" wrote:
> >>
> >> How do you re-index in SQL 2000? Thanks.
> >>
> >>
> >>
> >>
>|||Hi All,
Sorry, my mistake.I assume this as a matter of course
We have to use DBCC
Check following article:
<http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.msp
x>
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>Thread-Topic: re-index
>>thread-index: AcacDD33LO1Sb0jRQ3OKhL7Qt+d/RQ==>>X-WBNR-Posting-Host: 150.202.8.1
>>From: =?Utf-8?B?QmVuIE5ldmFyZXo=?= <bnevarez@.sjm.com>
>>References: <OF8reV$mGHA.4964@.TK2MSFTNGP04.phx.gbl>
<DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
<rJ$Z6gAnGHA.2028@.TK2MSFTNGXA01.phx.gbl>
>>Subject: RE: re-index
>>Date: Thu, 29 Jun 2006 23:13:01 -0700
>>Lines: 82
>>Message-ID: <97CCD26D-249B-46EB-8657-9A6DC5339867@.microsoft.com>
>>MIME-Version: 1.0
>>Content-Type: text/plain;
>> charset="Utf-8"
>>Content-Transfer-Encoding: 7bit
>>X-Newsreader: Microsoft CDO for Windows 2000
>>Content-Class: urn:content-classes:message
>>Importance: normal
>>Priority: normal
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>>Newsgroups: microsoft.public.sqlserver.server
>>Path: TK2MSFTNGXA01.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:436830
>>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>
>>Hi Vincent,
>>Looks like alter index does not apply to SQL Server 2000.
>>Ben Nevarez, MCDBA, OCP
>>Database Administrator
>>
>>"Vincent Xu [MSFT]" wrote:
>> Hi,
>> Check following two articles:
>> http://msdn2.microsoft.com/en-us/library/ms181671.aspx
>> http://msdn2.microsoft.com/en-us/library/ms188388.aspx
>> They apply to SQL 2000 as well.
>> Thanks.
>>
>> Best regards,
>> Vincent Xu
>> Microsoft Online Partner Support
>> ======================================================>> Get Secure! - www.microsoft.com/security
>> ======================================================>> When responding to posts, please "Reply to Group" via your newsreader
so
>> that others
>> may learn and benefit from this issue.
>> ======================================================>> This posting is provided "AS IS" with no warranties,and confers no
rights.
>> ======================================================>>
>> --
>> >>Thread-Topic: re-index
>> >>thread-index: AcacAMlXlL8ktvHYQViANEhvVtN9nA==>> >>X-WBNR-Posting-Host: 66.174.79.241
>> >>From: =?Utf-8?B?QmVuIE5ldmFyZXo=?= <bnevarez@.sjm.com>
>> >>References: <OF8reV$mGHA.4964@.TK2MSFTNGP04.phx.gbl>
>> >>Subject: RE: re-index
>> >>Date: Thu, 29 Jun 2006 21:51:01 -0700
>> >>Lines: 13
>> >>Message-ID: <DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
>> >>MIME-Version: 1.0
>> >>Content-Type: text/plain;
>> >> charset="Utf-8"
>> >>Content-Transfer-Encoding: 7bit
>> >>X-Newsreader: Microsoft CDO for Windows 2000
>> >>Content-Class: urn:content-classes:message
>> >>Importance: normal
>> >>Priority: normal
>> >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>> >>Newsgroups: microsoft.public.sqlserver.server
>> >>Path: TK2MSFTNGXA01.phx.gbl
>> >>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:436825
>> >>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>> >>X-Tomcat-NG: microsoft.public.sqlserver.server
>> >>
>> >>
>> >>Take a look at dbcc dbreindex on Books Online.
>> >>
>> >>Ben Nevarez, MCDBA, OCP
>> >>Database Administrator
>> >>
>> >>
>> >>"00KobeBrian" wrote:
>> >>
>> >> How do you re-index in SQL 2000? Thanks.
>> >>
>> >>
>> >>
>> >>
>>

re-index

Take a look at dbcc dbreindex on Books Online.
Ben Nevarez, MCDBA, OCP
Database Administrator
"00KobeBrian" wrote:

> How do you re-index in SQL 2000? Thanks.
>
>Hi,
Check following two articles:
http://msdn2.microsoft.com/en-us/library/ms181671.aspx
http://msdn2.microsoft.com/en-us/library/ms188388.aspx
They apply to SQL 2000 as well.
Thanks.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]|||Hi Vincent,
Looks like alter index does not apply to SQL Server 2000.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Vincent Xu [MSFT]" wrote:

> Hi,
> Check following two articles:
> http://msdn2.microsoft.com/en-us/library/ms181671.aspx
> http://msdn2.microsoft.com/en-us/library/ms188388.aspx
> They apply to SQL 2000 as well.
> Thanks.
>
> Best regards,
> Vincent Xu
> Microsoft Online Partner Support
> ========================================
==============
> Get Secure! - www.microsoft.com/security
> ========================================
==============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties,and confers no rights.
> ========================================
==============
>
> --
>|||How do you re-index in SQL 2000? Thanks.|||Take a look at dbcc dbreindex on Books Online.
Ben Nevarez, MCDBA, OCP
Database Administrator
"00KobeBrian" wrote:

> How do you re-index in SQL 2000? Thanks.
>
>|||Hi,
Check following two articles:
http://msdn2.microsoft.com/en-us/library/ms181671.aspx
http://msdn2.microsoft.com/en-us/library/ms188388.aspx
They apply to SQL 2000 as well.
Thanks.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]|||Hi Vincent,
Looks like alter index does not apply to SQL Server 2000.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Vincent Xu [MSFT]" wrote:

> Hi,
> Check following two articles:
> http://msdn2.microsoft.com/en-us/library/ms181671.aspx
> http://msdn2.microsoft.com/en-us/library/ms188388.aspx
> They apply to SQL 2000 as well.
> Thanks.
>
> Best regards,
> Vincent Xu
> Microsoft Online Partner Support
> ========================================
==============
> Get Secure! - www.microsoft.com/security
> ========================================
==============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties,and confers no rights.
> ========================================
==============
>
> --
>|||Hi All,
Sorry, my mistake.I assume this as a matter of course
We have to use DBCC
Check following article:
<http://www.microsoft.com/technet/pr...in/ss2kidbp.msp
x>
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
<DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
<rJ$Z6gAnGHA.2028@.TK2MSFTNGXA01.phx.gbl>[vbcol=seagreen]
so[vbcol=seagreen]
rights.[vbcol=seagreen]|||Hi All,
Sorry, my mistake.I assume this as a matter of course
We have to use DBCC
Check following article:
<http://www.microsoft.com/technet/pr...in/ss2kidbp.msp
x>
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
<DD275389-46FA-4FA8-AD04-C9AB9FE75B21@.microsoft.com>
<rJ$Z6gAnGHA.2028@.TK2MSFTNGXA01.phx.gbl>[vbcol=seagreen]
so[vbcol=seagreen]
rights.[vbcol=seagreen]