why? has the database come from another server and already has users (orphaned)?

shanila_minnu (5/20/2009)

---

i want to know the difference between login and users...

if a request came, "provide access to the database ABC of the server XYZ" what should i do...will i have...

Are you connecting from an application or via SSMS.

Is your system ste to mixed mode? If so its not advisable to be using SA anyway. Better to register your windows...

DUPLICATE POST. Please ignore. content removed.

You mean you cant remember all 11,098 responses off-hand? Tut-tut I'm disappointed?;-)

GilaMonster (4/28/2009)

---

Why, why, why do you want to shrink the log? It's very likely going to grow again, the shrink uses resources, the grow uses resources (possibly at the worst...

Gail, Steve,

Thanks for the speedy response. Sorry I took a while to respond, had what the wife calls a 'man-cold', though i'm sure its 'bird flu'.

Anyhoo, thanks for the response,...

Sorted! Thanks anyway. 🙂

Is this the line you mean?

What is this in context with. It looks like an error with the native client. What...

Is this the line you mean?

What is this in context with. It looks like an error with the native client. What...

It is not clear what you are asking here. I assume you did not mean to create the survey style (radio) buttons. If you are trying to put in a...

AshaRRichardson2nd (3/24/2009)

---

I need to add a disk to a sql 2000 cluster. I remember how to add the disk through cluster administrator, but what I can't remember is if...

Agree with 'SQL Noob'.

We tend to failover to passive node (out of hours), switch off the now passive node and then run the patch on the active.

The idea here being...

Cool 🙂

Make sure to say changes as this triggers the ssis package to recompile. 😀

Hey there,

Based on what you have said i would imagine that there is a database that has been removed and the job hasnt been recompiled. Do you run for all...