Thanks one and all.

lk

Then how can we avoid sql injection?

Thanks Tommy

Could we use 2005 as the witness when we have 2008 as other partners of the quorum?

Server is set on Windows or mixed authentication? Is this user is an admin of this m\c?

Does the available database tab changes the database name when you use following query?

USE <Any user DB>

GO

Also send us select @@version

Sorry Gupta. I found your question confusing... still

Do you mean I have to install sql server again if I don't have master DB backup. Thanks for telling that msdb and model would be rebuilt. Actually this is...

Re-indexing is ok but we need to analyze whether we have correct indexes. These indexes should help data retrieval process instead of bothering this. Post us the queries and the...

433--Could not find CHECK constraint for '%.*ls', although the table is flagged as having one.

8433--The message body may not be NULL. A zero-length UNICODE or binary string is allowed....

Agreed Nagraj

Following query can be run to update the remote access.

You are true Bru!

-Lk

Gila - "External fragmentation usually refers to file-level fragmentation that's fixed with a disk defragmentation program."

According to my understanding the external fragmentation is nothing to do with disk fragmentation program....

Run following query and let us know the result.

select * from sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED')

Find 'avg_fragmentation_in_percent' - External Fragmentation

and 'avg_page_space_used_in_percent' - Internal

I want you to go ahead and remove...