It sounds like you're trying to reinvent sequence or identity. Why not just use a sequence?

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...

Removed duplicate post following gateway error message.

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...

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...

You don't appear to have included the solution you wanted us to review.

Agreed 😀

Duplicate of https://www.sqlservercentral.com/forums/topic/dates-about-sql-oracle

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."

timestamp data...

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...

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...

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...

• This reply was modified 1 year, 11 months ago by ratbak.
• This reply was modified 1 year, 11 months ago by ratbak.

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...

Yes.  https://www.red-gate.com/products/sql-search/

Great extension.

I think they're at version 3.6.6.3856 currently.

Removed duplicate due to button click during slow save.