Marek Grzymala (3/31/2016)

---

Get-ADUser : The server has returned the following error: invalid enumeration context.

At D:\_TEMP\GetActiveDirectoryUsersWithPowerShell\GetActiveDirectoryUsers.ps1:123 char:22

+ $Results = Get-ADUser <<<< -Filter * -Properties * | select -property CanonicalName,sAMAccountName,ou,GivenName,SurName,DisplayName,email,emailaddress,StreetAddress,City,State,PostalCode,HomePhone,MobilePhone,OfficePhon

e,Fax, Company,Organization,Department,Title,Description,Office,...

matt 27758 (3/31/2016)

---

Thanks for this nice article very informative. Its been a while since I had to do anything with AD from SQL Server, we traditionally used a view...

typically you install the oracle universal installer on the sql server itself, and then configure/copy your tns files , and prove you can connect via typical Oracle tools from the...

JimiHaze (3/29/2016)

---

Hi, thanks for the response.

I'm trying to connect from one SQL instance to another SQL instance. For simplicity I will call the server initiating the connection the SOURCE and...

linked servers are just an ODBC connection, so i'd start by removing the linked server from the equation.

from anyplace on the LAN, or from the server you are adding linked...

you cannot update a calculated column.

the other thing is your trigger design!

if i see a variable declared in a trigger, i immediately expect it's not designed correctly. you are grabbing...

bdkdavid (3/24/2016)

---

That was a good thought!

SELECT LastName FROM DT5

WHERE CHARINDEX(CHAR(151), LastName) > 0

no results

SELECT LastName FROM DT5

WHERE CHARINDEX(CHAR(150), LastName) > 0

no results

SELECT LastName FROM DT5

...

there's at least two other longer than normal hyphens that has a different ascii code than the "normal hyphen ASCII('-')=45,without even going into nvarchar data sets.

i'm betting it's one of...

ok, i'm going through the same issue as well, we have two domains with two way trusts.

the network guys tell me it's not possible to change our existing group...

Jason Strates article lists missing indexes along with usecounts, costs, etc.

i'd start there and enhance as needed.

http://sqlmag.com/blog/missing-indexes-correlated-against-execution-costs-and-counts

othercolumns ...include_columns usecounts Cost AggregateCost Impact

...

you have to edit the report, and remove the parameter in the report as well. the report is still happily sending the parameters as it last knew them, it doesn't...

yeah i think you need to use sp_executesql and pass the two out parameters to get the errors that Redgates SQL Backup will return;

it will tell you the exact error...

in that case, I'm thinking the issue is most likely that you've included a username and password in the connection, instead of letting the security be handled by the AD...

sej2008 (3/21/2016)

---

thank you,I will try out your solution given by you.but one question when I have configured smtp feature from server manager in my os that is windows server 2008...

it's very easy to zip through the install clicking next next next, but forgetting to add AD login as an administrator on the SQL instance.

you probably need to add yourself...