Recent content by TomKane

Well done for fixing it! You live and learn, huh?

I had something like that happen once and it had something to do with the database ownership http://support.microsoft.com/kb/918040 Hope this helps

Just to clarify - SQL Server is on another computer and S: is a drive mapping on your computer to that computer or is S: a local drive letter on the other machine?

Further to what I just posted - is your s drive part of your computer or is it a mapping to an external drive? If it's not and you have to - check out this blog post - it's not something I've tried but the dude who owns the blog really knows his stuff...

I tried running your script on my local SQL Server (version 2005) and the create database part worked fine - I had to change the folder location as I don't have a drive S but otherwise it worked. Are you running the script as "sa"? It does sound like a rights issue.. maybe you could check...

You're solution is very elegant. The only one I could get to work is nothing like as elegant or efficient as what you were proposing but I'm pretty happy with it - here you go: /* Congfigure Environment Settings */ SET DATEFORMAT DMY /* Declare Variables */ DECLARE @StartDate DATETIME...

Well, you can't argue with a working solution! I did find this but, if you're up and running and working then maybe disregard :) http://nadiaamir.wordpress.com/2009/11/03/the-mail-could-not-be-sent-to-the-recipients-because-of-the-mail-server-failure/

By the way, are you able to supply the error message?

Oh right, strange.... Does outlook and your sql server work with the same mail server?

You could try taking a look at the mail item views, they may uncover something: SELECT TOP 10 f.mailitem_id, f.subject, f.body , f.send_request_date, e.Description from dbo.sysmail_faileditems f LEFT JOIN dbo.sysmail_event_log e ON e.mailitem_id= f.mailitem_id AND e.event_type =...

Do you have encryption already in place? It seems odd the SQL Server would be complaining about decryption when you're trying out encryption for what I'm assuming is the first time. Is there anything in your error log around the time of attempting the encryption that give us a bit more...

Hey, I personally don't have any experience of that but I read Brent Ozar's blog quite a bit and he has some good posts on the subject. Check this out. http://www.brentozar.com/archive/2012/02/sql-on-ssds-hot-crazy-love/ Regards,

Hey, I got this from the msdn pages - I hope it helps: To list the database snapshots of the instance of SQL Server, query the source_database_id column of the sys.databases catalog view for non-NULL values. http://msdn.microsoft.com/en-us/library/ms175469.aspx Regards,

I meant to say production mail server not product mail server

Olaf referred to the mail server and he had a good point. Does the server have access to the mail server set up in the send mail task? I know that in my environment the test server can't access the product mail server and visa versa.