Forum Replies Created

Viewing 15 posts - 1 through 15 (of 23 total)

  • Reply To: Python Map

    the second line of code inside your function should be indented

    def calcsq(n):
    return n*n
  • Reply To: solved - Row Level Security based on membership in AD Group or ServerRole

    For users who are members of db_owner group IS_ROLEMEMBER ignores the DB Role membership and falsely returns '0', so unfortunately it's useless in those cases. What if I want to...

  • RE: Scripting Environments in SSIS

    Dave Pendleton - Friday, June 2, 2017 12:35 PM

    ichv - Friday, March 24, 2017 7:00 AM

    May 7, 2018 at 7:13 am


  • RE: Pivot - what is wrong with this query?

    Phil Parkin - Tuesday, March 21, 2017 5:52 AM

    This, maybe?

    IF OBJECT_ID('Tempdb..#SourceTable') IS NOT NULL DROP TABLE #SourceTable
    CREATE TABLE #SourceTable ([VMID] INT, [VM_NAME]...

  • RE: Pivot - what is wrong with this query?

    Expected outcome should be:

  • RE: Isolation Level SERIALIZABLE

    Terje Hermanseter - Wednesday, March 8, 2017 12:24 AM

    Uwe Ricken - Tuesday, March 7, 2017 9:03 PM

    March 8, 2017 at 6:41 am


  • RE: The default differential

    Interestingly, if a full-backup file with exact same name (and .bak extension) is already in that path then the command will append (and merge) the differential content to it, without...

  • RE: Automatic update of outdated statistics

    An interesting thing happens after changing your Id column to:

    Id INT IDENTITY (1, 1) PRIMARY KEY NOT NULL, and using the clustered index stats, instead of the non-clustered index:


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

    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, extensionAttribute1,extensionAttribute2,extensionAttribute3,extensionAttribute4,extensionAttribute5, ...

  • RE: SQL Server Browser

    net start SQLBrowser will not show you the client IP/ports from which they try to connect or how many times they try before disconnecting, like this:

    CLNT_UCAST_INST w/refresh from[61784]

    CLNT_UCAST_INST from...

  • RE: sql/script to list jobs and schedules

    If you need a literal breakdown of the schedule, try looking at sysschedules.

    Except that in SQL 2000 there is no sysschedules table. What worked for me was this:[/url]

  • RE: Moving TempDB of the Cluster Resource

    Server: Msg 5184, Level 16, State 1, Line 1

    Only formatted files on which the cluster resource of the server has a dependency can be used.

    For all those who got this...

  • RE: Having Problem in restoring transaction log backup

    Thanks Gail,

    If I repeat the same sequence of steps with a CHECKPOINT added either after step 1 (FULL) or after step 2 (BACKUP LOG WITH TRUNCATE_ONLY) then the restore attempt...

  • RE: Having Problem in restoring transaction log backup

    This error will show up also if you try to restore a T-LOG backup that was done after a TRUNCATE_ONLY command. In other words if you follow this sequence:


  • RE: Event Notification on Server

    Bangla (5/23/2013)

    Nice one..I like the design of the question also..:-)

    Thanks, the scenario was from real life situation ...

Viewing 15 posts - 1 through 15 (of 23 total)