i believe the error is related to the fact that you have TWO left outer joins, but only one [ON]

you meant to left join S2 to S1, and then S3...

it's not possible.

if they login with a SQL logon, their windows information is not available.

other variables, like hostname, can let you know their machine name, but if it wasn't used...

i may have skimmed over your post too quickly and missed something, but it looks like you can get rid of all the variables, and simply fix the trigger to...

I opened my SQLStudio.bin file with a text editor, and it's a mix of readable strings and binary stuff;

when i looked into this before, every recommendation was to simply delete...

that threw me off too, as i expected it to be in a registry setting, but it's actually in a binary file.

it's an all or nothing thing, as far as...

i see two solutions here...raise an error or put the old value for the BI column back, and allow the transaction to go through.

something like this would simply put the...

no, you can't; the OUTPUT variable has access to the INSERTED and DELETED tables only;

so you need to pass in your original Id for example, so it could be part...

since SQL 2000 is limited to varchar(8000), and you may...

yeah i think you'll want to insert the output into a table variable, then join it to the original table to get everything you need:

DECLARE @myTableVariable TABLE(NewBrand_ID int,BrandName varchar(30) )

INSERT...

kancherla.ks (10/19/2010)

---

Hi Thanks for the prompt response,your scripts are helpful

but we are not aware what kind of HTML tags and the sqlscripts they might send us as we...

i use a regualr expression to remove what i think of as "malicious" keywords from a simple web page that is supposed to provide SELECT only statements;

this would be...

row number is what you want in this case;the key to it the PARTITION BY, which groups the rows based on the selected columns.

here's an example; if you look at...

i looked at this, and it seems the best solution would be a CTE so you can use regular expressions, right?

then you can find the word breaks before and after...

yes.

a backup is saved as a specific version, ie SQL 2008, so you can restore it on any same or higher version , ie Standard/Developer/Enterprise/Workgroup/Small Business/Express as well(given the db...

whenever i see a performance issue featuring "stored procedure" and "parameter driven", i think either out of date statistics or parameter sniffing as the core causes to look at first.

We'd...