How do I adjust the tab settings in SQL Server Enterprise Manager.

I found how to adjust the tab settings when editing a stored procedure using
Query Analyzer, but I don't see any way to adjust the tab settings when
editing a stored procedure using SQL Server Enterprise Manager.
Does anyone know how to do this?
Thanks,
VernThere isn't. That dialog is only really appropriate for viewing the code or
copying it. You should use Query Analyzer to edit and will find the task is
much easier and cleaner.
Andrew J. Kelly SQL MVP
"Vern" <Vern@.discussions.microsoft.com> wrote in message
news:DF5D3DF0-B5EE-49C9-9816-F124D350F4F8@.microsoft.com...
>I found how to adjust the tab settings when editing a stored procedure
>using
> Query Analyzer, but I don't see any way to adjust the tab settings when
> editing a stored procedure using SQL Server Enterprise Manager.
> Does anyone know how to do this?
> Thanks,
> Vernsql

How DBA can use processor powers in an effeient way?

hi seniors ,

can any one suggest/tell me the server settings/techniques? so that sql server 2005 could take advantages of all processors powers.becuase i am experencing a lot of spikes during my peak times, during presence of 8 no of 64 bit processor server machine and 64 bit window server 2003.

Note I have enabled AWE and also have maximize the sql server processes priority Up to 13 on windows server 2003.

Regards

The 64-bit version of SQL Server does not use AWE. 64-bit obsoletes that technology.

Anyway, SQL Server should manage its CPU usage perfectly fine on its own. It's possible that a certain query is causing problems. You can use the "SQL Server Profiler" tool to monitor running queries. Its configuration can be adjusted to show only long-running or highly-demanding queries. This can help you identify the problem.

-Ryan / Kardax

|||It is completely normal to see short period of high CPU utilization.

Are you seeing a problem other than high CPU? Do you see activity on all the processors?sql

how create linked server to informix

I want to create a linked server to Informix through OLEDB.
I tried to use sp_addlinkedserver but with wanted parameters
name!!!
Bellow settings are my odbc connection that can help you to advise me ,how
to setup parameter to values
working odbc
Servername=bronz
Host Name=192.168.19.184
service=bronz
protocol=onsoctcp
database name=development
userid=user
password=pass
client locale=cs_CZ.852
database locale = cs.CZ.852
thanksTarvirdi wrote:
> I want to create a linked server to Informix through OLEDB.
> I tried to use sp_addlinkedserver but with wanted parameters
> name!!!
> Bellow settings are my odbc connection that can help you to advise me ,how
> to setup parameter to values
> working odbc
> Servername=bronz
> Host Name=192.168.19.184
> service=bronz
> protocol=onsoctcp
> database name=development
> userid=user
> password=pass
> client locale=cs_CZ.852
> database locale = cs.CZ.852
Haven't tried a linked server, but we did install Informix drivers on
SQL Server and then utilized a DTS package to regularly pull data from
an Informix source into SQL Server so we could operate on that data.
Maybe that would meet your needs?
gorf