you posted in "working with oracle", so i thought you were using oracle.

if this is SQL server, then you would just stick with dateformats that are universally converted;

you said you...

Ray Herring (4/1/2016)

---

andre.quitta (3/31/2016)

---

when I tried to run the code in Powershell, I got the following error.

[font="Courier New"]Import-Module : The specified module 'ActiveDirectory' was not loaded because no valid module...

pretty sure you have to use oracles TO_DATE function, especially because you are passing a string,and also using UK date formats.

WHERE DateCreated BETWEEN

TO_DATE('01/01/2016 00:00:00','dd/mm/yyyy hh:mi:ss')

AND TO_DATE('31/01/2016 00:00:00','dd/mm/yyyy hh:mi:ss')

the problem...

you'll need to have a separate process save each query to disk on the server, and then the email will not have a query, only attachments.

i currently use a CLR,...

vijay_uitrgpv (4/1/2016)

---

Thank you very much Lowell.

Do we need to mention every column which is being updated in IF UPDATE statement ?

Is there any way out if any column is updated...

great job posting your code and your work!

The thing about triggers, is that they have a pair of psuedo tables named INSERTED and DELETED.

Thos tables have the before and...

i cannot remember the exact error , it says something about UAC,and it's bit me in the past.

i believe it's because you need to add the user in TWO...

I think using a pattern like this will work: its saying the first two characters are A-Z, and then anything after that.

Select top 100 RxClaims.prescriberId

from MHPDW.TransferDB.[dbo].[RxClaims] RxClaims

WHERE

RxClaims.prescriberId LIKE...

yes it does.

i export html from a database, via bcp, and need to use characters that are not going to appear in the data, becuase the classic terminators like CrLf,...

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...