Doh, love the simple fixes, thank you so much!!!

Not when it's your General Ledger... There's time to do it right the first time or find a new job. You do not want to be the...

I think I've got hold of a proper process given the circumstances.

This will ALL be done on a test database first. All testing by users will be against a...

Perfect, thank you Tracey!

INSERT dbo.MyTable DEFAULT VALUES

GO

INSERT dbo.MyTable DEFAULT VALUES

GO

INSERT dbo.MyTable...

Which really brings up the whole subject of stored procedures. I'd rather use a stored procedure in my .NET code with variables than embed the code in a string....

My guess would be;

CAST('2007-12-20 12:15:01.111' AS smalldatetime)

You don't have the 'time' portion.

using your date of course...

Thanks Jeff. We have a database from a vendor with about 900 tables. We are changing our account structure. The account number is imbedded in over 300...

I have no problem running this...

set @trig = @trig + 1

EXEC('select TabNam from Acct_Cursor where recno = ' + @trig)

Not sure why you're using int(10) rather than just int.

You have;

DECLARE @prod_num INT(10)

use

DECLARE @prod_num INT

Yes, of course, thank you!

GREAT ARTICLE!  Not unusual.  It's great when you work with a true group of professionals, all with a goal to make the process work more efficiently, take suggestions and give...

Your table really had me confused after the PIVOT example.  The '3' is hanging outside the table and I had to really look at that to figure out that it...

Looking forward to someone being able to explain why extent scan fragmentation shows in the high eighties or ninties AFTER turning OFF sql server services...  No change whatsoever...