No, that's not possible. I think the main reason why not, is the fact the the service account(s) can only be windows accounts and they need access to the server.

BTW if you're on SP2 or higher you can also do it in a maintenace plan, but thats basically a SSIS package as well.

I would do this in a SSIS package instead of a procedure. First of all it's easier to have multiple connections and second you can easily define different branches depending...

Add a maintenance cleanup task to your maintenance plan.

Ross McMicken (7/30/2008)

---

OK, it makes sense to grant a SQL login used only by an application the ability to change data. We do that by making the SQL login dbo....

Don't know about the latest patches, but so far I had never any problems. But of course that's not a guarantee for your situation.

Just remember to also update the...

I don't know about an option to comment ouot everything on the page, but to comment out the rows selected the default in SQL 2005 is Ctrl + K, Ctrl...

In SQL 2000 you can configure SQL Mail, which is used when executing xp_sendmail and SQL Agent Mail, which is used to send job notifications. You can set the profile...

The reports in SQL 2005 are based on dynamic management views which of course are not available in 2000. But can can still collect a fair bit of information in...

Most likely reason for this is that you don't have enough permission to add or view reports. Check if your windows account has access to the ReportServer database.

Don't wanna be too picky but from the answer:

The “//*” XQuery path matches every element node in the XML document, so (b) is also incorrect.

And I thought "B" was the...

db_datareader gives the right to run SELECT queries on any table or view. db_datawriter allows INSERT, UPDATE and DELETE on any tyable or view.

If you do all your data...

There is no standard database role for executing stored procedurees, but if you're using SQL 2005 you can grant execute permission on the schema which contains the stored procedures.

Dogers,

the article you mentioned describes how to replicate a databases which is also mirrored. But the principal database is published.

From what I understand from the original poster he doesn't...

I agree with Denby.

You're scenario is not possible, neither with logshipping nor with mirroring. The logshipped database would be in standby mode and can't be replicated. When using DB mirroring,...