not sure on the space saving thing....is it that important to try and downsize the db?

for the second part, if adding a column affects the application, i think you'd...

ok forget the do it yourself thing: download this free program:

SQLRecon[/url]

it will scan your entire network in a LOT of differnet ways, and find all installations, including multiple instances ont...

I would do this outside of SQL with either a sqlcmd , cmd script or an application. personally doing it in vb.NET is easiest for me, your milage...

niter can you show us the current query you are using? we can probably infer a lot from that, but the CREATE VIEW definition would help as well;

the requrement looks...

Twinsoft is right...if you import the diagrams into a database that does not have the exact same object_id's, it fails with the same error...

not sending externally is definitely a relaying issue, that was my point....it's not really a SQL issue anymore if you know you've already added everything for basic authentication. get with...

Terry this is a pretty common situation, and the issue has to do with relaying and your exchange server / mail server.

mail servers are set up to avoid spam. as...

lets cover the basics, Andre, since this is your first post:

a VIEW is a saved SQL statement...so if you have other views in the test database, you will need to...

Way to go Sean; eventually it'll be featured in an upcoming newsletter and get a lot of exposure.

You put a lot of effort into putting it together, along with...

the brackets INSIDE the quotes means you are looking for the brackets also...that's not what you want.

try this instead:

update address_table

set addr_line_1 = replace(addr_line_1, char(9), ',')

where CHARINDEX(char(9),addr_line_1 ) > 0 --if...

"resetting" their permissions is not a big deal...fairly easyactually, but it's seems iuntimidating if you have not done it before.

say you need a role where they can read/write and also...

Wiki has a good explanation of the format:

http://en.wikipedia.org/wiki/Quicken_Interchange_Format

Well looking at the format of the QIF file, it's not difficult, but it's not easy either.

I've done it the other way...using a utility that converts QIF to comma delimited,and...

you could use the OPENROWSET command to run the proc and insert its resulting data into a table on the fly.

then you can drag the table into a typed dataset...

whodunnit info is contained in the Default Trace, which keeps only a brief history of all DDL changes(CREATE/ALTER/DROP...not SELECT UPDATE DELETE, which is DML statements.

only a limited amount of data...