additionally, both Enterprise Manager and SSMS GUIS's have the built in ability to add an extended property for ease of use: just go to teh table and select "Design",...

actually, what a lot of people do is to put the data in the database itself by using extended properties...(sys.sp_addextendedproperty / fn_listextendedproperty)

you can put descriptions up to 255 chars in...

there was a recent thread on teh same subject:

http://www.sqlservercentral.com/Forums/Topic1056364-324-1.aspx

a lot of people reported they lean towards a "don't ask don't tell" policy, so if they don't ask for your expertise...

nope...something is specifically occurring...there's got to be something that is issuing the commands...

i made a simple csv with a bunch of the possible dateformats.

it looks like using convert with format 109 or 126 is probably best...it leaves the date and time alone...

i'm not sure what you mean by parent object...a trigger, for example, would have the parent_object_id in sys.objects, but i don't think a specific command would have any references to...

here's a quick example of a bunch of the formats available. sometimes you need to combine some of them togetehr to get exactly what you are after:

FormattedDate ...

ok i saw this image on derp.membase and had to switch avatars today. not my dog, but what a pic.

yes, you can;...

http://jobsearch.monsterindia.com/searchresult.html?fts=sql&loc=

yep...monsterindia.com...easy enough to find once you know you want to search fro "sql jobs india"

what about experience in programming languages?

Most of the people we hire in my shop for example are C# or vb.net developers, and we look for SQL skills in that mix.

Unfortunately,...

I think you can do what you want as a set of case statements

let me know if this model works for you:

SELECT

OtherFields,

CASE

WHEN...

I agree With Dave B; bcp, or BULK INSERT, or openquery would all be blazingly fast in comparison;

I've used bulk insert to load files with a million rows in under...

for the executable and services, you don't have a choice...it must be installed on the same drive as the operating system.

after the install, you can move most of the...

Also because mine is purtier!

one of the main reasons i did this was formatting, and removing/pruning items that are optional in a table script, so the don't need to...