Stop services rename the drive, name the new volume to the orig drive, restart services.

John Zacharkan

Hi sqlinsite,

I can sympathise with you to a degree, but in a company as small as yours, (so it seems) if you don't have a UAT, SAT, Test, or a...

Steve did you still need this?

John Zacharkan

Definitely a solution, and I have thought of it. I was looking to replicate what is done with SQL-Mail. Somehow it captures a select anything, multi record set without having...

Here's a copy of the sp that generates the result set

 



Create procedure test_for_job_failure   

as

set nocount on



declare @num_days int

declare @first_day datetime

,@last_day datetime

declare...

It uses extended sprocs, here's an example of the code

DECLARE @EMAIL_ID INT

DECLARE @EMAIL_FROM_1 [varchar](128)

DECLARE @EMAIL_TO_2 [varchar](256)

DECLARE  @EMAIL_SUBJECT_5 [varchar](200)

DECLARE @EMAIL_BODY_6  [varchar] (1500)

DECLARE @EMAIL_CC_3 [varchar](256)...

Found the answer, coming from an untrusted domain is the problem.

Even though I register my Server with a SQL server user login my EM still uses NT authetication to...

Server 1 DB pubs is logshipped to server 2 db pub.

Seperately, Server 1 db pubs replicates to server 2 db pubreadonly.

Double the storage requirement but get the most out...

Server 1 DB pubs is logshipped to server 2 db pub.

Seperately, Server 1 db pubs replicates to server 2 db pubreadonly.

Double the storage requirement but get the most out...

Yep, that is correct.

If you need to a have a database for your users to do reporting against setup to the same server that your log shipping to. This...

Hopefully, this should be last post on the topic. As promised for what it's worth here's the official written word from Microsoft

Hi John,

As agreed yesterday , I am providing...

Ok, everyone ready for the big answer from Microsoft?

The problem appears to be within the log reader com object and network connectivity. The problem was only reproducible at Microsoft...

yes

quote:

---

Both are set to mixed mode, right?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring