email send/receive

How can I have my email download automatically instead of clicking send/receive all the time?

create an activation stored procedure that calls a CLR stored porcedure which calls a webservice which checks your mail.

are you sure you posted this in the correct forum?

EM frozen when viewing tables

Hi,
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual.
I
close EM and tried several times, it's still the same. How can I
troubleshoot? ThanksIs this on the actual server or on another workstation using the client tool
s?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:

> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual
. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> Is this on the actual server or on another workstation using the client to
ols?
> In any case, you may need to install SP4 on the client. If it happens on t
he
> server, you need to do an impcat analisys before installing SP4. I would n
ot
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:
>

EM frozen when viewing tables

Hi,
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual. I
close EM and tried several times, it's still the same. How can I
troubleshoot? Thanks
Is this on the actual server or on another workstation using the client tools?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:

> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks
|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> Is this on the actual server or on another workstation using the client tools?
> In any case, you may need to install SP4 on the client. If it happens on the
> server, you need to do an impcat analisys before installing SP4. I would not
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:

EM frozen when viewing tables

Hi,
When I tried to view tables of one my database (sql2000) from Enterprise
manger by clicking on Databases --> <database name> --> Tables, it got
frozen. But if I do it from Query Analyzer, I can query any table as usual. I
close EM and tried several times, it's still the same. How can I
troubleshoot? ThanksIs this on the actual server or on another workstation using the client tools?
In any case, you may need to install SP4 on the client. If it happens on the
server, you need to do an impcat analisys before installing SP4. I would not
be surprised that some applications are not up to date with the current SP
from MS.
"Jen" wrote:
> Hi,
> When I tried to view tables of one my database (sql2000) from Enterprise
> manger by clicking on Databases --> <database name> --> Tables, it got
> frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> close EM and tried several times, it's still the same. How can I
> troubleshoot? Thanks|||it's on another workstation. Restart service clears it. Thanks
"Edgardo Valdez, MCSD, MCDBA" wrote:
> Is this on the actual server or on another workstation using the client tools?
> In any case, you may need to install SP4 on the client. If it happens on the
> server, you need to do an impcat analisys before installing SP4. I would not
> be surprised that some applications are not up to date with the current SP
> from MS.
> "Jen" wrote:
> > Hi,
> >
> > When I tried to view tables of one my database (sql2000) from Enterprise
> > manger by clicking on Databases --> <database name> --> Tables, it got
> > frozen. But if I do it from Query Analyzer, I can query any table as usual. I
> > close EM and tried several times, it's still the same. How can I
> > troubleshoot? Thanks

Editing table data in Query Analyzer

Hi All !
I open a table in Query Analyzer by right clicking on it and
selecting 'Open' and when the data is displayed in the view pane I
would like to be able to edit it. It seems however that tables marked
as read only (as shown on the top bar e.g. SQL Query Analyzer - [Open
Table ServerName.DBName.dbo.TableName(read-only)] ) can not be edited
whereas the one that do not have that attribute infront of the name I
can edit. Is there a way I can change the read only attribute of a
table so that I can edit data directly in the view pane?
Please let me know if there is !
Thanks a heap ! :)

Harkirat"harry" <i1073@.tamu.edu> wrote in message
news:1105726082.290783.48450@.f14g2000cwb.googlegro ups.com...
> Hi All !
> I open a table in Query Analyzer by right clicking on it and
> selecting 'Open' and when the data is displayed in the view pane I
> would like to be able to edit it. It seems however that tables marked
> as read only (as shown on the top bar e.g. SQL Query Analyzer - [Open
> Table ServerName.DBName.dbo.TableName(read-only)] ) can not be edited
> whereas the one that do not have that attribute infront of the name I
> can edit. Is there a way I can change the read only attribute of a
> table so that I can edit data directly in the view pane?
> Please let me know if there is !
> Thanks a heap ! :)
> Harkirat

I suspect your table has no primary key (which it normally should have) or
unique index. If there's no way to identify each row in the table then you
can't edit it because there's no way to know which row you're changing. You
can still use an UPDATE statement to modify the table data of course.

Simon|||Yesssssssssss !!! That was it !! Sure wouldn't have guessed that
one...:p
Thanks a heap Simon ! :-)

Harkirat

Simon Hayes wrote:
> "harry" <i1073@.tamu.edu> wrote in message
> news:1105726082.290783.48450@.f14g2000cwb.googlegro ups.com...
> > Hi All !
> > I open a table in Query Analyzer by right clicking on it and
> > selecting 'Open' and when the data is displayed in the view pane I
> > would like to be able to edit it. It seems however that tables
marked
> > as read only (as shown on the top bar e.g. SQL Query Analyzer -
[Open
> > Table ServerName.DBName.dbo.TableName(read-only)] ) can not be
edited
> > whereas the one that do not have that attribute infront of the name
I
> > can edit. Is there a way I can change the read only attribute of a
> > table so that I can edit data directly in the view pane?
> > Please let me know if there is !
> > Thanks a heap ! :)
> > Harkirat
> I suspect your table has no primary key (which it normally should
have) or
> unique index. If there's no way to identify each row in the table
then you
> can't edit it because there's no way to know which row you're
changing. You
> can still use an UPDATE statement to modify the table data of course.
> Simon