Just a small typo in this, should be

select id, convert(varchar(10), date, 120) from temp

Ace - that will be filed in my 'Useful SQL Utilities' folder, thanks.

Thanks v much, that's nearly exactly what I need.  But the 'Name' field that is returned appears to be the logical file name corresponding with the data/log file selected (and...

Noeld – please explain why you should not cast a datetime as int.  I have used

cast(cast(GETDATE() - 0.5 as integer) as DateTime)

with apparent success.  Just interested ... the...

I have a similar related question.  I have a script which uses a cursor to update a large number of records - is there any way of indicating progress (10...

Alternatively, after performing the delete, go into EM, design table and set the Identity Seed of the primary key to something else (eg 2) and click on Save. Then set...

Just in case ...

Casting my mind back to the SP3 install, where the first exe you run just unzips files (and doesn't actually do the install).

Look for a setup.bat or...

Agree with previous post. Also presume you want to write a different message to the log if the main transaction fails? Perhaps it would be better to have one log...