To get the list of the objects on a Particular file group use the following

SELECT DISTINCT un.name, ung.groupname

FROM sysobjects un INNER JOIN sysindexes si ON un.id=si.id

INNER JOIN...

I wouldn’t delete it, prefer to deny the access

To use both sa and your NT Accounts, configure your server security to "SQL Server and Windows'. Go to EM -> Server Properties -> Security. You need to restart your...

NOPE

Yes you can uncheck the Sysadmin privileges, but they still have DBO rights on the DB, you can’t uncheck either. If you don’t want your NT Admins to access the...

You don't need to pay for MSCS, but if your Cluster is ACTIVE/ACTIVE you need to pay for the License for SQL on both the nodes

Did you enable the Distributor at the publisher?

-- What kind of Complex transformations?

-- Your business rules change the data? And you want to replicate, yes you can.

Use the following SP to compare structure and data in two databases

CREATE PROC sp_CompareDB

@db1 varchar(128),

@db2 varchar(128),

@OnlyStructure bit = 0,

@TabList varchar(8000) = '',

@NumbToShow int = 10,

@NoTimestamp bit = 0,

@VerboseLevel tinyint =...

Please check your Errorlog file on the hard disk. See is there any Error number

Try the Following

1) Create a standard login

2) Use SP_changedbOwner to change owner to the standard login.

3) Check SP_HELPDB

4) Change the owner back to sa.

Use isql /U <Login_ID> /P <Pwd> /i <Query_FileName.qry>

Use sp_changedbowner to change the owner of the DB and see how it shows in the EM.

You can not force a restore over a restoring database. You must use sp_dbremove or sp_detach_db.

I recently started using Shutgui.exe. This shuts down or reboots your system depending on the options you choose. Once the primary node comes up, I reboot the other one with...