Thanks Tom,

I was trying to avoid Temp table in favour of Table variables. I have found a way to do what I want with a UDF, and on re-looking, may...

I couldn't find this from the information_schema views, so I resorted to:

select  sot.[name] as 'Table Name',

 sc.[name] as 'Column name',

 sod.[name] as 'Default Name'

from  sysobjects sot

  inner join

 syscolumns sc

  on sot.[id] = sc.[id]

  inner...

how about:

select 'drop index '+ object_name (si.id) + '.' + si.[name]

from  sysindexes si

 inner join

 sysobjects so

  on si.id = so.id

where  si.indid not in (0,255)

and so.xtype = 'U' 

It may need some work...

2300 User created indexes? Good grief, that better be a huge database, or a warehouse...

I think all you can do is:

(1) allow the script to generate - it should do this...

Out of interest, what version of SQL are you using? Your reference to "dump" makes me think of 6.5 etc., in which case I don't have any practical experience in...

SQL Server Optimizations should always be run. This should be part of your ongoing monitoring and maintenace of your production databases (which IMHO you should not do via maintenance plans,...

Hmm - interesting difference's. BOL doesn;t describe the +checkpoint option for Kill - I'll have to see what that does. Also, I see he log's each attempted kill.

But still...

Thanks Allen - I'll probably do wither that, or else perhaps a simple select from sysprocesses where spid = @spid - not sure which would be more efficient...

I'm really looking...

Found my mistake - errors in log shipping UNC directory - Transaction Log backups weren't being found and copied.

Thanks Martin - it definitely seems I've got some kind of problem in the way I set it up - which is kinda strange, given that I just used the...

I'm on the same page - Steve's SP sounds interesting...

I've toyed with the idea of creating a maintenace database that keep track of statistics, last times, tables izes, number of...

Are you using MS log shipping, or a home-grown variation?

If is it home-grown, ehre's a thought for you - consider compression of log file before copying, and then decompression afterwards.

I...

Will test and try - thanks!

Thanks for the response Helen

I am trying to find out whether it is possible to do this and pick up the defaulty collation...

Vladan,

True enough, but given 3 validly (is there even such a word ? ) different companies, they might incorrectly match...

As I said...