Viewing 15 posts - 1 through 15 (of 23 total)
the second line of code inside your function should be indented
def calcsq(n): return n*n
January 15, 2020 at 8:48 am
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...
June 21, 2019 at 11:29 am
May 7, 2018 at 7:13 am
IF OBJECT_ID('Tempdb..#SourceTable') IS NOT NULL DROP TABLE #SourceTableCREATE TABLE #SourceTable ([VMID] INT, [VM_NAME]...
March 21, 2017 at 5:59 am
Expected outcome should be:
March 21, 2017 at 5:57 am
March 8, 2017 at 6:41 am
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...
February 22, 2017 at 8:26 am
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:
Id INT IDENTITY (1, 1) PRIMARY KEY NOT NULL,
September 19, 2016 at 9:30 am
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, ...
March 31, 2016 at 7:00 am
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
January 20, 2014 at 7:59 am
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: http://solihinho.wordpress.com/2009/01/01/query-for-listing-sql-server-job-schedule/[/url]
December 30, 2013 at 2:17 am
Server: Msg 5184, Level 16, State 1, Line 1Only formatted files on which the cluster resource of the server has a dependency can be used.
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...
November 30, 2013 at 4:41 am
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...
September 23, 2013 at 2:34 am
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:
September 19, 2013 at 2:19 am
Bangla (5/23/2013)Nice one..I like the design of the question also..:-)
Thanks, the scenario was from real life situation ...
May 23, 2013 at 9:51 pm