you'll have to explain...it depends on what you mean by "received"

if they are "received" in a folder on the disk, vs "received" a s in a new row is created...

File operations directly from TSQL are a pain.

SQL server is designed to fiddle with objects INSIDE a database, and as soon as you want to step outside of that context(to...

AndrewSQLDBA (10/4/2011)

---

Is there a simple way to update All columns in a single table? Other than selecting the column name from the syscolumns table and writing an update statement with...

you have...

you have to define the column names for the inserts:

create trigger sampletrigger

on sample view

instead of insert

as

insert into basetable1(name,id) --right names?

select name,id from inserted

insert into basetable2(result) --right column name?

select result from...

Colleen you are defining it in the Cascading Style Sheets of the template, right?

the tag in CSS is the background-color:

BODY { background-color: #EFEFEF;}

sure!

this was the first select + collation example i had in my snippets:

SELECT

'REVOKE ' + convert(varchar(50),x.[Action])

+ ' on ' + x.[Schema]

+ '.'...

i'm guessing here, but i'm thinking that using a FOR XML to concatenate the itwm field into a comma delimited list might be what you are after;

here's a basic example...

is the login the user is connected to a member of the sysadmins?

is "User1" really a domain account like myDomain\User1 that might be inheriting BuiltIn\Administrators,?

not sure what you mean by elimination, nor what data you wanted at the end;

to me it looks like you have to join the table agaisnt itself...

is this right?

/*

--Results

organization account...

mohammed moinudheen (10/4/2011)

---

There could be problem with your SMTP server. You might need to check with your network team regarding this to verify if ports are open etc. for the...

for me, cursors are ok in certain situations...when dealing with metadata items like you are.

my rule of thumb is: if it's in one database, no cursors allowed.

so the corallary...

it's pretty well documented that SQL will keep data for a TEXT datatype in a varchar(8000) as long as it's less than 8000 chars, otherwise it's stored a different way,and...

your sample data didn't show the "or" part of your query...all the data would be returned regardless, because the4y are all between your start and end dates.

i changed the sample...

paul take a look at this thread from a while ago

http://www.sqlservercentral.com/Forums/Topic1115027-359-1.aspx

in that thread, I slapped together an example of a proc that executed as dbo,and did the following:

created(or found) a...