Thanks Gianluca for your kind reply. It is just for example i quoted the script. I achieved my requirement. I am going to implement a centralize monitoring in our environment....

Thanks Jason for your reply.

I am trying to achive to capture all the transactions which is goin on my database in a different database table. In that case i dont...

Thanks for the reply,

Run DBCC CHECKDB in Emergency mode:

==============================

Msg 2533, Level 16, State 1, Line 1

Table error: page (1:1156536) allocated to object ID 2121058592, index ID 0, partition ID 72057594038845440,...

Hi Buddies,

I am facing the same problem even my database Auto_close option is False. When the application team running package, database going on suspect mode. rest of the time its...

🙂 I know bro. I m talking...

Suresh B. (3/11/2012)

---

Use this query:

SELECT

DB_NAME() As DBNAME

, DB_ID() AS DBID

, SUM(size / 128) AS 'Total Size in MB'

, SUM(size /...

Its Ent edition.

PaulB-TheOneAndOnly (3/11/2012)

---

Did you increase the datafile size or did you allow SQL Server to extend datafile up...

Hi dskinner,

Please try the following,

1) Create one domain account on the Domain machine with administrative previllages for the login, if exist then good.

2) restart your mssql server machine and login...

bitbucket-25253 (2/11/2012)

---

Yet again I see another question which obviously effects the size of your database at:

http://www.sqlservercentral.com/Forums/Topic1250789-146-1.aspx

Now how about try this T-SQL and we can see if any of those indexes...

Hi Gila,

But on server performance problem, how i can resolve that?

The Index size is >=502544KB, and

Pages are >=277 on each cluster and...

I checked there is no problem with // slash and also i checked to run this command manually. Its working fine but when its running in schedule its genrate an...

Hi venkat,

Try it once please login on ur SQL server with SA login and go into the security folder in object explorer and check the logins, is there your...

Hi venkat,

Please login on ur SQL server with SA login and go into the security folder in object explorer and check the logins, is there your windows login or...