Yea- that's what I thought he was looking for.

So changing the select part to this will round up the hour based on minutes >=30 and change 0 to 24.

SELECT

CASE

(DATEPART(hh,LEFT(dates,23))+

CASE...

does the account sql is running under have access to create at jobs?

Try running the cmd file from a sql agent job with an server administrator proxy instead of using...

Are you talking about tempdb??

If not, Can you not shrink the file?

DBCC SHRINKFILE (logicalfile, size in mb)

Abhijit More (8/5/2009)

---

hey thxs for th eprompt reply.

As per the database records I have to convert the record to know whether it is midnight / nooon.

And the expected results is...

You need to provide full details because something is being left out.

You are running a view? post the create statement.

You are running many dates though query analyzer?

-...

Assuming your date columns are consistent in size:

CREATE TABLE #t (dates nvarchar(50))

INSERT #t

SELECT '2009-06-05 00:00:00.000 2009-06-05 00:59:00.000'

UNION ALL SELECT '2009-06-05 01:00:00.000 2009-06-05 07:00:00.000'

UNION ALL SELECT '2009-06-05 17:00:00.000 2009-06-05 23:59:00.000'

SELECT

CAST(DATEPART(hh,LEFT(dates,23)) as...

Do you mean the output should be:

1. 0 0.59

2. 1 7

3. 17 23.59

If the first one is 12, then you would have midnight and...

right click on the "line" between the two. You will see Success, Fail and completion.

These are the conditions it will go to the next step. Default is On...

well - somewhere to get started, maybe generate some thoughts

did the db instance update to SP3?

did the sp3 installer fail or give error messages?

errors in the install...

did you check BOL? you will see that the config_value of 0 means self managed. So your max is the server instance maximum.

Also -- this looks interesting:

PRSQL01 MS_SQL_PCT_MAX_Locks_Critical[(Percent_Max_Locks>=80.00...

Just know that if you recover your database, you will need to setup log shipping again. And if you backup the tail of log you will leave your production...

google up:

tsql sql server error log agent

I found the first few results to be very useful when setting up jobs to read error logs for server and agent.

Google sql server maintenance plan, specifically the database backup task.

Robocopy is what I would recommend. I use it all over the place.

Has sync folder options, auto restart if the copy fails, can resume a copy that fails without...

What happens when you run the SP alone (outside the scheduled maintenance plan). If it runs OK --->

You mention you only have 1 backup for the first DB ---...