Hi Gail,

In SQL Server 2016, if we DENY Connect to login on Primary Replica, the user cannot connect to secondary replicas as well using Listeners.

Did you checked connecting to...

sqlnaive (8/22/2013)

---

Hello SSIS Masters, I'm currently going through the learning phase. I have two questions regarding package deployments:

Q1. What is the ideal mechanism to deploye the packages (and which one...

Hi,

I faced the same issue , on analysing I found that Article setting for "if the object with same name already exists" was to "Truncate table and reload data" ...

Thanks it was really helpful information

You can also try by commenting out the Product key by Adding a ; in front of

;PID= "XXXX-XXXX-XXX..."

The file can be found in setup folder \x64\DefaultSetup.ini

Thanks this Kb really helped , it works for SQL server 2008 clusters as well

🙂

In the source window where you are mentioning the query to populate xls, press the preview button and check what is the format of the decimals is getting displayed there....

Hi

Would like to put it like this , "It takes two to tango", both windows admin and DBA should be responsible for the box as they are both expertise...

Hi

Try out this link it extensively talks about the null problem with SYSNAME datatype , that you might be facing.

http://www.sqlmonster.com/Uwe/Threads/List.aspx/sql-server/5631/SP-helplogin

Regards

Avijeet

Hi Jambu

They are really Great and helpful. I was trying to configure transformable replication in which only one column is name is to be modified but it is throwing DTS...