The ones that are not seeing the Server role are pre-SP2. In SP2 SMO was upgraded to be able to see the Server Roles.

Can you provide a more detailed example of what you are doing and what happens?

Check the versions of the different SSMS images (under Help..About..).

Here is how to drop and rebuild the key/indexes making the secondary key the clustered index:

/* To prevent any potential data loss issues, you should review this script in detail...

You can leave the Primary Key the same, but you definitely have to change the Clustered index.

It all depends on whether you think that there is any chance that that column will need to store Unicode characters that are not covered by Varchar().

This is exactly what I usually do. Here is an example:

Declare @sql NVarchar(max)

Set @sql =...

You guys are right, my bad: WITH (INDEX..) is Ok for Updates.

NDF is the conventional file type extension name for secondary data files. Thus LDF's are the log data filse, MDF's are the primary data files and NDF's are the...

Like this:

Select IssueId, UserID, MAX(CreatedDate)

From #tab1

Group By IssueId, UserID

These are Table Variables, not temporary tables. They are similar but different in some important ways. For instance, table variables are batch-scoped, which means that they go away...

Agreed.

vijinarav (12/1/2008)

---

we are testing the server performance like both disk's read-write performance while using sql server with the load, so to get differrent load (throughput) all we need to change...

I think that the word you want is "bifurcate". Even with the corrected spelling, most people are going to have to Google it to figure out what you mean....

Not so far as I know.