From what I see in your query, you are looking at Jobs.

FROM msdb.dbo.sysjobschedules AS js

JOIN msdb.dbo.sysschedules AS s

Both of them are for Jobs. Thats why you are looking in the...

Two options...

1. Have two columns. One a Char(1) with default value of P and the other an Identity. When selecting Concat both fields. PK based on two fields.

2. Have a...

I think Polar Beer is more tastier than polar Bear..... 😀

Stamey (12/14/2009)

---

I have been considering TDE, but nixed the idea when I read that once the data is encrypted you have little or no ability to compress it. If your...

Congrats to Barry.... Barry is THE MAN. Barry kicked the Thread in the back and made it roll over.. 🙂

Or maybe "The Thread" himself/herself should have the honor of hitting the milestone.. 🙂

You could actually get more details regarding this in BOL. Just search for GRANT.

example

GRANT EXECUTE ON [dbo].[SPNAME] TO [ExecuteRole]

GRANT SELECT, UPDATE on [DBO].[TableName] TO [SELECTROLE]

GRANT CREATE...

We have never had this problem... But the only thing I can think off is your Disk IO maybe quite high. Replication uses the Log file and if your data...

For the time you are starting the Snapshot agent, you can stop the log reader agent and once the snap shot is done you can start it again. I dont...

You can give granular permissions for each object. Give the permission for each objects to three different groups according to your business needs or security model. Then add the users...

snu155 (12/10/2009)

---

If someone hacked into your server and you had excluded the built in admin group, and they were only able to steal files, then they would not be able...

Gianluca Sartori (12/11/2009)

---

One single Italian was able to do the same thing...

Lynn Pettis (12/10/2009)

---

Alvin Ramard (12/10/2009)

---

GSquared (12/10/2009)

---

And plenty of Americans who give us...

To be honest, There are lots of Indians here who give other Indians a bad name... 🙁

Grant Fritchey (12/10/2009)

---

Roy Ernest (12/10/2009)

---

I guess the sunny Caribbean island can beat your climate Gail... 🙂 When do you want to drop by Grant? Also you dont have to travel...