on a similar issue, if you want to drop a FK on a column, but don't know the actual FK constraint name, i made the proc below...

you simply call

EXEC DROP_FK_FROM_SPECIFIC_COLUMN...

the error tells you exactly which line to go to to fix it....

it's pure syntax:

Msg 102, Level 15, State 1, Procedure SP_ResetCreditLimit, Line 32

Incorrect syntax near 'UPDDATE'.

Update is misspelled. remove...

i use something like this, involving an ORDER BY featuring a case statement:

i want nulls at the end, but non-numerics at the beginning;

ORDER BY

CASE WHEN ISNULL(Yourfield) = 1...

if you add the access database as a linked server, you can treat it as any otehr table...

so you could SELECT...INTO NEWTABLENAME FROM ACCESS:

for example, if you created a linked...

yes, but he needs the same WHERE clauses in his subsequent inserts/updates to his other three tables....so I thought he needed the comparison for the later SQL's....

same thing, different island,...

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...