Try the following syntax -

ALTER TABLE dbo.test1

ALTER COLUMN test VARCHAR(255) COLLATE German_Phonebook_CI_AS NULL

Note: There sould not be any dependent objects for the column......if exists, you need to drop them and...

By default trace, do you mean that by default a trace runs for the SQL events always? What are the events that are logged in it?

Where is it saved(default location)?...

Points worth noting -

For Backup/Restore

1> As the databases are on the same server, the necessity for moving data is not there. But, in future, if you plan to move the...

Try by setting the isolation level to serializable......

this might be due to changes in how locks work in SQL 2005.........there is an accountable change in the same.....

You can also view the data collating the column to the required one as follows -

select test collate German_Phonebook_CI_AS

from dbo.test1

Note: Check your relevant collation from the SQL Server collation list

I merely gave it as a support for my opinion that for a different order of data, SQL Server needs to store it in the order specified by the index...

I am sorry to say this, but the project pans are the properties of the respective companies.....releasing them will lead to breach of contract and is against professional ethics.

Please don't...

Well, to support my opinion about storage and clustered index, try out the following....

create a view with schema binding......then try to create a non-clustered index on it......

Remove.....delete.....re-create......simple....

else, check your where clause for the delete statement.....

and you can never truncate a table with imposed constraints on it....you have to have to remove the constraints for that.....

I accept that this aspect was unknown to me, that a table need not have a Clustered index to have a NC index...thanks for that....but does this change my basic...

Now drop the index and create the following index on the table -

CREATE NONCLUSTERED INDEX [TEST1]

ON [dbo].[test1]

(

[test] ASC

)

INCLUDE ([id])

WITH (PAD_INDEX = OFF,

STATISTICS_NORECOMPUTE = OFF,

SORT_IN_TEMPDB =...

Ok GilaMonster.....I am giving an example....can you please tell me why this happens?

CREATE TABLE [dbo].[test1](

[id] [int] IDENTITY(1,1) NOT NULL,

[test] [varchar](255) NULL

)

INSERT INTO test1([test])

VALUES('1')

INSERT INTO test1([test])

VALUES('11')

CREATE NONCLUSTERED INDEX [TEST1]

ON [dbo].[test1]

(

[test]...

if you really want to drop the table, you can script the drop by right click on the table in Management Studio (SSMS)......

But it seems you have complicated things and...

I am devising a way to help you out in looping, as I know the tidious job in doing recursive work for a volume as big as 100 servers.....

As of...

what is the initial size and auto growth values for your database?

and are you sure that ur fill factors are 100%? This is true for the master database...check the differences....