Hi Grant, Solarwinds is a server performance monitoring application which is 3rd party. We logged a call with them enquiring about the tempdb issues we haing.

We will monitor the temodb...

Hi Guys an update ...

The Tempdb is staying at the 35Gig mark. We are happy to leave it at that size as it is not growing to fill the drive...

lol thanks, I'm monitoring it currently, tempdb files sizes and checking queries as the day goes on.

Hi Guys, the Tempdb is currently on 35Gig ...

the main database on the server is 126Gig ...

DBCC OPENTRAN ==> No open transactions!!!

MANU-J. your query gives me NULL in all the...

Hi Guys, well the Tempdb is once again 36Gig on a 40Gig drive.

I ran this query

SELECT SUM(unallocated_extent_page_count) AS [free pages],

(SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB]

FROM sys.dm_db_file_space_usage;

Free Space in...

you can use SSIS to do that easy 😉

Who went this route and what was your experience???

I save this learning plan on the learning.microsoft site ==> Learning Plan for Transitioning from MCITP SQL Server 2005 DBA to MCITP...

I was afraid of that :pinch:

Thanx for the reply Gail

exam 453 is next now 😉

this option is for when you connect to the server remotely, from a remote PC, desktop, server, laptop to a MS SQL2005 instance on a server.

The applications connect to your...

under you MSSMS go to server properties and under connections, untick the allow remote connections to the server.

That should do it ...

Do you have permissions set on the out going SMTP server to give your MS SQL 2005 server to send mail via this SMTP server ???

Hi Guys Thanx ...

Googled the problem and did a DBCC UPDATEUSAGE on the...

What we discovered with this problem or apparent problem is that we call a stored proc to insert the batch into the DB. pass parameters to the stored proc and...

THANX!!!

Will probably send a text file to the SQL server per download or batch of downloads and then create a SSIS package to do the rest ... ;-);-)

Some extra info,

I went through a trace file and a batch of 922 scans takes +- 4 seconds to complete in our Live production evironment to insert via 922...