Hi,

that is certainly possible, at least if you use custom logshipping.

The linking of the servers may be needed for starting jobs or executing procedures, and that (as far as...

Yes, it works with sql2k. I did nothing special regarding VB, simply dropped the script into an job step in EM, selected ActiveX-Script and marked VB as script language.

The script is...

perhaps something along the lines of:

(rough draft, not tested)

 create Table #backs ( ID INT IDENTITY, baks sysname NULL)

 DECLARE @back sysname, @i int, @cmd varchar(4000)

 SELECT @back =...

Hi,

also you have to verify that the mail server is prepared to accept mail from your sql server. Most mail servers nowadays have pretty tight security regarding relaying. does the email have...

If we are talking text data and you want to display the result in multiple lines you might add a char(10)+char(13) to each result, and concatenate everything into one big string.

In a web...

Hi Wayne,

the following vb-script will script out all Jobs:

------------------------------ snip ---------------------------------

Option Explicit

Dim conServer

Dim fso

Dim iFile

Dim oJB

Dim strJob

Dim strFilename, strServer

Const ioModeAppend = 8

strServer = "SQL-Server1"

Set conServer = CreateObject("SQLDMO.SQLServer")

conServer.LoginSecure = True

conServer.Connect strServer

strFilename...

Hi,

you could try if

SELECT T.col1, T.col1

FROM MYTABLE T

WHERE COALESCE(T.col1+T.col2, T.col1, T.col2, '') Like '%SearchText%'

is marginally faster (if T.col1+T.col2 remains less then 8165? Byte)...

regards

karl

Hi,

the main difference for me is that you can do a

insert #temp exec xxx

but not a

insert @temp exec xxx

regards

karl

Next time the problem occurs you could try not to run the procedure in QA but run "exec sp_recompile procedure". Then run the procedure from Delphi at least two times....

Hi,

to clarify: you are truncating the log by using "backup log with truncate_only", or are you using "backup log ..."?

truncate_only should only be used if you've got trouble and can't...

Hi,

looks to me like there is a problem with the relation between sql-cluster group and physical drives.

is each physical disc a member of only one cluster group?

had a case once...

part of my logshipping procedures is a full backup with a restore on the standby server - one of my main reasons for logshipping is the implicit verification of my...

Hi,

may be a dump question, but hopefully you do full backups of serverA regularly?

regards

karl  

Hi,

this is what i use (db management is my db for managerial things).

The procedure sp_start_audit_logins is startet by a job at 00:00 each day:

CREATE PROCEDURE sp_start_audit_logins AS

declare @dumpfile nvarchar(128)  --...

Hi,

if you do the restore with standby instead of with norecovery you can get the current LSN:

  select  top 0 * into #dblog1 from  ::fn_dblog( default, default ) 

  insert  #dblog1 exec (' use sitesql...