Yes, The easiest way would by to use oSQL (or sqlcmd, but I've never used that), and save the output file somewhere other than the DB server. Again, all...

I have this in my toolkit, IIRC, it was written by Gregory Larsen. It reads the backup history from the msdb, and sorts out the NoRecovery, recovery for you.

Of...

I know this is nearly two years late, :w00t: but I've just spotted this. What an excellent addition. I'll test this avro and post it with due credit on...

I think...

I used TSM at the last place, approx 3 years ago, and I found the only issues I had were when restoring.

As I've said on this page, restoring a SQL...

You can find the best info on how to do this in this article[/url]

HTH

Dave J

From the script header 😉

' Instructions.

' To use this script, you need to create a project in VSS & create various sub projects.

'

' ...

Balbir,...

Once again, many thanks

Dave J

Peso

many, many thanks. I owe you a beer. 😀

declare @TestTab Table (add1 varchar(50) null, postcode varchar(50) null)

Insert @TestTab values('Glossop', 'SK13 8LY') --Valid

Insert @TestTab values('M1 1AA',NULL) --Valid but wrong field

Insert @TestTab...

I have been looking at this

set NoCount ON

declare @TestTab Table (postcode varchar(50) not null)

Insert @TestTab values('SK13 8LY') --Valid

Insert @TestTab values('M1 1AA') --Valid

Insert @TestTab values('M60 1NW') --Valid

Insert @TestTab values('GIR 0AA')...

Jeff Moden (8/12/2008)

---

I think Matt might agree with me on this one ( maybe not :hehe: )... you don't need the overhead of a RegEx CLR for simple post code...

I know I'm late to the party, but can anyone point me in the direction of Matt's CLR UDF for regex? I could use it for my Postcode validation...

Like this?

create table #t1 ([group] char(3), data1 int, data2 int ,data3 int)

create table #t2 ([name] char(4), [group] char(3), data1 int, data2 int ,data3 int)

insert into #t1 values('ONE', 60...

No, I need to be smarter about building the join. 😉 I think I've got...