SELECT [name] FROM sysobjects

WHERE uid = USER_ID('User_to_be_dropped')

This will give you a list of objects owned by that user.  You will then have to decide whether to drop...

Magic!  Ron, you're a genius.  I ran process mon and I noticed that I had an invalid path for sqlagent.out.  I changed that in the registry and it worked.  Thanks...

Thanks for the tip, Ron.  I'll try that and let you know how I get on.

John

Frances

Without an explanation of how the actual result set differs from the anticipated one, never mind any DDL or sample data, it's difficult to help you.  However, I don't think...

Paul

What login does SQL Server Agent use to connect to the database?  Does it have permission to execute DBCC SHRINKFILE?

John

That's helpful, but it's not a perfect analogy.  The very fact that you have to go to the page to get the data means that it isn't a covering index for the...

Davor

I can't think of any way of doing that server-side.  You'd need to configure your application to do that.

John

Anders

That'll probably be it, then.  A quick fumble in Books Online and I found this: "Scalar-valued functions must be invoked by using at least the two-part name of the function". ...

Davor

If you change the default schema of the calling user to dbo then you shouldn't need to qualify the name of the function.  Bear in mind that if the user...

One more thing in favour of separate instances is collation.  Although you can have different collations for each database (indeed you can specify collation down to the column level), if...

Carl

I'm not sure about using -c -m.  I've only tried it with -f.  See if that works for you.

John

Yes, or back up msdb2 and restore as msdb.  This has the advantage of avoiding stopping SQL Server (I think you can restore msdb without starting SQL Server with special...

Carl

The mssqlsystemresource database has to be moved to the same location as master, but it doesn't automatically get moved with it.  Start the server with the parameters /f /T3608, then...

Jan

Yes, but only the data in the indexed columns.  Going back to my example, if you wanted SELECT d, e, f FROM MyTable WHERE a = 10, the index would...

Jan

A covering index is a covering index with respect to a particular query.  So if your table contains columns a, b, c, d and f, and you have a non-clustered index...