Jeff Moden (11/25/2009)

---

I'll start a new post called "Companies that Use SQL Server" (so that the search engines can easily find it) and post the link here... gimme...

In addition to Sabya's question, have you checked if the the Job is running under the context of SQL Agent and with Admin rights?

Task Manager does not always show the correct memory usage of SQL Server.

The results show that SQL Server is using the 55 odd Gigs you have configured it to.

Any clue...

Run this query and post what's the values returned.

select * from master.dbo.sysperfinfo where counter_name LIKE '%Memory%'

and [object_name] like '%SQLServer:Memory Manager%'

Is your problem solved, what do mean by "already tried that one"

Which one did you try already?

No clarity in either of your posts 😉

Look at the performance monitor for the Memory SQL Server is utilizing.

Tom West (11/25/2009)

---

How do I set it up? Is there anything specific I need to do for SQL to see it as a distributor?

All servers are Windows Server 2003...

Before someone might suggest, let me tell you that you can also use Except clause.

SELECT town FROM table1

EXCEPT

SELECT town FROM table2

Can't help much without description about the tables / column names.

But let me give a try...

SELECT column list from table1 where town NOT IN (SELECT DISTINCT town FROM table2)

That's obvious, and if it's a production server, inform the application team / owners...

I am confused now...:-)

Use having clause at the end.

having [Purchase_%] > 50

I did not try on your query since I don't have the table / column details.

vikas bindra (11/25/2009)

---

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'ProfName',

@recipients = '',

@query = 'SELECT 1,1,1,1,1',---specify your select query here

...

Thanks Jason, Lynn, Grant and GSquared on your welcoming replies.

As Grant adviced, I am all set and ready for the ride.

Congrats Jason on joining the top 100.

Explanation is understood, still, each data file of 1 GB may cause way too many files.

SQL Server does not create a data file automatically. You need to do a custom...