SQLWB.EXE = SQL Work Bench, otherwise knows as SQL Server Managment Studio; that's the executable you are using to look at and connect to SQL server, running the sqlserver.exe process.

Grant Fritchey (4/22/2010)

---

I had to know for sure, so I just validated it. I started a trace with no stop time, shut down the server, restarted the server, the trace...

jameswhitby (4/22/2010)

---

Lowell,

By doing that I get the following error message:

Msg 7313, Level 16, State 1, Line 1

An invalid schema or catalog was specified for the provider "Ifxoledbc" for linked server...

james it's probably just the dbname.schemaname then;

you said you were running this commnad:

select * from LIVE.live_db.informix.thistable

try

select * from LIVE...thistable instead; that lets the linked server infer the dbname and...

when you concatenate, you cannot alias the CASE statement...right at the end of your case you have this:

end as type||','||

also you have a logic hole: null concated with anything...

yes you can Eric; i did the same thing making a SSMS clone in .NET, for me it was just for fun, but you learn all the pieces you need.

What...

it took me 3 searches for the definition till i found Pointy Haired Boss, which i should have realized right away...

i have a bunch...

well, I've never had to restart the default trace or a c2 trace; i could be wrong, but that's...

am i reading this wrong?

i thought a server side trace starts when you run the command EXEC sp_trace_setstatus @traceid, 1, and runs continuously. rebooting or stopping/starting the server...

solid advice so far; I agree with everyone above that encryption should be selective to specific items.

think it through a little though:

Is it not true that if EVERY field is...

try this command first:

EXEC sp_tables_ex LinkedServerName

that should give you a list of the tables the login you are using can view/has access to;

if the linked server has access to more...

well, you can't get TRUNCATE to activate a trigger on a table;from BOL:

TRUNCATE TABLE cannot activate a trigger because the operation does not log ... the db_owner and db_ddladmin fixed...

in 2005 and above, syscomments is a view, and no matter the override setting, cannot be updated.

please test any advice you make before posting it...it can mislead floks who don't...

just use the ISNULL function to convert the null, i would think should work just fine:

SELECT

C.LOCATION_NAME,

SUM(ISNULL(A.SALE_AMOUNT,0.00)) AS SALE_AMOUNT

FROM SALES A,

LEFT OUTER JOIN ACCOUNT...

you'll need to paste the exact code you are using; encrypting part of a string, then concatenating the decrypted results is easy, so it's probably something fairly basic that is...