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 2 years, 8 months ago by ratbak.
• This reply was modified 2 years, 8 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.

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

On top of the technical reasons not to that have already been mentioned is a business reason:  SQL Server is frequently your most expensive storage.

Is the primary key on LogID clustered?

Are inserts slow? Updates? Selects? All? Does slow mean seconds/minutes/hours? For how many rows in a transaction?

If the transaction rate is...

• This reply was modified 2 years, 9 months ago by ratbak.

How many rows? How large is the average error? max?

When you say slow to query/slowing the table down, do you mean select queries? Insert queries? Both? You don't have updates,...

Can you provide the link to that article?

Layout on that page is rendering most of the article illegible (at least in Chrome).

SQL Server 2012 SP4 is here

Security Update for SQL Server 2012 SP4 (KB4057116) is here 

replace(replace(col1,char(146),''),char(133),'')

Maybe a TVP w/ SortColumnName and Direction/SortOrder columns? SortOrder could be constrained to 'ASC' & 'DESC', or '+' & '-'

With validation in the procedure that SortColumnName is actually a valid...