ADO.NEt Drivers can resolve localhost or . as meaning the current server however OLEDB providers cannot so if your using the later then the solution is to use servername typed...

So you have one parent and multiple child package, each child package needs to be executed in parallel ( concurrently), In this case you need unique variables defined for...

pivot makes sense if the message column is a int or numerical data type on which aggregations need to be performs else if the number of messages is static you...

the query can timeout if it is unable to acquire the required locks and resources. Every application needs timeot to prevent a query from running indefinelty. The Job might run...

This is normal behaviour , once you shrink tempdb , sql tries to find out which parts of the files are in use , after ignorning these parts it...

craig.bobchin (8/28/2015)

---

Jayanth_Kurup (8/27/2015)

---

I think your looking at the problem the wrong way. using t-sql to do fuzzy lookups is kind of tricky since the db is not really suited to...

You could use the XMLA task within SSIS to loop over the roles

This should be simple enough to test , just like how you tested EXplanFull ,whats the problem here? Is it not working as expected?

I have always used Expand Full mainly...

Files are not in restoring state is the database that is in restoring state.

Could you try this:-

On the Server were the database is in ONLINE state ( PrimarY), take a...

Hi Charmer I had posted a link in your post on how to loop through files, It answers all these question , take a look.

http://www.enabledbusiness.com/blog look at the...

the link contained the blog series , with steps to do file looping as well as dybamically change the file path for source connection. In fact there is a youtube...

BACKUP DATABASE is terminating abnormally. Cannot open backup device 'J:\SQL Backups\DB\Differential\DB_Differential_Backup_201508241903.bak'.

Have ypou check if the file exists and the service account has access to the path.

Also You mentioned fail over...

http://enabledbusinesssolutions.com/blog/ssis-starter-kit-for-the-uninitiated-foreachloop/

everything you need is explained here [/url]

https://www.youtube.com/watch?v=zrarG-cU4RQ

I think your looking at the problem the wrong way. using t-sql to do fuzzy lookups is kind of tricky since the db is not really suited to doing pattern...

Is this an OLTP system ? the defaults are the best usually when you don't know what value to set. SQL automatically decides when to use a parallel plan and...