I found this recently:

if powershell is installed on the server, you can use that to add yourself (your domain login) as a sysadmin;

this example does the same thing by...

a trigger featuring a linked server was what i was suggesting to avoid; network problems or permissions issues related to which remote user is used to insert into the remote...

i spent a bit of time on this same thing before, and it really depends on the results you are looking for, and how deep you want to make them...

Tobar (3/26/2013)

---

I see that part, but the error I was getting, which I should have mentioned in the beginning, was

"Error converting data type nvarchar to numeric". And I don't think...

take a look at the syntax for an oracle trigger here:

there's an example there, and you can see how fields are referenced with the :columnname indicator

see if that helps you...

right, but if you try SELECT convert(decimal(3,1),'333.14')

you get a conversion error;

that's what i'm thinking is the issue; other daata than the examples you posted are outside of the data...

i don't think that's correct;

you should be able to add just...

Minnu this looks a lot like homework, and we hate to do folks work on their behalf, because they don't learn the concepts they need later;

Oracle triggers are different than...

there must be more to the story;

this works without an issue at all:

With MyCTE (val)

AS

(

SELECT '.7' UNION ALL

SELECT '2' UNION ALL

SELECT '1.3'

)

SELECT *,convert(decimal(3,1),val) FROM MyCTE

could...

i have some old examples in my snippets, but this just goes back to the same comments all other posters have made:

bad idea. the posters so far on here all...

ok you are doing a server side trace, so you are good to go;

when i read commandline, i had assumed a call to profiler.exe with some parameters to a...

abitguru (3/25/2013)

---

Thanks Lynn!!!

Several post later I explain what I'm try to do. 😛

I understand what you say about bottleneck, but I have no option (in my knowleage :-P). Because...

you can use some index stats to find those kinds of totals since the last time the service was stopped and started;

it's not kept aywhere else unless you start capturing...

timotech (3/25/2013)

---

Hi All,

Please i need an answer to this question. I have two servers, one locally and one hosted, i normally upload data to the online one using data export...

other possibility?

SELECT T2.KWMENG,

T1.NETWR,

T1.NTGEW,

T1.MATNR,

...