http://vyaskn.tripod.com/code/sp_show_huge_tables.txt

How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007

http://support.microsoft.com/default.aspx?scid=kb;en-us;931975&sd=rss&spid=2855

Yes... @DataName = your db name...

at the end of the procedure use your alter database statement...and make sure you use SET MULTI_USER option..

In 2005 MP are stored as SSIS packages and not system tables so you can't script them but I believe you can copy the SSIS package from some server to...

Some one is connected that db...

Do you any monitoring tools connecting to this db...

What is the error you are getting...when you try change it to multi user mode?

Try the following...

I agree with Aaron, if you rely on the HW it is upto you...but it is not advisable...

It matter between 0.5 and 0.05 execution times when the procedure executes many...

Indexes will reduce query I/O cost...if the table is small or no where clause in you the query at that time... you don't see any diffence...

Enable STATISTICS I/O run the...

You can find the backup files location from system tables...

Check the following script which works in 2000 but I have not tested in 2005...

select  

database_name as 'Database_Name' , 

(b. physical_device_name) as...

Check this..

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=235765

May be Barbara referring to the following one...

SQL Server 2000 or SQL Server 2005 may temporarily stop responding on a Windows Server 2003 Service Pack 1-based computer

http://support.microsoft.com/kb/922658

It should be as long as it set to autogrow...

When you insert new data and SQL requires more space it will grow automatically...or you can increase the size manually...

When you have 12 GB then configure max memory 10 GB and leave 2 GB for OS.

What ever the process/job you ran requires the tempdb space and your tempdb ran out of space...

All temporary tables created in tempdb will be dropped at the end of the...

I have not done this any time... but check the following thread..

http://groups.google.com/group/microsoft.public.excel.programming/browse_thread/thread/95f0f1a88146b161/4fac5cdcf6f93046?lnk=st&q=how+to+import+%3E+65000+rows+into+excel+from+sql&rnum=1#4fac5cdcf6f93046

SQL Server has long supported two forms of OUTER JOIN syntax, the ANSI syntax (using LEFT OUTER JOIN, RIGHT OUTER JOIN, etc.), and the simplified T-SQL syntax (using *= and...