First question : Why ?

- don't trust the network people ....that is not an argument

- they don't have a clue about sqlsever and the consequences of the sqlserver related actions...

I use this script to generate the restore log sequence(s).

(and the header time indication may help to determine which full backup to start from )

start with setting the current database to another state !

e.g.

Alter database set single_user with rollback immediate

-- don't put GO overhere or you may lose your db connection !! (so...

Gift Peddie (3/16/2009)

---

hmm... your db-engine can still be 64-bit and take advantage of all that comes with it !

Maybe the db-level might be kept to 80 (sql2000) for a little...

Actually you would need to do the same as if you would handle files on "regular" disks.

That goes for :

- raid

- allocation size

- number of files

...

Whenever we move physical files,...

Gift Peddie (3/16/2009)

---

That is not correct what is generally needed is if you have a very old application like those using .NET 1.1 you need to run the database in...

I would suggest to contact SQLCAT (ms sqlserver customer advisory team) !

They may have more experience with that kind of volume(s) and may be in close contact with the sharepoint...

Did you try to handle it this way ?

ALTER PROCEDURE [EDMS].[sp_DeleteArea]

@PageID int,

...

peace2007 (3/14/2009)

---

here's the stored procedure that most of the times cause time out. on the previous messages u said that some clustered indexes should be defined on related tables. I'd...

Can you try to provide a valid password for the sqluser sa

IMO, even if sql auth is not actively in use for the instance, the upgrade will validate...

I did write a little article "adventures with service broker" stating my first experiences with SSB.

http://www.sqlservercentral.com/articles/Service+Broker/2897/

IMO Klaus Aschenbrenners book is still one of the best !

(Pro SQL Server 2005 Service...

chicagonj (3/12/2009)

---

Ok...looking under Management, Current Activity, Locks/Process ID

Out of the hundreds of entries, there are entries labeled as 'Blocked By XX' When i click on those, I'm getting 3...

This proc (in master db please) shows blocking activity

-- ALZDBA install sp_DBA_WhoBlocks.sql

-----------------------------------

USE [master]

GO

/****** Object: StoredProcedure [dbo].[sp_DBA_WhoBlocks] ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_DBA_WhoBlocks]') AND...

Keep in mind you cannot drop objects that are actually in use !

I didn't test resend features for dbmail.

I don't think this feature is supported, unless you actually recompose the mail and issue another sp_send_dbmail