With regard to naming convensions, I have never understood why vendors frequently call their stored procedures with a prefix such as PROC_% or SP _%.

Surely if you have a naming...

Sorry if I am missing something, but when you say you are deleting 400K rows from table A, is that ALL the rows from table A or just a subset?

If...

The tool was I think written in house and it's real intent was a simple tool for all software.

Other products (not SQL Server), often use exe versions and other...

Bowing to those individuals with better SQL knowledge than me, but surely the supplied statements from zahran is a bit like running down the road to the sweet shop to...

Firstly, what sort of cardinality do you have on AddrType.

The sample queries all appear to state a value of 'ME', so is that one of many AddrType values?

My thinking here...

Not sure I understand what you are trying to do/achieve.

Can you give a sample of the sort of processing you are doing?

Silly question, but why so many indexes?

In some cases, you have NameAddr1, NameAddr2, NameAddr3, NameAddr4, WorkAddr1, 2, 3, 4 etc.

So how often do your queries look for a specific value...

Go it (I think!)

Created a Maintenance Plan job to run TSQL via a remote connection to backup database on Server A to put backup file on Server B via UNC...

Latest status.

Running via Query screen the following syntax works fine and a subsequent check on the Security details for User Andytest show it has datareader defined correctly for Copy_MI database.

Run...

Thanks for the SID bit (I had forgottent that).

However, when I run the following:-

USE [Copy_MI]

GO

EXEC sp_change_users_login N'auto_fix', N'Andytest'

GO

USE [Copy_MI]

GO

CREATE USER [Andytest] FOR LOGIN [Andytest]

GO

USE [Copy_MI]

GO

EXEC sp_addrolemember N'db_datareader', N'Andytest'

GO

The Datareader role...

You didn't say whether Minaz's solution sorted you out?

However, if you have say two database DB1 and DB2, each being backed up to what I might view a logical location...

Resolved.

Needed to correct the linked servers via SP_DropServer and SP_AddServer remembeing the local option.

Been doing some further playing.

If we set the source file as an Excel file (.xls) rather than a CSV file.  The method the business use to supply changes to the...

Snapshot process is working fine.  Daily publisher/distribution tasks completing.

However, I now have a related problem.

The database being used as the source here is a vendor supported structure.  Periodically we will...

Thanks for the Snapshot suggestion. 

I set that up last week after the post, and so far it appears to cover the requirements nicely.

Thanks for the comments.  So nice to...