nope, this DoubleTake software is suppose to replicate in real time.

I would like you to build me a toaster, how would you do that?

http://www.ihispano.com/job/employer/2063140/view/detail/results/teksystems/kansas-city/missouri?=Indeed_Sponsored&utm_source=Indeed&utm_medium=cpc&utm_campaign=Indeed

Ninja's_RGR'us (3/21/2011)

---

Jason Messersmith (3/21/2011)

---

I'm just curious if anyone had updates on their rates? I basically got told that $50 per hour was way too high for someone with 4...

I'm just curious if anyone had updates on their rates? I basically got told that $50 per hour was way too high for someone with 4 years DBA, 6...

nevermind, i loaded up profiler and found out that there was spaces missing after the WITH statement, i guess an enter isnt sufficient. go figure.

try searching for '%&q=%'

Why dont you just do a query for WHERE Column is null or do you have hundreds of columns in your DB?

how many databases are you mirroring?

file > print ?

Your best bet is making an application or SSIS package to do this. Then use xp_cmdshell or SQL agent to call on that application or package.

I would take a look at SQL Profiler.

DECLARE @serviceaccount varchar(100)

EXECUTE master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE',

N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',

N'ObjectName',

@ServiceAccount OUTPUT,

N'no_output'

SELECT @Serviceaccount

select * from sys.configurations

Are you looking for the account running the SQL and SQL Agent Service?

I think you can shrink the primary database and it will shrink the other database.