The last time I heard about a problem like this was when someone had SQL Express installed on their system prior to trying to install a different version of SQL...

if not then what are the advantages of adding the users in the schema. what if the user Joe is Db owner? it does not make sense to give him...

Ah, yes. The old "double-talk" standard.

Could be the contracting rep shoved his way into the company and insisted they needed this position. The company almost bought it, maybe...

From what I understand, SQL 2008 isn't changed a whole lot from 2005. And since it's not coming out for several months, and the exams will probably be out...

I agree that honesty is the best policy, but so is tact.

If you left the previous job because of personality conflict or because you hated the work environment...

Gotta love a job with a boss that says "Go home at the end of the day and don't take your work with you!". @=)

I got one of those...

Open up BOL and look at "dbo". This will explain the dbo user account to you.

Maybe the problem is, when you removed SysAdmin access from the "admin"...

Sorry this took so long, but I didn't have a paypal account and wanted to look at alternatives before I signed up for one.

Pricing is as follows:

Pirates of the Blue...

Wow. Profiler recorded nothing.

I ran both queries twice on a 69 column wide, 7,538,289 row long table. Select Distinct * and Select Distinct (columnlist). I...

Today when I got it, there was no "Possible UCE::" on the title. I wonder what the difference between yesterday's and today's is that this didn't appear...

Okay, now I'm curious.

I'm running a test on a table that has 69 columns and between 6-7 million rows of data. No WHERE clause and I'll include the "DropClearBuffers"...

egejo15,

I know you're eager to get your problem resolved, but speaking as a paranoid DBA, you should NEVER upload your database files up where someone can hack them. There...

Wow. I didn't even think of that option. Thanks, Matt. I'll give that a try.

I have created SSIS packages which run on a SQL 2k5 server but connect to my SQL 2000 server and do work on it without any problem.

So if...

Ian,

There are other possible show stoppers. Linked servers and queries that use OPENDATASOURCE / OPENROWSET. Make sure you account for all possible objects that have references to these...