Indianrock (9/9/2009)

---

Systems reactivated the LUN and the drive letter to it. But since the ndf file was in the root of that instead of in the correct subfolder, the...

on another note, if you want it to work only on a working week.

change it to weekly and just select the days that you want it to run on.

Occurs every 4 day(s) every 1 minute(s) between 09:14:00 and 23:59:59. Schedule will be used between 21/08/2009 and 28/12/2009.

you need to change it to

Occurs every day every 1 minute(s) between...

The forums were down this morning, I am assuming that it was down to maintenance. I can see that my title has gone up. but not to the correct one,...

Michael Valentine Jones (9/8/2009)

---

How would I do with these answers?

What would you describe as your strengths?

I can answer really stupid questions without letting my contempt for the person asking the...

Dave Ballantyne (9/9/2009)

---

Although IMO , its better to base the distinction on functional need. 🙂

If you NEED to trim trailing and leading...

mohinidba (9/9/2009)

---

hi,

iam having problem with port numbers.

client is trying to connecting to sql server having 2 instances from application server using port 1433.

but in sql server i have...

Both of them use the clustered index, and both use a clustered index seek.

execution plan2 is marginally faster and doesnt have a separate operation for Compute Scalar.

So not much between...

looking at them now

Better to remove the users before the login, check as well that the user doesnt own any objects and if they used to do backups and restores, make sure that...

FNS (9/9/2009)

---

The application team say yes, they do use pooling.

I don't know if it creates new connections for each data request or reuses them in the code but...

Paul White (9/6/2009)

---

If CHECKSUM page validation is enabled for the database (and always has been*), the chances of a data corruption going undetected are rather small. So long as...

Hilda (9/8/2009)

---

Cannot add any maintenance plans after chaning the login's password. The error that my log shows is the following:

The prelogin packet used to open the connection is structurally...

the easiest thing to do is to look at the query plan. if you need help with that, just attach them here

try this and see what it returns

the first select will give you the server permissions for the account

the second select will give you the permissions within that database for...