Have you tried running the linked server query from SSMS both as yourself and with the EXECUTE AS USER = ? It could be a permissions issue with the other...

The easiest method is to use the Import Data wizard. Right-click on the database, select Tasks, and the Import Data. There is an option under Mappings to delete existing rows....

Once a particular task is repeatable, documentable, and doesn't involve much decision making, it can and should be moved lower down on the food chain. Because if it isn't, management...

You could use an SSIS package, as described here:

http://www.sqlservercentral.com/blogs/sqlstudies/2012/10/31/looping-through-multiple-servers-in-ssis/

Here is a link of how to add monitoring after the fact:

http://www.mssqltips.com/sqlservertip/2799/steps-to-add-log-shipping-monitor-into-an-existing-sql-server/

This is something that a DBA might actually be called on to debug.

If you have a real requirement to fail back to the primary server as quickly as possible, then perhaps you should use mirroring instead of log shipping. And I understand...

The agent will never start on Express Edition. Unfortuantely, the status in Configuration Manager is misleading. Look at this link for more details:

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.100).aspx

When you copied the file from the G to H drive, the data was likely going back and forth on the same physical connection, hence the 3x slower result. Are...

This also makes no sense for relational purity. A foreign key is really an attribute of a different entity, so it shouldn't have a different prefix on the other end...

Start with the CPU utilization for the SQL Servers. Go back over a 30 day period, and take note of daily processing cycles. Check month and year-end requirements. My experience...

Obviously, they won't tell the recruiter about someone's personal issues. But it with a little bit on persistence, it might be possible to determine if the person left because of...

If you got the interview thru a recruiter, they might be able to tell you why 'the company is anxious to get this position filled ASAP', or why it's been...

You can have up to 25 clustered instances with 2005/8, due to drive letter limitations. 2012 supports SMB file shares, so the full 50 are possible.

http://technet.microsoft.com/en-us/library/ms143432(v=sql.105).aspx

But having...

I would ask about the top handful of items the hot line or on-call person fields on a typical day. If they are as evasive on that one as with...