Viewing 15 posts - 886 through 900 (of 13,841 total)
I'm assuming you mean something more than comments in the code itself? Where are you expecting/hoping the help will be displayed?
June 16, 2023 at 10:34 am
Out of interest, can you try this version?
INSERT ...
SELECT TOP((@i_sequence_end - @i_sequence_start + 1) / @i_inc_val)
value = (ROW_NUMBER () OVER...
June 13, 2023 at 3:49 pm
OK, is the SQL Server service running under the same account as one of the users you have tested?
June 13, 2023 at 9:03 am
Are you saying that permissions have definitely not been changed?
June 13, 2023 at 8:54 am
Have you got multiple versions of PowerShell installed? Eg 5.x and 7.x
June 12, 2023 at 3:14 pm
Sounds like there may be an error occurring which is forcing the window to close despite the Sleep.
Try this instead:
Read-Host -Prompt "Press any key to continue"
though I don't expect it...
June 12, 2023 at 10:38 am
A source control repository contains a (technical term) bunch of files which form some sort of logical grouping. That grouping is your choice.
An example repo would be 'Databases'. This could...
June 12, 2023 at 9:19 am
I used to work that way about 15 years ago.
Here is a sample process developing using SSDT. It assumes that devs do development locally.
June 12, 2023 at 8:50 am
That is rather a large topic! But SSDT allows you to create a 'project' for each of your databases. These projects are contained in one or more 'solutions'.
Each project contains...
June 12, 2023 at 8:13 am
This has happened to me several times, and it's a pain.
But uninstalling and reinstalling 'Microsoft SQL Server Integration Services Projects' and SSDT has worked in fixing it.
Next step would be...
June 12, 2023 at 8:06 am
Deploying using SSDT takes care of this for you. Have you considered using that?
Another possibility would be to snapshot your UAT database prior to deploying and do a revert in...
June 12, 2023 at 7:58 am
Does this work? Likely not, as XML things tend to behave differently from how you would expect.
SELECT *
FROM TEST.SDE.label l
WHERE EXISTS
(
SELECT 1
...
June 12, 2023 at 7:52 am
You could put the statement 'pause' at the end of your script. It will prevent the window auto-closing and maybe there will be some sort of informational message there.
June 9, 2023 at 2:42 pm
What happens when you try this ... is there an error?
June 8, 2023 at 4:23 pm
But this will be hosted on production server where there are all other databases get backed up and patching etc. I agree that we should not support a database...
June 5, 2023 at 12:33 pm
Viewing 15 posts - 886 through 900 (of 13,841 total)