well, it's pretty straight forward to do in a trigger, but i would just make the [edit] column a calculated field instead and get rid of the trigger idea altogether.

...

i think there's an issue where if you concatenate a varchar(max) with a varchar(somethingless) it will concat to a varchar(8000)

i think you have to explicitly use all (max) variables, or...

look at what you pasted from BOL: it is NOT doing EXECUTE @SomeVariable = sp_executesql

that is where your error lies. you want to test the value of the OUTPUT...

you are both asigning the variable to the true/false results, and expecting it to have a parameters OUTPUT; so for a picosecond the @sendmail has a value returned from the...

what the original poster calls a "group" is what books on line calls a "role". you typically create a role and add the expected rights tot eh role, then add...

Brian I have this saved in my snippets as the solution for getting most of the command(DBCC inputbuffer is limited to 256 chars)

this worked at the end of a long...

this seems to work for me...

create table old_table(columnOne varchar(30),existing_col int )

insert into old_table

SELECT '119',119 union all

SELECT '129',129 union all

SELECT '125',125 union all

select '100',100

IF NOT EXISTS ( SELECT * FROM...

I think you can also switch to dynamic SQL; in that case the ALTER would be fully committed for the next state,ment.

it all comes down to connectivity.

for example, if a server is exposed to the internet, you can connect by IPAddress-comma-port instead of machine name: ie 209.191.122.70,1433 and then use a...

on any one physical server, you may install as many instances as you want under that license.

the license is really per machine, not per instance.

http://download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%20SQL%20Licensing%20Overview%20final.docx

i had not seen anyone try that before...getting a file from an url.

I'm awful sure the retrieving of an attachment is a file operation only, and the file must exist...

i don't think you can have variable names with the dash in them...it's interpreted as trying to minus something from the value @sd

change your variable to @sd adn @sdaux and...

for whatever reason, reading email and/or attachments was possible in SQL 2000, but deprecated for 2005 and above, i believe.

the code to read a POP3 mailbox in .NET is pretty...

sushantkumar1984 (7/22/2010)

---

@ lowell

So the synonyms A,B and C which i created will be local to database level or server level..?

and how to deallocate those synonyms once the use is over?

thanks

Sushant

Virgin...

sushantkumar1984 (7/21/2010)

---

is there a method to avoid writing the server name in a query..

like xyz.dbname.dbo.tablename1 A

xyz.dbname.dbo.tablename2 B

...