We already use double take to replicate other files we need replicated besides SQL files. Since we already use it, I had no interest in visiting thier site.

Perfect - that looks like exactly what I need. Thanks for pointing me in the right direction.

Thanks, but my main problem is trying to get perfmon to run every day for a specific time frame. I can only schedule a start and a stop time for...

It may not be the best method, and probably isn't, but it has worked for me in the past - I'm sure there is a better way - this does...

Thanks, I'll try using 2005

I think I have tracked it down to an internal problem. Looking at the code for sp_helprotects, I found that there are columns in sysprotects that don't have a corresponding...

you could also try using bcp utility as well.

I save all my frequently run queries as tql and put them in my templates folder. then they all show up in object browser. I'm still on 2k, but I...

Thanks, why I did not find that on my own is beyond me, right in front of my face. Anyway, thanks a bunch for the help! that's exactly what I...

I take a different approach here

create proc myproc @param1 varchar(1) = null,@param2 varchar(1) = null

as

SELECT* from mytable WHERE mycol = CASE WHEN param1 is null THEN mycol ELSE @param1 END AND...

we are on 2000, but we are planning on going to 2005, and I know they have much better support for XML anyway, plus the try / catch functionality. I...

Sure, this is where it errors out, and i'd like to be able to catch the error, but when it errors, it doesn't even make it to the error handler

SET...

Well, that will get this thing going anyway, you would think there would be a way to trap the error and continue execution, but I guess my only option is...

Well, this is what I am doing here, and it halts execution, and prints out error:

SET @sql = '

   insert into master.dbo.db_size(svr_name,dbname,db_size,stat_time) SELECT ''' + @srvName + ''' AS SVR_Name,

       '''...

you could link tables in access to sql tables and do the same thing you would normally do in access. there is no front end native to sql, so you...