Viewing 15 posts - 91 through 105 (of 747 total)
Did you actually move the files (e.g., using file explorer, powershell, robocopy) before executing alter database? ALTER DATABASE doesn't do that -- just registers the new location.
If so, it sounds...
December 14, 2023 at 10:51 pm
Removed duplicate post following gateway error message.
December 6, 2023 at 11:14 pm
Does the code actually work?
That looks confusingly written, if not wrong, because the on statements for the joins do not always directly follow the table they are joining.
The second ON...
December 6, 2023 at 11:11 pm
Does SQL Server have permissions to write to that folder?
Are you getting any error messages?
Are you executing in SSMS? If so, does the login have permissions to write to that...
December 4, 2023 at 9:27 pm
You don't appear to have included the solution you wanted us to review.
November 22, 2023 at 8:35 pm
November 21, 2023 at 10:07 pm
https://github.com/MicrosoftDocs/sql-docs/issues/3933:
"The 'DateTime' data type has not been declared as Deprecated. There is nothing more to say about the continuing status of DateTime, nor about any other data type."
November 17, 2023 at 10:44 pm
You probably need to find out from the users if those rows are needed.
Is delete included in your publication? If it is, they were probably either added manually or added...
November 17, 2023 at 2:25 pm
I'm sorry, but what is the value add to including a script that generates sample data beyond what I have provided thus far?
Reproducibility
Consistency
Testability
Efficiency -- Saves time for people who are...
November 10, 2023 at 4:27 pm
It seems like you may be confusing server login with database user, or we're not fully communicating on what steps you took to grant user access to other databases.
The scripts...
November 2, 2023 at 10:02 pm
Have you verified that there are users tied to those logins in the desired user databases? That they have the permissions you expect?
It sounds like the login was not mapped...
November 2, 2023 at 8:53 pm
Yes. https://www.red-gate.com/products/sql-search/
Great extension.
I think they're at version 3.6.6.3856 currently.
October 26, 2023 at 7:37 pm
Removed duplicate due to button click during slow save.
October 26, 2023 at 7:37 pm
Based on the last five rows, it looks like you would want to use a CTE to go back through ancestors (parent -> grandparent -> great-grandparent -> etc. until you...
October 25, 2023 at 5:19 pm
Viewing 15 posts - 91 through 105 (of 747 total)