I looked at the SQL 2008 licensing guide and it included the phrase:

Use of hardware and/or software that reduces the number of devices or users that directly access or use...

I am looking now, but honestly I think you can make the price point purely on CAL vs core even without considering the one-way traffic.

MSRP per core for standard is...

Please reply to http://www.sqlservercentral.com/Forums/Topic1478648-364-1.aspx

CEWII

I would have to check the SQL 2012 licensing guidance but I believe that if you have more than a few end points that core/processor licensing of SQL would save...

I am not familiar with that package (never heard of it before), but I did find a link: http://fmforums.com/forum/topic/78838-usql-transoft-odbc-driver/[/url]

CEWII

You could do a SELECT * INTO dbo.NEwTableName FROM dbo.OldTableName WHERE 1=0

BUT I don't recommend it. If that table gets modified for any reason you will now carry that modification...

In the message with all my screen prints look at the very last one, You need to see what is in Evaluated Value, THAT is what is going to be...

Paul Hernández (7/26/2013)

---

Every customer has its own card number and customer number, but a partnership has only one account. That means, every member of the partnership has its own card...

You don't need to define or map the variable in the component, the reference to it in the expression handles all that. You need to find out what it is...

I understand your mistake now. You can't use that property, it doesn't line up to the command to execute. SQLStatementSource is the property you need to set. With...

There is no mapping needed.

I'm having a little trouble following you. Where did you set the expression? What object? What property? What was your exact formula?

CEWII

I would do it with an SSIS package.

CEWII

I have seen processes that use linked servers tend to die in ways that cannot be trapped within a sproc, these errors tend to kill a connection. You can have...

You can set the default location for user databases in management studio. There are good articles online for movie the system databases. It would be better to use...

You might want to look at something like:

https://nclsqlinv.codeplex.com/[/url]

Also using linked servers to reach out to a lot of servers tends to fail, a lot. It can be done but it...