Does any process recreate the view on a regular basis? You can check it by a query like the following:

SELECT NAME, create_date, modify_date

FROM sys.objects

WHERE NAME = '** View Name...

Is the SQL Server 2005 server the exact same server as where you were running SQL Server 2000? In other words, did you do an in-place upgrade or did you...

The port change only takes effect on a SQL Server restart. The value is actually stored in the registry and the SQL Server service only reads it when the service...

If the case is it's not working from any remote host, that pinpoints it as a server problem. Take a look at the KB article cited earlier, it's probably the...

Is the SQL Server on the same server as SMS?

If the users are coming into the database as their Windows accounts, or if they know their SQL Server logins with respect to an application that uses them, the short...

If you're on a cluster, you must first determine which physical node is hosting the virtual node. Then run it on that physical node.

As long as the schema owners are the same, you're in good shape. That's what is actually used to determine cross-database ownership chaining in SQL Server 2005.

I apologize, I was out of pocket for most of the week.

Here's what should work.

- Ensure the database owner for DISA and DISB are the same.

- Activate cross-database ownership chaining...

As asked, have you tested a remote connection form another source other than your desktop? The problem could be either at the server or at your desktop. Testing from another...

Use of sa is strongly cautioned against because it doesn't undergo any security checks. So if you have someone connecting as sa, there's not anything you can do to stop...

Is the security group a local group or a domain group?

Giving it admin rights doesn't fix a bad username or password, so I would recommend against that. I know you probably have already, but re-check the keyed in username as...

When you change the port and then stop and restart SQL Server, bring up a command prompt and run the following command:

netstat -ano

Look to see if you have something listening...

In SQL Server 2000, anyone with sysadmin rights can decrypt an encrypted stored procedure at any time. Depending on the length, someone with db_ddladmin could pull it off, too, with...