Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
service pack 3 for server 2000
Hi occas, To answer your question: SELECT ServerProperty('ProductLevel') This will return the service pack level. However, Microsoft's Service Packs are almost always cumulative. To quote the main download page for SQL 2000 SP3 (http://www.microsoft.com/sql/downloads/2000/sp3.asp)...- KatanaCS
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Export to Excel DTS Fails too Many rows?
rxsid - Your limitation isn't in MSSQL, it's in Microsoft Excel. MS Excel only supports up to 65,536 rows; this means there is NO way it will accept all that data. You'll need to use some other program to store the output, or break it into 2-3 Excel files. Regards, KatanaCS- KatanaCS
- Post #3
- Forum: Microsoft SQL Server: Data Transformation Services
