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...

with SSMS, you can script the restore statement it will use. (use the script button after you've filled out everything you need.)

Can you script it to a new query window...

- what kind of error are you getting ??

- can you post the script ?

We always take backups to local disk, the xcopy the bak files to a UNC-resource (safezone).

If you've run out of disk slots to add more disks, you may even consider...