It copies the backup files not the .mdf or .ldf , moeover the article explains some params of the roocopy so that it will retry a few times to copy...

Any way I think ORDER BY constant should be innofensive. Why such a severe message?

Regards,

Iulian

First you need the SQL Server Agent running. Here is something about the agent:

http://msdn.microsoft.com/en-us/library/ms189237.aspx

Then you create your jobs, schedule and maintain them. Here is something about creating the...

Nice one, thanks

Iulian

Hi Gil, Inserted and Deleted tables are maintained by the system. You can not modify the data there or to create index on these two tables.

Regards,

Iulian

This might be a good start: http://msdn.microsoft.com/en-us/library/ms177443.aspx

http://msdn.microsoft.com/en-us/library/ms189051.aspx

Regards,

Iulian

Without ORDER BY it runs fine, also it works fine like this:

use master

select * from

(

select fileid, name from sysfiles intersect

select file_id, name from sys.master_files

where file_id in('1')

) as...

There is a post here that might help: http://www.sqlservercentral.com/Forums/Topic356230-162-1.aspx#bm357996

Regards,

Iulian

The convert functions in T-SQL has more options for dates, but not for numbers.

The formatting of numbers to percent, currency, float, decimals etc. is usually done in the GUI...

Why don't you use datetime type?

Regards,

Iulian

I think what Jeff expects is something like:

CREATE TABLE #sample_table (

enquiry_refno INT

, attrib_code VARCHAR(10)

, sub_attrib_code VARCHAR(10)

, date_value DATE

)

GO

INSERT INTO [#sample_table] ([enquiry_refno] ,[attrib_code] , [sub_attrib_code] ,[date_value]) select123456,...

Thank you for the question

Iulian

That is a nice, thank you.

I am using something simmilar but through windows tasks.

Iulian

you can query SQL Server from Excel

this can be used as a basic reporting system

Regards,

Iulian

That was realy nice, thank you

Iulian