Hi Matt

Thanks for the quick answer - I will cetainly keep visiting this site, and will try to participate rather than just lurk as I often do 😎

thanks again...

are there other ways of accumulating points as well as answering 'Today's question' correctly?

I'm unsure of exactly how the points thing works, but I'm interested in trying to increase...

Hi Jeff

I am a frequent lurker and occasional poster on this site. Firstly, I would like to thank you and others for the invaluable info that you post here -...

another possible solution:

Create a secondary report that displays the 'staff details' e.g. name, address, phone, whatever

Then, on the main report, turn the name of each staff member displayed on the...

Hi All

I have a question about backing up mirrored databases:

Say you have the principal on server A, the mirror on server B and the witness on server C

If the principal...

try this:

select top 4 [rank]= Rank () OVER(order by wickets desc, inruns),id,wickets,inruns from **tablename** order by wickets desc, inruns

you could also try the "WITH TIES" option when selecting TOP...

I was unable to find a solution to the problem and ended up doing a workaround by importing into access, then exporting to a text file and finally importing from...

Thanks guys - you have provided very useful info, and i take on board the comment about not using the wizard for creating backup jobs. Will try configuring the backup...

Thanks for the information, I'll have a look at the link and try it out 🙂

re: "need to run an extra script"

I haven't had to do this - perhaps its only required for 64 bit installations of SQL 2005 where linked to SQL 2000?

personally I would steer clear of Access altogether. Although the SQL tables can be linked from Access, I have found Access to be fairly unstable, and every so often it becomes corrupt....

as far as i know Reproting Services is available for SQL 2000 as well - its free, easy to use and has some nice features - the simplest of which...

create a new login/password on the target server that you want to link to. Make this login a user on the databases that you want to query, and ensure that...

i have had exactly the same error in reporting services when adding a new field to the underlying stored proc (or query), then adding the new field to the existing dataset for...

Found the answer - it's much easier than i thought.

For all those who share my ignorance:

select the item to be bookmarked. In the properties window (View | Properties Window),...