hi there:

You can use the followings script, fist script will give you list of permissions on tables/views; second one will list permissions for the Stored procedures

/*List permissions on tables*/

--

--delete the 'work'...

Hi Derek:

I have also had a similar experience with application port conflicts on a multi-instance SQL Server.

The fix for this problem is by isolating the ports that are needed by...

to resolve the issue of orphan users, refer to this link

http://www.sqlservercentral.com/columnists/glarsen/orphan_user.asp

To migrate users to a new server:

http://www.sqlservercentral.com/columnists/glarsen/migratingloginstoanotherserver.asp

There is an article on Microsoft site on this topic

EMPLOY_REFvarchar

SURNAMEvarchar

FORENAMEvarchar

ADDRESS1varchar

ADDRESS2varchar

APPOINTEDdatetime

A_NUMsmallint

A_LEVELSvarchar

AID_REVIEWdatetime

BIRTHDATEdatetime

BANK_ACCvarchar

BANK_NAMEvarchar

BS_ROLL_NOvarchar

CONT_SERVdatetime

COUNTYvarchar

COSTCENTREvarchar

CONTRACTbit

CONTR_ENDdatetime

DATE_LEFTdatetime

DATE_LASTDAYdatetime

DEPARTMENTvarchar

DEG_CLASSvarchar

DEG_SUBJvarchar

DEG_CLASS2varchar

DEG_SUBJ2varchar

DRIVEvarchar

DIVISIONvarchar

ENTRY_BYvarchar

ETHNIC_ORGvarchar

EYE_TESTdatetime

EMP_TYPEvarchar

EMP_AGREED_DATEdatetime

EMPLER_NTCEdecimal

EMPLE_NOT_MNbit

EMPLR_NOT_MNbit

EXIT_IVbit

E_MAIL_IDvarchar

EXT_EMAILvarchar

FAXvarchar

FIRSTAIDERbit

F_EDUCATvarchar

GENDERvarchar

GRADEvarchar

GRADE_DATEdatetime

HEALTH_CHECKdatetime

INITIALSvarchar

JOB_REFvarchar

KNOWN_ASvarchar

LEAVERvarchar

LOCATIONvarchar

MAIDENNAMEvarchar

MGR_REFvarchar

MANAGERvarchar

MOBILEvarchar

NATIONALITYvarchar

NOTICEvarchar

NOTESvarchar

NI_NUMBERvarchar

NIGHT_WORKERbit

NOISYENVbit

O_NUMsmallint

O_LEVELSvarchar

OTHERNAMESvarchar

PAYROLL_NOvarchar

POSTCODEvarchar

PHONEvarchar

PROF_QUALStext

PROBATIONsmallint

PROB_ENDdatetime

REASONLEFTvarchar

RETIREDATEdatetime

RW_PAYNUMvarchar

SAFETY_REVIEWdatetime

SAFETY_OFFbit

SORT_CODEvarchar

STARTDATEdatetime

STATUSvarchar

TEL_EXTvarchar

TITLEvarchar

TOWNvarchar

TOTAL_HOLSdecimal

UPDATED_ONdatetime

VDU_USERbit

WK_EXPDATEdatetime

WK_PERMITbit

WTD_OUTbit

PWORDvarchar

RE_EMPLOYbit

CONTR_TYPEvarchar

DISABLEDbit

DISABLED_TYPEvarchar

DISABLED_NOTEStext

COMPANY_REFvarchar

COMPANY_NAMEvarchar

COUNTRYvarchar

EXTERNAL_DELEGATEbit

PHONE2varchar

FAX2varchar

HOLIDAY_TYPEvarchar

FRAMEWORK_REFvarchar

SYS_CREATED_BYvarchar

SYS_CREATED_ONdatetime

SYS_EDITED_BYvarchar

SYS_EDITED_ONdatetime

DEDUCTIONmoney

DEDUCTION_BASEdecimal

EX_RATEdecimal

CUR_LOCALvarchar

CUR_BASEvarchar

LEAVER_NOTEStext

POSTAL_CORRESPONDENCEvarchar

POSTAL_ADDRESS1varchar

POSTAL_ADDRESS2varchar

POSTAL_TOWNvarchar

POSTAL_COUNTYvarchar

POSTAL_COUNTRYvarchar

POSTAL_POSTCODEvarchar

POSTAL_TELNOvarchar

POSTAL_FAXvarchar

POSTAL_MOBILEvarchar

POSTAL_EMAILvarchar

HOME_WORKERbit

CRB_CHECKdatetime

CRB_CHECK_TYPEvarchar

CRB_CHECK_RESULTvarchar

MARITAL_STATUS_IDint

DATE_DECEASEDdatetime

EMP_AGREED_DATAbit

SIGN_ONvarchar

MANAGER_NAMEvarchar

DEPT_DESCvarchar

INSITE_CODEvarchar

IA_SALARYmoney

FIRE_MARSHALLbit

FIRE_MARSHALL_RETRAINdatetime

TEAMvarchar

WORK_FLOORvarchar

SWITCHBOARDvarchar

EMP_WRITTEN_ACCP_DATEdatetime

HOLIDAYS_LEFTdecimal

DAYS_DEDUCTdecimal

COMPANY_LOANSmoney

PAY_LIEU_NOTICEmoney

PAY_LIEU_NOTICE_TAXmoney

PENSION_DEDUCTmoney

LEAVE_SICKNESSbit

DEDUCTION_DESCvarchar

LEAVE_EMAILbit

EMP_STATEvarchar

CON_SUPPLIERvarchar

CON_PROJECTvarchar

CON_PROJECTIDvarchar

CON_PONUMBERvarchar

CON_DAILYRATEvarchar

uphotovarchar

photoimage

USR_NTLoginvarchar

PAYROLLvarchar

PAYMETHODvarchar

BANKACC_DATEdatetime

TO_SOURCE_STARTDATEdatetime

SDS_IDint

OLDSDS_IDint

SAL_MGR_REFvarchar

SALARY_MANAGERbit

Index info:

FORENAMEnonclustered located on PRIMARYFORENAME

IDX_FULLNAMEnonclustered located on PRIMARYEMPLOY_REF, SURNAME, FORENAME

IDX_JOBREFnonclustered located on PRIMARYJOB_REF

PK_EMPLOYEEclustered, unique, primary key located on PRIMARYEMPLOY_REF

SURNAMEnonclustered located on PRIMARYSURNAME

Ah.sorry I dont know that one....but if u need i can share a script that we use to monitor jobs...

HTH,

Gurbaksh

Hi Michel:

Which product of NETIQ is this query about; is this query about SQL diagnostic manager from IDERA

Regards,

Gurbaksh

Thanks Sree this worked for me.. 🙂

STEP I:

Open Query analyzer for the source server and run the following command:

BACKUP DATABASE aaa

TO DISK='F:\MSSQL\backups\aaa_migrate.bak'

STEP II:

Move the *.bak file to server yyyy

Migrate all your logins to yyyy

STEP III:

Open Query...