Viewing 15 posts - 6,301 through 6,315 (of 13,469 total)
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...
December 2, 2011 at 10:12 am
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...
December 1, 2011 at 2:51 pm
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...
December 1, 2011 at 2:28 pm
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!
December 1, 2011 at 11:34 am
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...
December 1, 2011 at 9:54 am
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...
December 1, 2011 at 9:44 am
go to tools options...
i'm guessing the default settings on your specific connection do not have the same settings as mine, for example:

December 1, 2011 at 8:40 am
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...
December 1, 2011 at 7:48 am
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...
December 1, 2011 at 5:48 am
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...
December 1, 2011 at 5:28 am
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:

November 30, 2011 at 7:51 pm
MyDoggieJessie (11/30/2011)
Lowell, I have no doubt that the origination of the SQL I posted was derived from this website 🙂
I've been haunting this place a while, and i never tripped...
November 30, 2011 at 2:39 pm
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...
November 30, 2011 at 2:08 pm
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...
November 30, 2011 at 1:59 pm
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
November 30, 2011 at 1:56 pm
Viewing 15 posts - 6,301 through 6,315 (of 13,469 total)