Recreate the ODBC connection. If that doesn't work, go to Microsoft's website and download the latest MDAC. Install that and try again.

I don't think it's anything with an orphaned connection....

I believe the only way is if you were already tracking login information. The only login information is for current connections. Once the connection is broken, SQL Server doesn't care...

Here is the link for Previous Versions of Microsoft SQL Server:

http://www.microsoft.com/sql/prodinfo/previousversions/default.mspx

-SQLBill

So help others out here.....what was the solution?

-SQLBill

What edition & version are you using? Run this:

SELECT SERVERPROPERTY('edition'),

SERVERPROPERTY('productversion'),

SERVERPROPERTY('productlevel')

Thoughts: it could be an evaluation edition...

Andy,

I didn't believe for a moment that SSC placed it there purposely. That's why I said so in my post. But check out Yahoo's mail login page sometime. It's...

There must be data in both totVoid and totOpen. This query isn't adding or duplicating data into your tables - it's only a SELECT statement. Did you check your...

As an addition to mkeast's excellent comments. If you set your instance to Windows Authenication Only, the SA account no longer works.

-SQLBill

Sushila,

That should be "when and how to APPEAL about the peel" LOL!!!!!

I thought the bent corner ad was awesome, until it kept getting in my way when I was logging...

As you should be aware, a view has no data. So, does the data (tables/columns) exist already in the new database? Are they correct (the same as the old...

John,

I don't believe the argument is about 'having advertisments'. At least I know that's not what I'm bringing up.

Sometimes the site adds new 'styles' of ads (such as the...

Nope, I have auto-statistics on (I also run UPDATEUSAGE frequently) and I do regular maintenance. In fact, I had just finished defragging the indexes and had updated usage and stats.

-SQLBill

Out for Justice,

I had checked the fragmentation and it was slightly fragged. So I did a INDEXDEFRAG and ran it with the results I posted.

Kenneth,

It's been repeatable. MAX() doesn't use...

Andy,

Right now the 'bent corner' ad is no longer in the Active Topics forum view. So that's good. I haven't had any problems since you adjusted the menu bar.

Thanks.

-SQLBill

How are you getting "Bob"? If you can put that into a variable, your insert could be:

INSERT INTO tblname

SELECT @newname,

...