is this query returning 1 row in your case

SELECT TOP 1 * FROM [serverN].MASTER.dbo.sysobjects

u need to setup linked server for "ServerM"

but right now. In Production databases, Log files used to be 60-100 MB before but right now it increases upto 14 GB.

so I try that command above manually and I...

below query can help you to list down all db for backup but you need to cutomize your current scripts

declare @tbl_backup_list table (id int identity ,[db_name] nvarchar(200))

insert into @tbl_backup_list

select...

GRANT VIEW SERVER STATE TO <<login name>>

This will grant <<login_name>> VIEW ANY STATE permission.

homebrew01 (5/11/2012)

---

I want to look through about 30 trace files from this past week. I can open each one, then "Save as Trace Table" to a SQL table to run...

i...

Nagendra Rao (5/10/2012)

---

Hello Bhuvnesh,

I have the same problem. Can you please tell me what Network issue you had. In my case,

1. I am able to navigate from my SQL...

set the sql profiler and trace the lock and deadlock there.

it will be get reflected automatically to all the area/section wherever used.

but haven't you hard coded rthe password anywhere ?

have you checked the job history for error ?

mike schreiner (5/9/2012)

---

2. Go to cmd prompt and Run as Administrator

5.Go to the Binn directory of the SQL Server instance. In this case it was d:\Program Files\Microsoft SQL Server\MSSQL10_50.AFVCSQLSERVER01\MSSQL\Binn

6.In...

Set trace on performance monitor see if there are high IO spikes

It...

.Netter (5/7/2012)I understand what every one has written and i appreciate your time on this subject, but my point was if im not going to use them columns then why...

Having separate users can help you to track and restrict their usage or activities.If you are using SQL 2008R2, resource governor can help you to manage resources usage for every...