Viewing 15 posts - 61 through 75 (of 1,417 total)
The duplicate value is listed in column ID or in column OrigID. So you also have to delete the rows where the duplicate value is listed in the OrigID column.
April 25, 2018 at 3:09 am
March 14, 2018 at 9:11 am
March 14, 2018 at 9:03 am
pietlinden - Wednesday, March 14, 2018 8:29 AM
With the link of PietLinden you can investigate the possibility's. Just try and...
March 14, 2018 at 8:51 am
In the code posted in my previous post it is just the letter "x".
March 14, 2018 at 8:35 am
You must give a name or alias to the sub select part.
I you enter a "x" (or even better: a more descriptive name) between the closing bracket and the...
March 14, 2018 at 8:01 am
March 9, 2018 at 5:04 am
March 8, 2018 at 5:53 am
Have you taken a look at the PowerShell scripts at DBAtools.io?
After a quick glance I guess you can use the function "copy-dbasysdbuserobjects".
Edit:...
March 8, 2018 at 4:53 am
The information form the "Job Activity" monitor can be queried from the tables in the [msdb] database. Join the [sysjobs] and [sysjobsteps] tables to get the details of the job...
March 8, 2018 at 4:34 am
The problem has re-occurred. I've uninstalled AntiVirus program, and disabled Windows Firewall, restarted SSMS but...
February 26, 2018 at 5:12 am
As from this URL: https://msdn.microsoft.com/en-us/library/azure/dn495240.aspx
Azure is the Windows PowerShell module that you can use to control and automate the deployment and management of your workloads...
February 22, 2018 at 4:36 am
Seggerman-675349 - Wednesday, February 21, 2018 2:14 PMI created a logical device on the database server
You need to create a logical device...
February 21, 2018 at 2:25 pm
It is possible if the device is (or can be made) available on the other server. From there you can do a normal restore action.
February 21, 2018 at 1:53 pm
February 21, 2018 at 1:11 pm
Viewing 15 posts - 61 through 75 (of 1,417 total)