the second line of code inside your function should be indented

def calcsq(n):
  return n*n

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

• This reply was modified 4 years, 10 months ago by  Marek Grzymala.

Expected outcome should be:

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

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:

On...

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

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 10.94.49.224[61784]

CLNT_UCAST_INST from...

Except that in SQL 2000 there is no sysschedules table. What worked for me was this: http://solihinho.wordpress.com/2009/01/01/query-for-listing-sql-server-job-schedule/[/url]

For all those who got this...

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

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:

1....

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