double check the path to the xp is correct.

Check its path on the "old" server or maybe even restore an old mastedb (to an alternate dbname !) to find out...

One of the flaws in SQL2005 partitioning, is that you need to add the partitioned key to any unique or primary key, if you want that index applying the partitioning...

IMO you'll have to simply order it all

select ProductID ,

min(ProductName) as ProductName,

min(ProductCode) as ProductCode

from #Product

group by ProductID

I'm completely with Fernando on this xp_cmdshell attitude !

It's a registry key !

have a look a this script ...

-- Alter Local Default Backup Directory

-- xp_fixeddrives

Declare @NewDrive nchar(1)

Declare @RootDirectory2Add nvarchar(512)

Declare @NewDirectoryPath nvarchar(512)

Declare @Override char(1)

select @NewDrive = N'F'

,...

did you check sp_helprolemember ?

btw with sql2005 you can use:

select *

from sys.database_permissions

where class_desc = 'schema'

and grantee_principal_id = DATABASE_PRINCIPAL_ID ('Urole_Appl')

no, not using a system stored procedure.

also with...

you've posted in a sql7- sql2000 forum ??

- are you using the correct cluster server ?

double check you opened clusteradmin to the correct cluster configuration (perferably "." (i.e....

Dutch should be no problem for me. It's my mother tongue :hehe:

Any ways, as a dba I'm used to mystic names :w00t: , not telling me what's the actual...

If it uses the index you intended to, and it is returning those columns at that point in the plan, it will have them from the index.

btw With SQL2005 you...

Henk Schreij (11/14/2008)

---

I need an index on a heavily used table with 10,000 + rows for using in a where clause.

Is, in addition to a distinctive column, including a...

Frequency ? That's entirely up to you :w00t:

Most of the time, system databases are small, so what's the space impact of an extra backup.

Backup frequency of the model db ?

Do...

I think you'll get the best grip about it when reading Dr. Codd rules for normalization.

here's an overview: http://www.sqlservercentral.com/articles/Advanced/coddsrules/1208/

If you include the system databases, be sure to put msdb at the end, because it contains all backup info.

We are using a single job for all our databases (daily)...

As always ... if you want order, you must use ORDER BY in the final select clause.

However, at insert time, an order by can have some influence, as stated in...