Another question Brandie, if you don't mind...

The script above, is that no different than providing access through creating a Login user with mapping to a specific database, then selecting the...

I think I found out what happened.

It looks like the user was scripted without a default schema as:

USE [database]

GO

CREATE USER [dbuser] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]

GO

This is off the base...

Hey Brandie,

This is a relatively new user that didn't go through any SQL updates/upgrades. The user is not an orphaned user. The person who put this user in there doesn't...

Where do I input the table reference (TASKS) as the FROM is a SELECT statement?

Thanks again everyone for helping me in my nubness. People like you guys make support forums...

Hi Everyone thanks for the replies.

For the first 2, I'm not using static dates as per your queries.

Scott, your query is just casting values for actual field values....

The step is being run as the SQL Service Agent account which previous steps in the same job utilize without any problems. I confirmed permissions from the root on.

Steve

I have confirmed the directories are referenced the same in the batch file AND the dumpdevice. This is a local drive that is fully accessible by the SQL Agent Service...

D:\MSSQL.1\MSSQL\Backup\dailyprocessLog.bak

1 File(s) copied

The system cannot find the path specified.

My apologies Gail, there wasn't much in there either, hence why I didn't post it originally.

(Edit): Nevermind, my copy didn't work...

That resolution was chalked up to be a network issue. Credentials are as they are on the DRP server and it works fine on that side. I have confirmed all...

Thanks for your reply Steven. I am getting the error below.

Msg 8117, Level 16, State 1, Line 1

Operand data type varchar is invalid for avg operator.

I would have...

We were testing a DRP location, by where the software data went from a flat file data to SQL. I want to fail the software and the DB back to...

Sorry, no, I am not using a witness server in this instance.

Ok just a bit of digging and it looks like the failover is the way to go:

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

My question at this point is, how does this affect any services...

I figured I'd fail-over if I wanted services to continue to run on the Principle server, but can you confirm that is the case when using 'Fail-over'? I'm not sure...

Can you also confirm that you left the other Client Protocols enabled?