Help on Showing Querry Execution Plan in SQL Server Management Studio

Hi Everybody,
I am trying to run a querry (calling a sp) in SQL Server Management
Studio and have it display the Execution Plan.
When I try to do this SQL Server creates a system tempdb table that
eats up all my physical memory (goes over 20 + gig and keeps growing
until the computer can't take it anymore and dies... I actually have
to manually get rid of that table for my computer to ba able to
runnormally again).
I am doing some research online about this but so far can't find
anything...
Is there a way I can avoid SQL server from creating that tempdb table
when I want to show the execution plan for a querry? or is there any
setting I can modify to avoid that tempdb table to keep growing?
Thanks a lot,
Taslim
PS: My computer is a P4 3.06 Ghz, 1.25 gig ram and has 24 gig free
physical memory...sqlserver uses tempdb for its workspace. so, the answer is 'no'.
from the sound of your description, this must be some sproc that does tons
of dml operations!
-oj
<taslimn@.gmail.com> wrote in message
news:1149616073.134649.115920@.h76g2000cwa.googlegroups.com...
> Hi Everybody,
> I am trying to run a querry (calling a sp) in SQL Server Management
> Studio and have it display the Execution Plan.
> When I try to do this SQL Server creates a system tempdb table that
> eats up all my physical memory (goes over 20 + gig and keeps growing
> until the computer can't take it anymore and dies... I actually have
> to manually get rid of that table for my computer to ba able to
> runnormally again).
> I am doing some research online about this but so far can't find
> anything...
> Is there a way I can avoid SQL server from creating that tempdb table
> when I want to show the execution plan for a querry? or is there any
> setting I can modify to avoid that tempdb table to keep growing?
> Thanks a lot,
> Taslim
> PS: My computer is a P4 3.06 Ghz, 1.25 gig ram and has 24 gig free
> physical memory...
>

Help on Showing Querry Execution Plan in SQL Server Management Studio

Hi Everybody,
I am trying to run a querry (calling a sp) in SQL Server Management
Studio and have it display the Execution Plan.
When I try to do this SQL Server creates a system tempdb table that
eats up all my physical memory (goes over 20 + gig and keeps growing
until the computer can't take it anymore and dies... I actually have
to manually get rid of that table for my computer to ba able to
runnormally again).
I am doing some research online about this but so far can't find
anything...
Is there a way I can avoid SQL server from creating that tempdb table
when I want to show the execution plan for a querry? or is there any
setting I can modify to avoid that tempdb table to keep growing?
Thanks a lot,
Taslim
PS: My computer is a P4 3.06 Ghz, 1.25 gig ram and has 24 gig free
physical memory...sqlserver uses tempdb for its workspace. so, the answer is 'no'.
from the sound of your description, this must be some sproc that does tons
of dml operations!
--
-oj
<taslimn@.gmail.com> wrote in message
news:1149616073.134649.115920@.h76g2000cwa.googlegroups.com...
> Hi Everybody,
> I am trying to run a querry (calling a sp) in SQL Server Management
> Studio and have it display the Execution Plan.
> When I try to do this SQL Server creates a system tempdb table that
> eats up all my physical memory (goes over 20 + gig and keeps growing
> until the computer can't take it anymore and dies... I actually have
> to manually get rid of that table for my computer to ba able to
> runnormally again).
> I am doing some research online about this but so far can't find
> anything...
> Is there a way I can avoid SQL server from creating that tempdb table
> when I want to show the execution plan for a querry? or is there any
> setting I can modify to avoid that tempdb table to keep growing?
> Thanks a lot,
> Taslim
> PS: My computer is a P4 3.06 Ghz, 1.25 gig ram and has 24 gig free
> physical memory...
>sql

Help me!

Hi Master!
I'm students in NIIT. I need info of Data management Strategies of SQL
Server to write Project and I dont' know Find Topic where. Pls send to me
Everything like i talk above.
I speak Eng not good, beacause I'm VietNamese. So sorry!!
Pls send back faster, i very need it.
Thanks for your Help!!
Hi
"Inside Microsoft SQL Server 2000" by Kalen Delaney
Hardcover: 1088 pages
Publisher: Microsoft Press; Book & CD edition (November 15, 2000)
Language: English
ISBN: 0735609985
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Thanh Hai" wrote:

> Hi Master!
> I'm students in NIIT. I need info of Data management Strategies of SQL
> Server to write Project and I dont' know Find Topic where. Pls send to me
> Everything like i talk above.
> I speak Eng not good, beacause I'm VietNamese. So sorry!!
> Pls send back faster, i very need it.
> Thanks for your Help!!
>
>
|||http://www.microsoft.com/technet/its.../smfstomg.mspx
"Thanh Hai" wrote:

> Hi Master!
> I'm students in NIIT. I need info of Data management Strategies of SQL
> Server to write Project and I dont' know Find Topic where. Pls send to me
> Everything like i talk above.
> I speak Eng not good, beacause I'm VietNamese. So sorry!!
> Pls send back faster, i very need it.
> Thanks for your Help!!
>
>

Help me!

