Create and manage Store Procedures from inside VS

With a local conn to SQL2000 I can edit sprocs no problem, but if I change the connection to a remote computer (to which I have all permissions) I cannot create or manage stored procedures from within VS IDE? Is there a work around?

I noticed that a procedure written for the localhost accepts CREATE PROCEDURE and changes it to ALTER PROCEDURE. When I script the sprocs from my development machine to the server, those scripts with ALTER in them do not work. I change them to CREATE and they work fine.

I haven't found anything yet on MSDN about this, but will continue to look.

Thanks in advance,

_EHi _E

You may have better luck with this question in the SQL Server Tools - General forum.
Allan|||Thanks, I'll try there. Didn't know if it was an IDE or SQL thing.

_E

Create a cached instance of a view from a linked server?

Hi
How do i manage to create a cache of a view from a linked server?
I have this view on a linked server (takes app. 15 secs) and i would like to
have a "local" cache of this view.
What would be the best way to handle this - to ensure both performance and
consistency?
Hope somebody can give me an answer to this.. :-)Hi
Persist the data to a local table, and have a job that refreshes the table
on a regular basis.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"pnp" <pnp@.discussions.microsoft.com> wrote in message
news:ADA26A03-95C5-4737-9176-B4C114E15EA6@.microsoft.com...
> Hi
> How do i manage to create a cache of a view from a linked server?
> I have this view on a linked server (takes app. 15 secs) and i would like
> to
> have a "local" cache of this view.
> What would be the best way to handle this - to ensure both performance and
> consistency?
> Hope somebody can give me an answer to this.. :-)|||Ok, thanks...
Thought that would be the best way - but didn't know if there were any
built-in features that allowed me to do this easier.
But thanks - i'll take this road then... :-)
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Persist the data to a local table, and have a job that refreshes the table
> on a regular basis.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "pnp" <pnp@.discussions.microsoft.com> wrote in message
> news:ADA26A03-95C5-4737-9176-B4C114E15EA6@.microsoft.com...
>
>|||Replication is an option. But I wouldn't do it for just one table. Keep it s
imple.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"pnp" <pnp@.discussions.microsoft.com> wrote in message
news:4D5977DE-FB7A-4C19-8236-6E3BC3B70C8A@.microsoft.com...[vbcol=seagreen]
> Ok, thanks...
> Thought that would be the best way - but didn't know if there were any
> built-in features that allowed me to do this easier.
> But thanks - i'll take this road then... :-)
> "Mike Epprecht (SQL MVP)" wrote:
>

Create a cached instance of a view from a linked server?

Hi
How do i manage to create a cache of a view from a linked server?
I have this view on a linked server (takes app. 15 secs) and i would like to
have a "local" cache of this view.
What would be the best way to handle this - to ensure both performance and
consistency?
Hope somebody can give me an answer to this.. :-)Hi
Persist the data to a local table, and have a job that refreshes the table
on a regular basis.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"pnp" <pnp@.discussions.microsoft.com> wrote in message
news:ADA26A03-95C5-4737-9176-B4C114E15EA6@.microsoft.com...
> Hi
> How do i manage to create a cache of a view from a linked server?
> I have this view on a linked server (takes app. 15 secs) and i would like
> to
> have a "local" cache of this view.
> What would be the best way to handle this - to ensure both performance and
> consistency?
> Hope somebody can give me an answer to this.. :-)|||Ok, thanks...
Thought that would be the best way - but didn't know if there were any
built-in features that allowed me to do this easier.
But thanks - i'll take this road then... :-)
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Persist the data to a local table, and have a job that refreshes the table
> on a regular basis.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "pnp" <pnp@.discussions.microsoft.com> wrote in message
> news:ADA26A03-95C5-4737-9176-B4C114E15EA6@.microsoft.com...
> > Hi
> >
> > How do i manage to create a cache of a view from a linked server?
> >
> > I have this view on a linked server (takes app. 15 secs) and i would like
> > to
> > have a "local" cache of this view.
> >
> > What would be the best way to handle this - to ensure both performance and
> > consistency?
> >
> > Hope somebody can give me an answer to this.. :-)
>
>|||Replication is an option. But I wouldn't do it for just one table. Keep it simple.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"pnp" <pnp@.discussions.microsoft.com> wrote in message
news:4D5977DE-FB7A-4C19-8236-6E3BC3B70C8A@.microsoft.com...
> Ok, thanks...
> Thought that would be the best way - but didn't know if there were any
> built-in features that allowed me to do this easier.
> But thanks - i'll take this road then... :-)
> "Mike Epprecht (SQL MVP)" wrote:
>> Hi
>> Persist the data to a local table, and have a job that refreshes the table
>> on a regular basis.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "pnp" <pnp@.discussions.microsoft.com> wrote in message
>> news:ADA26A03-95C5-4737-9176-B4C114E15EA6@.microsoft.com...
>> > Hi
>> >
>> > How do i manage to create a cache of a view from a linked server?
>> >
>> > I have this view on a linked server (takes app. 15 secs) and i would like
>> > to
>> > have a "local" cache of this view.
>> >
>> > What would be the best way to handle this - to ensure both performance and
>> > consistency?
>> >
>> > Hope somebody can give me an answer to this.. :-)
>>

