the purpose of encryption is to not store the data unencrypted at all, storing it both ways makes sense during the testing/development phase, but not after you've proved the encryption...

if you've gotta do it via TSQL, instead of stepping out via SMO to get it , i've spent a lot of time refining a few stored procedures to do...

i thought you had to get the actual counts from sys.indexes; since the index must have a heap/PK index for every table, teh row counts are materialized exactly correct there:

SELECT...

well there's only two solutions:

1. modify the Oracle...

relaying is sending emails to addresses that the SMTP server doesn't actually administrate itself.(ie gmail.com forwarding to yahoo.com)

Also remember there are two kinds of relaying:

anonymous relaying and relaying for an...

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...