Definitely care. That's not the purpose of these forums.

I'd really recommend spending a couple hundred $'s on one of the tools. This is likely something you'll be doing on a regular basis and the tools also help...

Another option is do buy one of the comparison tools: RedGate SQLCompare, ApexSQLCompare, xSQLCompare. These do a schema comparison and will make the changes or generate the scripts necessary...

For anyone who may stumble upon this thread and wonder what the solution is, the error is in the WHERE clause.

where user_defined_id in (26) AS 'CLASSIFICATION'

should be

where user_defined_id...

I still don't understand exactly what you are asking. Do you want to know how to restrict users from deleting a specific row from a table?

Here's an article[/url] that...

GilaMonster (11/19/2009)

---

Jack Corbett (11/18/2009)

---

Well then ask some questions. What are you confused about? I'm sure Gail, the author, will try to...

The main way is to make sure you have applied security using the least privileges method. Basically only give users the rights they need. So none of your...

Well then ask some questions. What are you confused about? I'm sure Gail, the author, will try to clarify, and I'll...

Pedro,

The answer is it depends on what you are doing. Replacing a cursor with a while loop is still not creating a set-based solution. SQL Server is designed...

I should have asked this before, but if the data is "mostly static" why do you need nolock? With mostly static data you shouldn't have much in the...

No problem Bru. Yours worked, but with some caveats, and using yours helped me clarify mine. I was originally excluding the Windows Groups.

Ankur, I'd share if I...

Alvin Ramard (11/18/2009)

---

Lynn Pettis (11/18/2009)

---

You mean I have been hitting...

Wish I knew the answer. Will ask some friends.

Do want to log the update if the data in the column does not change. For example:

Update Table

Set column = column

Will cause an update trigger...

Bru Medishetty (11/18/2009)

---

Use this script

select [NAME] from dbo.syslogins where isntname = 1

If I am not wrong SQL Server does not store the First Name , Last Name of the...