Some things to remember when using the SQL Agent p(r)oxy account...  1) If the job owner is a SQL Sysadmin, all SQL and file access is done using the security...

I definitely agree wit hqcp77's posting.  In any job management tool (Control-M, Tivoli, Unicenter,etc), the object is to replace the SQL Agent batch processing so you get the benefits of...

As other people have said, you cannot stop a sysadmin doing whatever they want.

However, you can prevent them reading data that is sensitive, and you can find out what changes...

So, you are saying that a query run on a box with 1.6 Ghz of power runs slower than a query run on a box with 5,6 Ghz of power. ...

Remi is completely correct.  I have been working with relational databases for over 20 years and my advise would be the same as Remi's.

All that I would add is if...

Did you format your new disk as basic or dynamic.  If you used dynamic you may need to set the Bypass Traverse Checking right.

Either way, hopefully you will have checked...

You can lead a user to data, but you cannot make them think.

The issues around having Exchange and database servers distributed around the world seem the sort of problem you could get a good consultancy organisation to find a solution to...

If your organisation is affected by SoX or similar nlegislation, it may be worth checking with your Compliance people before using Simple recovery mode.  They may take the view you...

If xp_sendmail encounters a timeout when connecting to Exchange, xp_sendmail is disabled until SQL Server is restarted.

Outlook may work fine, but once xp_sendmail has been disabled, SQL Server needs to...

The root cause of the problem is a glitch in the mail processing.  There are a few KB articles about different variations of this, and how long the impact lasts...

When you use Windows authentication, the accounts must be set up as domain\ID in SQL Server.  This can easily be done in Enterprise Manager.

I strongly recommend that you assign your...

Using a file system for images may look like the easiest to design, but it is also by far the hardest to maintain.  There have been a lot of posts...

You can change the table owner to dbo with sp_changeobjectowner.  You will have to re-link the tables in Access after doing this.

If you want any new tables from that user to...

SQL is poorer than some other DBMSs in recognising dates in character strings.  If dates are in YYYY/MM/DD format (you can use other delimiters in place of the /) your...