sorry Boss, the same error come again

I m using SQL 2K8 R2 64 bit-version.

IF EXISTS(SELECT 1 FROM sys.objects where name='NewTable' and type='U')

begin

DROP TABLE NewTable

end

GO

select *

into NewTable from tbl_contract_emp_master...

error

Msg 2705, Level 16, State 3, Line 1

Column names in each table must be unique. Column name 'STATUS' in table 'NewTable' is specified more than once.

1.

[TBL_IRIS_IMAGES_MASTER]

[GUID] [varchar](50) NOT NULL,

[LEFT_IMAGE]...

problem resolved after enable file sharing port number 445,

now database has been synchronized mode between two servers.

I have configured High performance mode for DR setup..

Thanks for reply..

what could be bigger issues if using NT Authority/Network Service account in SQL server service? Pl. suggestion me

Mr. Perry, I have one question?

1. Principal server

SQL service account running under NT authority/Networkservice

2. Mirror server

SQL service account running domain account..

can we configure database mirroring on different service account,...

Great, I got reply from script author Mr. Ola Hallengren.

I have configured index rebuild on weekly basis at 3 AM..in production server,

I have checked at 9 AM there is...

opc.three (9/27/2012)

---

Have a look at Ola Hallengren's Database Backup script. It does what you're wanting and if setup in a SQL Agent job you can send an email if the...

Thank you for your reply...

Total server memory 8 GB, I have set it max memory 6GB but SQL side using 5.79 GB, so it seems ok in sql side. But...

ok, I had developed SSRS reporting services in development setup for monitoring sql server database like backup overdue, failed jobs etc.. it is working fine local instance databases.

How to connect...

Pl. provide, any open source webpage script is available?

Should I run extented event script at production database? is there any restriction?

thanks

ok, thanks for reply... I learned today about traceflag no use, if using exented events in SQL 2008.

Pl. confirm...

Does Background process LOCK MONITOR to handle the deadlock and detect automatically...

Execute the following script in Query Editor to move the tempdb files into a new location:

-- Moving tempdb to a new location

-- Checkout current location and logical names...

Do you have separate physical disks or just logical drives on the same disk set or SAN attached LUNs, etc?

if just different logical drive on the same disk set,...

Ceating many subplan instead of configure any one of the HA method between primary & secondary server.