HowardW (3/31/2011)

---

If the application calls a Stored Procedure that you do have access to, then yes, you can wrap it in a TRY...CATCH block and raise a custom error message.

If...

What Yuri55 said plus scheduling your SP to kick off when SQL Server starts should get you where you want...

Gianluca Sartori (3/31/2011)

---

From your private message:

The first entry for the google search I suggested points...

Please do not cross-post, it just fragments responses.

Direct all comments here: http://www.sqlservercentral.com/Forums/Topic1087179-1632-1.aspx

Not that you won't get help in this forum...but you may have better luck in one of the Reporting Services forums:

http://www.sqlservercentral.com/Forums/Group416.aspx

I looked around for a way to do the update all in one statement and I think it's possible using the query() method on the XML data type column and...

Craig Farrell (3/31/2011)

---

opc.three (3/31/2011)

---

You'll notice that a clustered index was not defined as part the CREATE TABLE statement and I was pointing out that in the absence of a, [explicitly]...

WayneS (3/31/2011)

---

Not so. A table either has a clustered index (clustering...

You said you had already created database objects to hold your data. Please re-read my previous post. If you're not sure what I am asking please read this article: http://www.sqlservercentral.com/articles/61537/

Would something along these lines work?

DECLARE @xml XML = N'<package>

<header>

<recipient>123456</recipient>

</header>

<contact>

<first_name>John</first_name>

<middle_name />

...

Have you looked into tools like Red Gate SQL Data Compare or the Data Compare functionality within Visual Studio 2010 to see if it will do what you want?

If those...

Here is a query that uses INFORMATION_SCHEMA that will run fine on 2000 and 2005. (Option 1 from ColdCoffee).

SELECT t.TABLE_CATALOG,

t.TABLE_SCHEMA,

...

Double-post...direct comments here: http://www.sqlservercentral.com/Forums/Topic1086425-148-1.aspx

What version of SSIS are you running? What OS? I know you posted in the 2005 SSIS Forum but we do not have a 2008 Forum and I saw you...

Cross-post, direct comments here: http://www.sqlservercentral.com/Forums/Topic1086425-148-1.aspx