Viewing 15 posts - 38,296 through 38,310 (of 49,571 total)
No need to delete them. SQL only keeps a certain number (default 6) and automatically deletes the older ones. New error logs get created (and older ones deleted) whenever SQL...
June 22, 2009 at 9:11 am
chris_wallace_000 (6/22/2009)
06/09/2009 10:18:54,spid21s,Unknown,An error occurred during recovery preventing the database 'KentLive' (database ID 8) from restarting. Diagnose the recovery errors and fix them or restore from a known...
June 22, 2009 at 7:40 am
Not enough information.
If you want advice on indexing a query, please post at minimum the query, the table definitions and current index definitions as well as the execution plan for...
June 22, 2009 at 7:34 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
It would be far more useful if you...
June 22, 2009 at 7:32 am
RichardB (6/22/2009)
and the ever irritating dtproperties.
Oh, right, the database diagrams table. I believe to get rid of those you need to filter using ObjectProperty with the IsMSShipped property. I think...
June 22, 2009 at 5:18 am
RichardB (6/22/2009)
GilaMonster (6/22/2009)
Actually, for SQL 2005 the easiest way is to use sys.tables.
SELECT COUNT(*) FROM sys.tables
Which is fine, as long as you remember that it also includes the occasional system...
June 22, 2009 at 4:50 am
That's 800 lines of code there.
Using a cursor is bad regardless of whether it's on a temp table or a real table. As for fire-hose or read-only, neither. Your...
June 22, 2009 at 4:34 am
Actually, for SQL 2005 the easiest way is to use sys.tables.
SELECT COUNT(*) FROM sys.tables
June 22, 2009 at 4:31 am
jordonpilling (6/21/2009)
1) put the database into simple before rebuilding the task, then back to full afterwards?
If you do that, you'll have to take a full backup after switching back to...
June 22, 2009 at 4:16 am
saidwarak01 (6/15/2009)
June 22, 2009 at 4:12 am
Jeff Moden (6/21/2009)
June 21, 2009 at 12:30 pm
caselig (6/21/2009)
That's just it. What is the instance_name?
No idea. That's why I'm asking to see the name of the Windows service.
Also to check that it's running.
June 21, 2009 at 6:31 am
Go to Services (Start-Control Panel-Administrative tools) and look for a service that has SQL Server in the name. Post the exact name of that service here (or take a screenshot...
June 21, 2009 at 6:08 am
JamesNZ (6/21/2009)
This almost seems like a problem with SQL Server then in what I've experienced :crazy:
It's not a bug, if that's what you're asking. In 99% of the cases I've...
June 21, 2009 at 5:32 am
Right. That's snapshot replication. No sign of transactional replication. (it has a different icon for the publication)
Since snapshot replication doesn't use the tran log, running sp_repldone would not have broken...
June 21, 2009 at 5:08 am
Viewing 15 posts - 38,296 through 38,310 (of 49,571 total)