I'd like that script. Can you send it to me at greg.larsen@doh.wa.gov

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

We are a long way from the norm on this, but we normally only reboot our boxes, if maintenance requires. This is around once a month or so, although...

To verify the time to 3 milliseconds try the following code:

declare @datetime datetime

set @datetime = '2002-12-16 23:59:59:993'

print convert(char(17),@datetime,114)

set @datetime = '2002-12-16 23:59:59:994'

print convert(char(17),@datetime,114)

set @datetime = '2002-12-16 23:59:59:995'

print convert(char(17),@datetime,114)

set @datetime =...

If a piece of code actually runs in under a millisecond, why would you care to time it?

I think SQL Server only support timings to within 3 milliseconds.

Gregory Larsen, DBA

If...

I'll give that a shot.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

We are using a tool called "Change Manager" by Embarcadero for saving versions of database schemas. I'm not really sure you could say it is version control software. ...

We are using a tool called "Change Manager" by Embarcadero for saving versions of database schemas. I'm not really sure you could say it is version control software. ...

Can't remember who on the list provided this, but here is a method to read the transaction log. I have yet to give this code a test ride.

To read...

Interesting Idea using a function. How much less overhead is this over building a temp table? Done any benchmarks?

Gregory Larsen, DBA

If you looking for SQL Server Examples check...

Try this out:

create table x(x char(10))

insert into x values('xxx_001')

insert into x values('xxx_002')

insert into x values('xxx_003')

update x

set x = replace(x,'_','-')

select * from x

drop table x

Gregory Larsen, DBA

If you looking for SQL...

You can a database backup you can specify how long to retain it by using the RETAINDAYS clause on the BACKUP DATABASE clause.

Basically you are getting this error because...

There are two ways that I know of:

Method 1: Create a new table insert all the rows. Make sure the new table has and identity column with a seed...

Here try this:

select @Temp as '@Temp',@T1 as '@T1', substring(cast(100+month(@t1)as char(3)),2,3) as 'month1' , substring(cast(datepart(mm,@t1)+100 as char(3)),2,3) as 'month2'

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website...

This is I think more of a manual process. You should be able to send email to users, but who says they are going to read it, or worse...

I think I would consider using the status bit, but look for whether it is in a mode that is not 'normal', loading, recovery, recovering, etc. This should give...