newbieuser (5/16/2016)

---

Hi friends,

We would need to create tables in Oracle via Linked Server in SQL Server.. I tried select * into from table, I get the below error..

...

there's a DMV with that info:

select s.virtual_machine_type,

s.virtual_machine_type_desc

FROM sys.dm_os_sys_info s

a row_number() in a view might be a solution, since he wants a repeating value.

i think i would just a dd a calculated column that does the checksum; that would...

it's not the server, it's your individual connection that is the issue.

something related to Remote desktop must be setting your regional settings, which in turn affects your specific session setting

run...

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,...