The first thing I ask when dealing with problems on maintenance plans in 2005 is which Service pack is installed. There have been a couple of bugs and most of...

Usually if you can't expand a database in SSMS it's because the database is not online. Check the status of the database either through sys.databases or DATABESPROPERTYEX.

Depending on the state...

ahutchens (5/8/2008)

---

A user is getting this error when trying to execute a stored procedure that truncates Table_X:

"Table_X does not exist or you do not have permissions."

I've verified that the user...

Trigger actions are limted to the local server.

Replace you're ddl trigger with an event notification. You can then send message to anther server using service broker.

Gail

there is a webcast aboutthis, at least I hope it's still available.

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032275439&EventCategory=5&culture=en-US&CountryCode=US

in your original post you worte it works on the server but not on the client.

So now I wonder where is your Excel sheet located ? On the server or...

The DDL_DATABASE_EVENTS have a database scope, so this won't work. Unfortunately for you only CREATE_DATABASE is...

Just saw your edit of the original post and now I'm sure. In the RTM version it was called Object Explorer details and either Sp1 or 2 changed it to...

Not sure if this is the case for you, but I seem to remember that there have been some changes to the summary page through the different service packs. Did...

You could try to use a DDL trigger. I have never tried it but it should be possible.

As said before, if you need both databases available replication is the only option.

Merge replication is only necessary if you want to make changes on both databases, otherwise I...

Oops, I should have read it more slowly.

Actually you're if you look at your code 65536 and add the 512 for Offline the result is 66048.

The value in sysdatabases...

These are the official statuscodes from the SQL2000 documentation

Status bits, some of which can be set by the user with sp_dboption (read only, dbo use only, single user, and so...

The number of jobhistory records which are kept in the masb is limited. If I remember right the default is 1000 rows. It looks like your every10min job creates so...

With SP2 for SQL 2005 MS introduced LOGON Triggers.

See

http://msdn.microsoft.com/en-us/library/bb326598.aspx

or

http://www.sqlservercentral.com/articles/SQLServerCentral.com/sqlserver2005logontriggers/2366/