I think this is what you are trying to do. This is what I use in a SQL job, the first step takes a full backup and appends a date...

Alex,

Doesn't look as though you got a response to this, have you started using DPM yet? I was also recently asked to evaluate DPM2010. I'm finding it difficult to...

My dad always told me... "There are never any stupid questions!" 😉

You are a genius!! That was it. After I read your question I googled it and found that he needed to add the instance name because by BCP looks for...

Hi Roy!

We took a look at the remote query timeout and it’s set to 600 seconds which is the default on both servers, not sure if this is...

Thanks for the reply Jeff!!

Yes, I can get a dir listing from both servers - they are able to see the network file server where we are writing the...

Jeff, I can install Adventure works on my test server. Thanks for your help!

Ok, so how do you propose I build test/dev? The developers need data. Are you suggesting I generate all fake data? Their argument is that the users need to be...

Yes, I'm trying to scramble the prod data in the test/dev environment. Is this the wrong way to go about this?

SQL 2005 by default has the built-in Administrators login. Have you tried to log in using the administrator acct?

How about running the repair option on client tools? Will they...

When you go to admin tools under services - is the agent showing up there? If so, is it started? What account is it running under...those are some of the...

In SQL 2005 Express you can not see jobs. Could that have been installed by accident?

Apparently the permissions, because of a restriction on the folders when created where not trickling down. I have it working now!

It sounds like there are a lot of people on here that are anti-smart phone…but for me it’s the greatest thing ever invented. I know someone else mentioned while their...

Thanks! That works perfectly! I really appreciate it.