Many thanks - I will incorporate these measures into my work plans from now on. Chris
Thanks - both computers are running SQLS 05 but the OS's are different and the hardware specifications are different too. May I add a question about...
I back up databases by using the SQLS wizard (Sequel Server 2005). Occasionally, I need to restore the backup onto a different computer. When I do...
I am not using Developer Edition for production purposes. I use it to develop methods that enable me to output text data to statisticians. I never...
Thanks, Hemant and Satya. I am running 64-bit 05 Developer under W Server 2003 x64 and also under XP x64. I have had a look at the suggested...
I was trying to install 64-bit 05 Developer Edition into the most recent patch of Vista Ultimate 64-bit. Chris
Since my previous posts on security, I have come under a degree of pressure at work to secure Sequel Server using the same methods that everyone else...
Thanks for the thought. In the end, I decided to forget Vista and run XP X64 instead. So far, this seems to be working fine, and I have managed to...
Next instalment... The MS compatibility documentation says that SQLS 05 Developer X64 will instal under XP Pro 2003 X64. However, the only release I...
I've just checked the requirements and it seems that Vista Ultimate works (or should work) with SQLS 2005 Developer Edition. One puzzle is that it...
Vista = Ultimate (patched up to date by the company that built the computer); SQLS = Developer. To the best of my knowledge, the installation disks...
Many thanks for the suggestion about SYNONYM. I will try this - sounds like a very interesting idea. Chris
I was told by a Sequel Server Consultant that SQLS 2005 64 bit would install fine on Vista 64 bit. I've just tried...and it failed...several...
Thanks for this idea - very interesting. The method closely resembles that for Common Table Expressions (which I use frequently), so I will...
Thanks - I will ensure that I do this in future. I have checked out OPENQUERY in BOL and, unfortunately, it doesn't work because (or so it seems)...
Thanks, Adriaan - yes, I accept your observations - the second approach does, indeed, produce the same difficulty. Do you know if SQLS 2005 uses the...
Many thanks to you all. I would like to add some detail - I may be misunderstanding some of what you are saying. a) - I have read the link on...
In our medical research work, I feequently have to use derived tables in the form of views when I build queries: a typical example (that I used...
Thanks, Satya. I will explore your advice - and will assemble the various pieces of advice in this topic into a set of recommendations for our group...
My version of SQLS is 2005 64-bit, SP2, running on (a) Windows Server 2003 64-bit, SP 2 and (b) Vista 64-bit. None of my databases exists on a...
Separate names with a comma.
