what kind of errors did you see int eh log? exact error messages help us diangnose a lot better;

if there were no messages at all,

i think you'll need to...

check to see fi there is a specific error coming back from the SMTP server:

it sounds like the email goes out but is never received;

it might be no relaying allowed,...

assuming the Oracle view is updatable because it has no aggregates or calculated columns, it's exactly the same as any other insert.

if it's not, you have to insert into the...

this CLR code is really nice, and something i have on my dev server:

http://www.simple-talk.com/sql/t-sql-programming/clr-assembly-regex-functions-for-sql-server-by-example/

for the expression itself, it looks very close to the format for an ip address;

take a look...

an index seek would only occur if it was looking for one value, or a range of values that were consecutive; otherwise it has to scan the index, right?

so WHERE...

Access has linked servers?

i think i just read your question wrong.

If you've correctly set up an Oracle Linked server, you can first use sp_tables_ex MyOracle and you should see a...

someone else does the same crap for anything barcode related because he made some plug in he's selling; annoying, to say the least, I agree.

not with a mirror; the mirror is a read only copy of whatever is in production, right?

It's been a while since i did this, but i think you...

ok here's one way to do it with SQL2000:

declare @sql_handle-2 binary(20),@spid smallint;

declare c1 cursor for select sql_handle,spid from master..sysprocesses where spid >50;

open c1;

fetch next from c1 into @sql_handle-2,@spid;

while (@@FETCH_STATUS...

wow SQL 2000;

edit : whoops this is clearly for 2005 or above; let me look again in my snippets; i know i have something

I have this proc saved in...

the error "identifier too long" is probably because a column name is longer than 30 characters, which is the Oracle size limit on object names.

review the table you are trying...

you can also do it SQL2000 style(before the wonderful row_number/ranking functions came out) , using nested TOP statements to get the top 11, and then the top 2 of...

you can get a pretty good copy of the table , which would not have the any foreign key constraints, by doing something with the INTO statement:

SELECT *

INTO MyNewTable

FROM MyLinkedServer.DatabaseName.dbo.TargetTable

WHERE...

I Am probably reading this wrong:, but since I never stay at a Holiday Inn Express, I don't have the required Expertise:

http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx

but i don't see a # of connections...

that is by design, and the normal behaviour for SQL server:

SQL tries to keep everything in memory to support subsequent queries. if you leave an installation at it's default settings(2...