Thanks for this Lowell.

However, I have been through the instructions but I get to the point where i have to find the GUID for Microsoft SQL Server 2005 in the...

Hi

try searching 'reportviewer.render' in google which should return results on how to export an SSRS report to pdf programtically.

thanks

Nic

Am i right in saying that you cannot use a name that you give a calculation in a select statement within the where clause.

Therefore RANK is not recognised, but if...

Hi Minaz

thanks for the reply, this is good then.

is this because in simple mode it truncates the transaction log and in full it doesnt unless you ask it to by...

you could try declaring the insert statement into a large varchar variable and then executing the whole string by using Exec(yourVariable) within your stored procedure.

you could then change the where...

well, after half a day of checking that all the necessary protocols were enabled and on the same ports, making sure the firewall was configured and typing the password very...

well i will always check the keyboard settings now!!!!

well sort of

i was remote desktopping to it and getting the same error message, which was confusing me even more as i could sit on the server and log on...

thank you all for you're however it is now resolved.

you're not going to believe this, but when the server was set up the keyboard was left as US. this meant...

the sa login is not locked out, although i have done this accidently a couple of times through the amount of failures i was getting.

i can login in using sa...

i have already tried this, sorry for not mentioning it.

i am going to install the SP1 on it as the WMI seems to be playing up slightly.

maybe this will solve...

i have checked the authentication mode and it is mixed.

i then changed it to windows authentication and then changed it back just to be sure.

as i said before, i can log in using the windows authentication now, however the error below is given when connecting the the sql instance from my laptop through SSMS.

Cannot...

remote connections are enabled and sql server browser is running.

to add to the last post, i have created a user using windows authentication and for some reason that can connect in.

the sql server is set on mixed mode, so...