Here is another option in the SQLCLR-space for concatenating grouped strings:

GROUP_CONCAT string aggregate for SQL Server[/url]

Something like this?

IF EXISTS ( SELECT *

FROM sys.objects

...

Anytime. Thanks for the positive feedback!

drew.allen (4/20/2012)

---

There is a third option. Update the rows in Table2 so that the constraint will still be valid after the delete. You can either update that column...

kodalisridevi (4/20/2012)

---

I need to delete rows in table 1 :

I am getting an Error message :

The DELETE statement conflicted with the REFERENCE constraint "FK_Users_Divisions". The conflict occurred in database "BidManagerCommon",...

Please do not cross-post. It only fragments replies and wastes people's time. Direct all replies here:

http://www.sqlservercentral.com/Forums/Topic1287003-146-1.aspx

I assume you're planning to replicate from Oracle to SQL Server or vice-versa? Golden Gate being an Oracle product you may do better on Oracle Technet.

For the record SQL Server...

S_Kumar_S (4/20/2012)

---

Hi

Although I have seen clarifications on the difference between these 2 events, but I am still not very clear practically.

My purpose is to run a trace that captures procedure...

DTLoggedExec[/url]

I have seen that happen when a Domain Controller is restarted. If the Domain Controller restarted was the one cached by your application server the authentication errors begin...and unfortunately the...

rickeb1 (4/20/2012)

---

Thanks very much for the response! Yep, doing that worked fine. So now my question is, if I have a function (and only the function) defined in...

What do you mean by "dynamically". I usually create a config file through one of the packages, then if I want to use that config in another package I'll open...

Note that ONLINE indexing is only available in Enterprise, Developer and Evaluation Editions of SQL Server 2005 and above.

If the only contents of your script are the function definition you showed, then all your script does is define a function...now you have to call it 🙂

Try running a...

Sure you can...I do it all the time. When you have...