I don't think this is the case in...

MysteryJimbo (10/27/2011)

---

Lexa (10/27/2011)

---

It's configured Weekly, Mon-Fri, begin 8 AM, end 7 AM, run every 3 hours. Not sure why you cannot have schedule which spans days, since the option...

MysteryJimbo (10/27/2011)

---

How have you configured the schedule?

You cannot have schedules which span days.

Also, if you want 8am – 7am your schedule will begin at 8am Monday and finish...

GilaMonster (10/25/2011)

---

I assume you're trying to shrink the log file. Does it have free space in it? If not, shrink's going to do nothing (btw, TruncateOnly is an option only...

Ninja's_RGR'us (10/18/2011)

---

Actually the first test would be to see if removing it helps.

Step 2 would be to see where and how that table is used.

Most of the time when you...

You can, but why would you want to? If you want a query to not run in snapshot you'd more likely just change...

Evil Kraig F (10/11/2011)

---

SQL Stud (10/11/2011)

---

IT depends... lol! If you can afford to read data that may not be commited yet, in favor of not locking the table and thus...

SQLRNNR (10/11/2011)

---

The only way I have been able to achieve this is to use xp_cmdshell and tsql. I am sure there is a method using powershell or a script...

LutzM (10/8/2011)

---

It depends 😀

If the DBs are in the same instance, use the same collation and security context, have a similar layout of file groups (e.g. in terms of log...

Jeff Moden (10/8/2011)

---

Lexa (10/8/2011)

---

Hi,

We're implementing a set of new features for our app and require dynamic creation of tables. My concern is that there will be lots of new...

Never mind, had to change the variables too.

Thanks all

abrukovsky.v (10/4/2011)

---

Lexa (10/4/2011)

I can change the database context but I don't like the fact that I need to have the procedure in every database. In case there is a...

abrukovsky.v (10/4/2011)

---

I changed a copy of sp_spaceused and placed it in each DB. But I do not like that solution, I like that sp_spaceused can be called with any...

george sibbald (10/4/2011)

---

Lexa (10/3/2011)

---

Thanks, I'm trying to monitor DB growth at database level not at a file level for all...