actually, thinking about it some more, the table could be updated, but the status was already 3...

for exmaple, if a NOTES field was updated int eh table, but the status...

your issue is you are locked into thinking about one row at a time:

you think the trigger will affect one and only one row, and that you can grab a...

here's a sample trigger doing what you want....note it is assuming the update has more than one row occurring, so all the operations are set based on the virtual INSERTED...

yeah i carry the advanced version on a flash drive now that I've downloaded it;

i had a problem with VS 2005 installing; It would only install if i explicitly skipped...

you need to find the SQL Server Express 2005 with Advanced Services:

Microsoft SQL Server 2005 Express Edition with Advanced Services

that contains the Express version of SS management Studio

i didn't have studio in fromt of me; this is the correct syntax:

For i = 0 To myArray.Length...

you tried what? you didn't really say what you tried...i doubt you tried using parameters.

what are you doing? are you expecting that if the Me.textbox1.Text contains 8 lines of data,...

you should always use parameters to prevent sql injection attacks;

here's what you need to change:

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

...

personally, i think linked servers are the best way to tackle this;

a link to ServerA allows you to join to serverB , then filter the data based on the join...

I'd look for two things: how much free disk space is on the server? if it's not much over the size of the restore, that would be an issue, as...

i believe what you are seeing is the difference in the reserved space of the database....

you can create a new database right now, which is just a copy of the...

there's an XML Workshop article here [/url] on SSC that shows how to get the number of records in xml, and then loops thru the set, but it depends on...

I'm not sure what you want to do yet either;

what is in the xml? is it data ro sql commands or what?

what does your stored procedure do ?

Are you...

Christopher Stobbs (12/12/2008)

---

Looks like the TSQL column is too small you either need to do as Lynn said and disable the triggers or simply alter the table and extend the...

i believe COALESCE requires all parameters to be the same data type, right?

Coalesce(int,varchar) will fail.

this fails:

select(coalesce([Number],' Not Assigned')) from

(SELECT 1 AS [Number] UNION

SELECT 2 UNION

SELECT NULL...