Jeff,

Hint for restore: select * from sysmessages where...  There are a couple of IDs for Database and log restore: 18267, 18268 and also for file restore 18269

For tracking DDL...

My feeling are too towards Guest account. Lloyd has a point here. As I said, when I removed Select on Sysdatabases from Guest I could see all the same "No...

Noel,

This is so cool! I never think of this possibility because we have Lotus Notes and I have to use SMTP mail anyway and can get only NEt Send...

We had several domain migrations. I was resposible only for SQL Server transition, not for the actual domain transition. The move to Active Directory as compared to just domain transition...

Chris,

In this case check out this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;248749

It is for SQL Server 7, but the error mesage essentially the same. It talks about TCP/IP packets. Just for the try, did...

Chris,

Is it the only thing you wonder?

I have the same thing. What I did now is to remove a check mark on Select for Public in Sysdatabases. Then connected as...

Chris,

I just reproduced this problem. I just denied Select on Sysdatabases in Master for user Guest. I was connected to SQL server as a low-privileged login, I could see all...

Chris,

Did you check only db_owner group for that user? I had to help in several cases when ALL roles in the database were checked for a user, including, well db_denydatareader and...

Jeff,

use whatever language you are more comfortable with. It also depends if you have Exchange on the network and can send SQL emails. If not and if you decede to...

Hello, we discussed it yesterday too.  It looks like 2005 Client tools do not show dates correctly  There was somewhat similar problem. See discussion topic on this Administration forum 

corrupt...

I needed to monitor services over the weekend once and I used Win32_Service object to get status of the services using WMI inside VBscript. You can use sort of Where...

Hello,

Did you try MSDB database Backupfile table? It contains a record for each file that is backed up. I backed up my test database 2 times and there are 4...

Hello,

Path not found to what? To Master Database? Please, let us know when do you get this message. You may also check the Event log with all messages, but in...

Adam,

thanks. Maybe I should.

Yelena

I am glad that you feel much better now. I really don't want to interfer with your cheerful mood. I just want to mention that when I used 2005 Enterprise...