In this case, I think that's a bad idea because that may not match the actual...

In this case, I think that's a bad idea because that may not match the actual number of...

Have you tried getting the row count from the sys.partitions view?

John

Your New-Object command is running before you've done any existence check.  If the database already exists then you'll get an error.

John

What happens if you run the SELECT statement on its own?  What number does it return?  What happens if you run from EXEC to the end?  Does it send an...

Create a temp table and insert the results of the EXEC statement into the temp table, then select from that table at the end.

John

I suppose you could try filtering like this

database_name = 'DatabaseName' OR sql_text LIKE '%DatabaseName.%' OR sql_text LIKE '%[[]DatabaseName].%'

.Forgive me if I haven't escaped those square brackets correctly!

John

Have you tried a SQL Audit?  You can control what you capture with very fine granularity.

John

If you've got different execution plans, chances are something is different.  It could be that the statistics are more up to date on one server than the other, or maybe...

• This reply was modified 5 years, 5 months ago by John Mitchell-245523. Reason: Added tip about updating statistics

You need either to manually delete the referencing rows after the referenced rows, or recreate the foreign key constraint with the ON DELETE CASCADE option.

John

Are you updating statistics with the same frequency on both servers?  Please post the actual execution plan for the query on each server.

John

The datetimeoffset data type isn't as flexible in the range of string formats it supports as datetime is.  Please see the documentation.  I think you'll need to remove the...

Looks like your linked server object is set to connect with the login name suser, but that login doesn't exist on the remote server.

Help us to help you.  We're not...

Use STUFF to replace the first five characters with a blank, or LEN and RIGHT to return all but the first five characters.  Have a go and post back with...

Have you tried stripping the day name from the beginning of the string?

John