Based on the sample data, what kind result you want to get?

It does not take more time but the reason is we are not able to execute the script for each server when we take backup and execute it during database...

Try this:

SELECT COUNT(id) as SessionCount

,CASE WHEN DATEPART(HH, convert(varchar,DATEADD(hh, DATEDIFF(hh,0,timeuploaded), 0),120)) = 0 then '12 AM'

WHEN DATEPART(HH, convert(varchar,DATEADD(hh, DATEDIFF(hh,0,timeuploaded), 0),120)) > 12 THEN CAST ( ( DATEPART( HH ,...

malavika.ramanathan (12/20/2010)

---

Sorry i was not very clear.

I am getting 12 AM TWICE if i try to use a case to change the 0 to 12.

the query i am using now...

Can you check "CREATE PROCEDURE " on BOL?

Hardy21 (12/17/2010)

---

Thanks Henrico. I have already checked this link but this will not work for me. Because...

1) Check Database Mail log, there mush have an entry if the dbmail works fine.

2) Since the operator 'NEVER' receive a mail, you may forget to restart the SQLAgent after...

If you are absolutely sure that the database is not for replication, why not disable the replication?

(Use the following script:)

sp_replicationdboption 'database_name', 'publish', 'false', 1

GilaMonster (10/28/2010)

---

Hint: What makes a clustered index different from a nonclustered index?

Yes, it may be possible with work to make a nonclustered index larger than the cluster, it's not something...

Steve Jones - SSC Editor (11/9/2010)

---

Thanks for the update, and glad it's working. The network can have big issues.

Note that you can mitigate this if you must do it. You...

You'd better check BOL. It has the answer to all your questions.

If it is for SQL Server, then ask someone to check the error log.

Otherwise, you post on a wrong site.

Edit: if one flag is on to write the deadlock info...

Lynn Pettis (11/4/2010)

---

A better way, direct from the QotD for Oct 19, 2010:

select

sum(row_count)

from

sys.dm_db_partition_stats

where

(index_id = 0 or index_id =...

[quote-0

The only things that break the log chain are:

* Switch to simple recovery

* Backup log with nolog/truncate only

* Deleting a log backup (won't stop you taking log...

I use a local variable...