Hello,

Can you post the estimated execution plan?  I'd surely like to see it.  I believe that looking at the plan will help answer your question about which is faster.  (querying...

Hi newbie.  google for: How to configure sql mail

There are some configuration settings in the client access tools that can be made that affect the transaction isolation level that is used.  This is supposed to allow updates without having journaling...

And I forgot to mention that the SQL7008 error you might get (and did get in some of your queries) is probably because journaling is not set up on the...

I'm sorry but I don't have access to the machines until Tuesday.  I will try to help in the meantime.

The 4 part name method (your first query) should be the...

Hi, This is a frustrating subject, indeed.  I've had similar problems and there isn't much help out there.

What I did was use the IBM driver to create an ODBC connection,...

Please note that it is a violation of your licensing agreement with the makers of the Crystal Reports software to reverse-engineer even the reports that you yourself created.

Are you sure...

P.S.

Did you apply all of the patches BEFORE you created the backup?  There was a case with that product where an error message would lead you via their KB to...

Is the database still listed in the EM?  Or does it show up if you run

Select * From master..sysdatabases

?

This whole Mickey Mouse thing about Pluto just seems Goofy to me.

Glad I could help.

jg

What I've done in the past is used a modulo operator on a suitable numeric column.  Perhaps an identity column.

Like so:

---

Update SomeTable Set SomeColumn = SomeNewValue

where IdentityColumn % 10 =...

If you can get rows back from this query:

SELECT  name,

 substring(Password,3,4) as salt,

        substring(Password,27,20) as UpperCaseHash,

 substring(Password,7,20) as MixedCaseHash

FROM [master].[dbo].[sysxlogins]

on the server you want to crack, you can enter the values into...

Another couple things you might check are antivirus software and filesystem backups.  Either of them can get the OS to report that a file doesn't exist even when it actually exists,...

I would posit that the reason that you can't find a reference to a good explanation is that there is no such explanation.  There is no possible argument that it...