It is not advisable to use truncate log command on the Tlog replicated database. As in Tlog replication logreader agent is reading data from LOG ONLY!!!.

Try

sp_helplogins

to find the logins previlages.

Refer the following link to understand locks in detail:

http://support.microsoft.com/kb/822101/en-us

Guest user permission is default for the every user and as the Application Role created for the perticular database is having minimum credential as Guest user.

But here it is...

In any programme 100% accuracy is not possible and there will be some bug. Hence I stongly recommend for Service Pack 3.

Mearly selling product will not help in long tearm;...

Remember one thumb rule; if your query fetches more than 50% than table scan is ideal else use indexes.

Most probably as per database design empid is primary key (to...

Just try following link:

http://www.nyx.net/~bwunder/sql/logSync.htm

Just post your feedback.

Best thing is you can try your query creting cluster Index, Non-cluster index and without using any index.

If we think logically field is having M or F and probably half...

As your database is in full recovery mode; your log file is getting biger and unable to free the space of logfile. For the solution of this questions you need...

Refer the following link:

http://support.microsoft.com/kb/271509

http://support.microsoft.com/kb/832524

http://support.microsoft.com/kb/q169960/

There are two ways to monitor your logs:

1. While setting up logshipping configure monitor server which will keep all the track of tlog applied or is lacking behind or out...

you can also refer (Scott's quer is part of sp_helpdb)

sp_helpdb

See the status of the database.

I think Scott's query is more close to your requirement.

It is possible.

You have to create package and than use Altiris to deploy the same on the server. If licencing of Altiris is the problem you can run the package...

Subject to your company policy if you are using mixmode security you can assign the 'SA' for the maintenance jobs.

Do not forget to check your company policy; why they have...

DBCC SHRINKFILE

( { file_name | file_id }

{ [ , target_size ]

...