CozyRoc (6/14/2009)

---

This will not be enough. When you use this...

Glad we could help.

george sibbald (6/14/2009)

---

Barry,

should the default database file locations have been set via the database settings in SSMS properties, your query would not be guaranteed to return the default locations for...

GilaMonster (6/14/2009)

---

Truncate log on checkpoint is a deprecated option (has been since SQL 2000 I think) and will be removed in a future version. The replacement is to use the...

Glad we could help!

I guess almost everybody knows this trick by now?

If you tell us what "doesn't run" means we should be able to help you better.

Of course, if you do need to find the default location from within T-SQL, this is what I've been using:

Select @DfltDir = Replace(physical_name, '\master.mdf', '\')

from master.sys.database_files

where name =...

Or alternativley, "DontSaveSensitiveData" and just run it under an account that has the rights to access everything that it needs.

Not AFAIK. Why would you want to do this anyway? This option can do bad things to your DB environment.

Can we ask why you are making 100 separate tables? Why not just make one pair of tables adding the XXX as part of the key? You could...

Show us your derived column definition. It's saying that it cannot parse it.

You description mentions shopper guid and sessionID, but your query mentions ShopperID and CartID. Could you clear this up for us?

Trashcan2007 (6/13/2009)

---

When data is read / written to the database it is recorded in the transaction log, does this mean that if the transaction log is slow, then the database...

Has the code for these Jobs been posted yet? If so I must have missed it. If not, then we definitely need to see it.