Might be me, but not sure where 'Second' is?

I did wonder about STUFF, e.g.

SELECT STUFF ('200', 2 , 0, ':')

DECLARE @MJBtime INT

SET @MJBtime = '10200'

SELECT LEN(@MJBtime)

SELECT STUFF (@MJBtime, LEN(@MJBtime)-1, 0, ':')--Not 2 as 1st value before first...

You will not meet all your work colleagues at the interview. And any IT / ICT job over just a very few years is 'metamorphic'.

Ack. I did wonder as you could end up with, say, a CustomerID starting part way along in a supposed virgin database.

I might be off on a tangent, but does this handle SEEDs?

NB: 40 Tree Rd became 30 Tree Rd at some point.

USE whatever at the top is my recommendation if you do not want an occassional accident.

In ORACLE I was always using SELECT * FROM GLOBAL_NAME; to see if I was...

You can get this where there has been a disconnection. You push F5 (or whatever) against your previously executed code, it tries, passes back an error. The next...

Now, suppose they get smart. There is a copy somewhere. But assume there is some latency getting from current master to secondary. And pop, the primary is...

Mosaic. That reminds me - when I read about that a few weeks back, it said the US laws were more rigid.

Just a thought, but if TRUNCATE then likely will reset SEEDS and there might be some cases where these might need to be kept? Maybe. Possibly. Especially...

In the interim you could:

select BackupDate = convert(varchar(10),backup_start_date, 111), SizeInGigs=

CAST(round(backup_size/1073741824,4) AS decimal(18,4)),

backup_size AS [Raw backup_size],

CASE TYPE

WHEN 'D' THEN 'Full'

WHEN 'F' THEN 'Filegroup'

WHEN 'I' THEN 'Differential'

WHEN 'L' THEN 'Log'

ELSE 'Unknown'

END AS...

Aka http://www.hl7.org/ (http://http//www.hl7.org/).

I did note this in the Forum if of any use... http://www.sqlservercentral.com/Forums/Topic672649-391-3.aspx

If you need that space back, then you need that space back. A warning on the side effects and gentle background automated 'heal'.