i think the issue is this:

SET LMTD_TRCDMA = (SELECT C.CRT_Cod,

...

doesn't a successful login set the badpassword count to zero?

ugg;

stick to the data ...without the data we cannot help.

lets forget all about formatting, cursors, everything...for now.

does this return all the records that should receive an email?

it's ok if the...

i see differences on most of my servers, too; one server is under two seconds, others as much as 37 seconds:

also, i got overflow adding the milliseconds, so i had...

i could help...

ok, based on your specific example now,

you can see you are not providing the Table1.ID, which joins Table@ and Table1 together.

so you end up inserting NULL,[name] from INSERTED, so...

kenyangyiwei (10/5/2011)

---

Receive means a new row of BLOB objects arrive at receiver SQL Server Database, how to check that? is it best to use trigger event or build a stored...

i used my Google-Fu on "linked server 4D database" and "4d database ODBC driver", thinking that should get what you need

this link seemed to have an example of creating...

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]

+ '.'...