Thanks Welsh Corgi!

Thanks for creating the test table..

Im trying to get col 3 to be

Col1 COL2 COL3

1 ...

thanks guys... gone the 4 col way and so far so good 🙂

thanks.. taking a look now.. i did a search but clearly didnt look at articles 🙁

Also found this:

SELECT * FROM [ipaddress]

ORDER BY CAST(PARSENAME([IPAddress], 4) AS INT)--,

...

im trying to put a list together as well to get my documentation up and running.

Trying not to change anything major, but put in a few basic settings that...

ok..

Got my datasource string wrong.

It is now:

="data source=" & Parameters!server.Value & ";initial catalog=" & Parameters!database.Value

(taken from the thread about the post) and its working.

I set the default...

Just as an add on..

Id prefer if i could use a drop down list to pick the server i run the report on.

Is there a way to make...

Hi Markus,

I might be being simple..

but that isnt working for me. I try to deploy it to test and i get an error

The definition of the report '/MYReport'...

Spoke to soon.

Ive done the below exp and it seems to work!

=Format(DateAdd(DateInterval.Day,-1,Now),"yyyy/MM/dd")

Hi,

Sorry I was meant to update, Yes I event saw the forest though the trees and read that article.

If you use:

Select name, physical_name from sys.master_files

It shows some files...

Hi all,

Ok after getting some sleep seems my head got a little clearer..

Got it all working now finally.

the things that solved the problem (and clearly would have...

in event viewer i can see im single user mode as the sharepoint account is trying to access it and getting

Login failed for user 'xxxxxxxx'. Reason: Server is in...

ok so current situation:

The service will start with

NET START MSSQLSERVER /c /f /T3608

I then try and log in with sqlcmd and get failures.

I dont know the SA...

hey,

As you my have guessed fell asleep at that point :/

just tried sqlcmd -S 127.0.0.1,1434

got a new error.

an error has occurred while establishing a connection to...

Update,

So the service is now started but i cant connect.

Ive tried SSMS from my work machine. which fails/times out

Ive tried sqlcmd on the server using my domain account...

Ok..

not thinking. So i've taken out the trace flag and -c in the Server Config. Then using the command line. The service started.

When i tried the sqlcmd we...