I've never seen this behavior.  In fact, I can't imagine how it could even happen.  Are you absolutely sure the backup was taken *after* the missing objects were defined?

> I'm very confused!!!

> I have implemented snapshot replication.

Well, that explains that!    Sorry, couldn't resist.  (Don't mind me -- I'm a replication-hating Luddite!)

I'd have...

I've had a similar problem.  The initial install failed, and I was told that the most sure solution was to slick the machine and start over.

MSDE is free, and worth every...

If the directory is on your network, do you need FTP?  Unless I misunderstand, you could just use the NT-shell 'COPY' command and reference the target folder as a share.

Who...

It should pretty much all be there.  The 'sysjobsteps.command' column is defined as an NVARCHAR (3200), meaning it will hold 1600 characters.  I've never tried creating a job step that...

Try going to 'msdb' and running:

SELECT j.name job_name

     , s.step_id

     , s.step_name

     , s.command

FROM   sysjobs     j

  JOIN sysjobsteps s ON j.job_id = s.job_id

ORDER BY j.name

Have you tried scripting them out, using Enterprise Manager?

You can join to a different server via "linked server", but performance will hover toward the bottom of the toilet.  If it's feasible, especially if you're running repeated queries against...

I've seen studies on this, and if memory serves, I don't think it makes enough of a difference even to worry about.  I usually just select what I need, but...

This depends on how many attributes they share.  Most of us, I think, tend to think of a table as modeling a "thing" in the real world.  We might, for...

Try this:  Create another job step (CMD EXEC) after the output file has been created, which strips the first x number of lines out of the output file, making you...

You needn't be concerned with the fact that you stored it as 2.07 and EM is showing it to you as 2.070000.  The database itself is storing that value in...

Either approach ought to work.  The "best" one is the one that gives you the best trade-off between performance and easy-to-read code.  IF or CASE logic is fine if it...

Assuming that the text file has row delimiters, you can BCP it into a table from a T-SQL procedure, invoking it through 'master..xp_cmdshell'.  Something like:

  IF OBJECT_ID ('tempdb..tempfile')...

Turn it off when you want it off with:  SET TRANSACTION ISOLATION LEVEL READ COMMITTED

Its effect stays on until you tell it otherwise.

If you want to lock only individual tables,...