That test button is only valid when using SQL Mail. If you have set this up and cycled the agent service it should now be working.

Look up sp_executeSQL in books online. You can input and output variables to a dynamic query executed with the above.

You need to configure SQL Server Agent's alert system to use database mail.

Right-click on SQL Server Agent in Object Explorer and select properties. Select the Alert page and configure...

Randy (6/12/2009)

---

You could create a clustered index on your #temp table. That would force the order to be however the index is ordered because at the very bottom of a...

BTW - if you do not specify file locations in your create database statement, the default location defined for that instance will be used.

Grant Fritchey (6/11/2009)

---

You will see contention between these two processes.

I'd suggest getting the DBCC run first. If there are problems with the database, you want to know prior to running...

Ken (6/10/2009)

---

Actually I'm a little embarrased to admit it.

I took a second look at the query and I am not adding (or finding the min, max, avg, etc...) anything.

So, feeling...

aa2home (6/10/2009)

---

thanks all of you

I realy have problem with DB

Evrething is wrong .... database was not in full recovery model and backup is old

Any way

The...

Can you post the query that is causing the problem? I would bet that it is because of the way the query is joined and/or how the query is...

Not sure - because I am not sure what you have available.

Do you have a backup of the database?

Do you have a backup of the transaction log?

How old are the...

Based upon what I have read here - my guess is that you rebuilt an index (or attempted to rebuild) that has not been previously selected. It now was...

If the server (OS) already sees all 32GB of memory, and SQL Server is reporting 32GB of memory available then the PAE switch is enabled.

Now, all you have to do...

mathieu_cupryk (6/3/2009)

---

The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK...

In the boot.ini file on the server - you have to have the /PAE switch set. I am going to guess that this is already the case because the...

If you want to get help with your questions here, you really need to read the article I link to in my signature and post the create statements, sample data...