As a pure guess, I am thinking the UI is issuing a full delete of a list as a way around trying to figure out how many PersonIDs had been...

No disrespect intended, but the commands shown only generate the commands to change the collations.  Did you run the generated commands?

The LIKE approach works for me.  Do you get bad results from this (note, make sure no new-line characters invade the LIKE string):

drop table #temp

create table #temp
(col1...

Try to create this in a view to start with.  Computed columns can not be used in the definition of other computed columns, so that will cause you some problems...

Things to check here;

1. Is there a pop-up or message box in the package.  SSIS will not get past this point.
2. Can the SQL Server resolve the connect identifier?  This...

Better than looking at the file list would be to look at the backup tables in the msdb database.

use msdb;

select bs.Database_name, bs.user_name, bs.backup_start_date, bs.type, bmf.physical_device_name

from backupset bs...

• This reply was modified 5 years, 5 months ago by  crow1969. Reason: Tried to clean up code tags

If it has a different database_id, how are you certain it should be associated with database_id = 15?

I see entries for the System Resource Database, but that is ID 32767. ...

Next time this happens, have a look at the wait_type and/or wait_resource fields in sys.dm_exec_requests.  That may give you a few more clues as to what is going on.  The...

If the server is crashing, you should (hopefully) be able to get some sort of error from the errorlog.  When you run the following:

xp_readerrorlog 1

Do the final few lines look...

Instead of deadlocks, this sounds like regular lock contention.  Have a look at the output of sp_who2 when this happens, and check the BlkBy (Blocked By) column.  If there are...

My first thought is that the Z:\ drive is a user mapped drive, which the server has no access to.  Can you use the fully qualified name (\\server\share\folder\filename)?

I do a lot of code reviews, so I usually rely on saying "It is a cross between a building inspector, and a teacher"

You can use an outer join to a fabricated "table" of months:

with months (mon)
as
(select mon
 from (values (1), (2), (3), (4), (5), (6), (7), (8), (9), (10),...

I usually use a hex editor for this sort of thing.  In general the process would be

1. Shut down SQL Server
2. Copy MasterData.mdf and MasterLog.ldf somewhere safe
3. Edit the MasterData.mdf...

• This reply was modified 5 years, 7 months ago by  crow1969. Reason: Removed double negative making the post look like second grade gibberish

My first guess would be firewall rules.  Turn on monitoring at the server side, and see if there are any dropped packets.  Evaluate what ports these are being dropped on,...