Hi Master!
I'm students in NIIT. I need info of Data management Strategies of SQL
Server to write Project and I dont' know Find Topic where. Pls send to me
Everything like i talk above.
I speak Eng not good, beacause I'm VietNamese. So sorry!!
Pls send back faster, i very need it.
Thanks for your Help!!Hi
"Inside Microsoft SQL Server 2000" by Kalen Delaney
Hardcover: 1088 pages
Publisher: Microsoft Press; Book & CD edition (November 15, 2000)
Language: English
ISBN: 0735609985
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Thanh Hai" wrote:
> Hi Master!
> I'm students in NIIT. I need info of Data management Strategies of SQL
> Server to write Project and I dont' know Find Topic where. Pls send to me
> Everything like i talk above.
> I speak Eng not good, beacause I'm VietNamese. So sorry!!
> Pls send back faster, i very need it.
> Thanks for your Help!!
>
>|||http://www.microsoft.com/technet/itsolutions/cits/mo/smf/smfstomg.mspx
"Thanh Hai" wrote:
> Hi Master!
> I'm students in NIIT. I need info of Data management Strategies of SQL
> Server to write Project and I dont' know Find Topic where. Pls send to me
> Everything like i talk above.
> I speak Eng not good, beacause I'm VietNamese. So sorry!!
> Pls send back faster, i very need it.
> Thanks for your Help!!
>
>

Help me!

Hi Master!
I'm students in NIIT. I need info of Data management Strategies of SQL
Server to write Project and I dont' know Find Topic where. Pls send to me
Everything like i talk above.
I speak Eng not good, beacause I'm VietNamese. So sorry!!
Pls send back faster, i very need it.
Thanks for your Help!!Hi
"Inside Microsoft SQL Server 2000" by Kalen Delaney
Hardcover: 1088 pages
Publisher: Microsoft Press; Book & CD edition (November 15, 2000)
Language: English
ISBN: 0735609985
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Thanh Hai" wrote:

> Hi Master!
> I'm students in NIIT. I need info of Data management Strategies of SQL
> Server to write Project and I dont' know Find Topic where. Pls send to me
> Everything like i talk above.
> I speak Eng not good, beacause I'm VietNamese. So sorry!!
> Pls send back faster, i very need it.
> Thanks for your Help!!
>
>|||http://www.microsoft.com/technet/it...f/smfstomg.mspx
"Thanh Hai" wrote:

> Hi Master!
> I'm students in NIIT. I need info of Data management Strategies of SQL
> Server to write Project and I dont' know Find Topic where. Pls send to me
> Everything like i talk above.
> I speak Eng not good, beacause I'm VietNamese. So sorry!!
> Pls send back faster, i very need it.
> Thanks for your Help!!
>
>

Help me to connect

TITLE: Connect to Server

I have downloaded the sql server express edition 2005 .When i open Sql Server Management Studio i am unable to connect this is the error message Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)

hi,

are you sure this is the exact exception you are reported with, or does the error message say "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection"?

if this is the case, SQLExpress install by default disabling standard SQL Server authenticated connections.. only WinNT trusted connections will be available.. you can thus connect via a local Windows account member of the local\administrators group, as this group is by default granted login to local SQL Server instances...

once you are connected, you cane use SQL Server Management Studio to modify this behaviour after install time... you can select the "server"'s properties and, in the "security" tab (ok, it's no longer a tab, but I hope you understand my meaning) and enable "SQL Server and Windows authentication mode".. this will enable mixed security authentication, allowing you to connect with standard SQL Server logins..

as regard "sa" login, please verify it's property (node Security->Logins) and, in the "status" tab (again, it's no longer a tab :D) check that the login is "enabled"..

regards

|||

Hi,

I was able to connect to sql server with local Windows account member of the local\administrators group.now in "server"'s properties and, in the "security" tab which one is SQL Server and Windows authentication mode".. I am able to see only the logins

1. Builtin/Administrator

2.BUILTIN/Users

3.Khatri/SQLSERVER2005MSFTEUSER$KHATRI$MSSQLSERVER

4.Khatri/SQLSERVER2005MSSQLUSER$KHATRI$MSSQLSERVER

5.NT AUTHORITY\SYSTEM

6.Sa

and also i see tht-for all the above login properties , In the status tab permession is grant and login is enabled for all the above,In the general tab i am unable to select any of them as they disabled or out of focus.

Which one to select?Please help me out

Thank You

Amitha.

|||

hi,

>1. Builtin/Administrator

>2.BUILTIN/Users

>3.Khatri/SQLSERVER2005MSFTEUSER$KHATRI$MSSQLSERVER

>4.Khatri/SQLSERVER2005MSSQLUSER$KHATRI$MSSQLSERVER

>5.NT AUTHORITY\SYSTEM

al these are WinNT related logins, used someway with trusted connections...

you only have

>6.sa

as standard SQL Server login...

after you modify the security setting, you have to restart the service in order standard SQL Server authenticated logins to be granted connection...

>and also i see tht-for all the above login properties , In the status tab permession is >grant and login is enabled for all the above,In the general tab i am unable to select >any of them as they disabled or out of focus.

please excuse me, but I'm unable to understand your requirements.. can you please expand on this?

thank you