You shouldn't need to truncate the log file. You should be able to manage that by taking log backups. Since you need to do that anyway for log...

Check this article, see if it helps: http://www.sqlservercentral.com/articles/T-SQL/65540/

Yes.

Countdown to 12000?

Why bother? I think powers of 10 will be enough for this thread! 🙂

Alvin Ramard (2/23/2010)

---

Roy Ernest (2/23/2010)

---

george sibbald (2/23/2010)

---

cheers Roy...

Mainly, it means you won't be able to do all traditional/normal/required DBA functions without help from the admins.

If, for example, you need to restart the SQL service after a failure,...

Please only post each subject one time. Not necessary to post in multiple forums.

"Mail queued" is what it's supposed to show. That means it's in the queue to send and should go.

The best you'll get on this is doing log backups on a regular basis, like every 15 minutes, or maybe even more frequently.

Then, assuming your logs are on a different...

Ray K (2/22/2010)

---

I had one interview where they gave me (I think it was) a half-hour to answer ten programming questions. (It was sufficiently long enough ago that I...

Is DBMail enabled on the server?

If so, does it have a profile set up?

If so, is the account information correct?

If so, are you calling sp_send_dbmail with the correct parameters?

I'll say the same thing I always say: Do pivoting in the front end, not in the database. Easier, more efficient, gives the end user more options.

However, if you...

James Goodwin (2/22/2010)

---

Here's the thing that gets me:

Why is everyone using CASE WHEN (number % 5)=0 And (number % 3)=0, instead of CASE WHEN (number %15) = 0?

I want to...

CirquedeSQLeil (2/22/2010)

---

GSquared (2/22/2010)

---

Just to annoy Jeff, here's my "ultimate version":

SET NOCOUNT ON;

DECLARE @Table1 TABLE (

ID int IDENTITY PRIMARY KEY,

Number int);

DECLARE @Number INT;

SELECT @Number = 1;

WHILE @Number <= 100

BEGIN

INSERT INTO @Table1...

Steve Cullen (2/22/2010)

---

If you're going to setup your table with a while loop, just for a set-based solution, wouldn't the direct while loop be quicker without the table? Such...