hi,

you can check Idera's - SQL Compliance Manger Tool

sql server is configured to use mixed mode authentication.

To fix the problem, you can call the following stored procedure:

sp_changedistpublisher 'YOUR-PUBLISHER-NAME', 'active', 'true'

thnaks a lot for the advice. i ahd the smae issue and wasted almost an hour to solve this problem !!!

you can cehck in your sql server log to find out why the backups failed. generally it turns to be an IOerror

hi all,

thanks for your response.

i have set up trace file to track database growth. i am not able to figure out at which query the data / log...

hi,

i have solved this problem. our network administrator ahd defined a policy accross the network disabling any users to install any kind of software on thier local machine. after he...

tnaks mike for your reply. i will go through it and check

i think when you do it will give you an error about the service pack compatibility issue.

i tried did this long time back but faintly remeber that i did get...

you can try exec sp_helplogins. but you will have to run this for all the databases. may be you can write a small script and use this sp to get...

hi all,

one more question.

when we create a windows group what all right apart those which the dba will give at sql server should be given ?

thanks.

hi,

try lloking for SQL Server Enterprise Manager.MSC

this will be where ur sql is installed eg C:\Program Files\Microsoft SQL Server\80\Tools\BINN.

try if it works.

hi tjay thanks a million for your help.

hi tjay excellent article !!!

i was jsut trying to browse thsi site and it give an error.

http://sigs.sqlpass.org/SIGs/AuditingCompliance/tabid/135/Default.aspx

and also i could not find the code for the jobs...

for sql server 2005

Before you configure Database Mail, you need to review the following prerequisites

1.Database Mail must be enabled

2.Service Broker needs to be enabled in the Database Mail host database

do...