You may need to add a login to the linked server

sp_addlinkedsrvlogin [ @rmtsrvname = ] 'rmtsrvname'

[ , [ @useself = ] 'useself' ]

...

Thanks for the article we have a test cluster to do this on shortly so we can try it out.

Do you get any results from the contents of the backup file try the following to verify the backup:-

restore FILELISTONLY from disk =

'D:\Microsoft...

Several times in my career I have been able to prove my cost benefit to an employer either by cost savings or increased sales both times I was inadequately rewarded,...

Right click on SQL Agent select properties and then Alert System ensure Enable Mail Profile is checked and there are the correct values in the Mail system and Mail profile...

I'm not sure if this is happening with you but the following article http://blog.sqlrx.com/wp-content/forwarded-records-article.doc may give you some insight on some hidden performance killers when working with heap tables.

If you want to filter the result set SET @ Filter = 'Whatever you want to filter by'

DECLARE @filter VARCHAR(100), @LogDate DATETIME

SET @LogDate = getdate()

SET NOCOUNT ON

set transaction...

I believe this is possible using Reporting services scripting see http://msdn.microsoft.com/en-us/library/aa179659(SQL.80).aspx , this needs a bit of work to set up but I think this should avoid the need to...

Are you taking transaction log backups? These are what will start reducing the log file size, it will not reclaim the space though.

I think being able to initiate a good 2 way conversation with an interviewer is key, they get an understanding of how you work and you get a heads up...

See http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/d5d3e5fc-d8ce-4f42-b7ea-9bbbb7756a20

It's 3pm on a Friday, your production OLTP environment is down, every hour down costs the company one million dollars. People are phoning constantly, folks are rushing the hallways, running...

How about the one I got told when I asked if they had any models of the database...

"You don't understand we don't know what the users want when we start...

The favourite here is "Its much better than what we had before" .....

My usual reply that still doesn't mean it's any good.

Or at somewhere else I worked "It failed...

Can you show a screen print of the Conditional Split Transformation Editor for us to see what you are actually using to split the data?