The code itself inside the function produces the correct results. It seems like the RETURN from the function is where the issue is. If I have 3 results only the...

Functions are identical at the subscriptions. I have deleted them and recreated them using the create as and copied from the publisher to the subscribers.

That is a manual copy and build. Data sources and passwords alone will be a pain. I'm thinking about building out SQL server 2012 doing a migration and then upgrading...

Thanks, this looks like something that will work for us.

It is required by the app and yes I have pushed back but gotten nowhere. Even if they weren't I would still have an access issue. Looking at the firewall...

Thanks everyone for all the input.

Looks like ISCSI isn't getting the link to the DB drive set fast enough. Some other research recommends setting a delay on the SQL Server...

Thanks, network admin was looking into how to set a dependency on ISCSI for SQL server.

Sorry bout that.

Date,Source,Severity,Message

03/15/2013 13:00:10,Backup,Unknown,Log was backed up. Database: Prolaw<c/> creation date(time): 2012/10/26(19:21:51)<c/> first LSN: 66562:5011:1<c/> last LSN: 66688:41:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'R:\Transaction_logs\Prolaw_backup_2013_03_15_130000_7710445.trn'}). This is...

My network guy is thinking it might be that sql server is starting befor ISCSI gets its job done.

Here is my entire error log since the reboot this morning.

Date,Source,Severity,Message

03/15/2013 07:56:46,,Warning,[396]...

No errors and the same informational messages on my servers that don't have this problem.

I have 3 servers with DBs replicating and they are all configured the same but only this one server has the problem. Shouldn't be the server or its configuration. I...

state_descis_auto_close_on

ONLINE 0

Nothing but the standard informational startup messages. No errors or warnings.

Service agreement says we can't modify. Thanks for the reply. That is kind of what I though but it's nice to get a second opinion.

That helps with part of my problem. I have a third party application hosted in house. We have read only to the DB period. I need to pull data and...