Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 13,460 total)

  • RE: Powershell To Get Active Directory Users And Groups into SQL!

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 1, 2016 at 8:46 am

    #1869177

  • RE: Oracle BETWEEN DateTime statement

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 1, 2016 at 8:35 am

    #1869172

  • RE: Send Multiple query results as multiple csv files in a single email

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 1, 2016 at 8:27 am

    #1869166

  • RE: Update trigger

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 1, 2016 at 5:53 am

    #1869114

  • RE: Update trigger

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 1, 2016 at 5:14 am

    #1869096

  • RE: User Account Control Restrictions message

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 31, 2016 at 3:13 pm

    #1869011

  • RE: Need help with SQl syntax

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 31, 2016 at 12:20 pm

    #1868980

  • RE: sqlcmd export tables with triple pipe

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 31, 2016 at 11:24 am

    #1868964

  • RE: Powershell To Get Active Directory Users And Groups into SQL!

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 31, 2016 at 7:38 am

    #1868842

  • RE: Powershell To Get Active Directory Users And Groups into SQL!

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 31, 2016 at 6:42 am

    #1868822

  • RE: OLEDB Driver for Oracle in SQL

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 30, 2016 at 12:11 pm

    #1868699

  • RE: How to prove a network problems with Linked Servers

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 29, 2016 at 1:46 pm

    #1868385

  • RE: How to prove a network problems with Linked Servers

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 29, 2016 at 1:16 pm

    #1868378

  • RE: Instead Of Trigger to pseudo-update computed column

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 24, 2016 at 1:54 pm

    #1867609

  • RE: Search for hyphen in database: it does not find the hyphen?

    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

    ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 24, 2016 at 1:46 pm

    #1867603

Viewing 15 posts - 1,156 through 1,170 (of 13,460 total)