There may a couple of reasons you did not receive the meanth mail.

- check you db-mail objects to see if it has problems

use msdb

go

exec sysmail_help_queue_sp -- @queue_type = 'Mail'

go

select...

BP is to close the connection.

If you have connection pooling enabled, windows will keep the ( logically closed ) connection open (I think by default 60 seconds).

So if you...

Gail has written a nice article : http://www.sqlservercentral.com/articles/64582/

Also keep in mind you transaction log will grow up to the size it needs to handle your largest transaction !

Also keep in...

SQL Server Migration Assistant for Access

Brief Description

Automates database migration from Access to SQL Server 2005.

http://www.microsoft.com/downloads/details.aspx?FamilyId=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en

- is the sql heart beat check working ?

(cluster account needs connect granted for the sqlinstance)

AFAIK no.

It all depends on your connections / commands ansi settings.

If you login to sqlserver sql as a non sysadmin, you should be able to define the wanted schema as default schema for that account.

btw MS has published a tool...

We use @temp tables to provide a usable example.

Just replace the table name in the query and use the currect column names and you should be fine.

I'm glad it could be of use to you.

We haven't encountered the issue on any other servers (yet) and still don't know what caused the files to be missing.

- there are a number of split functions available at SSC.

- or you can use a combination of :

e.g.

left(yourcol,charindex(':', yourcol)-1)

and

right(yourcol,datalength(yourcol) - charindex(':', yourcol)+1)

how about an hard IIS reset or "recycle" of application pools .... can that be causing the issue ?

See the IIS logs.

Kent Zhou (4/16/2009)

---

Thanks, guys. I found the solution.

The solution is restart DTC service, not need to restart the engine.

But what I'm confused is: why Begin distributed transaction doesn't work...

Certainly no blame Gail 😉

Chances are I misinterpreted the advise and may have taken it to be applicable for as well dbcc updateusage as well as sp_updatestats.

Once again proves we're...

Hi Gail, it must have been on 2009-03-10.

That's the date I modified my rebuild proc.

My "my posts" history only goes back til 2009-03-11 🙁

venu_ksheerasagaram (4/16/2009)

---

venu_ksheerasagaram (4/16/2009)

---

Hi friends

...