ALTER AUTHORIZATION ON DATABASE::[dbname] to [owner]

For Example

ALTER AUTHORIZATION ON DATABASE::adventureworks to sa

Check out BOL

Are you sure the SQL Server service is running when you are doing the deletes?

In SSMS you can navigate to the DB right-click -> properties -> Options. It is the top option.

OR

exec sp_dboption [dbname], 'autoclose'

Have you looked at the job steps? There are parameters/options in the call to run DTS that may include the changed password.

SQL Agent Jobs have an owner that must have rights to run a job. Look in BOL under Proxy accounts (SQL Server Agent).

Here is a link to a forum where someone has SQLMail working with Notes using MAPI, but has a different problem, so it is possible to use SQLMail.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=15912

As far as...

My first disclaimer, I know nothing about Notes, but if you can use Outlook (not Outlook Express) to connect Notes I believe you can use SQLMail.

For SQLMail to worl you...

Thanks for the welcome to FL. I am really enjoying the weather.

I know there is something going on as far as a Jacksonsville PASS group. There is a...

Brad Rhine (12/19/2007)

---

That is a good suggestion, yet we were testing the limitations of Report Builder and have run into a few similar to this. The users current...

Could you use a link to another report instead of bringing all the data down?

If I had not gone to the meeting last night I would have done the same thing for the columns. I had always assumed that it was building the...

Did you set the Maximum Insert Commit Size on each destination? IF left to 0 it does one BIG transaction so committing after x rows will probably free resources...

PLease post your code. Also if you are running this against a column in a table there is an invalid date. Look in BOL for valid dates for...

Is the drill down a sub-report or a layer in the matrix?

Mike Levan (12/18/2007)

---

when i tried doing this

select startDate from tblemp where startDate between '1/1/2006' and '12/31/2006'

i dont get that date range, why?

startdate is varchar(100), I Cant change that in the...