Hi

try

USE yourdb

--get securables permissions assigned

SELECT

CONVERT(NVARCHAR(10), state_desc) COLLATE Latin1_General_CI_AS + ' ' +

CONVERT(NVARCHAR(10), permission_name) COLLATE Latin1_General_CI_AS +

' ON [' + sch.name + '].[' + obj.name + '] TO...

Hi check the sys.backup_devices table for these and get the physical filenames.

to add to Lowell's entry, you can also launch the account provisioning immediately after installing the SQL Server service pack (click the check box before clicking finish)

slightly confusing, so is the question about size or throughput?

Truncate will also reset seed values where delete won't

The document will differ based on your host set up. You should be following the section that installs the SQL Server 2008 failover cluster.

Raju The Leader (5/24/2010)

---

RESTORE DATABASE UK

FROM DISK = '\\SQLSERVER\Backup\Newfull.bak'

WITH REPLACE,

MOVE 'LIST_New' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\UK.mdf',

MOVE 'LIST_Log' TO

'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\UK_log.mdf'

WHEN I AM EXECUTING THIS COMMAND I AM GETTING...

the only way to upgrade your sql 2000 system databases to sql 2005 is to carry out in place upgrade on the instance.

If you want a side by side...

your welcome

your welcome!

No

you may also want to check my tutorial for installing SQL Server 2008 in a clustered configuration at this

link, it may help quite...

saimonkhan15 (5/21/2010)

---

In SQL 2000, you cannot give anyone else permission to truncate your table.

I have always thought this was a bit strange, since truncate is so much

faster. You can grant...

Alex Webber (5/21/2010)

---

Thank Perry. I have read that. But it still doesn't explain why 2 x backups are required, if anything that article insinuates that 1 backup should be enough!...

before removing any files check their contents. Can you post the results of the following queries?

USE yourdb

select name from sys.filegroups

USE yourdb

select a.name as 'Index name', b.name as 'Filegroup',

c.name as 'Table...

check this link for more info

the following info is relevant

A log backup is required to move the head of the log forward (full or bulk-logged recovery models only).

Note:

Log backups...