Viewing 15 posts - 361 through 375 (of 2,436 total)
Your SQL Server support from MS expired in July of 2007 !!!
If you upgrade to SQL 2000 SP4 you can get support from MS until 2013 .
March 17, 2009 at 1:48 pm
yet another method:
SQLCMD -H-1
1> exec sp_helptext sp_procname
2> go
March 17, 2009 at 1:23 pm
Here's a code snippet of mine to get you started - xp_servicecontrol did not exist in v7.0 so you have a voild to fille - likewise I have no 2008...
March 17, 2009 at 12:04 pm
It is not a 32 character limit:
Executed ALTER INDEX PK_ProductProductPhoto_ProductID_ProductPhotoID ON a1234567890_1234567890_1234567890_1234567890_AdventureWorks.Production.ProductProductPhoto REBUILD
Executed ALTER INDEX AK_StoreContact_rowguid ON a1234567890_1234567890_1234567890_1234567890_AdventureWorks.Sales.StoreContact REBUILD
Executed ALTER INDEX IX_StoreContact_ContactID ON a1234567890_1234567890_1234567890_1234567890_AdventureWorks.Sales.StoreContact REBUILD
Executed ALTER INDEX IX_StoreContact_ContactTypeID ON a1234567890_1234567890_1234567890_1234567890_AdventureWorks.Sales.StoreContact...
March 17, 2009 at 10:07 am
and yet again to prove why it does work:
CREATE PROC [;] AS BEGIN
EXEC ('ALTER PROC [;] AS SELECT NULL')
EXEC [;]
DROP PROC [;]
END
GO
EXEC [;]
March 16, 2009 at 9:01 am
It's a cute brain twister that I enjoyed with morning coffee at home before going into the office. 🙂
March 16, 2009 at 7:32 am
The real fault most probably lies with management in this instance. To me it sounds like a question of either the 'old boy' network or just plain 'cutting corners'.
The bottom...
March 11, 2009 at 10:47 am
In the words of Bill'n'Ted ...
MOST EXCELLENT !
March 11, 2009 at 8:24 am
I really like the comic strip humor. It would be nice to have something like this more regularly. It made this mornings coffee at home especially enjoyable today ! Thank...
March 11, 2009 at 6:46 am
No active support - however I believe that MS still does security. I do recall that either MS08-040 or MS08-052 security hot fixes had components for v7.0 too !
March 10, 2009 at 8:42 am
We actually have 2 v7.0 servers that I am aware of. They function perfectly well and will not be changed - this is due mainly to business needs and the...
March 10, 2009 at 8:18 am
Steve, MS is keeping up on security patches - our latest to apply is MS09-004 - it contains both a GDR patch and a QFE patch - prior to thet...
March 9, 2009 at 5:02 pm
This situation is kind of odd ... let me explain briefly ...
In a business, the business processes and requirements that said drive the use of technology, including SQL Server, within...
March 9, 2009 at 12:27 pm
I run it on the database daily after I defragment and reindex.
defragment individual indexes daily
- (not indid 0 & 1)
- when 10% or more of the rows have...
March 6, 2009 at 12:47 pm
Viewing 15 posts - 361 through 375 (of 2,436 total)