ruchika thapa (4/16/2009)

---

jacek0 is right. application that uses global temp table is not the same application that exec sp_reset_connection. And they arenot using same databases since they are two different...

That is assuming the code is clean and what is using the global temp table is not some process that is propagated into SQL Server from another layer of the...

There is no way for an application to close another connection if both are not using the same database, the reason all SQL Server connection string include a catalog which...

That is nonsense ask them to send you the connection pooling code and how the connection object is dropped. You should also ask them if they are using a...

The field "E-mail name:" in the Opertaor property wanted the correct yomama@somewhere.net address.

This is what confused me from the other SQL 2005 servers. They had MAPI configured and they used...

Reboot the box and if it is still not working then talk to your Exchange people because there is some break down of the SMTP traffic.

That is correct but it was cause by what happened to you and other users who could not run IIS dependent features because Windows have disabled IIS.

When we do this in my server W2K3, one of the questions was that...and our Infra Adm says when enabled smtp service the port is open..so if in IIS7 does...

Huh? Why does the SMTP service need to be installed? I don't want to broaden the the vulnerability of my server by adding the SMTP service. Is this entirely necessary...

The information you got is correct but it is not relevant to you hecause IIS7 comes without SMTP so yes you need another way to send SQL Server mail. ...

Here is a free book from Microsoft that will help you to SQL Server 2000 because that is the version in use with 9i.

http://technet.microsoft.com/en-us/library/bb496494.aspx

LINQ is not going anywhere but the LINQ to XML will be dependent on people using it and giving feedback to Microsoft because XML is in ANSI without basic relevant...

Then drop it and create a new one this time make sure auto populating option is used. This will show if something is wrong with your install. I...

That is correct you need the collation and unicode that is Nchar, Nvarchar and NText. Check the long thread below for all you need to know about this problem...

English, Chinese and Japanese collation is important because you have three separate alphabets the Latin for English, while both Chinese and Japanese use separate alphabets that is more than...