There is no agent in SQL Express so the only way to schedule it is to use a Windows task.

That being said do you have a full version of SQL...

Try disabling the named pipes client protocol, it should be the last one it falls back on anyway, typical config is that it goes shared memory, tcp/ip, named pipes.

Use the binary hex as the clause for the job_id

SELECT * FROM msdb.dbo.sysjobs where job_id = 0xD498185D4A27E947ABE673A5CD93B09B

Now we fall into the troubleshooting steps of why it cannot connect.

Server up and running?

Correct server name listed in the -S switch?

Can connect via SSMS to the server?

Server set to...

what error do you get?

Can register from the Prometric site, there are two options for MCM when I log in selecting the UK as my country,

Microsoft Certified Master Programs (088)

Microsoft Certified Master Program...

Setup a windows scheduled task which executes a batch file that contains the nessesary SQLCMD switches and pass in the command in a SQL file via the -i switch.

http://msdn.microsoft.com/en-us/library/ms162773.aspx

You need to select it from the lab section of the MCM its not in the theory list.

I would seriously recommend getting them to unblock the site then as there is just to much information on that site to copy and paste into the forum

Would have to do something like the following due to the way that CHAR stuffs the white space with a space

declare @i char(8) = '1'

select right('0000000'+REPLACE(@i,' ',''),8)

Use Ola's index maintenance scripts, give you a lot more control than the standard MP's do.

Link can be found in my signature.

Then I suggest you build a table which houses all the different probabilities

You need to do a condition where Date >= FromDate and Date <= ToDate

DECLARE @Table TABLE (FromDate DATETIME, ToDate DATETIME, ResultDate DATETIME)

INSERT INTO @Table VALUES

('2012-01-01','2012-03-31','2011-12-31'),

('2012-04-01','2012-06-30','2012-03-31'),

('2012-07-01','2012-09-30','2012-06-30'),

('2012-10-01','2012-12-31','2012-09-30')

SELECT

ResultDate

FROM

@Table

WHERE

GETDATE() >= FromDate

AND

GETDATE() <= ToDate

Please can you follow the second link in my signature on posting code and data so that we can help you with a query.

The alias needs to be created on the clients.