I am not an expert in this subject but my guess would be how about creating covering index.

Try this:

Provided by Michelle F. Ufford:

Alter Table dbo.yourTableName

Add Constraint PK_yourTableName

Primary Key (column1, column2) -- ensure one of these is the partitioning key

With (MaxDop = 1); --...

Yup follow what's been suggested here. MERGE would be your choice.

Software comes with the server, you have to ask your IT ppl to get you that software, but still I guess best bet would be to ask them about all...

You can always try to restore 2k database to 2k5 in your test environment then see if everything works well as required then you are all set, but after you...

You have to...

Try this:

EXECUTE msdb.dbo.sysmail_help_status_sp ;

Hope this helps.

Ok, first you need to run SQL Server Upgrade Advisor, to find out what problems you might face during migration and fix those problems. you can download it from Microsoft's...

Thanks Michelle F. Ufford.

I implemented Partition table but wasn't able to get primary key on a column but with the help of your script now I have primary key...

Thanks Jeffrey. That's how I figured it out when I dropped the object using default trace files created by the SQL Server.

Thanks for the reply Greg.

Did you create unique clustered index on the columns which were mentioned in the composite primary key? If you did then I guess You have created unique constraint and I...

Nice Very tricky. I ran each statement separately. I answer it as TABLEA. I read comments posted and tried again, then only I got TABLEC.

when you are doing installation on the machine if IIS is not installed then both options would be disabled.

Server name is SMTP server name. If you are using gmail then server name would be smtp.gmail.com