Nevermind, I just found the solution. I just had to move the databases and restart the services. Everything is fine now and I can see all the subscriptions in SQL...

Nevermind, I added the database name in front of the schema name to solve the problem.

I would suggest try the fully qualifed name in place of just the server name. example: servername.domain_name.com

Well that won't work unless you have enabled the check box. So I would suggest if possible re run the setup again. Just for the heck of doing it.

Have you tried this ?? Do you get any error when running this command?

EXEC sp_configure filestream_access_level, 2

RECONFIGURE

I tried this and it works perfect. What is the exact error you are having? See if this works.

create view vw_temp

as

select convert(date,convert(char(11),[changedate])) as Dateonly from sqlwatch.dbo.SW_ChangedObjects

select * from vw_temp

You have to check the first and second checkbox to be able to check the third one.

Is the first checkbox- Enable FILESTREAM for Transact-SQL access greyed out?

Try this and let me know if you get an error.

SELECT cbasagentroster.Lname, cbasagentroster.CellPh, cbasagentroster.AgentEM, cbasagentroster.offcodeID, officeinfo.offcodeID AS Expr1, officeinfo.office,

officeinfo.officePh

FROM cbasagentroster

left outer join officeinfo

on cbasagentroster.offcodeID=officeinfo.offcodeID

group by cbasagentroster.Lname, cbasagentroster.CellPh, cbasagentroster.AgentEM,...

you should be using left join and not cross join. Left join will give you all the values from Table 1 and only the matching corresponding values from tabe 2.

Thank you for the reply. Here are the details.

1. SQL Server 2008 Enterprise Edition 64 Bit SP1

2. Records are inserted first into the Staging table from the flat file using...

It is finally fixed. Someone had messed up with the public role. View any database was granted but view any definition was denied. Since deny takes precedence over grant all...

This does not do the trick either. There seems to be something else that is not letting these logins to view the database.

Have you checked for the users in the database? Not just the security. Go in that particular database you are trying to give access to that particular user, under security...

I am not sure if the replication would work after restoring the two databases. What I would suggest is to remove the replication. Restore the databases and set up the...