This is a log shot but try running this to see if any system objects are taking up the space. system objects do not show up on the Disk Usage...

One reason to do this is to have tempdb in different compatibility. If you have a user database in 2005 compatibility on a 2008 instance any code using tempdb will...

I think the issue is, They need to parse out table name even if it is not aliased. If that is not the case please provide expected results.

Declare @sqlQuery...

You could try creating a central management server(http://msdn.microsoft.com/en-us/library/bb934126.aspx) an then use sp_msforeachdb 'USE [?]; EXEC dbo.sp_changedbowner @loginame = ''sa'', @map = false'

try using this example to achieve you requirements

declare @datefrom datetime,

@dateto datetime

set @datefrom = '05/30/2007'

set @dateto = '06/04/2007'

select DATEDIFF(dd,@datefrom,@dateto)

Here is link describing the datediff function

http://msdn.microsoft.com/en-us/library/ms189794.aspx

also, please read the link in my...

Are you referring to a SSIS package? If so, I think the the package ID is part of the application name. If it is you run a trace on updates...

I just checked my local instance of SQL Server Express 2008 R2 and it looks like only Shared Memory Protocol is enabled by default (I dont ever remember changing it)....

Did you try just typing in the instance name instead of selecting from the list?

I would look at SSIS. I am by no mean a SSIS guru (novice more like it) but you should be able to use you file as a source with...

This would be a better setup although this would require...

Splitting a single drive to multiple partitions does not help the performance of a database. What you would want is to have a separate physical drive(s). More spindles = better...

One way to accomplish this would be to create a linked server for all servers you would like this SP to run on then create a cursor that will loop...

If it is a partitioned table it can be in multiple File groups, each partition can be in a different file group. I am unsure what info SSMS would give...

You have all the pieces you need in the script provided by Ki Chiang. Instead of individual columns in the select, add them together as a string to create your...

try using xp_cmdshell to BCP the results to an XLS file. Excel might complain that it is in the wrong format but should still open the file.

exec xp_cmdshell 'bcp "exec...