Hi,

try

set @sPool = 'w' + COALESCE(RTRIM(@sPool),'') + 's'

I added the COALESCE to avoid errors if @sPool should be NULL at some point...

regards karl

Hi,

SET @SUMMARY = '%html$%body$%H1$REPORT%/H1$%br$%br$%table$' + '%tr$%td$Phone # %/td$%td$ Hr Called %/td$%td$Call Date %/td$%td$ State %/td$%td$ Zone %/td$%td$ Stop 1 %/td$%td$ Stop Hr %/td$%/tr$'

Then append to that with line...

Hi,

if the possibility exists that some user changes any data during the time you do the reindex you should use

BACKUP LOG MyDB WITH TRUNCATE

because otherwise you might lose that change...

Hi Drew,

since backing up the transaction log should not have a big impact on database performance (if it has you simply need better hardware) you could go as far as...

Hi,

make sure that on the new server each file is in exactly the same path as on the old server, and of course the service pack/hotfix level has to match...

Hi Peter,

following procedure defrags indexes ordered by size desc, fragmentation desc. Stops after a given time, but you can change that to stop after 10 Indexes.

Needs some tables in a...

Hi,

one solution would be to go with the navision sql option...

We have Navision running on SQL Server 2000 with 150 users, the database currently has 50 GB...

regards karl

H,

please have a look at

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=214717

especially the posting of Martin Mojzisek...

regards karl

Hi,

your IT staff should be able to tell you if and when transaction log backups occur. they also should be able to tell you if the transaction log backups are...

Hi,

you might want to use a backup software that uses on-the-fly-compression, like LiteSpeed from Imceda (Quest) or SQL Backup from Red Gate or ...

We are using LiteSpeed here, mainly because...

Hi,

STANDBY or NORECOVERY should work.

Try to put a WAITFOR DELAY '00:05:00' between database restore and first log restore. If that should work you can shorten the delay to the...

Is it logshipping out-of-the-box or did you implement it by yourself?

check the log backup statements for "with not_truncate", if that option is set, you might want to set it to...

Hi,

in the DSN, did you configure "change default database to 'LDF_Consult'"?

regards

karl

Hi,

we've had similar problems on a 4 cpu machine, where cpu load never got over 35 percent, even if the server responded very slowly. we were told that hyperthreading might...

Hi,

this is a script that sends an email if files in a certain directory get older than 10 minutes. You might adapt it for your purposes by storing the filedate...