Ask the person to secure the user permissions before refreshing the database and reapply the permissions once it is done. Any DBA should be aware of how to do that...

Well, It's not an error. It is an Informational Message which will appear during the server startup, not at the time when you are testing your Linked Server.

Try this....open...

Should be in Error logs whether SPN has been registered successfully or not. SQL Server will attempt to register SPN each time it starts and records the status in error...

'NT AUTHORITY\ANONYMOUS LOGON' -- Sounds like SPN issue. Did you checked SPN registrations on both the Instances?

With "CONNECT ANY DATABASE" we can basically let users to have visibility to all the databases but not the underlying data inside the databases. As Gail mentioned, there is no...

Total of 4. Place them on the same Drive.

SQL Server Express Edition can participate as a Subscriber in replication topology, not as a publisher. If you are taking about both Publisher and subscriber running on Express edition, am...

Just Curious...Why the App team wants Database Server host name and IP to be changed?

You can't delete or eliminate particular database file during restore operation.Once the database has been restored to your destination, you can empty the extra 2nd log file and then remove...

SQLSentry can do that.

np...So after changing it back to FULL, have you shceduled T-Log backups?

Make sure you have got regular T-Log Backups scheduled for any database which is in "FULL" recovery model. If...

What does log_reuse_wait_desc say?

Can you run the below stmnt and see what it says?

SELECT log_reuse_wait_Desc FROM sys.databases

WHERE name = 'Your_DB_name'

michael.minarzick 97083 (7/1/2014)

---

Thank you for the suggestion on the Cost Threshold for Parallelism setting. I'm going to change the value and see how the system performs.

There's no doubt that...

See this...

http://www.sqlservercentral.com/Forums/Topic941321-391-1.aspx

Hope this helps.

If you are still getting the same error message when dropping the login, Did you checked who the Database Owner is as Gail suggested?