Sounds to me like you need to do a replacement of the data when you display it. IE: When you have an e with an accent you change it to...

I would say that it all depends on the data you have. Personally I'm still using temp tables for a lot of my work. I do this because I typically...

I recently had a situation exactly like what Phillip described where I had to go back several days to get to some valid data. Luckily for me I have a...

I would take a look at BOL for 'Pivot Table'. This is a classic case where you need to pivot the data on the values. They are a royal pita...

A couple more comments. What is the reasoning behind using a varchar field for the NextCustNo and CustID fields? As Mark stated it seems these fields should be INTEGERS and...

Have you tried simply the Linked Server name plus the table name? IE:

SELECT * FROM Test2...ATAB

Gary Johnson

Microsoft Natural Language Group

DBA, Sr. DB Engineer

Since you already have the linked server have you tried just using the fully qualified table name with a normal Insert or Update query? IE:

UPDATE LEAVESBOX.YourDB..YourTable

SET Field = 'blah'

WHERE Foo...

After a table has data in it you can't set the field to have the identity property. So in order to do this you will need to create a new...

The simple answer is no you can't do that.

You need to think of "Table Variables" instead as a temporary table that is stored in memory instead of the tempdb. You...

UDT's are great when modeling a database. Having said that I don't use them in any of my databases as I prefer to use the base data type. This lessens...

You might want to create a simple stored procedure that calls the suser_sname() function in SQL Server. The Access CurrentUser function will only work if you have turned on the...

The best way to go about this in my opinion is to put the data you want to compare into a formatted XML string. You can then use OPENXML in...

I would create a small app that connects to SQL Server using their credentials and then have the app call sp_password to make the change. This way they will be...

I would go about this a little differently than everyone has suggested so far. I would make server c the publisher and servers a and b the subscribers. I would...

I would probably create a table to hold the values you want to replace and then do something like the following...

UPDATE t

SET Addr = SUBSTRING(t.Addr, LEN(t.Addr)...