[font="Times New Roman"]

When you restart your server instance, all the databases residing on that instance are recovered.

During recovery process all uncommitted transacations are rollbacked and all committed transactions are...

[font="Times New Roman"]

Its true that when we create cluster index in some other filegroup then table data would be in that file group also. but during backup table and index...

[font="Times New Roman"]

How a table can be transfered from one file group to another file group??

Regards,

Anil K

[/font]

[font="Times New Roman"]

Guest account can not be deleted but you can disable it.

[/font]

[font="Times New Roman"]

Hi,

It depends on indivisual perception. In my opinion, i would not change my current job in that case.

Regards,

Anil K

[/font]

[font="Times New Roman"]

Thanks a lot guys :-):-)

Regards,

Anil K

[/font]

[font="Times New Roman"]

Thanks for the link:-D.

By the way that link is related to Log shipping not database mirroring at all.

Regards,

Anil K

[/font]

[font="Times New Roman"]

First check your table data.

Regards,

Anil k

[/font]

[font="Times New Roman"]

Hi,

I am not clear with your requirement.

If count of code should be greater then or equals to two while grouping by groupid then 5th and 7th record could...

[font="Times New Roman"]

Hi,

Check the following script:

SELECT Number

FROM TABLE_NAME

WHERE code

IN

(

SELECT code

FROM TABLE_NAME

GROUP BY Type

HAVING COUNT(*)>=2

)

GROUP BY code

HAVING COUNT(*)>2

Regards,

Anil K

[/font]

[font="Times New Roman"]

Hi Shilpa,

As far as my knowledge is concerned we don't need shared folder when configuring database mirroring.

Regards,

Anil k

[/font]

[font="Times New Roman"]

Thanks a bunch for your precious time:-)

I want to know whether database mirroring uses two phase commit or not. If not then how a transaction can be committed...

[font="Times New Roman"]

Thnx for sharing the link:-)

[/font]

[font="Times New Roman"]

Hi,

You may try something like:

CREATE TRABLE dbo.tblName (id INT)

Regrads,

Anil

[/font]

[font="Times New Roman"]

Hello Imran,

I agree with you that principal will wait for acknowledgement from mirror. But if mirror is responding lately in that case: principal would not process any more...