I'm with primary keys....

but i'll settle for indexes indexes and more indexes... - developers often assume that what they've written against their dev database which has 50 rows of data...

you'll need to dig yourself out of this using scripting rather than GUI tools.

as an emergency to get the log size down you might want to look at running...

LAST backup time

SELECT d.NAME,MAX(b.backup_finish_date) FROM

MASTER.dbo.sysdatabases d LEFT OUTER join

msdb.dbo.backupset b ON d.NAME=database_name AND b.server_name=@@servername

WHERE backup_finish_date>'01 oct 2008' AND TYPE='D'

GROUP BY d.name

For reference I'll post some of the procs I created previously - as and when i get time - i'd welcome suggestions from others.....

here is one to check...

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)...