How often do you log ship?

Depending on your db size and table size you should reindex in small chunks.

You can also set log shipping to execute every 5 mins during...

Did you experience errors in this KB

Those views are in SP1 but i would suggest to upgrade to SP3.

RELEASE NOTES:

Installing SQL Server 2005 SP3 on a Failover Cluster Instance

http://www.google.com/url?sa=t&source=web&ct=res&cd=1&ved=0CAwQFjAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F5%2F7%2F1%2F5718A94A-3931-457B-8567-AA0995E34870%2FReleaseNotesSQL2005SP3.htm&rct=j&q=sql+server+2005+installing+sp3+on+cluster&ei=c5XYSoTLJtWtlAebhNmhAQ&usg=AFQjCNF0WtNLoI8JwDS5Zr921IxzAFy2OA&sig2=tfd1ujgza8BF0TXH5PX1fw

How to apply sp3 to a clustered MS...

krypto69 (10/14/2009)

---

No expierence with encryption

my boss asked me to :

Could you provide me with any screen shots that demonstrate encryption for the transit of data from our DB’s?

How...

Try this:

BULK INSERT OrdersBulk

FROM 'c:\file1.txt'

WITH

(

FIRSTROW = 2,

MAXERRORS = 0,

FIELDTERMINATOR = ',',

ROWTERMINATOR = '',

ERRORFILE = 'c:\file1_error.txt'

)

-- ================================================

-- Template generated from Template...

brown9071 (10/6/2009)

---

I have a linked Server form SQL Server 2005 to an Oracle Database connection.

I understand well the security configuration of the linked server, in that you can control access...

balbirsinghsodhi (10/7/2009)

---

Getting following error while using following switch command.

------

ALTER TABLE

Transac_Archive_Stage

SWITCH TO

Transac_Archive PARTITION 6

GO

Msg 4972, Level 16,...

You should download this whitepaper and read it.

it's got a lot of pictures which will help you greatly.

It shows you step by step on how to install and configure the...

I'm sure it was a delay in SMTP server.

turn off antivirus or antispyware.

you have to create a linked server and use fully qualified table names in your trigger.

This is from another forum. I used this many times in the past to capture last executed time of stored procedures. It uses the syscacheobjects table.

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

Ok, we came up with...

yes you can as long as that user has appropriate rights for those tables that the sp is modifying.

Here you go.

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/3021/