July 19, 2009

To get table and column which are using particular data type

select object_name(c.id),c.name
from sys.objects o,
sys.syscolumns c,
sys.types t
where o.object_id=c.id
and c.xtype=t.system_type_id
and t.name='varbinary'
and o.type='U'

1 comment:

Anonymous said...

Can anyone recommend the top performing Network Management tool for a small IT service company like mine? Does anyone use Kaseya.com or GFI.com? How do they compare to these guys I found recently: [url=http://www.n-able.com] N-able N-central system monitoring
[/url] ? What is your best take in cost vs performance among those three? I need a good advice please... Thanks in advance!