Looks like this was posted in the wrong category (per the OP). Please direct all replies there. http://www.sqlservercentral.com/Forums/Topic1332538-1292-1.aspx

I think you just did. 😀

Most of us...

You need to explain a...

You are welcome. Hope your...

dtopicdragovic (7/19/2012)

---

🙂

It is hard to explain and the process itself is very complicated.

More I work on it gets more confusing. :angry:

We want to show to our contacts what we have...

dtopicdragovic (7/19/2012)

---

I thought more in case when user deletes for example info in some specific field. Since I update just changed info into NeedApproval.Table, I wondered what I will do...

sqlfriends (7/19/2012)

---

Thanks, I know how to check collation from SSMS and code.

I cannot connect to this server somehow from other SSMS client.

And on the server itself no SSMS installed, there...

That would far too complex to automate. What if you are using new datatypes? What about table parameters?

We can help you rework it but you need to post the script...

A quick google search would be way faster for this type of thing. I typed "view collation sql server"...here is hit #1.

http://blog.sqlauthority.com/2007/08/30/sql-server-2005-find-database-collation-using-t-sql-and-ssms/%5B/url%5D

pdanes (7/19/2012)

---

Thanks, that also helped clear up some confusion about...

Celestial (7/19/2012)

---

here is the Structure of the Table

DescriptionNode(HierarchyID)StringPath

Manager0x /

Dev Manager0x58 ...

There are several ways you could handle this. One might be to change the ISNULL to check to a case statement.

Something like:

case when na.UserID is null then ui.FName else na.FName...

Check out Gail's blog post on catch all queries. This explains a couple of ways to go about this.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

dtopicdragovic (7/19/2012)

---

Do you think it is reliable to keep staging table (in your case UpdateInfo_NeedApproval table) in the same db as the production table (in your case UpdateInfo table)?

Our web...

Right click on the database --> Tasks --> Generate scripts.

This will bring up a script wizard. You can select everything in your database including all indexes, keys, constraints etc... You...