Check your maint plan. If you've set the option to repair any errors, it has to put the db in single user mode to do so and there was a...

Sure. This works in Northwind.

select productid, count(*) as count from [order details] group by productid having count(*)>1

Andy

http://www.sqlservercentral.com/columnists/awarren/

Exactly. You can set the ignore dupe option to just get all the unique rows - if that makes sense in your situtation.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Always something to learn here. I always backup to disk so never encountered this, though it does make sense, wouldnt want your backup job to just sit there and no...

Migrated how? Detach and copy, or moved using DTS? Scripted? What kind of problem?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Create date. If you want more than that, you have to roll your own. Either via profiling/auditing, storing the schema for all objects and doing a compare, or by using...

I agree. You'll learn a lot by replacing some of the Access module level code with stored procs, get into security, do some Profiling, etc. I'd also suggest considering moving...

Not quite a duplicate thread, I posted some basic how to code in the related thread here:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8994&FORUM_ID=7&CAT_ID=1&Topic_Title=Replication+of+System+Tables&Forum_Title=Replication

Andy

http://www.sqlservercentral.com/columnists/awarren/

Interesting idea. Im not opposed to modifying system objects when it makes sense, not sure in this case it's worth it. The headache with this one is that a service...

DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE should free some. In general don't worry about the memory, SQL uses everything you give it and that is a good thing. As other requests...

Not quite what you're looking for but one way to do it would to write a tool that would run through all your procs and add explicit code to dump...

You're not far off. Tested this, works ok:

Dim oserver As SQLDMO.SQLServer

Dim oDB As SQLDMO.ReplicationDatabase

Dim oPub As SQLDMO.MergePublication

Dim oArticle As SQLDMO.MergeArticle

'create standard server object first

Set oserver = New SQLDMO.SQLServer

With oserver

...

Dont know of immediate fix. Short term you might just BCC the server email so you have the copies at least.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Cool, I'll try to work on it tomorrow morning. Maybe when you're done we can talk you into writing up the experience as a case study and submitting along with...

Just because no job doesn't mean not being used. Could be they are executed manually as needed, or that someone is connecting using VB to run it (and maybe make...