Viewing 15 posts - 1,006 through 1,020 (of 2,044 total)
It's normal that performance degrades when running DBCC CHECKDB.
What is your current disklayout?
July 29, 2008 at 11:08 am
There is a command to force a checkpoint: CHECKPOINT
CHECKPOINT permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles, and are not...
July 29, 2008 at 10:58 am
Indeed weird, creating indexes on that column and selects don't cause problems.
July 28, 2008 at 11:31 am
I would drop the table at the subscriber. And see if it gets recreated.
ms page on dropping/adding articles:
http://msdn.microsoft.com/en-us/library/ms152493.aspx
Have to tried in another sequence?
Drop subscription
Drop article
Refresh
Add article
Add subscription?
July 28, 2008 at 10:06 am
Perhaps a problem with the insert/update/delete stored procedures?
July 22, 2008 at 11:55 am
Have you checked of the replication share is reachable/ not out of space?
Is there some detail info on the error?
July 21, 2008 at 5:46 am
Was there a new snapshot since the reactivation?
July 21, 2008 at 5:28 am
You will have to find why it is timing out. (bad code, bottlenecks, no indexes, ...)
Execute sp_who2 will show you a list of connections and if they are blocked. Sql...
July 15, 2008 at 10:47 am
I haven't much experience with replication. Is it feasible to store the inserts in a seperate table?
July 10, 2008 at 3:03 pm
Can you explain your goal a little further?
1.Redirect a page on the webserver to another (with changepermissions on the server)
2.Using a kind of plugin to generate an identification control (like...
July 10, 2008 at 3:00 pm
pure guess:
A basic knowlegde on Active Directory (add/remove users, trusts between domains, consulting performance counters/event log, security settings) besides some basic pc troubleshooting.
July 10, 2008 at 2:33 pm
When exactly does the script stop from working.
According to the IE error, it is when the "count" variable is introduced.
Any mix in lettercase?
Does a select ownerID FROM callRecord instead of...
June 21, 2008 at 11:09 am
Which field are trying to modify?
* CONSTRAINT [eq_em_id] FOREIGN KEY
(
...
June 20, 2008 at 11:08 am
You could improve the accurary of the report with
DBCC UPDATEUSAGE
( { 'database_name' | 0 }
...
June 20, 2008 at 11:05 am
Viewing 15 posts - 1,006 through 1,020 (of 2,044 total)