i fixed myself the new machines did not have the

c:\users\temp directory

got to love microsoft

it should have said will this work

i have commented in dynamic sql all the time

😉

SQLRNNR (1/19/2012)

---

Trey Staker (7/22/2010)

---

I used to work with a DBA who was a pretty good lock pick. We had a server down on a saturday and neither of us...

Error Occurred Calling Object: ODSOLE Extended Procedure sp_OADestroy usage: ObjPointerToBeDestroyed int IN.

copying the exact info from the last post

word application

spellcheck

http://www.sqlservercentral.com/articles/Editorial/77292/

didnt phil factor say PS is going bye to

i saw that earlier too

but everytime i run it i get

on all 3 calls

ODsole extended procedure error

thanks i found that:-P

but i dont see how to make the connection (everything i have tried gives me error :unsure:

EXEC @hr= sp_OACreate 'Microsoft.SqlServer.Management.Smo', objServer OUT

or

Microsoft.SqlServer.Management.Smo.Server

o

'Microsoft.SqlServer.Smo'

or

'SQLSMO.SQLServer'

not sure there is a best practice

I personally have servers from sql2000 to sql2008r2

I tend to remote into them to use the tools on the servers

to make sure that...

also there is an overhead with merge replication

if there are a large number of updates going both ways you will probably notice a performance hit

also make sure none of the tables uses identiy columns

as you will have to program around these

you could start with this

sp_configure 'remote query timeout (s)'

that is how my backups work, I have each sqlserver backing up to 1 fileserver and the logs going to another fileserver. The tape then reads from those 2...

usually when it is red either the copy or the restore jobs have had a problem.

usually you can tell which one by which report column is behind

look at the job...

you said you ran the profiler

since it runs everyday it is probably a sql job or external job hitting the database, run the t_sql tuning option or t sql...

not sure why you would want too

if the log isnt growing that big set it to 15 minutes

If you think is going to get that big set it 5 minutes