Viewing 14 posts - 1 through 14 (of 14 total)
The DBs in my instance are frequently going into recovery mode.
A select * from sys.databases where name='DBName' renders the following results (note: no STATUS column)
sys.objects Column name...
May 30, 2011 at 9:48 am
Well, the db in recovery isn't causing a problem .... YET...
It's something I'm starting to track as part of the problem solving process - and it's come up now on...
May 30, 2011 at 9:06 am
LATEST UPDATE:
Having scripted out all of the database objects, moved the data over, recreated all permissions and rebuilt the solution, everything is fine...
I can now recreate stored procs, create functions...
May 30, 2011 at 8:56 am
Yep, definitely not possible that anyone setup replication.
I actually had a similar problem when we deployed the DB to a client's site. We then scripted out the DB, imported...
May 25, 2011 at 11:30 am
Thanks John - it looks like I'm going to need a lot of luck on this one.
We are not using any replication on this DB at all - so I'm...
May 25, 2011 at 11:18 am
Nope - no DDL triggers.
In fact, I have a duplicate DB that is a restore of a backup of the DB in question. The backup is maybe 3 days...
May 25, 2011 at 9:58 am
I posted in the data corruption section 'cause I thought that it seems like some kind of corrution issue - but I have run DBCC CHECKDB - and found...
May 25, 2011 at 9:48 am
Yep, the Database mail functionality in SQL Server Express is disabled.
The solution is to develop a simple SMTP app and use this within SQL Server as a CLR. Take...
May 25, 2011 at 9:27 am
1 of 2 things:
1. You have a trigger on your table that is attempting to do stuff on insert or
2. (More Likely) You have a column named RunDT in your...
May 25, 2011 at 9:12 am
Our dev team recently needed to develop a complete solution for a Multi-Level Network Marketing company. They needed to provide a set of reports and views for all of...
March 14, 2011 at 12:16 pm
Using HierarchyID Datatype with this solution
If added a new column into the table called OrganisationLevel with a HierarchyID datatype, then updated this column with the Hierarchy data that you generated...
March 10, 2011 at 11:54 am
Nice article Jeff. I see that you promised a more in-depth/advanced discussion within the body of your article. Are you going to be discussing the HierarchyID data ...
March 10, 2011 at 10:24 am
It would help to start the discussion by looking at the startup form and analysing the startup set of macros.
The best way to start this is to hold the SHIFT...
July 28, 2010 at 11:31 am
Hmm :ermm:
Yes, I have to increment.
Please don't jump on my case all at once:w00t:. I have lambasted enough DBAs about using the tools provided, but in this...
January 14, 2009 at 5:46 am
Viewing 14 posts - 1 through 14 (of 14 total)