Cholliet,

I can't let this pass by.

I can understand your frustration. However, this is an International site. (It might be run by people in the USA, but the users/members are from...

dbo is DataBase Owner. Anyone can be assigned the dbo privilege/permission.

Use Enterprise Manager, drill down to Security. Expand that and select Logins. Right click on a login and select Properties....

Ooppps. I made a mistake.

I just tried this.....

SELECT CONVERT(DECIMAL(9,3), '1.23')

and it returned:

1.230

So the VARCHAR can include the decimal point.

Are you sure there's no other characters (spaces, commas)?

-SQLBill

QUOTE: Not all the numbers are integers UNQUOTE.

What else can numbers be?

Yes Varchar to decimal is allowed.

BUT! It must be ONLY numbers. No commas, no decimal points.

This can be...

This is interesting. I think it's a mistake in BOL.

I looked at your reference and found the same thing you did.

But now go to BOL, use the Index tab, enter...

Where did you get the information that a RETURN in a stored procedure will stop all other SELECTs?

I looked in BOL, used the Index tab, entered Stored Procedure and selected...

Did you run the BACKUP LOG mydata WITH TRUCATE_ONLY (or NO_LOG) at any time?

Let's say you do a FULL backup. Then changes happen (transaction log begins increasing). You truncate the...

Your E drive only has 11 GB of free space? Well, you aren't going to be able to backup a 62 GB database to that drive.

Since this database isn't going...

Remember, WITH TRUNCATE_ONLY or NO_LOG only truncates the INACTIVE portion of the log. So, if you have an active transaction nothing will happen (as Mark pointed out).

-SQLBill

Cindy,

"The convert function will truncate the time part and give the output in the format 'mm/dd/yy' (for 101)"

Only works when you are converting to a CHAR or VARCHAR format....

I missed answering your real question...both will work just fine as long as you are giving the correct data. When the CONVERT happens, your query is really:

SELECT * FROM tblprojects...

Cindy,

First, this is the forum for the Question of the Day. The QOD is a 'test' question that appears in the SQLSERVERCENTRAL newsletter (it can also be found by going...

In T-SQL:

BACKUP LOG dbname WITH TRUNCATE_ONLY

Replace dbname with the database name.

-SQLBill

Is the job ENABLED? Usually when the next run date says what you posted, then it means the job is not enabled.

-SQLBill

Two things to check....

First, is the database set to FULL recovery mode? (Use Enterprise Manager, drill down to the database, right click on the database, select properties, go to the...