we have multiple instances on our sql server. To access our default instance we need to access servername\defaultInstance on port 1433.

We need to access our test instance...

Thanks very much for the fast response. Much appreciated.

I have just found my question answered here in more detail:

http://www.sqlservercentral.com/Forums/Topic514126-8-1.aspx

If anyone else is interested.

Kind Regards

Paul

Hi All,

ok what i have now done is create a data set in reporting services and put the following code in it

select DATEPART(weekday,getdate())

then create a table in the body of...

Thanks for the article. It was very interesting.

I believe that the DATEFIRST varible is set correctly:

1) when i run the following code select datepart(weekday, getdate()), i get the expected answer....

Thanks very much for the reply, it is much appreciated. I'm still racking my brains over what o do.

Can you think of any tests I can do.

So...