Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » 2000   (RSS)
Thursday, June 04, 2009 3:19 PM

SQL Server TempDB – Number of Files – The Raw Truth

I continue to answer questions about the number of TEMPDB files and trace flag –T1118.   It seems there are plenty of advice blogs, wikis, articles and other resources.   To help clarify this I am going to post my latest e-mail exchange.
Posted by psssql | 2 Comments
Filed under: , , ,
Tuesday, March 17, 2009 3:38 PM

How It Works: What Are The Event Source Names Used By SQL Server

  Sent: Tuesday, March 17, 2009 4:24 AM Subject: Event Source changed from MSSQLServer to MSSQLSERVER to all upper case   Our different SQL server versions write to the Eventlog in a mixture of upper/lower case.  One version writes as Event
Posted by psssql | 1 Comments
Filed under: , , , ,
Thursday, February 19, 2009 12:56 AM

How to copy DTS 2000 packages between servers (and from SQL 2000 to SQL 2005 and SQL 2008)

I was posed the question today, how do I migrate my SQL Server 2000 DTS packages to a SQL 2005 Server without upgrading them, thus leaving them as legacy DTS 2000 packages within SQL 2005? In other words, how do I copy or move DTS 2000 packages into SQL
Posted by psssql | 2 Comments
Filed under: , , , , ,
 
Page view tracker