DesNorton

Works for me.

Thank You so much!

Regards!

Grant,

I guess you are right

Thank You All

Grant,

Thank you for reply, but Basic availability groups are only supported for Standard Edition servers.

There are no IDENTITY columns.

Rowes to be deleted From Trip_Log :1.2 Billion

Trip_Log Clustered index size:150 GB

Trip_Log is stand alone table,no FK

Rowes to be deleted From Trip:30Million

Trip Clustered index size:15 GB

Trip...

As i mentioned above,we are 24/7 operations.

By deleting (in batches) old data will not cause any downtime. There are over 1 million daily  inserts/updates just in these 2 tables( out...

Uploading  failed.

Here is my script

CREATE TABLE [TRIP](

[Trip_Id] [int] NOT NULL,

[Trip_Date] [datetime] NOT NULL,

CONSTRAINT [PK_TRIP] PRIMARY KEY NONCLUSTERED ([Trip_Id] ASC) ON [PRIMARY]

) ON [PRIMARY]

go

CREATE TABLE [TRIP_LOG](

[Log_ID] [int] NOT NULL,

[Log_Time] [datetime] NOT...

Here are the steps and screenshots:

Server #1

USE master

GO

CREATE LOGIN [MyLogin]

WITH PASSWORD = '######',

DEFAULT_DATABASE = MyDB,

CHECK_POLICY = OFF,

CHECK_EXPIRATION = OFF ;

USE [MyDB]

GO

CREATE USER [MyLogin] FOR LOGIN [MyLogin]

GO

USE [MyDB]

GO

ALTER ROLE [db_datareader] ADD...

FYI

I run same query on different server where mylogin can connect to MyDB and got same results:

First SELECT  sa

Second SELECT no results

Second Select did not return anything

Hi Steve.

Thank you for your time and effort.

I run your query and it returned

Database  Name Database Owner              Name Owner Name

master         ...

Let me rephrase  my problem and make it very simple.

I have Login/user (myLogin) which can connect to myDB. myLogin can read/write... on myDB.Also myLogin is owner of master database. If...

I executed exec sp_change_users_login 'Auto_Fix','NewLogin' on user database.

And then i checked on NewLogin properties on Security section of Login as well as at database security/users/membership .

If i grant NewLogin  'master'...

And as i mentioned ,

I was able to create NewLogin on different server

Confirmed that NewLogin has read/write permissions by going to NewLogin->Properties->User Mapping

I scripted one of the 'good' login.

CREATE LOGIN [Login1] WITH PASSWORD=N'****',

DEFAULT_DATABASE=[master],

DEFAULT_LANGUAGE=[us_english],

CHECK_EXPIRATION=OFF,

CHECK_POLICY=OFF

GO

Changed login name and pwd

CREATE LOGIN [NewLogin] WITH PASSWORD=N'********',

DEFAULT_DATABASE=[master],

DEFAULT_LANGUAGE=[us_english],

CHECK_EXPIRATION=OFF,

CHECK_POLICY=OFF

GO

Mapped NewLogin with database user