Recent content by equus2

So, do you think that doing a backup and restore of the msdb db across servers is the best method for keeping the disaster recovery server in sync (jobs, pkgs, etc) Thanks

Thanks

Hi, Once I started thinking about this, I realized I don't really know how to do this. Basically, we have a disaster recovery server that will be kept up-to-date via a 3rd party log-shipping tool. But what about non-user database objects, such as 1.) jobs 2.) operators 3.) linked servers...

hmm anyways, found workaround with osql

Like: Name Rows Reserved Data Indexsize Unused ABC 100 1K 1K 1K 1K I'm bcp-ing this to a file, there's no column headers. I'm trying to add the column headers to my output so they'll show up on the file. The "select" stmts work fine on their own. Don't like the...

SELECT 'Name', 'Rows', 'Reserved', 'Data', 'IndexSize', 'Unused' UNION SELECT Name, Rows, Reserved, Data, IndexSize, Unused FROM ##TableSpaceUsed ORDER BY CAST(Rows AS INT) Error: Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'Rows'. TRYING TO OUTPUT COLUMN NAME + RESULT SET...

Hi, SQL Server 2000 I need a way to email a formatted result set from a Select statement. What is the best/simplest way to to this? SSIS? Thanks

Hi, Besides the fact that log shipping is available with Standard edition w/ 2005, are there any other significant advantages of 2005 log shipping vs 2000 log shipping? Not having used either, I am interested to know other's opinions. Thanks much

I found a solution. I created a "controller job" that calls a stored proc that contains the logic for when to start the "dynamic job". Of course, the job isn't dynamic. The code in the stored proc is "dynamic"... which uses WAITFOR and sp_start_job to start the job based on the logic I want...

Hi, I need a way to change the run time of a job that normally runs at 4:45 am each day. The catch is, I only want to change the run time on 2 days of the month (which will be dynamically determined each month); so it's not like I know the days before hand. Help, is there a good way to do...

thanks i found some clues on google using row_number functionality

I'm sorry I meant 25gb

Hi, I need to query that can calculate the date of the 3rd Friday of every month. Any ideas? Thanks much

About 25MG I think, it is a .bak file

Hi, I am looking for alternative ways to copy and restore a database backup from SF to NY. I tried using robocopy to copy the backup, but it was very very slow and would have taken about 16 hours to complete. That doesn't work. I am asking for people's input and suggestion for how to best...