Thanks for the link.

WHen you changed the service account for your SQL Server where did you change it from?

SQL Server Configuration Manager?

or

Windows Services?

Thanks.

Why not just use sp_send_dbmail's functionality to send the query as an attachment?

sp_send_dbmail [ [ @profile_name = ] 'profile_name' ]

[ , [ @recipients = ] 'recipients...

Read through http://www.sqlservercentral.com/Forums/Topic675622-146-2.aspx ... there is alot in there on how to get Server back up after system dbs are lost.

Check out: http://blog.sqlauthority.com/2007/10/18/sql-server-2005-fix-error-msg-7411-level-16-state-1-server-is-not-configured-for-rpc/

And what permision did you give it? When you try it from app does it return to you saying login failed with state information?

Mohit.

Check the error logs to see if there are failed logins?

Check http://sqllearnings.blogspot.com/2008/10/error-18456-severity-14-login-failed.html. If there is an error 18456; that article can help you narrow down where the...

larry Hennig (3/13/2009)

---

LOL! I just realized "Ten Centuries" is a descriptor, not a handle. DOH!:D

It now seems clear that I need to be prepared for a REBUILD or...

larry Hennig (3/13/2009)

---

Ten Centuries, I had left out the fact that we also make on-disk backups of all system databases and user databases, and those BAK and TRN files are...

Sorry I missunderstood a bit; if you can't even start the SQL Server you have to first rebuild you master database.

You do that with following command using the setup files...

Does the database have FK defined? If so you can right click on the table and find the dependencies. From there you can build your script on how...

Database Master Key is used for encryption...

You can create a SQL Login with password and grant that login access to the database. Don't grant any one access; then only people in Sysadmin and that login...

Try .. http://techxtra.tradepub.com/free/w_hp35/

ohernandez (3/13/2009)

---

Thank for your fast answer.

I forgot to tell that it´s happens when "reorganize index database" is running so the log is full fast (3 minutes approx.). ...

If your setting up cluster and the main hdd on active node failed it will automatically failover to passive node because it will fail the heartbeat check. You don't...