Retrieving data from another database on the same server is very straightforward. E.g. from the master database you can issue the command SELECT * FROM pubs..sales (no need to specify...

Bear in mind that the answer has been changed since the original posting. When I responded, both answers 2 and 3 stated database name and not filename.

This was corrected but no...

I'm just wondering why "use DTS" isn't an option - it's a far better method than 1 and 4...

There are many ways to do this (as the footnote to the...

Replies are split right down the middle between restoring using the logical database name and restoring using the physical database name. This seems to be evidence that people didn't have...

Oh come on guys! Theres no such thing as the 'Windows Application Application Log'. It is just called the 'Windows Application Log' - viewed using the 'Event Viewer' application

O.K. so I got it wrong (again)! Is SQL 2000 different to SQL 7.0 in that it doesn't save the ISS file by default?

According to Books Online for 7.0 :

By default, when...

So sorry So you did.

I'm suprised that noone has suggested using COALESCE. This uses the first non null value in a list of values. So how about replacing

-ISNULL(((KRE_MED_14),0)

with

-COALESCE(KRE_MED_14,0) etc.

oops sorry! Didn't read the question properly. I thought we were trying to dissable index hints for just one connection.

How do you set a trace flag for a connection? If the app is connecting through it's own logon, how do you 'get at' that connection to set the flag...

We also have a policy of always using character months (eg '19 Dec 2003'), however, we came a cropper when we opened an office in Switzerland - where they use...

OK so the answer was wrong and we want our points back - but not at the cost of losing the QOD section!

I look forward to the...

quote:

---

That means that you now have to have 1 million unique last order dates in your table.

---