That would take some additional engineering to avoid creating a bottleneck and also to release unused cached connections...like...

david.wright-948385 (9/18/2015)

---

allarmi (1/21/2014)

---

hello, thank you for your work.

i'm still looking for a transaction independent way of logging the activity going in an arbitrary number of procedures regardless of their nesting...

Only if you had something previously setup on the server during that time, e.g. a Trace or Extended Events session.

If you were capturing Successful Logins in the SQL Server Error...

this is what I am working off:

basically I'm trying to get actual row...

My code does not mention those values so chances are you have them in your data being returned by your view. make sure your view is using QUOTENAME where appropriate,...

Ok. What error?

Jayanth_Kurup (8/13/2015)

---

I should have been more clear about my points , sorry . My point revolve around the self service aspects of MSBI.

Its more difficult to implement singlesignon in...

Service Broker is a queuing system so won't be calling out as you might be thinking of it. You can attach to the queue an "activation stored procedure" that the...

Cross-post from MSDN Forums:

https://social.msdn.microsoft.com/Forums/en-US/b563d2a0-5046-4015-857c-8d3af0f97e05/transition-from-sql-server-2000-to-sql-server-2014?forum=sqlreplication

Not sure about how you might do this using SMO as you described but creating a server event notification requires a Service Broker queue to be setup first and is...

SQL is not an interpreted language so will not work the way you are thinking right now.

Here is a quick demo using your view that does work although the resultsets...

You can use the Report Viewer control in a stand-alone C# app and source report-content from a SSRS instance running...

In an SSIS 2012 Data Flow Task, you could use a Script Component (setup as a Source) to get a JSON string from Mongo DB and deserialize it into .NET...

if you need to process each remote file once and only once then a workflow like this would make sense to me:

1. create a table in one of your databases...

yuvipoy (8/6/2015)

---

Hi,

There are about 100 files are placed in FTP

all the files are needs to be processed at the same time

Parallel processing..

each file is about max 200 MB...