If you are talking about comparing a table in SQL Server to it's assumed equivient table by the same name on oracle, two important things are the way an IDENTITY...

I'm a bit confused...the PK will be the hashed binary/varbinary column? And you need to search the column? That doesn't sound right at all.

I don't think you can search for...

one of either two ways: send as plain text:

@body_format = 'TEXT',

or, as i mentioned before, add an extra column that will have a "<BR>"

@query = 'SELECT ##TableTemp.*, <BR> AS...

one of the many optional parameters sp_send_dbmail allows you to include the results of a query as either an attachment, or as part of the body of an email.

here's a...

i don't think it's 32 bit vs 64;

it might be that your zipgenus app is returning an error at teh command line that you are not seeing...

could you try this...

when you run xp_cmdshell, you are not running under your own credentials....

prove it to yourself by running this, which will show you what NT name you are running cmdshell from.

DECLARE...

the server executable itself is always installed on the same disk the %SYSTEMDRIVE% directory exists; databases, traces ,previous backups you can discover form some of the system views, but...

here's a single SQL with both examples:

formatted zip, and jsut the first 5:

select CASE

WHEN LEN(ZIPCODE) > 5

...

are you familiar with using the GROUP BY statement? i think a SQL combined with some of the functions that are allowed using group by (MIN(),MAX()AVG())

would get you what...

we'd really need the exact error you are getting...and also the exact code you are doing to really help. All i can offere is generalities.

where is param1 and param2? are...

it's working for me, but you had a lot of reserved words for your column names, so i quoted them, and see it's working that way.....:

With MyQuickTable AS (

SELECT 'MONTH_20101006_1_out.txt'...

ok just checking the basics here...at my job, for example, google mail is blocked by our firewall because it's a corporate time waster...utube/facebook etc are all blocked as well...could google...

here you go: visually, this is exactly how my gmail account is set up, and it works...the important piece is the port and mailserver address:

so are you not allowed to setup dbmail on the SQL server, or you just don't have a specific SMTP mail server that you know you can use?

I've setup a...

do you mean you want to create a role so that when users connect, the tables are read only?

USE Whatever

CREATE ROLE [ReallyReadOnly]

--give reader writes to this...