I haven't tried it yet since this change but have you also changed it so someone can report the same post more than once? so far on new site we...

when installing the oracle client make sure you select the connectivity tools (oledb and ado). by default they are not selected.

also make sure you did install the 64 bit versions...

on my shop we use group managed service accounts (GMSA) for ALL SQL instances (over 800 of them)- one per service per server

works great and no issues with it.

so server...

issue is that you are not looking for equality but for inequality - hence if either of the conditions is true it meets the criteria

so for your desired result it...

sometimes a google search does answer

https://www.mssqltips.com/sqlservertip/3307/managing-the-size-of-the-sql-server-ssis-catalog-database/

Note that with that size and depending on whether the correct indexes are inplace you may have issues - not sure now which ones but...

No it does not reverse the sql statement - but by using a...

haah.. I wasn't asking for one - just stating that yes he could do it as the others that were asking for it were saying he could not post it...

He can supply it - just needs to use SQL Sentry Plan explorer to anonymize  it before posting here.

If not mistaken that is one I managed to report - once...

if you change your query to

select *
 from @jo j 
inner join @temp t 
on j.txt=t.sait 
order by j.id desc

you will see why

in order to run SSIS packages targeting a particular version of SSIS you do need to have that version installed on the server (or a higher version in some cases...

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 ago by frederico_fonseca.
• This reply was modified 6 years 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.