Lowell (4/15/2011)

---

it depends on what you mean by viewable;

see this forum post on examples of how to

RE: How to retrieve Image file from a SQL Table

Sean Lange provided a...

it depends on what you mean by viewable;

see this forum post on examples of how to

RE: How to retrieve Image file from a SQL Table

Sean Lange provided a fine...

i have a DML trace running all the time, which is recreated by a startup proc whenever the server restarts.

i then also create a view which points to the trace,...

<-- i saw what you did there lol

via TSQL, no; you end up having to create and call something external

Whether an application which connects via POP3 and downloads messages and their attachments, it's going to happen external...

I'd have to assume that just like Windows, if the font that was selected does not exist, it defaults to some other font; I'd expect taht that might be the...

if an application explicitly codes the "Workstation Id = " section to a connection string, then you can blank or or spoof the values you might expect:

here's a connection...

you can use the EXECUTE AT feature of a linked server to create a table, then use an insert with 4 part nameingo convention to put local data in the...

I just tested this for proof of concept;

the idea here is to loop through all records in a table via a datareader and write each binary object to disk; in...

TSQL is the wrong tool for this; TSQL's really designed for set based information, and passing it as recordsets/datatables to an application layer.

TSQL's not designed to be writing to...

not sure what you mean by that... a data source is just a data source.

maybe you mean the other...

On SQL Server the order of your joins doesn't matter, because query engine will reorganize JOIN order depending on statistics for indexes and other things.

To prove it to yourself, what...

one thing you could grab a free cityname/state/zipcode database off the web(42K rows or so) and join it to your data on city/state/zip and see what doesn't match based...

just having a login gives you read rights to some master tables and the ability to create #tmp tables; that's perfectly normal.

you do not even need to be a user...

I'm just like you...i used to have a Dell , upgraded to an HP win7 64 bit with an I5 processor & 4Gigs , and have had tons of hardware...