Whoa- hold on there don't get too excited - it's fairly simple stuff!!

can i suggest the following is slightly more up to date SQL

SELECT H.NBname, H.DNSname, CAST(H.nField0 as varchar(3)) + '.' + CAST(H.nField1 as varchar(3))+ '.' + CAST(H.nField2 as varchar(3))+...

SELECT H.NBname, H.DNSname, CAST(H.nField0 as varchar(3)) + '.' + CAST(H.nField1 as varchar(3))+ '.' + CAST(H.nField2 as varchar(3))+ '.' + CAST(H.nField3 as varchar(3)) AS 'IPAddress', Count(F.FaultlineID)

FROM Vulnsfound F, Hosts...

Steve,

I've sent you pretty much the same, but if anyone needs any more detail or assistance please feel free to drop me a line or post a reply here-...

Ok guys,

here are the basics attached to this post.

one file contains the C# code in case you want to play with this - i.e change the authentication method etc...

Ok,

I've had a couple of private messages for the CLR - i'll ask Steve Jones Nicely if he can host the .net code and also scripts to implement it for...

They were in the leisure industry (casinos and the like) - with servers at each of the sites, plus servers to control electronic gaming and fruit machines.

400 doesn't count...

I think we seem to all be covering the same checks whcih is a releif!!

I used to work in an environment with approx 400 SQL servers

we used to have...

George,

I also live in the midlands(notts/derby) - there are several companies you can approach

quantix (based in beeston) are a consultancy service offering DBA support / holiday cover / special...

Agree Completely..

not just tables and views though - I've inherited a Database written by a .Net developer and all my columns have prefixes and suffixes

for example

Mytable_Mycolumns_tinyint

if i want to upgrade...

understood - that's why it's less risk - the checkpoint command will not truncate the log in FULL recovery mode.... full mode you would have a t-log backup (hopefully)...

on an aside - if ever in doubt or struggling with connection strings visit

http://www.connectionstrings.com

although in this instance failing to include the instance name wouldn't be picked up by that site.

There may be another choice here.

SQL determines when to issue a checkpoint for that database. I've seen several instances of checkpoints being issued way too infrequently on large databases,...

hey no-one said itwas perfect - just a tool to make long winded jobs easier

anyway - many ways to skin a cat - if you don'thave msdb available and you...

perhaps this is a slightly simpler example

create table #temp(tfield varchar(50))

insert into #temp select '00:00:50'

insert into #temp select '00:01:20'

insert into #temp select '01:00:50'

insert into #temp select '00:00:50'

insert into #temp select '00:00:50'

select...