Grant Fritchey (9/30/2008)

---

ruyfigueiredo (9/30/2008)

---

The problem is that the log files increase a lot.

I have an database with 250MB and a Log File with 24GB.

After i reconfigure the Autogrowth i have...

You bet. Thanks for the feedback. Just curious because other folks have had the problem of finding "Example E" and I'd like to be able to better direct...

You bet. Thanks for the feedback. Does this mean you're all set?

Mark... you showed the naming convention for the directories... what's the naming convention for the file names and extensions themselves?

rbarryyoung (9/30/2008)

---

Heh. Now this is one of the few things that SQLCLR is good for. It is fairly easy to write a SQLCLR Function with EXTERNAL_ACCESS rights to...

You didn't copy the script correctly... you're comparing an Object_ID to a table Name in your from clause.

But, again, all that just isn't necessary. Look at my previous post.

Ummm... ok... can you use xp_CmdShell or sp_OA* routines?

Just about anything that begins with "sp_" willl be checked for in Master first. I've known people to make Calendar and Tally tables that begin with sp_ just to...

The link is a Books Online link... you need to copy and...

SQL Server uses a lot of "B-Tree" for this type of stuff... start at the following Books Online listing and drill down on the various types of indexes...

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/8936789a-e803-4814-83f2-77e717f81736.htm

Gail is correct, but just curious... you need more than 249 indexes on a single table? 😛

Dunno about anyone else, but I'm not seeing an SP...

Sorry for the delay...

Not everything that goes into TempDB has to begin with a "#" sign... you can use TempDB just like any other database. In other words, if...

I agree... call it "DBA" or "UTIL" or whatever... but avoid Master like the plague if you can. Just use the 3 part naming convention when you call it.

Yep... but I need to know... do you expect that all of the file names are going to be in the same directory, or not?