Ratheesh.K.Nair (2/1/2008)

---

Hi All

Please help to solve this issue.

...

Jim Russell (1/30/2008)

---

I have been trying to discipline myself, and add an extended property named "Description" to any new objects (procedures, functions, views) I create.

Well, so much for documentation;...

Hi Rav,

you were not specifying what should get the new value (just an expression that evaluates to the new value)

UPDATE ASCEND_FC_INSDESC

SET FC_CODE=STUFF(FC_CODE, 1, 1, '')

WHERE LEFT (FC_CODE, 1) = '0'

Regards,

...

This is a good example of bad table design. You should not store the role membership in a single column as a list. Is this something you could change?

If not,...

Please note that the sysobjects is no longer a system table on SQL Server 2005. These have been replaced with system views, so sysobjects is a system view, which is...

JMSM (1/30/2008)

---

[font="Arial"]Hello,

Can you tell me how can i give permissions for the execution of the xp_cmdshell to one user without give the sysadmin permission. This problem appears because theres an...

Philip Horan (1/28/2008)

---

Andras I have now managed to execute the delete statement after removing the FK Constraint.

I take it I reverse the NOCHECK before re-importing the data?

Phil.

PS: Thanks...

Philip Horan (1/28/2008)

---

Hi Andras.

I launch Management Studio then connect to the Server (Server Name: My Server) using the sa account.

How would I ensure I am connected to a specific...

Philip Horan (1/28/2008)

---

Thanks for the reply. Tried to run that command against Products, sql returned error:

Cannot find the object "Products" because it does not exist or you do not have...

Hi Ido,

in terms of object names using case sensitive collation ensures...

You have one (or more) tables with a foreign keys on them that reference the table you would like to delete from. You could either delete the values from those...

Igor Marchenko (1/23/2008)

---

Hello!

I have just installed SQL 2008 (10.0.1057.4). For some reason, I do not see intellisense feature in SSMS. Is there something I need to do to...

Christian Buettner (1/23/2008)

---

Hello Andras,

could you please provide an example where TOP 1 speeds up the query?

I was always under the assumption that SQL Server would automatically TOP the query when...

antonio.collins (1/23/2008)

---

nugroho (1/22/2008)

---

Hi all,

Second Question:

SELECT * FROM Table1 WHERE (@S=1 AND CONTAINS(column1,'key1')) OR (@S=2 AND CONTAINS(column2,'key1')) OR (@S=3 AND CONTAINS(column3,'key1'))

Does SQL engine will search (CONTAINS) only in 1 column depending...

simon.letts (1/23/2008)

---

Hi, I run a lot of traces and have set them up both via t-sql and using the Profiler.

However what I need to do is have a trace run...