I'm not sure the return code will help; it signifies whether the procedure executed without errors or not...not whether the email was sent successfully. the email gets sent asynchronously, when...

i think you'll just have to wrap a section of the query into a subquery, since the data has to be filtered on the LIKE statement first;

because the second part...

also you said "online database"...maybe you meant you are using a web server and a database together?

in that case, the web server can return the IP Address and mac address...

are you familiar with connections to the database?

every connection is assigned a uniqueID..the @spid...they are typically an integer starting at 51, and goes up.

in any of your database code, you...

one of the DMV's has the IP address in 2205 and above:

select host_name(),app_name(),client_net_address from sys.dm_exec_connections where session_id = @@spid

i tend to use this snippet for auditing:

SELECT

getdate() as...

here's what i use.

note you have to download the command line version of 7zip. like all other zip files i know of, you cannot use the GUI, it's always a...

if you are importing data, i think BULK INSERT can do anything that BCP was going to do;

writing to a file is a different matter.

just alter the definition of the computed column so it includes a cast or convert;

however, since a DATE datatype doesn't have the time portion, i think you could get...

they are easy to find, you just have to realize they are not real tables...they are Views...and they are also system views, so they are in a seperate folder in...

a synonym is an alias...it can be anything, but obviously it needs to make sence to...

yes, you can create a synonym that points to the linked table.

a synonym must point ot an object...procedure,function, table view, etc.

it cannot point to part of a name.

sp_tables_ex MyLinkedserver

DROP SYNONYM...

same datatype as the column it's on....there's rare exceptions where you make an index on a persisted calculated column that is the substring of a column, so then it's the...

exactly;

I've got one table, for example, that i update every two hours during biz hours , and...