Thanks for the suggestion. I will give it a try.

I tend to agree that it is some sort of escaping issue. However, the error is not consistent and I have yet to duplicate it myself.

I remember reading somewhere that...

If I take the query string that is returned with the error and run it in SSMS, the same error is generated. Simply adding the missing single quote fixes the...

Thanks for the reply Chad. Unfortunately, the query is executed from within application code. No EXEC or Stored Procedure. Also, if it were a case of not escaping a single...

I recently had a need to accomplish the same task. I cam across this UDF that satisfied all of my criteria. Hope it helps.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56499

We use a service from U.S. Data Trust (http://www.usdatatrust.com/service/online-backup-service-benefits.asp). They do full/incremental remote backups and the service is configurable via a web interface. I'm not sure about the...

I have a similar situation as the OP and solved it by creating a calls_history table that has the same columns as the calls table. I then setup an ON...

Yes, I could do that and will. However, there are other processes that connect to the old server that I can't easily modify.

Thanks for the quick reply Matt. I didn't think that the local IP address as the alias looked right but it was the last of many iterations. I am still...

Thank you all who replied. I went with Jeffery Williams' solution as it produced the results I was looking for and was a nice use of a CTE.

Given that each subsequent diff backup contains all the changes since the last full backup, is it necessary to keep the previous diff backups? In a restore situation does one...

@Vegard

WOW! That was a very informative reply. I truly appreciate it. I can sleep a little easier now knowing that the backup strategy I have in place will work. Though,...

I too am an "accidental/involuntary DBA" facing similar issues as the OP. After considering our company's tolerance for data loss, I decided to go with Simple recovery, daily full backups...

@gary

Unfortunately, there is no consistency to the format of the unit numbers. So whatever solution the final solution, it has to work for any pattern.

One of the options...

@Christian

Thanks for the reply. Your solution will indeed work; however, I'm looking for a solution that will:

1) populate the sort_order column appropriately

2) work regardless of the format of the units

I...