Check the firewall settings and verify SQL Server is able to allow connection.

Refer following article:

http://www.sqlservercentral.com/articles/FCI/92196/

Nowhere in the question it is mention that login 'king_login' is part of sysadmin fixed server role?

Neither in the script login 'king_login' had been added to the fixed server...

Grant Fritchey (3/28/2014)

Sorry? What?

Do you mean set up an extended event session to capture sql batches and rpc calls? That's a good idea. I'm...

Check the option of Extended event.

You can also use:

select * from sys.columns where max_length = -1

/*Where -1 = Column data type is varchar(max), nvarchar(max), varbinary(max), or xml. */

Pl. refer following blog which might help you:

http://www.sqlservercentral.com/Forums/Topic1554747-2799-1.aspx

Can you check design on the other subscriber? Do you find FK on ther 10 subscriber too?

Bit tricky question. Overlooked word "hardened".

Now if the correct answer is "Login is not created" than second correct answer "If the login is created the password policy will be...

Yes, I missed extended events. Thank you Grant.

Pl. refer following article for further detail:

http://www.sqlservercentral.com/articles/FCI/92196/

HTH

Me too agree with Steve, Brent and everyone on this.

But DBA should keep in mind that this is not the place for falling and riseing approach. I do agree...

Refer the following link for detail:

http://technet.microsoft.com/en-us/library/cc708332(v=ws.10).aspx

HTH

Refer following link:

http://stackoverflow.com/questions/2077807/sql-query-to-return-differences-between-two-tables

HTH

Again are you going to insert data to that table?

howmuch rows and size?

Do you need the space badly?

What if you do not shrink?