Could you provide references or links for your statements?

Could you explain what recompile a table mean while using this stored procedure?

Did you check your AWE enabled?

We can get it using cursor. But many people do not like it.

Do you use PeopleSoft or Lawson application in your connection? Lawson system uses its own security tunnel to access SQL Server. If so, please ask your vendor for help. I...

You may try BIDS (Business Intelligence Development Studio).

You may try something like this,

DBCC SHRINKFILE(myLogicalFile, EMPTYFILE)

ALTER DATABASE myDB REMOVE FILE myLogicalFile

1. I would like recommend you to post such a question in T-SQL forum. People there are more happy for this kind of question.

2. You need to provide information on...

Find the training where trainer can help you get your certificate.

Find the materials which contains questions in exam.

Ask your friends which firms provide you this kind of stuff. The information...

Try the following links. The articles below list some possible approaches in trouleshooting this issue. May they help.

http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx

http://www.mydigitallife.info/2007/10/31/error-has-occurred-while-establishing-a-connection-to-sql-server-2005-which-does-not-allow-local-and-remote-connections/

Did you try

sp_who2

or

SELECT * FROM sys.dm_exec_connections

?

I did check. BOL states that DAC check default port first. If the default port does not exist, it will automatically check the open port for DAC.

Thanks all.

In SQL 2000 and Sybase 12.5, the attached string is related to connection session. In SQL 2005, it is not.

🙂

I used a sa account.

My SQL Server version is SQL 2005 enterprise edition with SP2.

Check this one

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