Search results for query: *

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...

The thing is, even if I had a business key, it's not useful because I am concerned about changes in fields that are not part of the business key. That is, the business key might be the same but another field is different. The only way to get around this would be to include all the fields in the...

I need some help thinking this out... I have a staging table that gets loaded with data from a file using ssis. The file is a rolling history file, in that every day's current file not only contains that day's data, but also data for the previous days in the month. So for example, if today is...

Hi, I have a table that has some rows with duplicate data. I want to find the duplicate data, based on 5 columns. That is, some of the rows have the same values in these 5 columns. How can I write this query? Thanks

I think the short answer to this is, rebuilding non clustered indexes won't order the heap, but it can defrag the index itself.

Hello, I am trying to solve a disagreement with a coworker. Does running DBCC REINDEX on a heap table have any effect? My position is no, it does not. A run of DBCC SHOWCONTIG before and after shows that the statistics do NOT change whatsoever. However, his position is that by running DBCC...