You can download a free administration tool from MySQL. It's a GUI interface, and then you can go to backup & restore options without having to use the command line....

How about image data ?

What if columns are retained, but values are set to NULL ??

Will SQL reuse that space for other data needs ? Or is it only...

Could you be more specific about what you want to accomplish ?

RPSql (10/14/2008)

---

We are having One group in active directory: If suppose group name is GroupA

In that group we are having three users...UserA...UserB...and UserC.

Now, we are giving read and write permission...

True .... you can get a pretty...

I don't know why the "disable" doesn't work ... I don't have a test account to try.

Maybe someone more knowledgeable can answer ?

What do you mean by unexpected...

You could disable the login, or remove permission to the specific database(s) so they can still access other databases.

I had something similar once. Turned out that the user's logins were disabled on one server somehow. Never did figure out the cause, but we were having odd server problems...

I don't quite understand. You want to allow the Windows groups to connect, but restrict them from certain adminstrative functions ? Can you give some examples ?

When you get to the new login screen, click "search" button. Then you get the "Select user or group" window. You need to click "Object types". And then select "Groups"....

For transactional replication, it does not purge the older data. You need to either re-snapshot, or create your own purge procedure. Be careful not o purge anything more recent than...

The_SQL_DBA (10/10/2008)

---

We use spotlight, never had any issues with it. I suggest you request a demo for spotlight at http://www.quest.com.The licensing and all issues can be asked for with the...

I just recently found this:

[font="Courier New"]IF OBJECT_ID('JobActivityMonitor','P') IS NOT NULL

DROP PROCEDURE [JobActivityMonitor]

GO

/*******************************************************************************************************

**Name:dbo.JobActivityMonitor

**Desc:Job Activity Monitor (SQL2005)

**Auth:Adam Bean (SQLSlayer.com) [original interval logic from William McEvoy - http://cookingwithsql.com/source/sp_ShowJobSchedules.sql%5D

**Date:09.05.2008

*******************************************************************************

**Change History

*******************************************************************************

**Date:Author:Description:

**-------------------------------------------------------

**

********************************************************************************************************/

CREATE...

Replication would be a pain. Any time new tables were added to the database, you'd have to remember to add them to replication.