I would handle failover situations differently than keeping data in sync across dev/qa/acceptance.

You should look at failover clustering or log shipping for this.

But as far as getting production data over...

I guess to me the question would be why?

Is it worth the time and money to create something to keep data in "sync".

Is it static data the application needs? or...

You can generate csv or xls from Sql Server DTS

Lots of info and tutorials on sqldts.com

Hey Mark,

Check the owner that the maintenance jobs are running under.

This message usually indicates that the owner of the job is either Invalid, pasword has expired, or user is...

Have you checked available disk space on the drive that tempdb is stored on?

Seems like there is no space.

tempdb does not need to be backed up.

Not exactly sure what you mean by Score., But have you looked at functions Soundex, and Difference?

They return a value based off comparison, but not a score per say.

I have not worked with...

Just grasping at straws, but perhaps you could extend notification services to do something like this?

What value?

The value of the last record inserted, the first, are you including a where clause?

Similar to Mkeast suggestion

If i wanted the last record inserted.

CREATE PROCEDURE sp_web_getPKIDFromNamedValue

(

  @Table varchar(50),

  @FieldName...

what exactly are you asking?

what do you mean by value?

you want the stored procedure to return to you the name of the column(s) that is the primary key for the...

Create a number table with numbers 1 thru whatever

then perform a left join

Select *

From MyTable

right Join numbers on mytable.pk = number

where mytable.pk is null

  and number < (select max(mytable.pk)...

I would not recommend you do it the way you are trying, You Should not create a looping structure. Plus you should always create your triggers to accept datasets, you...

look at the datepart function.

datepart(hh,mydate)

will give you an integer of the hour.

no, since the column is already variable, increasing the variable size should be instantaneous, if it was a fixed char, and increasing the char length, it would take foreeeevvvvveeeerrrrr. Do...

No thats basically it.

If you find yourself using that alot, you can certainly create a user defined function. and call it, instead of typing the convert statement a bunch of...

No, That way is bad, you have repeating groups, What if all of a sudden a driver has a 6th car, you have to add another colum to the table,...