Oh no!!! 🙂 I could provide c# scripts too, but I think the articles have already been lined up for publishing. I thought for...

sibir1us (4/20/2009)

---

I like your article. Seems interesting, and also a good idea. However, a several drawbacks could be:

1. getting that "own SQL Server "SQL_Admin"" might be a bit hard

2. how...

Yes sorry, a typo. I meant to say "then using row versioning WILL display older...".

I understand how it works (great article), but I thought the whole idea of locks etc...

Let me get this straight.

If a field has a value of, say $0 and it is in the process of being commited to $1000000000, then using row versioning will not...

So it is. I'll change it.

Thanks for that,

Drew

You got me scratching my head. But in others there are concatanations like so...

 

ALTER

Function [dbo].[formatline3_SQL]

(@flag varchar

Thanks for the posts.

I have managed to achieve the required using UDFs. There are so many ways of using UDFs, I really didn't know where to start. Here's a sample...

I thought it could be done by maybe putting the script in an activex step in DTS.

So this vbscript has functions that concatenates input parameters (amongst other things). The SQL...

Sorry, I was talking to both you and Jules (you first, then later refering to Jules code)

Bingo!

Thanks Peter, thanks Jules.

Incidently, I did have to change

select @sql = @servername + '.master.dbo.xp_readerrorlog @p'

to

select

@sql...

Hi Peter,

Thanks for replying (on both forums). I have double checked. I can browse the all 7 logs on the remote server. They are definately there. I do have the permissions.

Jules' solution looking...

Bizzare. That works for me too. I wonder if it is a Linked Server thing.

The error I get is:

Msg 2812, Level 16, State 62, Procedure usp_GetErrorLog, Line 29

Could not...

"Apologies if you feel 'offended'

Apology accepted. We'll leave it at that. Though, the first time "true DBA" is mentioned at all in this thread is in your post.

" (Point aside - concerning that Gov't databases are looked after by a 'true' DBA - no offence to yourself). "

Offence taken. Are you suggesting a DBA with more experience is...

Thanks Karl. That makes sense to me. I suppose I was worried that backing up Trans frequently may be considered as extreme, and as I have no "mentor", it's difficult...