Viewing 15 posts - 5,551 through 5,565 (of 39,754 total)
April 4, 2018 at 8:44 am
Isn't enough on my desktop. I need specific UAC actions.
March 29, 2018 at 1:21 pm
Is there some format you need? You can certainly use a sequence. You can use a newid() and convert this to a varchar if necessary.
March 29, 2018 at 11:23 am
Does the agent account have rights to do this? Quick test, set the agent to run under your account.
March 29, 2018 at 11:16 am
What Eddie said. Stop using datetime and getdate()
March 29, 2018 at 11:16 am
a- your packages need to understand how to handle partial execution and restart. The job won't move. If the cluster fails over because you move it, not a termination of...
March 29, 2018 at 11:15 am
The SQL Server engine service account runs the backup. This is why when you run the backup from SSMS, even though you might have access to a folder or share,...
March 29, 2018 at 11:12 am
As Perry mentioned, you can. The certs are the same as any other cert. Each needs a unique name, but you can have multiple certs in master. When you restore...
March 29, 2018 at 11:09 am
First pitch of 2018
http://www.espn.com/video/clip?id=22955580
March 29, 2018 at 11:06 am
It's a guesstimate in any sense. Look at log size, and then the time to xfer. Should be able to get an idea of bandwidth usage from there.
March 29, 2018 at 10:59 am
Arggh, image issues.
Here's the code I ran from an elevated prompt:
$ powershell
Windows PowerShell
Copyright (C) Microsoft Corporation. All rights reserved.
PS...
March 29, 2018 at 10:13 am
What's the problem? I know if I try this (in the image), I need to ensure I'm running in an elevated cmd prompt. Maybe you have an UAC issue?
March 29, 2018 at 10:09 am
And what does the PRINT show for you. Meaning, if you run the cmd from the CLI, what happens?
March 29, 2018 at 10:04 am
March 29, 2018 at 9:34 am
I've recently been investigating using Source Control to store/modify database objects scripts.
The option described...
March 29, 2018 at 9:28 am
Viewing 15 posts - 5,551 through 5,565 (of 39,754 total)