Can I remove the relationship or find all objects that contain the column name?

Neil

We have a few servers that have this problem. It has been reproduced. Who do I email?

Neil

I wanted to know how to limit the view. I know how to limit my query.

Neil

I guess, but how can I limit my query. I only want to query for a specific table and specific columns.

After about 2 hours I have come up with this:

select c.name AS ColumnName, C.Type, T.Name

from sysobjects o, syscolumns c, systypes t

where o.id = c.id

AND o.type = 'U'...

Do I have a way to view the TSQL. I am trying to join the syscolumns, sysobjects and systypes now 🙂

Neil

I don't seem to have that view. Do you have it available?

Thanks,

Neil

Right I only wanted the ones for SQL server. There is a roll up covering most of the Win2k Server patches.

I had used the last... But I noticed I had some bad data. Some ip had spaces before them and things like that. That is why I was...

One of my employees found this site: http://www.sqlmag.com/Articles/Index.cfm?ArticleID=7846

It looks interesting. We are going to play with it now...

Thanks,

Neil

I get this error:

Syntax error converting the varchar value '8.3' to a column of data type smallint.

yeah I think I was looking for something simpler 🙂

Thanks,

Neil

p.s. I guess there isn't a regexp() function 🙂

Nevermind I am dumb 🙁 I messed up my Stored Proc and that was truncating the values! 😀

Neil

I changed the user SQL server MSSQLSERVER service and it backsup properly. So apparently it does make a difference.