To me it sounds like permissions were set wrong likely when fixing the orphan users OR when copying the logins and roles over.

If you still have the 2016 instance around,...

This is an easy one - if you pick SQLNCLI for the provier, it will use the SQLNCLI driver.  SQLNCLI is the SQL Server Native Client driver.

My opinion is to give them least permission possible for them to do their job but also that they accept responsibility for permissions that they claim to require.  For example,...

To add to Erland Sommarskog's reply, adding indexes could make things worse too.  Not likely to make things worse in terms of memory pressure, but increased disk I/O, larger databases,...

Without seeing the script, that is a difficult thing to debug.

My guess is it is not hanging connecting to SQL as that should time out, not just sit hung.

First thing...

So I did a quick test of this by running the following:

DECLARE @test NVARCHAR(20) = '2225504600042'
SELECT CAST(DECRYPTBYPASSPHRASE('a test phrase!',ENCRYPTBYPASSPHRASE('a test phrase!',@test)) AS NVARCHAR(20))
SELECT CAST(DECRYPTBYPASSPHRASE('a test phrase!',ENCRYPTBYPASSPHRASE('a test...

To add to Jeffrey's response - the client data may have a newline character in it as well.

If SSIS is your only option, then you are going to need either some 3rd party tool that allows for editing the Excel OR you are going to need to...

Just so I understand what you are asking, you want to know if the following will be counted as 7, 30, 60, 90 and 180:

Insert INto #test1...

Looking at the execution plan, the slow operation is pulling the 5 million rows from the Contacts table into memory.  It is taking over 40 seconds to pull the 5...

I may be mistaken but I am pretty sure what you are asking for does not exist.

If it did exist, I can't imagine the performance hit that would cause in...

My opinion (I work at a company that is SOX compliant), if you do your best to follow SOX compliance as best as you understand it and you pass the...

A few thoughts here.  First, update statistics if auto update statistics is not on.  And it may even help if that is on.

Second thought - I think you forgot to...

I think the result I posted in my second edit should work with the potential for a gap.  I think the only thing that you may want to add would...

I realized the mistake.  Actually multiple mistakes on my part.

First mistake I did was assumed that I could just add up the number in the xxxDayReadmit column, but you want...

• This reply was modified 5 years, 7 months ago by Mr. Brian Gale.
• This reply was modified 5 years, 7 months ago by Mr. Brian Gale.