Search results for query: *

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...

...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 DECLARE @EndDate DATETIME DECLARE...

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.

Are you able to verify that \\SCONET\Data\SCO\Group\LGCR Files For Upload\2010-Group 2-12264807800-4112012.xls - is accessible from the server and that the SQL Agent account has the appropriate access?

Hi, Can I ask you what data type is the field tc.PDDATE? Regards,

Hi, Taking a bit of a stab at this but it appears to me that you have a SSIS package with a send mail task that is attempting to send an excel file as an attachment but it can't find it. This can happen when the SQL Server Agent account doesn't have permissions to access the file you're trying...

...VARCHAR(50))--94796040 KB SET NOCOUNT ON INSERT #temp EXEC sp_msforeachtable 'sp_spaceused ''?''' SELECT a.table_name, a.row_count, COUNT(*) AS col_count, a.data_size FROM #temp a INNER JOIN information_schema.columns b ON a.table_name collate database_default = b.table_name collate...

Hi, yes the index_size on space used is the Total amount of space used by indexes. When you say index rebuild script is it a T-SQL script?