the app probably recognizes the TEXT or IMAGE datatypes.

I've got applications that *think* they are storing in an TEXT column or an IMAGE data field , but i had converted...

here's a VB.Net snippet I wrote and tested for a different post on the same subject;

with a few tweaks realted to the connection and table to select from, this...

where's the link to Gails articles about catch all queries?

( -- Get Non-Peer Categories without regard to Assignments

(esc.statusname != 'PEER' And @FilterAssigned = 0)

OR -- Get Non-Peer Categories Assigned to...

amazing how smart i feel when i discover something i knew nothing about previously!

Like others have noted, this looks like a very useful tool!

Thanks!

Cadavre pretty much what i was thinking, unless she doesn't have access to 2005+, which means no varchar(max) or CTE's...it's all textpointers and stuff if she's locked into 2000, not...

Nancy you posted in a SQL 200 forum, so I'm assuming a lot here; i'm guessing the data is chopped up into VARCHAR(8000) columns, instead of being stored in an...

go to tools options...

i'm guessing the default settings on your specific connection do not have the same settings as mine, for example:

in some other dbmail related threads, there was a lot of examples/issues where even though dbmail was set up correctly, the service broker itself was not performing it's duties.

as a...

not sure if it's applicable, as I'm not sure of the specific error you were getting, but you have a logging table dbo.changelog;;

your trigger could potentially fail if the...

Yes, The example I provided is probably more oriented to developers who need a proof of concept, and the ability to test.

You wouldn't use GMail in a corporate environment, youd...

definitely Gmail is possible, and very handy for forum examples here too!

here's a screenshot of my working Gmail settings for database mail to use as a model:

I've been haunting this place a while, and i never tripped...

I have an amazingly similar HTML report for all objects in a given database.

here's a link to teh sql file, it's kind of long, but creates similar output;

it's based off...

yes, but only with 2008 and above, and i'm not sure if this is an enterprise edition only option. partitioning is certainly Enterrise only, but i think compression is part...

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:http://www.sqlservercentral.com/Forums/Topic1214220-392-1.aspx