first you are being a bad boy, changing dates to strings and back to dates.

if you simply select your code, instead of assigning it, you will see you are...

SSRS is wierd; that UAC error message is misleading.

there are TWO places you have to add the same group or user:

it should be

select * from [linkytomysql]...[mytable];

you cannot specify database or schema.

can you connect to your local mysql , using the exact same credentials, via mysqladmin?

yes, it would explain it.

Lowell (5/11/2016)

---

calling xp_cmdshell requires sysadmin privileges, and normal end users don't have that. the trigger will fail for normal users

the service account SQL runs on will...

Tava here is what i created, based on a post her eon SCC that i found;

I've enhanced it over time, but i just put this in master and run it...

alexferreira (5/12/2016)

---

I can safely assume only one row is inserted because the application that does the update or insert can only modify one record at a time luckily. I launched...

{edit}

whoops no you cannot, because that is a correlated subquery...it's returning more than one value, joining the inner data and the outer data .

i would move the query to a...

Matthew Saggers-700210 (5/12/2016)

---

This is a pain as it make the compute code massive in my case so I made them UDF like below

A

B

C = A+B

D = SumABX(A,B)

Function SumABX(A,...

kreuzer (5/12/2016)

---

Hi,

for me as a human user, it would be OK to type a captcha to post something.

Or, only confirmed accounts can post something. I think, it should be possible...

rathimittha.mb (5/12/2016)

---

Hi,

Thanks again for the quick response.

I tried with 4 part query. And it keeps throwing an error.

It says 'Invalid use of schema or catalog for OLE DB provider...

there's a few things that can be improved here;

your code is assuming one row from inserted exists, it should be modified to handle multiple rows.

calling xp_cmdshell requires sysadmin privileges,...

if you include the fn now function, there are seven ways i know of to get the current datetime; there's a few threads around that points out that a potential...

Thanks for the script.

couldn't resist.

there is a built in stored procedure from Ms to get the objects in FK hierarchy order.

If you have a circular reference, you can get stuck in a loop(A references...

Once you have the Linked Server in place I have found a few different ways of interacting with the mysql database:

Select Statements:

select * from mysql5...country

select * from OPENQUERY(mysql5, 'select *...