Create a cached instance of a view from a linked server?

Hi
How do i manage to create a cache of a view from a linked server?
I have this view on a linked server (takes app. 15 secs) and i would like to
have a "local" cache of this view.
What would be the best way to handle this - to ensure both performance and
consistency?
Hope somebody can give me an answer to this.. :-)
Hi
Persist the data to a local table, and have a job that refreshes the table
on a regular basis.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"pnp" <pnp@.discussions.microsoft.com> wrote in message
news:ADA26A03-95C5-4737-9176-B4C114E15EA6@.microsoft.com...
> Hi
> How do i manage to create a cache of a view from a linked server?
> I have this view on a linked server (takes app. 15 secs) and i would like
> to
> have a "local" cache of this view.
> What would be the best way to handle this - to ensure both performance and
> consistency?
> Hope somebody can give me an answer to this.. :-)
|||Ok, thanks...
Thought that would be the best way - but didn't know if there were any
built-in features that allowed me to do this easier.
But thanks - i'll take this road then... :-)
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Persist the data to a local table, and have a job that refreshes the table
> on a regular basis.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "pnp" <pnp@.discussions.microsoft.com> wrote in message
> news:ADA26A03-95C5-4737-9176-B4C114E15EA6@.microsoft.com...
>
>
|||Replication is an option. But I wouldn't do it for just one table. Keep it simple.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"pnp" <pnp@.discussions.microsoft.com> wrote in message
news:4D5977DE-FB7A-4C19-8236-6E3BC3B70C8A@.microsoft.com...[vbcol=seagreen]
> Ok, thanks...
> Thought that would be the best way - but didn't know if there were any
> built-in features that allowed me to do this easier.
> But thanks - i'll take this road then... :-)
> "Mike Epprecht (SQL MVP)" wrote:

cpu & memory usage on large, long-running query

Hi there
I'm not a SQL Server developer or power-user, mostly I do statistical and
similar analysis on large datasets and use SQL Server to manage the
underlying data.
I notice that, on my IBM workstation, my CPU utilization doesn't rise much
above 50% and my PF usage doesn't rise above 40% on large, long-running
queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
Can I whip up the speed a bit, or if not what's the limiting factor?
Best regards
Loane
If you aren't hitting any resource bottlenecks then look at
the execution plan for the queries and work on tuning the
queries themselves. One of the biggest factors will be use
of indexes. You can find a lot of information on performance
tuning at:
http://www.sql-server-performance.com/
-Sue
On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
<look_sharp_not@.hotmail.com> wrote:

>Hi there
>I'm not a SQL Server developer or power-user, mostly I do statistical and
>similar analysis on large datasets and use SQL Server to manage the
>underlying data.
>I notice that, on my IBM workstation, my CPU utilization doesn't rise much
>above 50% and my PF usage doesn't rise above 40% on large, long-running
>queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
>Can I whip up the speed a bit, or if not what's the limiting factor?
>Best regards
>Loane
>
|||Thanks Sue, will press on ...
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b2uk81lvrq2ekiq8fvgeug1f40ujnq5em9@.4ax.com...
> If you aren't hitting any resource bottlenecks then look at
> the execution plan for the queries and work on tuning the
> queries themselves. One of the biggest factors will be use
> of indexes. You can find a lot of information on performance
> tuning at:
> http://www.sql-server-performance.com/
> -Sue
> On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
> <look_sharp_not@.hotmail.com> wrote:
>

cpu & memory usage on large, long-running query

Hi there
I'm not a SQL Server developer or power-user, mostly I do statistical and
similar analysis on large datasets and use SQL Server to manage the
underlying data.
I notice that, on my IBM workstation, my CPU utilization doesn't rise much
above 50% and my PF usage doesn't rise above 40% on large, long-running
queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
Can I whip up the speed a bit, or if not what's the limiting factor?
Best regards
LoaneIf you aren't hitting any resource bottlenecks then look at
the execution plan for the queries and work on tuning the
queries themselves. One of the biggest factors will be use
of indexes. You can find a lot of information on performance
tuning at:
http://www.sql-server-performance.com/
-Sue
On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
<look_sharp_not@.hotmail.com> wrote:

>Hi there
>I'm not a SQL Server developer or power-user, mostly I do statistical and
>similar analysis on large datasets and use SQL Server to manage the
>underlying data.
>I notice that, on my IBM workstation, my CPU utilization doesn't rise much
>above 50% and my PF usage doesn't rise above 40% on large, long-running
>queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
>Can I whip up the speed a bit, or if not what's the limiting factor?
>Best regards
>Loane
>|||Thanks Sue, will press on ...
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b2uk81lvrq2ekiq8fvgeug1f40ujnq5em9@.
4ax.com...
> If you aren't hitting any resource bottlenecks then look at
> the execution plan for the queries and work on tuning the
> queries themselves. One of the biggest factors will be use
> of indexes. You can find a lot of information on performance
> tuning at:
> http://www.sql-server-performance.com/
> -Sue
> On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
> <look_sharp_not@.hotmail.com> wrote:
>
>