If your intent is to strip the time (or zero the time), then try:

SELECT dateadd(day, datediff(day, 0, DateColumn), 0);

Okay - this version is the initial SP2 that was released. You should be on a minimum...

Right-click on the Maintenance plan and choose View History from there. This will show you which step failed and you should be able find the actual error message.

Also -...

Sure it does - handle the error and RETURN 0 to the caller. Stored procedure will return to caller a status of successful completion.

Just so we answer the original question - use the RETURN statement to return the status back to the caller.

Does the script check the number of pages for the index? If not, how many of those tables are less than 100 pages?

Without seeing the script - not sure...

One thing I noted in the earlier part of this thread is the statement that there was no concern about the statistics being up to date because they reorganize the...

Yes, I would still set the size to 100MB. Why go through the overhead of an auto-growth event when you don't need to?

J M (11/26/2008)

---

Yes, I want to shrink the file.

I know why it got that big.....kind of a long story to type out. Bottom line is backups weren't being done...

An update statement in SQL Server can only update a single table. If you need both tables updated as a unit, then you need to use a transaction.

You can...

You are not going to lose any data by shrinking the transaction log. However, if your transaction log is 2GB now - something caused it to grow to that...

Paul DB (11/26/2008)Excellent question, Matt. I am using the query inside a stored procedure, which is referenced in the SelectCommand in a .NET TableAdapter object. Because the Configure......

Now, while what Gail has stated is quite true - in this particular case your query will always return ALL rows because that is exactly what you have asked it...

Not sure where you got the...

When the check_policy setting is turned on - yes, the system is going to validate using AD settings for that server.