Ramblings of a DBA

Tara Kizer
posts - 166, comments - 835, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

Gripes

Database Mail on a cluster

In our production environment, we have two 4-node clusters.  One cluster runs at the primary site; the other cluster runs at our disaster recovery site.  Each cluster is running 11 SQL Server 2005 instances. We setup Database Mail on all of the instances at both sites, so that we could e-mail internal customers the results of various ad-hoc queries.  It was soon realized that Database Mail was not working properly at the primary site on any of the 11 instances.  We got our Exchange, server, and network administrators involved, but we were unable to figure out what was wrong.  We never...

posted @ Tuesday, February 20, 2007 11:49 AM | Feedback (0) | Filed Under [ Gripes SQL Server - Database Administration ]

Something that I am dealing with today

Well today has definitely been interesting.  I have been working with a co-worker who is responsible for trouble shooting customer problems.  This specific customer is running our product with MSDE.  We do not have dial-up access to the server, so everything is being done over the phone, plus the customer speaks Spanish, which I do not.  It's hard enough explaining what to type at a cmd window to correct this problem and not knowing what they are typing cuz you can't see the screen.  All that we are trying to do is recreate a user and grant sysadmin rights.  I...

posted @ Tuesday, October 07, 2003 2:56 PM | Feedback (3) | Filed Under [ Gripes ]

My gripe today

I have been asked to look into why a stored procedure is failing.  The problem is that the application gets an error that a temp table doesn't exist.  Here is the code with the problem (my comments in blue, contents were changed to protect company information):        FETCH NEXT FROM @cursor         INTO @ID, @Name                IF @@FETCH_STATUS <> 0  This doesn't make sense, nor does the next WHILE statement.  It says if there are records in the cursor (which is SELECT * FROM a temp table), drop the temp table, get rid of the cursor, raise an error that something couldn't be found.  BUT IT...

posted @ Tuesday, September 30, 2003 12:18 PM | Feedback (1) | Filed Under [ Gripes ]

Powered by:
Powered By Subtext Powered By ASP.NET