Cause found but problem stays.... Microsoft sucks again. I keep on being amazed by the fact that Microsoft can be both brilliant in making a product like SQL Server but...

For me it matters that there are gaps.... in our setup the identity is used as the employee number, and the employees use it to log in. Because MS suddenly...

If I read my SQL correct, one conversion takes 0.2 msec.... way to go! Thanks to all!

What's the final code now?

For the loop it should be the same:

DECLARE @a CHAR(30)

DECLARE @b-2 VARCHAR(30)

SET @a = 'hello'

SET @b-2 = 'hello'

SELECT LEN(@a), LEN(@b)

results in 5...

Wow... thanks for the improvements!

Raymond

Yes, I saw older posts, was just wondering what fastest would be.

I eventually came up with this based on older posts:

ALTER FUNCTION [dbo].[__fx_test] (@countryNr INT, @telNr NCHAR(30))

RETURNS CHAR(30)

WITH SCHEMABINDING

AS

BEGIN

DECLARE...

Do you remember if the status of the databases were Synchronized or Synchronizing before you performed the seconda FO ?

My guess is Synchronizing.... I'm kinda new to AAG so I...

Hey, what I did, using the SSMS, was:

Connect to Server DB01 and navigate to AlwaysOn High Availability | Availability Groups | AAG-MyGroup (Primary)

Right-click, Select Failover

Check that Failover Readiness is "No...

yes and yes

I have a gut feeling I must reboot differently. I can't find on Google anywhere best practise how to reboot a clustered SQL sytem

Thanks for the feedback guys.

We nailed it down to the following: we looked at "running queries" and found out that there was a ASYNC_NETWORK_IO /

PREEMPTIVE_OS_WAITFORSINGLEOBJECT issue, and we...

Hmm, yes was considering using a trigger... thanks for all your inputs

Sounds like it should work, however when I change my formula to:

RTRIM(([dbo].[fx_formatTelnr]([project],[user_tel])))

I still get the error.

What strikes me is the following:I am trying to persist the field in table campaign,...

What I want is a system that a user can enter a telephonenumber, and that that automatically gets converted to international style. For example for a Ducth mobile number: 06-12345678...

Thanks for your reply. A pity.... probably have to use a trigger that updates the indexed field when the record is updated/inserted....