Welcome

select object_name(object_id) from sys.sql_modules where definition like '%tablename%' should do it.

You can modify the search condition any other way that suits your needs.

Iam not sure but my guess your sql 2000 had many sql authentication logins/users, thats why you get mixed mode.

Hi

There are many things you need to check to find out the reason. Without going into them i suggest you look up this site and other sql server sites and...

thanks for the...

Jeff Moden (4/23/2009)

---

Chirag,

Heh... man, I can only imagine some of the legacy code you must get from some folks. That's gotta be a nightmare especially when there's no documentation...

If the varchar column contains integer data implicit conversion will occur and comparision will work. But this is not the best way to do it. You may also get performance...

Jeff Moden (4/22/2009)

---

I've been very disappointed with every outsourcing venture we've had, so far. Examples include such things as code that has UDF's that call 4 levels of UDF's...

select DATEPART("dd",GETDATE()) will give you the day of the date. You can check that to see if its the first of the month.

mamidimahesh (4/20/2009)

---

using XML we can store full xml in one column. But I am looking at storing XML data elements into table columns. For instance I have below...

I dont know if you can find out who changed the sa pwd. Check out the sql logs to see if there is anything in there.

You can write a DDL...

You can use the OpenRecordSet or the OpenRowset method to import data from excel.

You can also use linked servers.

If you want to know how to store it in the db then you can use xml data type.

AWESOME.

Sorry to go off the topic... but this just underlines the need to be able to add forum questions to Briefcase (Have already mentioned this to Steve).