Mani-584606 (8/7/2012)

---

Hi,

We have log shipping configured in SQL Server 2008 R2 SP2.

Log shipping copy job is failing and I'm getting the below error most of the times when I'm trying...

saidapurs (8/22/2012)

---

Hi Mistihad,

Replication will happen on 2 major condition.

1. Table should be required a index (Cluster or non-cluster)

2....

Can you please use T-SQL commands to create subscription.

Chandan

As Gail suggested above, the higher is this ratio the better. It simply means that your memory is having sufficient amount of data in the cache which will reduce the...

Walsko (8/22/2012)

---

Hi,

Yes that works, I'm just at a loss to understand why it didn't work using my login baring in mind I have another server on the same domain connecting...

I have seen issues with linked server when I tried to impersonate windows\domain accounts. It is usually related to Kerberos issue where multiple hops are not supported.

I suggest you...

Lynn Pettis (5/24/2012)

---

This is the last LEFT OUTER JOIN from your view:

LEFT OUTER JOIN MOC_DT.dbo.TCN_Xref tcn

ON tcn.recid = (SELECT

MIN(recid)

...

TheSQLGuru (5/24/2012)

---

The left join on the MIN is going to suck in any case, but these are the real killers here I bet:

WHERE DsLocationCode = CAST(term.TerminalID AS VARCHAR)

AND (sup.SupplierCode...

this is an old thread but would like to inform that I could resolve this issue by changing the view to a procedure. Thanks to everyone who pitched in with...

Nothing was redeployed. Just the report. I also added a reply just above yours...

I mentioned that the users do not have to have browser permissions. We have a basic authentication setup on the internet webpage and it should use one common account to...

Thanks for replying. We are using an existing data source. This works for guys with admin access but...

Don't give up yet. I am not able to find a suitable environment for your problem here, but you can keep trying:

http://stackoverflow.com/questions/2899201/microsoft-ace-oledb-12-0-64x-sql-server-and-86x-office

Keep us posted and all the best!...

Deepak.Sharma507 (5/16/2012)

---

Hi Chandan,

Now that I have uninstalled all the components, I installed, I don't see any relevant "provider" when I try to link the excel file.

Even when I installed 32-Bit...

I have used linked server to read the data from excel and found it to be easy. Will that method work for you?

Thanks

Chandan