abivenkat (4/19/2012)

---

hi,

thanks for the reply first of all...

i have to group by all the columns such as CompanyName, CompanyContactNumber etc., except the DB_Name where more than one company can...

I guessed on this one. I've not experienced this error before.

Check the logs too

I figured what was being asked, no confusion here either...

I'd suggest rebuilding the indexes in batches maybe doing the largest ones individually and the smaller ones all together.

Yeah what is Subdate data type?

If its datetime keep it as datetime in the WHERE clause...

I like the 2012 questions. I'm learning lots. Thanks.

Thanks for question. I'm learning about this feature.

John Mitchell-245523 (3/21/2012)

---

That'll work well for three rows, but will get more and more inefficient the...

I have nothing to add as to the cause but I'm going to suggest you not rely on the backup process you described. You can use the Maintenance Plan...

?

sam.dahl (3/15/2012)

At the end of running the code and after stopping the execution my transaction remains open.

If I then commit the transaction I get the result you described.

However if I...

ames.f (3/13/2012)

---

Here is the culprit. Part of a Stored Procedure.

IF @Option = 0

BEGIN

EXEC sp_dboption @DBName, 'trunc. log on chkpt.', 'FALSE'

END

ELSE

BEGIN

EXEC sp_dboption @DBName, 'trunc. log on chkpt.', 'TRUE'

END

The procedure passes in...

Craving

I'd do the import again and this time handle the formatting pre-import when you select the xls source. If you use the import/export wizard this can be done quite...