does the account have write permission to the file location? Sometimes local admin doesn't always mean account has free reign over everything.

another option instead of adding permission to the AD...

I would...

this should work

SELECT [Name00],

[IP_Addresses0],

[Model00],

datefromparts('20'+substring(Name00,7,2),substring(Name00,5,2),01) as DateDeployed

FROM [System_IP_Address_ARR]

inner join [Computer_System_DATA]

ON [System_IP_Address_ARR].[ItemKey] = [Computer_System_DATA].[MachineID]

WHERE datefromparts('20'+substring(Name00,7,2),substring(Name00,5,2),01) < dateadd(month,-48,getdate());

you didn't give us alot to work with (read article in my signature) but this should get you the results you want.

select *

from tablename

where datefromparts('20'+substring(name,7,2),substring(name,5,2),01) < '2012-03-01'

did you enable the mail profile for SQL agent? right-click SQL Server Agent, choose properties and go to alert system page.

If your virtual disks are sourced from a SAN and all your virtual disks come from the same disk group within the same storage, then there shouldn't be much of...

you will nedd to drop the current constraint, then add the new one. https://msdn.microsoft.com/en-CA/library/ms190273.aspx

ALTER TABLE tmpHCDAXP

DROP CONSTRAINT PK_tmoHCDAXP;

ALTER TABLE tmpHCDAXP

ADD CONSTRAINT PK_tmoHCDAXP primary key clustered (DXFORM, DXFTYP, DXPCOD, DXPSDT, DXSSDT);

identify the active transaction using either dbcc opentran or sys.dm_tran_active_transactions.

Once open transaction is identified either commit or rollback transaction.

without sample data or table definition it makes it a little more difficult to provide answer. Please read link in my signature for how to post to get better answers.

that...

There is no Service Pack 2 for SQL server 2014.

if you are talking about an earlier version, then yes, just installing SP2 would include all previous fixes. There are some...

I still think it's due to the results being returned.

this should time out for you after five seconds when it clearly would run longer

SQLCMD -S localhost -d AdventureWorks2014 -t 5...

I think you are waiting for the result to get displayed in your powershell window. the query itself probably finishes before 5 sec.

I run your example and it does receive...

I think this may have to do with windows caching the AD information and what it had cached did not include the membership of user1. I had a similar issue...

I believe each license is for two cores, so two licenses would support 4 cores. I dont think you are able to buy a license for just one core, they...

you just need to put your query within the single quotes of the assignment and then qualify all your single quotes with the query.

Declare @sql NVARCHAR(MAX)

Set @sql = '

SELECT...