I'm not sure you can. I'm not sure it should matter from the server. The idea of the API is the server sees calls to it without worrying about clients.

Does...

Use SSIS to build a package. Base a query on dateadd to get the previous 11 months in your query.

You can't do this. The listener reacts to the read intent setting in the connection string. The architectural guidelines say that you should have multiple connection strings for your application...

There are a few things you can do. First, if you are loading into a destination that expects integers for the first field, you'll never load those records. However you...

It certainly sounds interesting. I'd like to give the desk on wheels a try if I go back to an office.

You don't get the chance to answer in the email. When you click, the whole question (Edited or not) appears, along with the answers. If you don't re-read the question,...

Fair enough, I was thinking of many CS problems that loop until space is exhausted.

I'd still argue this is an infinite loop in code. It's the hardware and environment that...

I guess perceptions are different. With the comments noting

-- first step

...

-- second step

...

I executed each section of code until the next comment, since that made sense to me. Executing...

I agree with OPC.Three that you doing this without knowing how to get started is concerning. If you're just unorganized, but you understand the idea of DR and options in...

It's not clear what you are trying to do.

There's a Derived Column transformation. Do you mean a computed column?

Glad to hear it, and glad things are going well.

Love to see a card trick if we end up at the same...

Lowell (2/27/2013)

Steve Jones - SSC Editor (2/27/2013)

Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.

I did run across...

You could call a remote stored proc and return values back. That might allow you to use OUTPUT on the remote side, and then when it returns, insert those into...

Stefan Krzywicki (2/27/2013)

I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link...

You definitely will get implicit conversions, which can be a huge slowdown. I'd fix this first.

The plan shows that the inserts to the AuditLog table, and then the full text...