dsachu (2/7/2013)

---

It means in your Example :

Table : Ant

Column :...

Please read second link in my signature on posting code and data for the best help.

Please supplied DDL of all tables, procedures, indexes etc being used along with sample data.

The data inside columns inside the brackets.

The Index Key is the columns, the value is the data inside the columns

No, Ant is the table, the columns are Name, DOB, Salary.

Take a look at the CREATE INDEX syntax.

Indexes are not defined on row, they are defined on columns.

dsachu (2/7/2013)

---

Hi,

Sorry.....actual on the basis of Gail Photo, I assume he is Mr.

----------

I have Table ABC. Where I have one Column Country id on which I have implemented primary key...

The service accounts need access to do the SPN registration unregistrations in AD, if it doesnt then it will have to be a manual registration unregistration.

dsachu (2/7/2013)

---

Hi Mr. Gail Shaw,

Don't mind but i am not getting below sentence.

The key columns (also referred to as the index key) can be likened to the terms listed in...

Check the SSRS error log and try to diagnose why it cant see the assembly.

You need to hack the databases.

DECLARE @OldUserID uniqueidentifier

DECLARE @NewUserID uniqueidentifier

SELECT @OldUserID = UserID FROM dbo.Users WHERE UserName = 'DOMAINA\OldUser'

SELECT @NewUserID = UserID FROM dbo.Users WHERE UserName = 'DOMAINA\NewUser'

UPDATE dbo.Subscriptions SET...

Only the owner of the subscription can change the subscription.

Use the query I supplied to find the owner of the subscription and get them to change it.

Personally my preference is...

Only one way to find out, transfer and run DBCC CHECKDB on the new database.

As your transfering the data, the corruption should disappear as it reallocates the pages, as your...

I take it the ..com is a typo, or is that really your domain extension?

The first one is ok, the second is the FQDN when it just needs to be...

Query sys.dm_db_index_physical_stats in each db, then you can see what needs re-indexing / re-organising.

Filter out heaps and anything with a page count < 1000.

For a script to do the rebuilds,...

You can try to export the data via DTS, but be aware that it may not work.

Otherwise you will need to run DBCC CHECKDB repair_allow_data_loss, and be prepared to lose...

As I said, Jobs in the view which you are looking at are reports which are running.

The only option you have in the jobs folder is to stop a report...