you can use BIML Express to generate the packages. Just takes a bit to prepare the metadata to generate them.

to execute them I would prepare a few command files (the...

For such a table I would consider checking for how many repetitions of the SQL exist - and if number is less than 20% of total records perhaps adding another...

• This reply was modified 6 years, 2 months ago by frederico_fonseca.
• This reply was modified 6 years, 2 months ago by frederico_fonseca.

SQL 2005 its not supported by SQL Client 11 https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/support-policies-for-sql-server-native-client?view=sql-server-2016 for supported versions.

you will need to use an older driver (2008 R2 works) https://www.microsoft.com/en-US/download/details.aspx?id=30440 or 2012 https://www.microsoft.com/en-us/download/details.aspx?id=29065

Note sure how you...

That being the case then rollback U3 and contact Vmware with the issue through support - fact that can be reproduced on a brand new environment will help them.

Possibly rollback U3 would be the best option at the moment, specially as there are other people complaining about possible issues with this update.

Then get a copy of this VM...

as I said you need to add a join to the sales.salesorderheader table - that is what you are missing. putting "sales.SalesOrderDetail.SalesOrderID  = sales.salesorderheader.salesorderID" is not joining - it is...

Few errors

Referencing a table on the select columns that is not part of the joins - that is your main error

Giving alias to some tables, and then using the full...

And depending on the needs RedGate SQL Monitor may also be an option - limited to SQL Server only (and some details of the underlying server) but with good info...

yes that is a reasonable assumption if the 2 tables are on the same database

from https://docs.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql?view=sql-server-2017

Each database has a counter that is incremented for each insert or update operation that...

As it is a HEAP it may not release the space - but doing a table rebuild will deal with the issue

remove the convert on the where clause - for display purposes you only need to change the select list.

and this really should be done on the visualization layer not on...

Sorry if my previous reply sounded a bit harsh.

Had a chance to review your replies and now I think the following will do what you need.

two options - both should...

Found another document - this is a bit more clear on the whole embedded subject.

https://www.arrow.com/arrow-services/msembedded/wp-content/uploads/sites/3/2019/07/windows-embedded-server-decision-tree.pdf

Main difference from "standard" licenses is a longer support period - possibly as Steve mentioned using...

that code you just posted, asking the "experts" if it is a good option is what I gave you on the first reply to you.

yes it is one of the...

But do take in consideration that the example that Lowel gave you requires Microsoft Office to be installed on the pc/server where it is executed - if on a server...