There must be another database that's using the same physical file names. Use the WITH MOVE clause as the error message suggests, and it should work.

John

Use SET.

John

What is the exact command that you ran?

John

I've never attempted it myself, but you could try writing a custom report that you invoke by right-clicking on Tables and choosing Reports -> Custom Reports.

John

Shovan

No, there are two separate options for the cluster resource, which, from memory, are Initiate Failover and Take Offline. The former will fail the resource (the whole group, I...

Shovan

Go into Cluster Administrator, take the SQL Server resource for the instance in question offline, then bring it back online. Don't forget to ensure that SQL Server Agent starts...

I would nearly always advise the SSIS route. It's more flexible and it enables you to do transformations that you can't (easily) do with T-SQL. It's also easy...

The best thing to do here is to look up the syntax for cursors in Books Online, have a go at writing it yourself, and post back if there's anything...

As far as I remember, Filestream isn't available in SQL Server 2005, so you're probably stuck with storing images in the database. You could purchase some document repository software...

Sum up your order lines before joining to Orders, something like this:

with Orders

as (select 1 Id,

...

Case solved. You need to post on an Oracle forum.

John

What happens if you run it in SSMS? Also, that error message does not look like one generated by SQL Server....

Have two ForEach loops - one for txt files, and one for Excel files.

John

I'm guessing one or more of your databases have a case-sensitive collation. The name of the INFORMATION_SCHEMA schema and the views within it are upper case.

John

What errors are you getting?

Actually, I would urge you not to split the dates into their constituent parts. Store them in the database as datetime, and perform any manipulation...