log files will grow in size automatically. they typically grow for two reasons: either a huge transaction occurred, or more likely, the database option for recovery is set to "FULL"...

to do the equivilent of row-number() in 2000, I've always had to create a temp table with an extra column, insert the data into the table, then run an additional...

jyoti you would not replace part of a string...

here's another script that i use a lot;

i stick it in master, and then in any database i might type "sp_find order" in any database;

and it returns all tables(or views)...

steve whenever i have an overall status that depends on the details, i do not store it in the parent/Orders table. I always try to calculate it based on the...

gotcha; you want to replace any value with isnull...

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:

...

you probably want to show us the two expressions, and how you want them to be used together , i would think.

a crappy example is the ISNULL function is an...

glad i could help a bit g_dion; i'm glad you were able to do what you needed to.

what i...

discovered that my problem was the period in the pattern...the period matches an character except a new line...the patter i'm using, if anyone else ever needs a regular expression to...

weird, I've always been told that a backup from a previous version(2000,2005) can be restored on 2008.

my google-fu found this link at MS, which says you can get that error...

you'd get much better,understandable answers if you were able to provide the CREATE TABLE definitions of your two tables; psuedo code like table_new and table_old is not nearly as useful...

i have to go with lobbymunchers suggestion; a standard parent child relationship would be much more appropriate; i think you are mentally locked into bitwise operations because it's neat to...

the command is extremely basic, all available in books on line;

use database1

drop user webdev

use database2

drop user webdev

what are you having trouble with?

you definitely need some coffee; god knows i've drawn blanks like that before my daily caffiene infusion.

if you need the max(payment date) per company, you simply need a group by;

something...