This seems to do the trick:

ALTER FUNCTION [dbo].[alias2dnsname] (

@alias NVARCHAR(50)

)

RETURNS TABLE

AS

RETURN (

WITH zones AS (

SELECT dnsname, alias

FROM dnszone AS A

WHERE A.alias...

Thanks for the feedback, George.

I'm still facing the problem and I checked the maintenance plan. It sets fillfactor 90% as you mentioned.

Let me ask you, since I'm not expert on...

Ehm... my function doesn't seem to return the correct results.

Let me work on it a bit.

You could also try the ITVF version:

CREATE Table dnszone (

alias varchar(50),

dnsname varchar(50)

)

INSERT INTO dnszone

SELECT '1.1.1.1', 'dummydummy.uk'

UNION...

[EDIT] I misread your question, post removed.

I think he meant COALESCE(@result, '')

DBCC FREESYSTEMCACHE('ALL') doesn't shrink tempdb, but deallocates all interal objects in tempdb, so that you can shrink it.

Until internal objects are deallocated, you can't shrink tempdb under the size in...

I don't think you can.

sp_start_job doesn't actually start the job, but tells SQLAgent that there's a start request and then returns immediately.

I think you could add a sleep...

You could use application locks:

http://www.sqlteam.com/article/application-locks-or-mutexes-in-sql-server-2005

OK, so you just have to query sysjobservers:

SELECT last_run_outcome -- 0 = Fail

...

Doesn't look to me like a great idea. Consider changing the function from scalar to ITVF.

Anyway, you can use something like this:

SET @concatenatedString =

...

I think you will have to add that column to your report from an appropriate table, mapping countries with currencies.

The query returns 1 when the input value is longer than 4 char (len(ltrim(rtrim(@vEmail)))>4) and contains the "@" char (patindex('%@%',@vEmail)>1).

PATINDEX returns the offset in the input string where the search...

These procedures should help.

-- Returns the status of each job

EXECUTE master.dbo.xp_sqlagent_enum_jobs 1, SUSER_SNAME

-- Returns the last execution outcome

EXECUTE msdb.dbo.sp_help_job

The first one is undocumented, but you should find some documentation with...

Yes, Nick, that's the idea behind.

SERVER1 - PROCESSING JOB:

STEP1 - Check if TRANSFER JOB is running and wait for its completion.

STEP2 - Process Data

SERVER1 - TRANSFER JOB:

STEP1 - Transfer...