Not that I know of.

I guess I don't understand the question. Stuff in a script is run in the order it's in the script.

If you have a batch, and then two procs, it...

The question "who guards the guards" has the potential, like any recursive algorithm, of becoming an infinite loop.

Let's say you run a full-on trace on every database, in order to...

Lynn is right about applications. Another thing to consider is not just front-end code, but procs. Are they doing string manipulations on the varchar dates, and will fail...

Don't worry about the English-language aspect of the question. By the definition being used to justify the answer on this one, neither query is equivalent to itself, since floating...

ericzbeard (9/24/2008)

---

Ok, I have come to the conclusion that it is not possible to link two Sql Server 2005 servers using windows authentication. I had to resort to creating...

There are several ways to do this, depending on your exact needs.

On the format, datetime data is stored as a pair of 4-byte integers, one for the day, one for...

I just tested both queries in a copy of 2008 Enterprise, and the only difference in the results was the order (which, by RDBMS definition, doesn't matter).

Here's my test:

create table...

Are you setting it to "SQL Server" or leaving it on "Other Data Source"?

Are you setting the security credentials? If so, what settings are you using?

GilaMonster (9/22/2008)

---

GSquared (9/22/2008)

---

Once you switch to 90, you can't switch back to 80, except by restoring from a backup taken before the switch. (Which means, of course, that you'd...

I see a pic in your post. Is that not what you want?

(By the way, there's a forum for non-SQL or page-specific questions. No big deal, but just...

You can specify a locking method in a select statement. Books Online has the specifics on how to go about doing this.

Another approach would be to put data into...

I guess it depends on what's bugged and what version of the database you're using.

One of my usual ways to debug a UDF is to break it out into a...

Actually, the question sounds like it belongs in an interview or an exam.

Once you switch to 90, you can't switch back to 80, except by restoring from a backup taken before the switch. (Which means, of course, that you'd lose any...