Please check database roles SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole on msdb database.

Joe-420121 (2/22/2010)

---

could some explain me what is the effect of the following two statements; Which one better one? both same?

update i set i.name= 'MR Y' from inventory i with (NOLOCK)...

sys.dm_exec_sessions -- 2005

sysprocesses -- 2000

Anamika (2/17/2010)

---

Hi All,

Thanks a lot for your inputs.

I'm working on those.

and i have installed performance dashboard reports to find out the time taking queries.

Once i find some significant...

mitch.fh (2/17/2010)

---

Thanks for your info.

But I must say, I tried to put the clusterd key index in another filegroup and it worked.

I not saying that it makes sense about it...

Congratulations!

About the books please see this http://www.sqlservercentral.com/Forums/Topic852227-10-1.aspx

If you move your post to Careers->Certification you might receive more replies.

Wish you all the best.

Suresh

2 GB RAM is not enough for a server with 200 GB database. You need to add more RAM.

luckysql.kinda (2/16/2010)

---

Following is the empdetails table in my organization which has been used for last 3 years.

create table Empdetails(empid int , empname varchar)

We noticed that there was no primary key...

parthi-1705 (2/11/2010)

---

HI

What is the Need of Files and filegroup backups

I created a database with

.......

checked --(Partial Database Restore Operations )

http://support.microsoft.com/kb/281122

......

RESTORE DATABASE Sales

FILEGROUP = 'SalesGroup1',

FILEGROUP...

1) Run DBCC OPENTRAN and see what are the open transactions.

2) I don't think replication is failing due to Tlog full. Confirm the reason for replication failure. Replication has log...

Barkingdog (2/4/2010)

---

Our developers wrote a stored proc that works fine when run from Query Analyzer but locks a table, the same table everytime, when run from either the VS.NET IDE...

Dominic Gagné (2/1/2010)

---

Hi,

I'd like to earn a MCTS certification in SQL Server 2008 Administration and development (exam 70-432 and 70-433). What do I need to pass the exam? Is the...

mahesh.vsp (2/3/2010)

---

Hi,

I have a question on server Level configurations when we are going for 2008 migration from 2000. What all parameters can i set to the 2008 instance to...

jared-709193 (1/29/2010)

---

I am researching the possibility of using ip address to query data on one server from another instead of using a linked server. Is this possible? If so,...

BACKUP CERTIFICATE MyServerCert

TO FILE = 'C:\MyServerCert.backup'

WITH PRIVATE KEY (FILE = 'C:\MyServerCert_PrivateKey.backup',

ENCRYPTION BY PASSWORD = 'xxxxxxx');

GO