If you copy a file, and the copy fails, you still have the file. If you do a move in Windows, you potentially could lose the file or cause corruption....

I have awarded back all points to date for this.

I have also reworded the question to note that one batch is needed.

I have corrected the typo and rewritten the question a bit. I've awarded back points as well

Don't believe that I deleted that thread, or at least don't remember that.

I have corrected the typo and rewritten the question a bit. I've awarded back points as well

It is a struggle to balance this. I think that setting aside some quiet time is the solution for most people. Many of the interruptions and questions, help desk tickets,...

If you call the stored procedure, you do it like this

exec [dbo].[p_Stationary_test1] @MyDate, @MySource

Where you've declared the date and character variables as the appropriate types and assigned values.

I have been doing backups with SSMS, or scheduling them with SSMS for years, and haven't had issues with bugs.

There is no reason to stop the SQL Server service or...

Enterprise and above. Most of those articles were written before Data Center edition was available and haven't been updated to state that.

Editions usually follow a hierarchy, so Data Center includes...

It sounds like a client tools issue on the server. Either some .DLL didn't register or got corrupted. You could try to uninstall the client tools and reinstall them, but...

phegedusich (7/25/2011)

---

From meeting-free Fridays, to don't-bug-me blocks of time, we've attempted a number of ways to schedule that pristine, get-the-work-done time.

The real issue is the corporate culture. Co-workers expect...

Number three is in editing now. We hope to publish this soon.

Are you having problem on your workstation or the server? Meaning, where is SSMS running?

Have you tried opening the plan from another workstation?

Has the plan been opened by BIDS by...

I would recommend you follow Gail's advice, and also that you switch to more intelligent rebuilding, but if you are running out of space on the disks, you need to...

Replication isn't designed for high availability. To reverse it, you need to stop replicating data from the old publisher, and re-set up replication in the other direction.

As mentioned above, you...