Viewing 15 posts - 38,731 through 38,745 (of 49,571 total)
The open tran indicates that this was once replicated (publisher) or was restored from a backup of a published database. Either way, there's left-over replication that's preventing the log from...
June 3, 2009 at 2:34 am
It's stored in a different place in SQL 2008 and it's treated almost as if it was a dll.
June 3, 2009 at 2:32 am
TheSQLGuru (6/2/2009)
alter PROCEDURE Test4 ( @ProdID int = null, @Qty int = null)
AS
select TransactionID
from [Production].[TransactionHistory] -- with (index = [IX_TransactionHistory_ProductID])
where ProductID BETWEEN coalesce(@ProdID, 0) AND coalesce(@ProdID, 99999999) --should use actual...
June 3, 2009 at 2:29 am
Dave Ballantyne (6/3/2009)
Can you post a full XML query plan of one of your queries that Seek ?.
If you could try to make the query as simple as...
June 3, 2009 at 2:23 am
What did you install and what did you mean to install?
June 3, 2009 at 12:48 am
Holger Degroot (6/2/2009)
Hi Paul,yes it was the first and only error.
If that's the case, I would suggest two things before you try a fix.
1) Evaluate your IO subsystem - check...
June 3, 2009 at 12:45 am
It means pretty much what the error says. The view cannot be schemabound because to do so all tables and functions must have a 2-part name (eg dbo.table1). Marcus said...
June 3, 2009 at 12:45 am
Jeffrey Williams (6/2/2009)
Nope - SQL Server 2005 SP3 and had the same experience on 2005 SP2 CU7.
Odd. I've played around with RECOMPILE on these before and on 2005 I always...
June 3, 2009 at 12:38 am
Paul, could the previous error have been hiding these, or do you think they're new corruptions?
June 2, 2009 at 5:20 pm
Check the error log. Are there any errors relating to those databases there?
June 2, 2009 at 5:03 pm
They're accurate since the last server start. I would still do some analysis before dropping any indexes.
June 2, 2009 at 5:02 pm
Holger Degroot (6/2/2009)
hi Gail,this worked out. Thankx a LOT!!!!
Excellent. I'm glad to hear that.
I don't understand the errors (sorry, don't speak or read German) so I can't advice you on...
June 2, 2009 at 5:00 pm
Check the error log. There should be some entry in there saying why MSDB is suspect.
Do you have a backup of MSDB?
June 2, 2009 at 4:59 pm
Recovery model has nothing to do with performance. It has to do with recoverability of the database.
If you don't care about losing transactions, set the DB to simple recovery....
June 2, 2009 at 4:58 pm
tikkani.praveen (6/2/2009)
Can you give me the exact procedure to follow to take backup.
Look up BACKUP DATABASE in Books online. If you have questions after, please ask them.
June 2, 2009 at 4:46 pm
Viewing 15 posts - 38,731 through 38,745 (of 49,571 total)