Use sp_dropserver to remove the old servername and sp_addserver to add the new one (see BOL for syntax)
I'm European and as you said it is quite common to learn multipple languages. I am native Dutch speaker, but I also get around with English and...
You sure should go with the second option. In the first option you have a Clustered Index on 5 columns. Any non-clustered indexes you add, will also...
Look at the queryplan of the query! Are proper indexes set on the tables? What is the datatype of column calling_party_num? Is it possible for you to...
Looks like user 'A' doesn't have the necessary rights on the database. Check if both users are assigned to the same ServerRole and have the same...
I've changed all the CASE in your SELECT. This is the new code: SELECT ev.ev_id AS [access_default_id], cl.cl_id AS [access_class_id], ins.in_id...
Try rewriting this into this: CASE ins.in_discount_ind when 0 then COALESCE(ins.in_principaldefaultamount, 0) else CASE...
Yes, off course, my mistake[:S]
For performance it is probably better to split "value1 <> value2" like this: "value1 < value2 AND value1 > value2" In this way SQL has better change...
Hi, There could be potentional problem with different collation settings. The problems will occur when comparing values that depend on the collation...
Like Frank Kalis said: create a table that has the numeric value and the string value in the same record. Then you can create a INNER JOIN to the new...
From the error-message it looks like some synchronisation (within SQL server) is lost, so the partition number and the index are not linked anymore....
Separate names with a comma.
