sturner (11/3/2010)

---

Yeah, that methodology won't cut it. If the the volume of this syslog data is really high a C++ program running native is the way parse and pump this...

Yea, i've been trying to play around and watch performance. I've spoken with our dev team and they say a simple c# program may be best.

FYI its for taking...

I asked a similar question a while back

http://www.sqlservercentral.com/Forums/Topic963333-391-1.aspx#bm964094

EXEC sp_MSforeachdb 'DECLARE @ln varchar(100) SET @ln=(SELECT name FROM [?].dbo.sysfiles WHERE fileid=2) USE [?] DBCC SHRINKFILE (@ln, 0)'

Deleted and recreated the Virtual Directory then re-ran the wizard and it seems to allow the execution of replisapi.dll?diag and not giving the 500 Error.

Excellent thanks thats just what I was after! 🙂

ashish.kuriyal (9/8/2010)

---

try this

SELECT userid,MAX(taskid) AS Maxtask

FROM tablename

...

The SQL version is 2008 but from talking with my developers seemingly these are legacy DTS jobs that were migrated over when we upgraded from 2005->2008 and most likely from...

I've just checked the ERRORLOG and around the time of the job running (and failing) there is nothing other that successful logons (which we need to log for auditing purposes)...

Finally getting somewhere now -

EXEC sp_MSforeachdb 'DECLARE @ln varchar(100) SET @ln=(SELECT name FROM [?].dbo.sysfiles WHERE fileid=2) USE [?] DBCC SHRINKFILE (@ln, 0)'

Hmm strange, when I script out the GUI the command includes the TRUNCATEONLY

Just looking at the variable side of things now cheers 🙂

DECLARE @command1 varchar(100)

DECLARE @command2 varchar(100)

exec sp_MSforeachdb set...

Ok cheers (ill keep that as a last resort)

If I was to try and get the MSforeachdb working am I on the right track? The reason I ask...

I know this shouldnt be done on a regular basis. Basically we need Full recovery model but some basic admin wasnt being performed and 100s of Logs files are...

Having been working on this for a while now I have found that when our developers need to modify a DB to add a table or SP to the Merge...

Cheers, I got round this by setting the Auto value to Manual and then setting the pub range, ident range and threshold.

Heres the code, hopefully it will help someone else.

USE...