Ram:

I did a test here and it worked. I stopped the sqlserver Agent (it was using the only one connection allowed) and then I was able to connect by SSMS.

p.s:...

Ram,

Once this happend with me. What I did was based on this post as follow:

{To use sp_configure to increase the maximum number of concurrent

connections, follow these steps:

1. Click...

Hi Matt,

"Check your event logs, as well as your sqlserver and sqlagent errorlogs. You may find a clue in there" (Chad)

Regards,

Rafael Melo - Br

GSquared,

I thanks you a lot for your advise... You solve my doubt.

Rafael Melo - Brazil

GSquared,

I was thinking about creating this function into the master database... What's your opion about it? Is that a good practice or I can run into some troubles??

Anyway, thanks for...

Hi Mega,

Thanks a lot for your replying. You really solve my doubt.

Regards,

Rafael Melo - Br

Thanks a lot for your reply...

Its works for me.

att.

Rafael - BR

Thanks anyway Grant Fritchey, I was really in doubt about "schemabinding" concept. You make it me clear.

Regards,

Rafael - BR

Thanks a lot for you reply. I was thinking that "schemabinding" had something to do with index use becase I can't create an cluster index (sql server 2005) without declaring...

PaulB-TheOneAndOnly (5/6/2010)

---

The good news is that a 600 Gig database is not such a large database - there should be no problems to properly maintain it; providing it is done...

sorry my mistake... The amount of rows of this is 600 million...

Thanks for your replying....

Rafael

Hi,

You should use: DBCC UPDATEUSAGE

but pay attention:

"Do not run DBCC UPDATEUSAGE routinely for databases created in SQL Server 2005 or higher or on upgraded databases that have been corrected once...

Ram,

Is there any connection/transaction blocking your table? Give a look at Active Monitor (or sp_who)...

Rafael Melo

Brazil.

Hi,

This option was descontinued in the 2005 and incorporated into the DBCC CHECKDB with the REPAIR_ALLOW_DATA_LOSS option in the SQL 2005.

Please, see this article wrote by CHECKDB's father Paul S....

You can use both HINTS:

-- ROWLOCK: When you wish row-level locks.

-- TABLOCK: When you wish a table lock.