Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TomKane

  1. TomKane

    .mdf" failed with the operating system error 2

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

    Problem migrating C# CLR Assembly from 32-bit to 64-bit environment SQL 2005

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

    .mdf" failed with the operating system error 2

    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?
  4. TomKane

    .mdf" failed with the operating system error 2

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

    .mdf" failed with the operating system error 2

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

    Date difference to nearest half day counting only working hours. Yikes!

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

    Emails bouncing back

    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/
  8. TomKane

    Emails bouncing back

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

    Emails bouncing back

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

    Emails bouncing back

    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 =...
  11. TomKane

    SQL 2005 Encryption error

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

    Thoughts on SSD drives and Raid strategy?

    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,
  13. TomKane

    Identify a Snapshot DB

    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,
  14. TomKane

    SSIS Package Works in BIDS Does Not Work SQL Server Agent HELP!!!!!

    I meant to say production mail server not product mail server
  15. TomKane

    SSIS Package Works in BIDS Does Not Work SQL Server Agent HELP!!!!!

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

Part and Inventory Search

Back
Top