Thanks.

I read part of the post without getting the whole story. Sorry.

Hi Snap

This is Mark Han again. i'm writing to follow up the issue.

according to your desription, I understand that the current issue is that
the log file of the temdb growed bigger.

in order to resolve the issue, we need to analysis the following
information. my email address is v-fathan (AT) microsoft (DOT) online.com(please
remove online)
1 SQL Server Error log
2 try to use DBCC shrink command to reduce the size of the log file
3 run the following command and tell me the result of the result.
sp_helpdb database name

se database name
go
exec sp_spaceused @updateusage='true'
go

DBCC SQLPERF('logspace')

select @@TRANCOUNT.

4 to figure out which the transaction is so large that the log file might
use up the available disk space and cause the "transaction log full" type
of error message such as Error 9002. So please run the following and send
the result with TXT format to me.
" Open ssms to connect to SQL Server instance.
" "ctrl+T"
" Run
select * from sys.dm_tran_database_transactions,
sys.dm_tran_session_transactions, sys.dm_exec_requests
where
(sys.dm_tran_database_transactions.transaction_id= sys.dm_tran_session_transa
ctions.transaction_id) and
(sys.dm_exec_requests.session_id=sys.dm_tran_sessi on_transactions.session_id
)

5 Also, run select * from sys.databases and send the result with TXT format
to me

I look forward to your reply.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Steve,

That's Ok. let's help Snap to resolve the issue together. Thank you for
help.

Have a nice day.

Best regards,
Mark Han
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
================================================== ==
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ==
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ==

Hi Snap

This is Mark Han, again. I'm writing to follow up the issue.

I am currently standing by for further update from you and would like to
know how things are going. If you have any questions or concerns on the
recent information I've provided you, please don't hesitate to let me know.

It's my pleasure to be of assistance and I look forward to hearing from you.

Best regards,
Mark Han
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======