OK, I'll take your word for that, since I never tried it in SQL Server 2005, and the option isn't available in SQL Server 2000. You still have to...

Steve

I back up my database to disk, then I restore to a different location using WITH MOVE. That would work, wouldn't it, and with no manual copying of files?

John

Backup and restore may not be the fastest option (although if you have very large database files with very little data in then there won't be much in it) but...

(1) This gives the total size of the database files, including free space within those files

(2) This gives the sizes of the individual database files, including free space

(3) The size...

Try COALESCE or ISNULL.

John

I think dynamic SQL is your only option to get round this somewhat dubious database design. Something like this:

DECLARE @sql varchar(1000)

SELECT @sql = 'SELECT * FROM ' + TableName

FROM...

Try SELECT @StartTime = GETDATE(). You should declare @StartTime and @StopTime as datetime rather than varchar.

John

Ram

Absolutely. I'm not preaching the supremacy of any language. But if you don't express yourself clearly in the language in which you have chosen, for whatever reason, to...

But if you don't express yourself clearly, then how can you be...

Karthik

Try reading some English-language newspapers. You will find that the sentences are clear, concise and well-formed. Stick to the type we in the UK refer to as "broadsheet"...

What do you mean when you say it doesn't work? Does it give an error message, or does it just not return the results you expect? Please provide...

Please will you post your table structures in the form of CREATE TABLE statements and also give some sample data in the form of INSERT statements. Also, please show...

Could it be to do with your regional settings? What happens if you do SELECT CAST (GETDATE() AS datetime)?

John

The data is stored the same no matter what your regional setting is. What changes is the way dates are presented, and the way SQL Server interprets dates that...

If shifts have to be 0, 1, 2 or 3, why do you have 4s and 5s in your view?

Something like this may do it for you. If it...