SSIS is probably the best way to go, although linked servers might be better, depending on your exact requirements.

John

sullyf50 (9/23/2011)

---

do you have a examples How to loop through SQL Table from SSIS to get file names and export

all i wanyt is to export all table from a database...

Not really. SSIS is a big subject. There are tutorials for getting yourself started in writing SSIS on the Microsoft website - I recommend you take a couple...

If you're doing this in T-SQL, you can use xp_cmdshell (if it's enabled) to run a DOS or PowerShell script. However, this is the kind of thing SSIS is...

This will only work if you insert or update one row at a time, will it not?

John

I take it that the share is on one of the cluster nodes and not somewhere on the shared disk? If so, what has happened is that the cluster...

How is the security of the linked server set up? Does it connect as a specified user, or as the currently authenticated user?

John

I take it the name of the user isn't dbo? If not, is there a trigger somewhere that's undoing the change?

John

You can set a CPU idle threshold and schedule a reindex job to run when that threshold is crossed. Of course, by the time the indexing is complete, the...

As others have said, it's best to make each backup to a separate file. If you have more than one backup in any file, however, you can use RESTORE...

What is the autogrowth set to? In other words, how many MB or how many percent?

John

Something like this?

select * from sys..dm_exec_cached_plans

WHERE objtype = COALESCE(@obj_type,objtype)

John

It doesn't make a difference whether you have active/active or active/passive. You still need one for each node, one for the cluster, and one for each SQL Server instance,...

I've just run a test. I created a new share on my PC and then backed up a database from a server to that share. No problem.

I suspect...

Joice

I'm afraid I don't have much experience of using the Lookup transformation. I've tried everything that was obvious - hopefully somebody else will be able to help you.

John