Viewing 15 posts - 2,761 through 2,775 (of 6,216 total)
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...
January 2, 2003 at 4:39 am
Sure. This works in Northwind.
select productid, count(*) as count from [order details] group by productid having count(*)>1
Andy
January 1, 2003 at 6:35 pm
Exactly. You can set the ignore dupe option to just get all the unique rows - if that makes sense in your situtation.
Andy
January 1, 2003 at 3:19 pm
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...
January 1, 2003 at 3:18 pm
Migrated how? Detach and copy, or moved using DTS? Scripted? What kind of problem?
Andy
January 1, 2003 at 3:16 pm
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...
December 31, 2002 at 3:29 pm
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...
December 31, 2002 at 3:26 pm
Not quite a duplicate thread, I posted some basic how to code in the related thread here:
Andy
December 31, 2002 at 8:17 am
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...
December 31, 2002 at 8:15 am
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...
December 30, 2002 at 8:54 pm
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...
December 30, 2002 at 7:12 pm
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
...
December 30, 2002 at 7:09 pm
Dont know of immediate fix. Short term you might just BCC the server email so you have the copies at least.
Andy
December 30, 2002 at 6:22 pm
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...
December 30, 2002 at 6:21 pm
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...
December 30, 2002 at 6:17 pm
Viewing 15 posts - 2,761 through 2,775 (of 6,216 total)