Can you please post the results after including i.name and i.indid as suggested by Gail?

Thayalan (7/4/2009)

---

Dear,

I have a sql server 2005 production database(600 GB) that has 5 data files and 2 ldf files. Data files are placed in 5 different drives(D,E,F,G,H) and log Files...

what are the data types of b and c and what is the expected output?

these two links contains details on how to make a query case sensitive. Hope they'll be of use to you.

http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm

http://sqlserver2000.databases.aspfaq.com/how-can-i-make-my-sql-queries-case-sensitive.html

The collation designator settings of the database should be case sensitive. check out BOL for details.

As Roshan stated, while taking the backup of the database, more than 1...

Can you post the result of this query?

select o.[name],i.[groupid] from sysobjects o

INNER JOIN sysindexes i ON i.[id]=o.[id]

This happens usually when you restore...

Query the table to see the changes!!

Do you mean you want to track which table's data...

Are you getting any error in selecting that?

I hope you're doing it in the same way as mentioned in this article (except point 4).

http://technet.microsoft.com/en-us/magazine/dd407825.aspx

Hmmm I've no idea but googling it gave some good articles including PDFs. May be you want to go through those.

http://www.google.co.in/search?hl=en&q=what+is+compliance+remediation&meta=&aq=f&oq=

Please post table structure, sample data and expected output from the sample data so that someone can help you better.

This link will guide you in doing that.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Are you comparing with Oracle?

What exactly do you want to do when u...

Well , i wait for questions under this category. Have scored 96%.. :w00t:

Also, these questions bring you more points than technical ones:hehe:

This seems to me like a bug.

can you check these two things?

1. check...