What is the main difference between SQL Server Express Utility and SQL
Server Server Management Studio Express? Can they both be used to
connect to SQL Server 2005 databases? Which one do you folks prefer?
Thanks,
J.S.
J.S. wrote:
> What is the main difference between SQL Server Express Utility and SQL
> Server Server Management Studio Express? Can they both be used to
> connect to SQL Server 2005 databases? Which one do you folks prefer?
> Thanks,
> J.S.
I think the overview on this page says it all:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Tracy McKibben wrote:
> I think the overview on this page says it all:
> http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
It mentions about the SSMSE but not about the SQL Server Express Utility.
Thanks,
J.S.
|||J.S. wrote:
> Tracy McKibben wrote:
>
> It mentions about the SSMSE but not about the SQL Server Express Utility.
> Thanks,
> J.S.
My mistake, I thought you were comparing the Express GUI to the full
product. Isn't the Utility product a command-line tool?
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Tracy McKibben wrote:
> My mistake, I thought you were comparing the Express GUI to the full
> product. Isn't the Utility product a command-line tool?
It might well be. I have only been using SSMSE but I'll install the
utility tool and see how it works.
Thanks,
J.S.
|||SSEUtil is a command line tool designed mainly to allow you to work with
User Instances. The other tools can't start up a user instance for example
but must attach to a running instance so if you are going to use the
standard SQL Server tools you may have to use SSEUtil to start up the user
instance first. There's more information on user instances here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"J.S." <jss@.nospam.com> wrote in message
news:Ot3c83JGHHA.2464@.TK2MSFTNGP06.phx.gbl...
> Tracy McKibben wrote:
> It might well be. I have only been using SSMSE but I'll install the
> utility tool and see how it works.
> Thanks,
> J.S.
sql
Showing posts with label studio. Show all posts
Showing posts with label studio. Show all posts
Thursday, March 29, 2012
Difference between SQL Server Express Utility and SQL Server Server
What is the main difference between SQL Server Express Utility and SQL
Server Server Management Studio Express? Can they both be used to
connect to SQL Server 2005 databases? Which one do you folks prefer?
Thanks,
J.S.J.S. wrote:
> What is the main difference between SQL Server Express Utility and SQL
> Server Server Management Studio Express? Can they both be used to
> connect to SQL Server 2005 databases? Which one do you folks prefer?
> Thanks,
> J.S.
I think the overview on this page says it all:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> I think the overview on this page says it all:
> http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
It mentions about the SSMSE but not about the SQL Server Express Utility.
Thanks,
J.S.|||J.S. wrote:
> Tracy McKibben wrote:
>> I think the overview on this page says it all:
>> http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
>
> It mentions about the SSMSE but not about the SQL Server Express Utility.
> Thanks,
> J.S.
My mistake, I thought you were comparing the Express GUI to the full
product. Isn't the Utility product a command-line tool?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> My mistake, I thought you were comparing the Express GUI to the full
> product. Isn't the Utility product a command-line tool?
It might well be. I have only been using SSMSE but I'll install the
utility tool and see how it works.
Thanks,
J.S.|||SSEUtil is a command line tool designed mainly to allow you to work with
User Instances. The other tools can't start up a user instance for example
but must attach to a running instance so if you are going to use the
standard SQL Server tools you may have to use SSEUtil to start up the user
instance first. There's more information on user instances here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"J.S." <jss@.nospam.com> wrote in message
news:Ot3c83JGHHA.2464@.TK2MSFTNGP06.phx.gbl...
> Tracy McKibben wrote:
>> My mistake, I thought you were comparing the Express GUI to the full
>> product. Isn't the Utility product a command-line tool?
> It might well be. I have only been using SSMSE but I'll install the
> utility tool and see how it works.
> Thanks,
> J.S.
Server Server Management Studio Express? Can they both be used to
connect to SQL Server 2005 databases? Which one do you folks prefer?
Thanks,
J.S.J.S. wrote:
> What is the main difference between SQL Server Express Utility and SQL
> Server Server Management Studio Express? Can they both be used to
> connect to SQL Server 2005 databases? Which one do you folks prefer?
> Thanks,
> J.S.
I think the overview on this page says it all:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> I think the overview on this page says it all:
> http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
It mentions about the SSMSE but not about the SQL Server Express Utility.
Thanks,
J.S.|||J.S. wrote:
> Tracy McKibben wrote:
>> I think the overview on this page says it all:
>> http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
>
> It mentions about the SSMSE but not about the SQL Server Express Utility.
> Thanks,
> J.S.
My mistake, I thought you were comparing the Express GUI to the full
product. Isn't the Utility product a command-line tool?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> My mistake, I thought you were comparing the Express GUI to the full
> product. Isn't the Utility product a command-line tool?
It might well be. I have only been using SSMSE but I'll install the
utility tool and see how it works.
Thanks,
J.S.|||SSEUtil is a command line tool designed mainly to allow you to work with
User Instances. The other tools can't start up a user instance for example
but must attach to a running instance so if you are going to use the
standard SQL Server tools you may have to use SSEUtil to start up the user
instance first. There's more information on user instances here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"J.S." <jss@.nospam.com> wrote in message
news:Ot3c83JGHHA.2464@.TK2MSFTNGP06.phx.gbl...
> Tracy McKibben wrote:
>> My mistake, I thought you were comparing the Express GUI to the full
>> product. Isn't the Utility product a command-line tool?
> It might well be. I have only been using SSMSE but I'll install the
> utility tool and see how it works.
> Thanks,
> J.S.
Monday, March 19, 2012
did debugging with SP3 ever get fixed for Visual Studio.NET?
When I installed SP3 on SQL 2000, I lost the ability to debug stored procedures
from Visual Studio - single stepping into the stored procedure.
I spent a day trying to fix it maybe 8 months ago - and gave up.
Are there any tech notes that actually work to restore the ability to debug when
SQL Server is on the same machine as Visual Studio?
If not, can I fix the problem by un-installing SQL Server and then installing
the SP2 version? I'm unclear if the database files would have any problems with
this - or have any problems when moving SP2 databases to my SP3 production
boxes?
--
Thanks in advance, Les CaudleWe can get it to single step through the procedure, but not set a breakpoint.
Was it ever possible to breakpoint? I note the documentation states it will
not "Break", but we took that to mean one could not break the execution and
re-start.
Cheers
Happy Harry
"Les Caudle" wrote:
> When I installed SP3 on SQL 2000, I lost the ability to debug stored procedures
> from Visual Studio - single stepping into the stored procedure.
> I spent a day trying to fix it maybe 8 months ago - and gave up.
> Are there any tech notes that actually work to restore the ability to debug when
> SQL Server is on the same machine as Visual Studio?
> If not, can I fix the problem by un-installing SQL Server and then installing
> the SP2 version? I'm unclear if the database files would have any problems with
> this - or have any problems when moving SP2 databases to my SP3 production
> boxes?
> --
> Thanks in advance, Les Caudle
>
from Visual Studio - single stepping into the stored procedure.
I spent a day trying to fix it maybe 8 months ago - and gave up.
Are there any tech notes that actually work to restore the ability to debug when
SQL Server is on the same machine as Visual Studio?
If not, can I fix the problem by un-installing SQL Server and then installing
the SP2 version? I'm unclear if the database files would have any problems with
this - or have any problems when moving SP2 databases to my SP3 production
boxes?
--
Thanks in advance, Les CaudleWe can get it to single step through the procedure, but not set a breakpoint.
Was it ever possible to breakpoint? I note the documentation states it will
not "Break", but we took that to mean one could not break the execution and
re-start.
Cheers
Happy Harry
"Les Caudle" wrote:
> When I installed SP3 on SQL 2000, I lost the ability to debug stored procedures
> from Visual Studio - single stepping into the stored procedure.
> I spent a day trying to fix it maybe 8 months ago - and gave up.
> Are there any tech notes that actually work to restore the ability to debug when
> SQL Server is on the same machine as Visual Studio?
> If not, can I fix the problem by un-installing SQL Server and then installing
> the SP2 version? I'm unclear if the database files would have any problems with
> this - or have any problems when moving SP2 databases to my SP3 production
> boxes?
> --
> Thanks in advance, Les Caudle
>
Sunday, March 11, 2012
Diagrams
I know that the BI studio can build a nice flow document that is associated with the package. Is there an easy way to build a series fo documents that can be shared with other users without having them go into Visual Studio?
http://www.softrus.org/dts/
Mark E. JohnsonI have an upcoming presentation and was wondering if there were any methods/features that could display all the SSIS packages, tasks, dataflows, relationships, and such in a functional diagram? Similar to what is seen in a ERD diagram. If not, are there any functions or tools that can help collage these SSIS displays (outside of screen shots)?|||We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K|||
Has a timeframe been defined yet?
Thanks Kirk.
|||Yes, around the time that Yukon ships.
K
KirkHaselden wrote:
We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K
Now that SQL Server 2005 has been released is there any news on this tool? I have been looking around for it but with no luck.
-Sune|||
The documenter is a "sample" application, not a released product, so there is no firm release schedule for it.
It's not quite ready yet. It should be quite soon, but I don't have a better estimate just now.
Donald
|||Thanks Donald. I'm looking forward.If you need an external beta tester just let me know :o)
- Sune|||Has there been any new progress made on releasing this tool yet?|||
Did you find anything about your request?
I am looking for a SSIS Documenter too!
|||The DTS documenter was there for a while:http://www.softrus.org/dts/
And I got a note that SSIS Documenter is coming from these guys as well.|||
Any updates on this?
|||I found the following free tool.
http://www.bidocumenter.com/Public/Default.aspx
Diagramming Print bug
Can someone tell me where to turn in bugs for SQL server?
I'm using the MS SQL Server Management Studio and when I change my table to
custom view and print them, they are printing funny. I can send the
printout to someone if needed.
Thanks!
Velvet
http://connect.microsoft.com/SQLServer
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Velvet" wrote:
> Can someone tell me where to turn in bugs for SQL server?
> I'm using the MS SQL Server Management Studio and when I change my table
> to custom view and print them, they are printing funny. I can send the
> printout to someone if needed.
> Thanks!
> Velvet
>
|||Hello Velvet,
Yes. You could submit via the link
http://connect.microsoft.com/SQLServer
I'd like to know if the version of SQL you installed? Did you apply SP1 or
SP2 CTP on the machine. You may let me know the exact reproduce steps and
send the screen shot you see to me. Plesase remove "online" in my email
address.
I look forward to your reply. Thank you!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Velvet (MSDNNospam216@.nospam.nospam) writes:
> Can someone tell me where to turn in bugs for SQL server?
> I'm using the MS SQL Server Management Studio and when I change my table
> to custom view and print them, they are printing funny. I can send the
> printout to someone if needed.
I found a couple of bugs on diagram printing:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=183815
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124922
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124788
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124760
Looks like there is little hope for fixes in service packs.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Hello Velvet,
I'm still interested in this issue. If you'd like to provide the related
information, please feel free to send me an email. We look forward to
hearing from you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Sorry, snow days up here where we are not used to getting snow... (Northwest
Washington)
I'm not quite sure I know how to tell you to repro the problem since it
happens on all of my diagrams. I have my tables in 'Table View' -- >
'Custom'. Columns showing are Column Name, Condensed Type, Allow Nulls, and
Identity.
The first one I printed only had two tables on it and was on one page. The
first few columns did not list the colum names where they were supposed to
be and I ended up having to write them in for my meeting. I still have this
one... It looks like the corner of somethign is covering it up and it's
shadded and has a double border. This only happened on one of the tables.,
the other table is fine except that where I would expect it to be blank, the
shading and border shows up at the bottom under the column.
On my bigger diagram, I didn't have to write anything in, but again where
there should be blank space along the right and bottom and there's some sort
of graphic trying to come through. It's very strange.
I saved it to a *.mdi file and I will forward it to you.
Here's my Management Studio info:
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
Thanks,
Velvet
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:vLisdrfNHHA.2024@.TK2MSFTNGHUB02.phx.gbl...
> Hello Velvet,
> I'm still interested in this issue. If you'd like to provide the related
> information, please feel free to send me an email. We look forward to
> hearing from you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ================================================== ====
>
I'm using the MS SQL Server Management Studio and when I change my table to
custom view and print them, they are printing funny. I can send the
printout to someone if needed.
Thanks!
Velvet
http://connect.microsoft.com/SQLServer
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Velvet" wrote:
> Can someone tell me where to turn in bugs for SQL server?
> I'm using the MS SQL Server Management Studio and when I change my table
> to custom view and print them, they are printing funny. I can send the
> printout to someone if needed.
> Thanks!
> Velvet
>
|||Hello Velvet,
Yes. You could submit via the link
http://connect.microsoft.com/SQLServer
I'd like to know if the version of SQL you installed? Did you apply SP1 or
SP2 CTP on the machine. You may let me know the exact reproduce steps and
send the screen shot you see to me. Plesase remove "online" in my email
address.
I look forward to your reply. Thank you!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Velvet (MSDNNospam216@.nospam.nospam) writes:
> Can someone tell me where to turn in bugs for SQL server?
> I'm using the MS SQL Server Management Studio and when I change my table
> to custom view and print them, they are printing funny. I can send the
> printout to someone if needed.
I found a couple of bugs on diagram printing:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=183815
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124922
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124788
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124760
Looks like there is little hope for fixes in service packs.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||Hello Velvet,
I'm still interested in this issue. If you'd like to provide the related
information, please feel free to send me an email. We look forward to
hearing from you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Sorry, snow days up here where we are not used to getting snow... (Northwest
Washington)
I'm not quite sure I know how to tell you to repro the problem since it
happens on all of my diagrams. I have my tables in 'Table View' -- >
'Custom'. Columns showing are Column Name, Condensed Type, Allow Nulls, and
Identity.
The first one I printed only had two tables on it and was on one page. The
first few columns did not list the colum names where they were supposed to
be and I ended up having to write them in for my meeting. I still have this
one... It looks like the corner of somethign is covering it up and it's
shadded and has a double border. This only happened on one of the tables.,
the other table is fine except that where I would expect it to be blank, the
shading and border shows up at the bottom under the column.
On my bigger diagram, I didn't have to write anything in, but again where
there should be blank space along the right and bottom and there's some sort
of graphic trying to come through. It's very strange.
I saved it to a *.mdi file and I will forward it to you.
Here's my Management Studio info:
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
Thanks,
Velvet
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:vLisdrfNHHA.2024@.TK2MSFTNGHUB02.phx.gbl...
> Hello Velvet,
> I'm still interested in this issue. If you'd like to provide the related
> information, please feel free to send me an email. We look forward to
> hearing from you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ================================================== ====
>
Diagram, script and security ...
Three things:
1 - I attached a database from another computer in the Microsoft SQL Server Management Studio Express tool. It looks like my database diagrams did not follow.At first, it told me that the owner of the database was not set correctly and, hence, diagrams could not be supported. I ran the following query to fix that -> Alter authorization on database::DB_NAME to [MACHINE_NAME\USER]. Now, I can create new diagrams but I would like to see the ones I had before. How can I transfer my database files (.mdf and .ldf) with the diagrams?
2 – I would like to generate a database script that would not only create the table structure but also generate the insert statements to populate the database. When I use the “generate scripts” wizard, I don’t see an option where I could get the insert statements included in the script.Any help would be appreciated.
3 - I would like to read/find a short tutorial on how to set up security for my database. For now, I use the default user/security everywhere and I am sure it is not a good way of doing things. Basically, I would like to make sure I am not leaving a big security hole without having to read an entire book on SQL Server.Where could I get started?
Thanks a lot,
Dom.
1/ the diagrams should have come across with the database as they are stored in special tables, was this a SQL 2000 db that was upgraded by any chance?
2/ There is no way to generate insert statements in the UI today, there are some samples out in the community that can do it through.
3/ Have you read books on line?
|||1 - No this is not a database upgrade, a SQL Server 2005 Express Edition to SQL Server 2005 Express Edition
2 - This is sad, there should be something to generate insert statements.
3 - Do you have any good ones to suggest?
thanks.
|||Check out Securing your SQL Server Express Edition Server, it's from beta, but all the prinicples apply. You can also read the various pages of the BOL linked to from the Security Consideration for SQL Server topic.
Regards,
Mike Wachal
SQL Express team
-
Mark the best posts as Answers!
Diagram Editor in SQL Server Management Studio
Hi,
I was playing with the diagram editor and I was wondering if that was a component available for other developers to use. We're using a similar control for our product, but that control is pretty slow and a little dumb, it displays overlapped tables and doesn't have the "arrange tables" feature that I really like in the Sql Server Management Studio.
So my question is, how could we get this control, is it available for purchase? Any suggestions to similar available controls? Basically, we need a diagram editor in which the objects and the relations are selectable.
Any help would be highly appreciated.
Thanks, Florin
That is a part of client tools to be installed and cannot be seperated as a component.Wednesday, March 7, 2012
devenv.exe hangs up with alomost 100% cpu usage
For some reason my visual studio with SSIS project hangs up with almost 100% cpu usage sometimes immediately after opening the studio.
Any resolution?
Thanks
I'm having the same problem and it is driving me nuts! I do a lot of BI work and this has disrupted my project timelines significantly.
As best as I can tell. it seems to have start after applying a patch to the .NET framework 2.0. The patch is defined in the KB922770. I'm not sure if this is the culprit by itself or if there are others factors re-enforcing the problem.
Let me know if you come up with a resolution.
Thanks, Darryl
darryl_jewett@.msn.com
|||We were able to reduce the occurrence of hangup by 90% with two settings... particulary with the first one.
1. Project property -> Configuration Manger - > Build = UNCHECK (This gets checked mysteriously even though we Uncheck and save in TFS - so we verify for this setting frequently when we open the project). If it is checked - all packages in the project are built/compiled irrespective of package you are working on and if there are 100's of packages - compiling all of them takes hell of time.
2. Tools->Options->Environment->AutoRecovery - Save autorecovery information... = UNCHECK. (I did this bz I saw in the status bar of VS the message: Saving autorecovery details.. when it gets stuck)
Hope it helps you as well (if above setting are not important to you ).
But the problem has not gone altogether.... it still hangs up once in a while.
Thanks
Development Tools
Are there any tools (other than Visual Studio.NET) that will allow me to
build SQL Reporting Services Reports? I just want to build some simple
reports and don't need (or want) to install the Visual Studio.NET.SQL Server 2005 will include a new tool called "Report Builder" that is
intended for end-users. It doesn't depend on VS.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <John@.discussions.microsoft.com> wrote in message
news:43A3C15E-9042-4204-BB90-CFA8A0BE86EA@.microsoft.com...
> Are there any tools (other than Visual Studio.NET) that will allow me to
> build SQL Reporting Services Reports? I just want to build some simple
> reports and don't need (or want) to install the Visual Studio.NET.
build SQL Reporting Services Reports? I just want to build some simple
reports and don't need (or want) to install the Visual Studio.NET.SQL Server 2005 will include a new tool called "Report Builder" that is
intended for end-users. It doesn't depend on VS.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <John@.discussions.microsoft.com> wrote in message
news:43A3C15E-9042-4204-BB90-CFA8A0BE86EA@.microsoft.com...
> Are there any tools (other than Visual Studio.NET) that will allow me to
> build SQL Reporting Services Reports? I just want to build some simple
> reports and don't need (or want) to install the Visual Studio.NET.
Saturday, February 25, 2012
Developing Stored Procedures using Management Studio Express
Hi,
I am new to SQL server 2005. I am developing stored procedures as follows in Management Studio:
1)Right click Stored Procedures folder on a database
2)Select "New Stored Procedure"
3)Write the query in a .sql file
4)Execute the query.
Now in this model, I dont seem to have a develop->test->develop and then deploy, type of development cycle. The problem is each time I execute a query it is deployed and re-executing it results in an error like: "There is already an object named 'NewEmployee' in the database." Which forces you to manually delete the SP and re-execute your query. It doesn't give you a chance to test your SP logic before deploying. Contrary to this, If I developed CLR SP's in Visual Studio, I would test/debug the procedure, and then "deploy" it later when I'm finished with it. Can I not do this in Management Studio?
Thanks,
Bahadir
right click the existing stored proc
click on "script stored procedure as">alter>"new query editor"
modify the scripts
and run
|||Doh! I think this was a bit stupid question. More clever next time :)Thanks,
Bahadir
Developing Stored Procedures using Management Studio Express
Hi,
I am new to SQL server 2005. I am developing stored procedures as follows in Management Studio:
1)Right click Stored Procedures folder on a database
2)Select "New Stored Procedure"
3)Write the query in a .sql file
4)Execute the query.
Now in this model, I dont seem to have a develop->test->develop and then deploy, type of development cycle. The problem is each time I execute a query it is deployed and re-executing it results in an error like: "There is already an object named 'NewEmployee' in the database." Which forces you to manually delete the SP and re-execute your query. It doesn't give you a chance to test your SP logic before deploying. Contrary to this, If I developed CLR SP's in Visual Studio, I would test/debug the procedure, and then "deploy" it later when I'm finished with it. Can I not do this in Management Studio?
Thanks,
Bahadir
right click the existing stored proc
click on "script stored procedure as">alter>"new query editor"
modify the scripts
and run
|||Doh! I think this was a bit stupid question. More clever next time :)
Thanks,
Bahadir
Developing CLR Objects - Visual Studio Requirements?
I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation,
and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere
on either system's VS installation the option to create a new Sql
Project/Solution to create CLR objects. Am I missing something, or do I
need VS Professional?
CraigHi Craig,
the option should be under
FIle --> New --> Project --> (Programming Language, e.g. C# ) -->
Database --> SQLServer project
In the Project you can define new object types like functions /
procedures / UDA etc.
HTH, Jens Suessmeyer.|||AFAIK, you need VS Professional version or (beta of) Team System dev.
Cheers,
Bob Beauchemin
http://www.SQLskills.com/bobb
"Craig S" <cscheets@.dontspam.kc.rr.com> wrote in message
news:e$AATwKDGHA.1384@.TK2MSFTNGP11.phx.gbl...
>I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation,
>and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere
>on either system's VS installation the option to create a new Sql
>Project/Solution to create CLR objects. Am I missing something, or do I
>need VS Professional?
> Craig
>|||You don't need to use Visual Studio to create and run
assemblies in SQL Server:
http://www.eggheadcafe.com/articles...5_clr_regex.asp
Robbe Morris - 2004/2005 Microsoft MVP C#
http://www.eggheadcafe.com/forums/merit.asp
"Craig S" <cscheets@.dontspam.kc.rr.com> wrote in message
news:e$AATwKDGHA.1384@.TK2MSFTNGP11.phx.gbl...
>I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation,
>and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere
>on either system's VS installation the option to create a new Sql
>Project/Solution to create CLR objects. Am I missing something, or do I
>need VS Professional?
> Craig
>|||True. By the description in the posting, it appeared that he was looking for
the built-in Visual Studio "SQL Server Projects" for .NET languages, that
are included as part of some editions of Visual Studio.
You could conceivably develop and deploy SQLCLR assemblies with a command
line compiler and SQLCMD.exe.
Cheers,
Bob Beauchemin
http://www.SQLskills.com/blogs/bobb
"Robbe Morris [C# MVP]" <info@.eggheadcafe.com> wrote in message
news:%23XoVWSLDGHA.3984@.TK2MSFTNGP14.phx.gbl...
> You don't need to use Visual Studio to create and run
> assemblies in SQL Server:
> http://www.eggheadcafe.com/articles...5_clr_regex.asp
> --
> Robbe Morris - 2004/2005 Microsoft MVP C#
> http://www.eggheadcafe.com/forums/merit.asp
>
>
> "Craig S" <cscheets@.dontspam.kc.rr.com> wrote in message
> news:e$AATwKDGHA.1384@.TK2MSFTNGP11.phx.gbl...
>|||Niels Berglund has released an custom SQL Server project, VS addin and a
stand-alone SQL CLR deployment tool which work with any edition of Visual
Studio.
http://staff.develop.com/nielsb/cod...ropAndAddIn.zip
David
"Bob Beauchemin" <no_bobb_spam@.sqlskills.com> wrote in message
news:%23AIOLzMDGHA.628@.TK2MSFTNGP14.phx.gbl...
> True. By the description in the posting, it appeared that he was looking
> for the built-in Visual Studio "SQL Server Projects" for .NET languages,
> that are included as part of some editions of Visual Studio.
> You could conceivably develop and deploy SQLCLR assemblies with a command
> line compiler and SQLCMD.exe.
> Cheers,
> Bob Beauchemin
> http://www.SQLskills.com/blogs/bobb
>
> "Robbe Morris [C# MVP]" <info@.eggheadcafe.com> wrote in message
> news:%23XoVWSLDGHA.3984@.TK2MSFTNGP14.phx.gbl...
>|||Yep. I was aware of that too. ;-) It sounded as though the questioner was
asking/wondering why the built-in projects didn't show up, rather than what
are the choices when...
Bob Beauchemin
http://www.SQLskills.com/blogs/bobb
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:eYUIWFNDGHA.748@.TK2MSFTNGP12.phx.gbl...
> Niels Berglund has released an custom SQL Server project, VS addin and a
> stand-alone SQL CLR deployment tool which work with any edition of Visual
> Studio.
> http://staff.develop.com/nielsb/cod...ropAndAddIn.zip
> David
>
> "Bob Beauchemin" <no_bobb_spam@.sqlskills.com> wrote in message
> news:%23AIOLzMDGHA.628@.TK2MSFTNGP14.phx.gbl...
>|||I was kind of asking both, mainly "how do I develop one without notepad.exe"
:) I found all of these posts to be both correct and very helpful, thank
you all.
Craig
"Bob Beauchemin" <no_bobb_spam@.sqlskills.com> wrote in message
news:uCuImBODGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Yep. I was aware of that too. ;-) It sounded as though the questioner was
> asking/wondering why the built-in projects didn't show up, rather than
> what are the choices when...
> Bob Beauchemin
> http://www.SQLskills.com/blogs/bobb
>
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:eYUIWFNDGHA.748@.TK2MSFTNGP12.phx.gbl...
>
and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere
on either system's VS installation the option to create a new Sql
Project/Solution to create CLR objects. Am I missing something, or do I
need VS Professional?
CraigHi Craig,
the option should be under
FIle --> New --> Project --> (Programming Language, e.g. C# ) -->
Database --> SQLServer project
In the Project you can define new object types like functions /
procedures / UDA etc.
HTH, Jens Suessmeyer.|||AFAIK, you need VS Professional version or (beta of) Team System dev.
Cheers,
Bob Beauchemin
http://www.SQLskills.com/bobb
"Craig S" <cscheets@.dontspam.kc.rr.com> wrote in message
news:e$AATwKDGHA.1384@.TK2MSFTNGP11.phx.gbl...
>I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation,
>and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere
>on either system's VS installation the option to create a new Sql
>Project/Solution to create CLR objects. Am I missing something, or do I
>need VS Professional?
> Craig
>|||You don't need to use Visual Studio to create and run
assemblies in SQL Server:
http://www.eggheadcafe.com/articles...5_clr_regex.asp
Robbe Morris - 2004/2005 Microsoft MVP C#
http://www.eggheadcafe.com/forums/merit.asp
"Craig S" <cscheets@.dontspam.kc.rr.com> wrote in message
news:e$AATwKDGHA.1384@.TK2MSFTNGP11.phx.gbl...
>I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation,
>and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere
>on either system's VS installation the option to create a new Sql
>Project/Solution to create CLR objects. Am I missing something, or do I
>need VS Professional?
> Craig
>|||True. By the description in the posting, it appeared that he was looking for
the built-in Visual Studio "SQL Server Projects" for .NET languages, that
are included as part of some editions of Visual Studio.
You could conceivably develop and deploy SQLCLR assemblies with a command
line compiler and SQLCMD.exe.
Cheers,
Bob Beauchemin
http://www.SQLskills.com/blogs/bobb
"Robbe Morris [C# MVP]" <info@.eggheadcafe.com> wrote in message
news:%23XoVWSLDGHA.3984@.TK2MSFTNGP14.phx.gbl...
> You don't need to use Visual Studio to create and run
> assemblies in SQL Server:
> http://www.eggheadcafe.com/articles...5_clr_regex.asp
> --
> Robbe Morris - 2004/2005 Microsoft MVP C#
> http://www.eggheadcafe.com/forums/merit.asp
>
>
> "Craig S" <cscheets@.dontspam.kc.rr.com> wrote in message
> news:e$AATwKDGHA.1384@.TK2MSFTNGP11.phx.gbl...
>|||Niels Berglund has released an custom SQL Server project, VS addin and a
stand-alone SQL CLR deployment tool which work with any edition of Visual
Studio.
http://staff.develop.com/nielsb/cod...ropAndAddIn.zip
David
"Bob Beauchemin" <no_bobb_spam@.sqlskills.com> wrote in message
news:%23AIOLzMDGHA.628@.TK2MSFTNGP14.phx.gbl...
> True. By the description in the posting, it appeared that he was looking
> for the built-in Visual Studio "SQL Server Projects" for .NET languages,
> that are included as part of some editions of Visual Studio.
> You could conceivably develop and deploy SQLCLR assemblies with a command
> line compiler and SQLCMD.exe.
> Cheers,
> Bob Beauchemin
> http://www.SQLskills.com/blogs/bobb
>
> "Robbe Morris [C# MVP]" <info@.eggheadcafe.com> wrote in message
> news:%23XoVWSLDGHA.3984@.TK2MSFTNGP14.phx.gbl...
>|||Yep. I was aware of that too. ;-) It sounded as though the questioner was
asking/wondering why the built-in projects didn't show up, rather than what
are the choices when...
Bob Beauchemin
http://www.SQLskills.com/blogs/bobb
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:eYUIWFNDGHA.748@.TK2MSFTNGP12.phx.gbl...
> Niels Berglund has released an custom SQL Server project, VS addin and a
> stand-alone SQL CLR deployment tool which work with any edition of Visual
> Studio.
> http://staff.develop.com/nielsb/cod...ropAndAddIn.zip
> David
>
> "Bob Beauchemin" <no_bobb_spam@.sqlskills.com> wrote in message
> news:%23AIOLzMDGHA.628@.TK2MSFTNGP14.phx.gbl...
>|||I was kind of asking both, mainly "how do I develop one without notepad.exe"
:) I found all of these posts to be both correct and very helpful, thank
you all.
Craig
"Bob Beauchemin" <no_bobb_spam@.sqlskills.com> wrote in message
news:uCuImBODGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Yep. I was aware of that too. ;-) It sounded as though the questioner was
> asking/wondering why the built-in projects didn't show up, rather than
> what are the choices when...
> Bob Beauchemin
> http://www.SQLskills.com/blogs/bobb
>
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:eYUIWFNDGHA.748@.TK2MSFTNGP12.phx.gbl...
>
Friday, February 17, 2012
develop RS2000 report through V Studio.NET 2005
Hi all, is it possible to create RS2000 format reports through Visual Studio
.NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
reports as my ERP system only supports SQL server 2000.No. If you need to develop RS 2000 reports then you need some version of VS
2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
work with rhe RS 2000 report designer. RS 2005 comes with its own version of
VS and not purchase of VS is needed.
Also, note that RS 2005 can be installed using SQL Server 2000. However, as
I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> Hi all, is it possible to create RS2000 format reports through Visual
> Studio
> .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> reports as my ERP system only supports SQL server 2000.|||Bruce, thank you for your reply.
My problem is, I will not purchase SQL 2005 until my ERP system is going to
support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
need to use Studio .NET 2005 in near future.
Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
future, say half year?
Any suggestion?
"Bruce L-C [MVP]" wrote:
> No. If you need to develop RS 2000 reports then you need some version of VS
> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
> work with rhe RS 2000 report designer. RS 2005 comes with its own version of
> VS and not purchase of VS is needed.
> Also, note that RS 2005 can be installed using SQL Server 2000. However, as
> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> > Hi all, is it possible to create RS2000 format reports through Visual
> > Studio
> > .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> > reports as my ERP system only supports SQL server 2000.
>
>|||You do not need to buy anything expensive for the VS 2003 requirement. Just
get VB.Net 2003 ($100).
I don't know about upgrades.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:8E045A08-069B-4395-AAD8-7FC57055B66A@.microsoft.com...
> Bruce, thank you for your reply.
> My problem is, I will not purchase SQL 2005 until my ERP system is going
> to
> support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
> need to use Studio .NET 2005 in near future.
> Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
> future, say half year?
> Any suggestion?
> "Bruce L-C [MVP]" wrote:
>> No. If you need to develop RS 2000 reports then you need some version of
>> VS
>> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will
>> not
>> work with rhe RS 2000 report designer. RS 2005 comes with its own version
>> of
>> VS and not purchase of VS is needed.
>> Also, note that RS 2005 can be installed using SQL Server 2000. However,
>> as
>> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
>> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
>> > Hi all, is it possible to create RS2000 format reports through Visual
>> > Studio
>> > .NET 2005? I am going to purchase Visual Studio .NET for developing
>> > RS2000
>> > reports as my ERP system only supports SQL server 2000.
>>
.NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
reports as my ERP system only supports SQL server 2000.No. If you need to develop RS 2000 reports then you need some version of VS
2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
work with rhe RS 2000 report designer. RS 2005 comes with its own version of
VS and not purchase of VS is needed.
Also, note that RS 2005 can be installed using SQL Server 2000. However, as
I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> Hi all, is it possible to create RS2000 format reports through Visual
> Studio
> .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> reports as my ERP system only supports SQL server 2000.|||Bruce, thank you for your reply.
My problem is, I will not purchase SQL 2005 until my ERP system is going to
support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
need to use Studio .NET 2005 in near future.
Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
future, say half year?
Any suggestion?
"Bruce L-C [MVP]" wrote:
> No. If you need to develop RS 2000 reports then you need some version of VS
> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
> work with rhe RS 2000 report designer. RS 2005 comes with its own version of
> VS and not purchase of VS is needed.
> Also, note that RS 2005 can be installed using SQL Server 2000. However, as
> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> > Hi all, is it possible to create RS2000 format reports through Visual
> > Studio
> > .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> > reports as my ERP system only supports SQL server 2000.
>
>|||You do not need to buy anything expensive for the VS 2003 requirement. Just
get VB.Net 2003 ($100).
I don't know about upgrades.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:8E045A08-069B-4395-AAD8-7FC57055B66A@.microsoft.com...
> Bruce, thank you for your reply.
> My problem is, I will not purchase SQL 2005 until my ERP system is going
> to
> support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
> need to use Studio .NET 2005 in near future.
> Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
> future, say half year?
> Any suggestion?
> "Bruce L-C [MVP]" wrote:
>> No. If you need to develop RS 2000 reports then you need some version of
>> VS
>> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will
>> not
>> work with rhe RS 2000 report designer. RS 2005 comes with its own version
>> of
>> VS and not purchase of VS is needed.
>> Also, note that RS 2005 can be installed using SQL Server 2000. However,
>> as
>> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
>> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
>> > Hi all, is it possible to create RS2000 format reports through Visual
>> > Studio
>> > .NET 2005? I am going to purchase Visual Studio .NET for developing
>> > RS2000
>> > reports as my ERP system only supports SQL server 2000.
>>
Tuesday, February 14, 2012
Determining numbers of rows affected in advance
Hi,
When workinf on a SQL2005 Db through Sql Server Management studio, is
there a way to determine in advance how many rows will be affected as
a result of an Update,Insert,or Delete statement without actually
performing the query?
thanks "in advance"
> When workinf on a SQL2005 Db through Sql Server Management studio, is
> there a way to determine in advance how many rows will be affected as
> a result of an Update,Insert,or Delete statement without actually
> performing the query?
No, but you can execute the DML in a transaction, select @.@.ROWCOUNT and then
rollback. Another method is to determine the number of rows that will be
affected is to change the DML to a SELECT COUNT(*) query.
Hope this helps.
Dan Guzman
SQL Server MVP
"Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
> Hi,
> When workinf on a SQL2005 Db through Sql Server Management studio, is
> there a way to determine in advance how many rows will be affected as
> a result of an Update,Insert,or Delete statement without actually
> performing the query?
> thanks "in advance"
|||Aamir
I'm not sure what you mean by 'through SQL Server Management Studio' but I
strongly recommend you don't do any data modification through a graphical
window, but always do it through TSQL code, using a query window or
application. You have much more control, and the ability to use the
techniques Dan suggested.
If you only want an estimate, you could also just look at the estimated
query plan after entering your query in a query window. You can get this
plan with Cntl-L
If you hold your cursor over the estimated plan's first icon, it should
display the estimated number of rows to be returned.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
> Hi,
> When workinf on a SQL2005 Db through Sql Server Management studio, is
> there a way to determine in advance how many rows will be affected as
> a result of an Update,Insert,or Delete statement without actually
> performing the query?
> thanks "in advance"
|||The SELECT COUNT(*) method can be much more efficient than your actual DML
statement because it will probably (hopefully!!) have a very tight, cheap
query plan using indexes since it just needs a count. And if you then DO
choose to run the actual statement then these pages will already have been
pulled into RAM hopefully making the run of the DML faster. Note that this
is still only recommended if for some reason you really do need the count
prior to the execution.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:34560279-FE9B-4EA1-BBBF-36ABFCB77F22@.microsoft.com...
> No, but you can execute the DML in a transaction, select @.@.ROWCOUNT and
> then rollback. Another method is to determine the number of rows that
> will be affected is to change the DML to a SELECT COUNT(*) query.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
> news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
>
|||But for anything but really trivial quries, that optimizer estimate is
probably so off that it may not be very useful.
Linchi
"Kalen Delaney" wrote:
> Aamir
> I'm not sure what you mean by 'through SQL Server Management Studio' but I
> strongly recommend you don't do any data modification through a graphical
> window, but always do it through TSQL code, using a query window or
> application. You have much more control, and the ability to use the
> techniques Dan suggested.
> If you only want an estimate, you could also just look at the estimated
> query plan after entering your query in a query window. You can get this
> plan with Cntl-L
> If you hold your cursor over the estimated plan's first icon, it should
> display the estimated number of rows to be returned.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
> news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
>
>
|||Well, I did say it was only an estimate. :-)
It may be way off, but it might not be. I think it would be better than
nothing, and perhaps better than completely running the whole query just to
get a rowcount, depending on how exact the OP needs the number to be.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:237D20BB-D329-464B-974E-D74B48C80E6B@.microsoft.com...[vbcol=seagreen]
> But for anything but really trivial quries, that optimizer estimate is
> probably so off that it may not be very useful.
> Linchi
> "Kalen Delaney" wrote:
|||Thanks for all the responses.
And I'm sorry, should have clarified it. I am actually running a query
from query window in the management studio.
The estimate query plan was really way off and was in decimals ?
I liked the Rollback Transaction solution and it fits my needs. I know
it may be costly but I am not worried about that in my circumstances.
The Select and Selct Count statements are good but still not the same
as running the actual queries (some of them much complex with multiple
joins & subqueries)
Once again, thanks all.
On Jan 7, 12:21Xam, "Kalen Delaney" <replies@.public_newsgroups.com>
wrote:
> Well, I did say it was only an estimate. :-)
> It may be way off, but it might not be. I think it would be better than
> nothing, and perhaps better than completely running the whole query just to
> get a rowcount, depending on how exact the OP needs the number to be.
> --
> HTH
> Kalen Delaney, SQL Server MVPwww.InsideSQLServer.comhttp://blog.kalendelaney.com
> "Linchi Shea" <LinchiS...@.discussions.microsoft.com> wrote in message
> news:237D20BB-D329-464B-974E-D74B48C80E6B@.microsoft.com...
>
>
>
>
>
>
>
> - Show quoted text -
When workinf on a SQL2005 Db through Sql Server Management studio, is
there a way to determine in advance how many rows will be affected as
a result of an Update,Insert,or Delete statement without actually
performing the query?
thanks "in advance"
> When workinf on a SQL2005 Db through Sql Server Management studio, is
> there a way to determine in advance how many rows will be affected as
> a result of an Update,Insert,or Delete statement without actually
> performing the query?
No, but you can execute the DML in a transaction, select @.@.ROWCOUNT and then
rollback. Another method is to determine the number of rows that will be
affected is to change the DML to a SELECT COUNT(*) query.
Hope this helps.
Dan Guzman
SQL Server MVP
"Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
> Hi,
> When workinf on a SQL2005 Db through Sql Server Management studio, is
> there a way to determine in advance how many rows will be affected as
> a result of an Update,Insert,or Delete statement without actually
> performing the query?
> thanks "in advance"
|||Aamir
I'm not sure what you mean by 'through SQL Server Management Studio' but I
strongly recommend you don't do any data modification through a graphical
window, but always do it through TSQL code, using a query window or
application. You have much more control, and the ability to use the
techniques Dan suggested.
If you only want an estimate, you could also just look at the estimated
query plan after entering your query in a query window. You can get this
plan with Cntl-L
If you hold your cursor over the estimated plan's first icon, it should
display the estimated number of rows to be returned.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
> Hi,
> When workinf on a SQL2005 Db through Sql Server Management studio, is
> there a way to determine in advance how many rows will be affected as
> a result of an Update,Insert,or Delete statement without actually
> performing the query?
> thanks "in advance"
|||The SELECT COUNT(*) method can be much more efficient than your actual DML
statement because it will probably (hopefully!!) have a very tight, cheap
query plan using indexes since it just needs a count. And if you then DO
choose to run the actual statement then these pages will already have been
pulled into RAM hopefully making the run of the DML faster. Note that this
is still only recommended if for some reason you really do need the count
prior to the execution.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:34560279-FE9B-4EA1-BBBF-36ABFCB77F22@.microsoft.com...
> No, but you can execute the DML in a transaction, select @.@.ROWCOUNT and
> then rollback. Another method is to determine the number of rows that
> will be affected is to change the DML to a SELECT COUNT(*) query.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
> news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
>
|||But for anything but really trivial quries, that optimizer estimate is
probably so off that it may not be very useful.
Linchi
"Kalen Delaney" wrote:
> Aamir
> I'm not sure what you mean by 'through SQL Server Management Studio' but I
> strongly recommend you don't do any data modification through a graphical
> window, but always do it through TSQL code, using a query window or
> application. You have much more control, and the ability to use the
> techniques Dan suggested.
> If you only want an estimate, you could also just look at the estimated
> query plan after entering your query in a query window. You can get this
> plan with Cntl-L
> If you hold your cursor over the estimated plan's first icon, it should
> display the estimated number of rows to be returned.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
> news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
>
>
|||Well, I did say it was only an estimate. :-)
It may be way off, but it might not be. I think it would be better than
nothing, and perhaps better than completely running the whole query just to
get a rowcount, depending on how exact the OP needs the number to be.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:237D20BB-D329-464B-974E-D74B48C80E6B@.microsoft.com...[vbcol=seagreen]
> But for anything but really trivial quries, that optimizer estimate is
> probably so off that it may not be very useful.
> Linchi
> "Kalen Delaney" wrote:
|||Thanks for all the responses.
And I'm sorry, should have clarified it. I am actually running a query
from query window in the management studio.
The estimate query plan was really way off and was in decimals ?
I liked the Rollback Transaction solution and it fits my needs. I know
it may be costly but I am not worried about that in my circumstances.
The Select and Selct Count statements are good but still not the same
as running the actual queries (some of them much complex with multiple
joins & subqueries)
Once again, thanks all.
On Jan 7, 12:21Xam, "Kalen Delaney" <replies@.public_newsgroups.com>
wrote:
> Well, I did say it was only an estimate. :-)
> It may be way off, but it might not be. I think it would be better than
> nothing, and perhaps better than completely running the whole query just to
> get a rowcount, depending on how exact the OP needs the number to be.
> --
> HTH
> Kalen Delaney, SQL Server MVPwww.InsideSQLServer.comhttp://blog.kalendelaney.com
> "Linchi Shea" <LinchiS...@.discussions.microsoft.com> wrote in message
> news:237D20BB-D329-464B-974E-D74B48C80E6B@.microsoft.com...
>
>
>
>
>
>
>
> - Show quoted text -
Determining numbers of rows affected in advance
Hi,
When workinf on a SQL2005 Db through Sql Server Management studio, is
there a way to determine in advance how many rows will be affected as
a result of an Update,Insert,or Delete statement without actually
performing the query?
thanks "in advance"> When workinf on a SQL2005 Db through Sql Server Management studio, is
> there a way to determine in advance how many rows will be affected as
> a result of an Update,Insert,or Delete statement without actually
> performing the query?
No, but you can execute the DML in a transaction, select @.@.ROWCOUNT and then
rollback. Another method is to determine the number of rows that will be
affected is to change the DML to a SELECT COUNT(*) query.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
> Hi,
> When workinf on a SQL2005 Db through Sql Server Management studio, is
> there a way to determine in advance how many rows will be affected as
> a result of an Update,Insert,or Delete statement without actually
> performing the query?
> thanks "in advance"|||Aamir
I'm not sure what you mean by 'through SQL Server Management Studio' but I
strongly recommend you don't do any data modification through a graphical
window, but always do it through TSQL code, using a query window or
application. You have much more control, and the ability to use the
techniques Dan suggested.
If you only want an estimate, you could also just look at the estimated
query plan after entering your query in a query window. You can get this
plan with Cntl-L
If you hold your cursor over the estimated plan's first icon, it should
display the estimated number of rows to be returned.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
> Hi,
> When workinf on a SQL2005 Db through Sql Server Management studio, is
> there a way to determine in advance how many rows will be affected as
> a result of an Update,Insert,or Delete statement without actually
> performing the query?
> thanks "in advance"|||The SELECT COUNT(*) method can be much more efficient than your actual DML
statement because it will probably (hopefully!!) have a very tight, cheap
query plan using indexes since it just needs a count. And if you then DO
choose to run the actual statement then these pages will already have been
pulled into RAM hopefully making the run of the DML faster. Note that this
is still only recommended if for some reason you really do need the count
prior to the execution.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:34560279-FE9B-4EA1-BBBF-36ABFCB77F22@.microsoft.com...
>> When workinf on a SQL2005 Db through Sql Server Management studio, is
>> there a way to determine in advance how many rows will be affected as
>> a result of an Update,Insert,or Delete statement without actually
>> performing the query?
> No, but you can execute the DML in a transaction, select @.@.ROWCOUNT and
> then rollback. Another method is to determine the number of rows that
> will be affected is to change the DML to a SELECT COUNT(*) query.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
> news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
>> Hi,
>> When workinf on a SQL2005 Db through Sql Server Management studio, is
>> there a way to determine in advance how many rows will be affected as
>> a result of an Update,Insert,or Delete statement without actually
>> performing the query?
>> thanks "in advance"
>|||But for anything but really trivial quries, that optimizer estimate is
probably so off that it may not be very useful.
Linchi
"Kalen Delaney" wrote:
> Aamir
> I'm not sure what you mean by 'through SQL Server Management Studio' but I
> strongly recommend you don't do any data modification through a graphical
> window, but always do it through TSQL code, using a query window or
> application. You have much more control, and the ability to use the
> techniques Dan suggested.
> If you only want an estimate, you could also just look at the estimated
> query plan after entering your query in a query window. You can get this
> plan with Cntl-L
> If you hold your cursor over the estimated plan's first icon, it should
> display the estimated number of rows to be returned.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
> news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
> > Hi,
> >
> > When workinf on a SQL2005 Db through Sql Server Management studio, is
> > there a way to determine in advance how many rows will be affected as
> > a result of an Update,Insert,or Delete statement without actually
> > performing the query?
> >
> > thanks "in advance"
>
>|||Well, I did say it was only an estimate. :-)
It may be way off, but it might not be. I think it would be better than
nothing, and perhaps better than completely running the whole query just to
get a rowcount, depending on how exact the OP needs the number to be.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:237D20BB-D329-464B-974E-D74B48C80E6B@.microsoft.com...
> But for anything but really trivial quries, that optimizer estimate is
> probably so off that it may not be very useful.
> Linchi
> "Kalen Delaney" wrote:
>> Aamir
>> I'm not sure what you mean by 'through SQL Server Management Studio' but
>> I
>> strongly recommend you don't do any data modification through a graphical
>> window, but always do it through TSQL code, using a query window or
>> application. You have much more control, and the ability to use the
>> techniques Dan suggested.
>> If you only want an estimate, you could also just look at the estimated
>> query plan after entering your query in a query window. You can get this
>> plan with Cntl-L
>> If you hold your cursor over the estimated plan's first icon, it should
>> display the estimated number of rows to be returned.
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.InsideSQLServer.com
>> http://blog.kalendelaney.com
>>
>> "Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
>> news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
>> > Hi,
>> >
>> > When workinf on a SQL2005 Db through Sql Server Management studio, is
>> > there a way to determine in advance how many rows will be affected as
>> > a result of an Update,Insert,or Delete statement without actually
>> > performing the query?
>> >
>> > thanks "in advance"
>>|||Thanks for all the responses.
And I'm sorry, should have clarified it. I am actually running a query
from query window in the management studio.
The estimate query plan was really way off and was in decimals ?
I liked the Rollback Transaction solution and it fits my needs. I know
it may be costly but I am not worried about that in my circumstances.
The Select and Selct Count statements are good but still not the same
as running the actual queries (some of them much complex with multiple
joins & subqueries)
Once again, thanks all.
On Jan 7, 12:21=A0am, "Kalen Delaney" <replies@.public_newsgroups.com>
wrote:
> Well, I did say it was only an estimate. :-)
> It may be way off, but it might not be. I think it would be better than
> nothing, and perhaps better than completely running the whole query just t=o
> get a rowcount, depending on how exact the OP needs the number to be.
> --
> HTH
> Kalen Delaney, SQL Server MVPwww.InsideSQLServer.comhttp://blog.kalendelan=
ey.com
> "Linchi Shea" <LinchiS...@.discussions.microsoft.com> wrote in message
> news:237D20BB-D329-464B-974E-D74B48C80E6B@.microsoft.com...
>
> > But for anything but really trivial quries, that optimizer estimate is
> > probably so off that it may not be very useful.
> > Linchi
> > "Kalen Delaney" wrote:
> >> Aamir
> >> I'm not sure what you mean by 'through SQL Server Management Studio' bu=t
> >> I
> >> strongly recommend you don't do any data modification through a graphic=al
> >> window, but always do it through TSQL code, using a query window or
> >> application. You have much more control, and the ability to use the
> >> techniques Dan suggested.
> >> If you only want an estimate, you could also just look at the estimated=
> >> query plan after entering your query in a query window. You can get thi=s
> >> plan with Cntl-L
> >> If you hold your cursor over the estimated plan's first icon, it should=
> >> display the estimated number of rows to be returned.
> >> --
> >> HTH
> >> Kalen Delaney, SQL Server MVP
> >>www.InsideSQLServer.com
> >>http://blog.kalendelaney.com
> >> "Aamir Ghanchi" <aamirghan...@.gmail.com> wrote in message
> >>news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com..=.
> >> > Hi,
> >> > When workinf on a SQL2005 Db through Sql Server Management studio, is=
> >> > there a way to determine in advance how many rows will be affected as=
> >> > a result of an Update,Insert,or Delete statement without actually
> >> > performing the query?
> >> > thanks "in advance"- Hide quoted text -
> - Show quoted text -
When workinf on a SQL2005 Db through Sql Server Management studio, is
there a way to determine in advance how many rows will be affected as
a result of an Update,Insert,or Delete statement without actually
performing the query?
thanks "in advance"> When workinf on a SQL2005 Db through Sql Server Management studio, is
> there a way to determine in advance how many rows will be affected as
> a result of an Update,Insert,or Delete statement without actually
> performing the query?
No, but you can execute the DML in a transaction, select @.@.ROWCOUNT and then
rollback. Another method is to determine the number of rows that will be
affected is to change the DML to a SELECT COUNT(*) query.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
> Hi,
> When workinf on a SQL2005 Db through Sql Server Management studio, is
> there a way to determine in advance how many rows will be affected as
> a result of an Update,Insert,or Delete statement without actually
> performing the query?
> thanks "in advance"|||Aamir
I'm not sure what you mean by 'through SQL Server Management Studio' but I
strongly recommend you don't do any data modification through a graphical
window, but always do it through TSQL code, using a query window or
application. You have much more control, and the ability to use the
techniques Dan suggested.
If you only want an estimate, you could also just look at the estimated
query plan after entering your query in a query window. You can get this
plan with Cntl-L
If you hold your cursor over the estimated plan's first icon, it should
display the estimated number of rows to be returned.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
> Hi,
> When workinf on a SQL2005 Db through Sql Server Management studio, is
> there a way to determine in advance how many rows will be affected as
> a result of an Update,Insert,or Delete statement without actually
> performing the query?
> thanks "in advance"|||The SELECT COUNT(*) method can be much more efficient than your actual DML
statement because it will probably (hopefully!!) have a very tight, cheap
query plan using indexes since it just needs a count. And if you then DO
choose to run the actual statement then these pages will already have been
pulled into RAM hopefully making the run of the DML faster. Note that this
is still only recommended if for some reason you really do need the count
prior to the execution.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:34560279-FE9B-4EA1-BBBF-36ABFCB77F22@.microsoft.com...
>> When workinf on a SQL2005 Db through Sql Server Management studio, is
>> there a way to determine in advance how many rows will be affected as
>> a result of an Update,Insert,or Delete statement without actually
>> performing the query?
> No, but you can execute the DML in a transaction, select @.@.ROWCOUNT and
> then rollback. Another method is to determine the number of rows that
> will be affected is to change the DML to a SELECT COUNT(*) query.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
> news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
>> Hi,
>> When workinf on a SQL2005 Db through Sql Server Management studio, is
>> there a way to determine in advance how many rows will be affected as
>> a result of an Update,Insert,or Delete statement without actually
>> performing the query?
>> thanks "in advance"
>|||But for anything but really trivial quries, that optimizer estimate is
probably so off that it may not be very useful.
Linchi
"Kalen Delaney" wrote:
> Aamir
> I'm not sure what you mean by 'through SQL Server Management Studio' but I
> strongly recommend you don't do any data modification through a graphical
> window, but always do it through TSQL code, using a query window or
> application. You have much more control, and the ability to use the
> techniques Dan suggested.
> If you only want an estimate, you could also just look at the estimated
> query plan after entering your query in a query window. You can get this
> plan with Cntl-L
> If you hold your cursor over the estimated plan's first icon, it should
> display the estimated number of rows to be returned.
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www.InsideSQLServer.com
> http://blog.kalendelaney.com
>
> "Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
> news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
> > Hi,
> >
> > When workinf on a SQL2005 Db through Sql Server Management studio, is
> > there a way to determine in advance how many rows will be affected as
> > a result of an Update,Insert,or Delete statement without actually
> > performing the query?
> >
> > thanks "in advance"
>
>|||Well, I did say it was only an estimate. :-)
It may be way off, but it might not be. I think it would be better than
nothing, and perhaps better than completely running the whole query just to
get a rowcount, depending on how exact the OP needs the number to be.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:237D20BB-D329-464B-974E-D74B48C80E6B@.microsoft.com...
> But for anything but really trivial quries, that optimizer estimate is
> probably so off that it may not be very useful.
> Linchi
> "Kalen Delaney" wrote:
>> Aamir
>> I'm not sure what you mean by 'through SQL Server Management Studio' but
>> I
>> strongly recommend you don't do any data modification through a graphical
>> window, but always do it through TSQL code, using a query window or
>> application. You have much more control, and the ability to use the
>> techniques Dan suggested.
>> If you only want an estimate, you could also just look at the estimated
>> query plan after entering your query in a query window. You can get this
>> plan with Cntl-L
>> If you hold your cursor over the estimated plan's first icon, it should
>> display the estimated number of rows to be returned.
>> --
>> HTH
>> Kalen Delaney, SQL Server MVP
>> www.InsideSQLServer.com
>> http://blog.kalendelaney.com
>>
>> "Aamir Ghanchi" <aamirghanchi@.gmail.com> wrote in message
>> news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com...
>> > Hi,
>> >
>> > When workinf on a SQL2005 Db through Sql Server Management studio, is
>> > there a way to determine in advance how many rows will be affected as
>> > a result of an Update,Insert,or Delete statement without actually
>> > performing the query?
>> >
>> > thanks "in advance"
>>|||Thanks for all the responses.
And I'm sorry, should have clarified it. I am actually running a query
from query window in the management studio.
The estimate query plan was really way off and was in decimals ?
I liked the Rollback Transaction solution and it fits my needs. I know
it may be costly but I am not worried about that in my circumstances.
The Select and Selct Count statements are good but still not the same
as running the actual queries (some of them much complex with multiple
joins & subqueries)
Once again, thanks all.
On Jan 7, 12:21=A0am, "Kalen Delaney" <replies@.public_newsgroups.com>
wrote:
> Well, I did say it was only an estimate. :-)
> It may be way off, but it might not be. I think it would be better than
> nothing, and perhaps better than completely running the whole query just t=o
> get a rowcount, depending on how exact the OP needs the number to be.
> --
> HTH
> Kalen Delaney, SQL Server MVPwww.InsideSQLServer.comhttp://blog.kalendelan=
ey.com
> "Linchi Shea" <LinchiS...@.discussions.microsoft.com> wrote in message
> news:237D20BB-D329-464B-974E-D74B48C80E6B@.microsoft.com...
>
> > But for anything but really trivial quries, that optimizer estimate is
> > probably so off that it may not be very useful.
> > Linchi
> > "Kalen Delaney" wrote:
> >> Aamir
> >> I'm not sure what you mean by 'through SQL Server Management Studio' bu=t
> >> I
> >> strongly recommend you don't do any data modification through a graphic=al
> >> window, but always do it through TSQL code, using a query window or
> >> application. You have much more control, and the ability to use the
> >> techniques Dan suggested.
> >> If you only want an estimate, you could also just look at the estimated=
> >> query plan after entering your query in a query window. You can get thi=s
> >> plan with Cntl-L
> >> If you hold your cursor over the estimated plan's first icon, it should=
> >> display the estimated number of rows to be returned.
> >> --
> >> HTH
> >> Kalen Delaney, SQL Server MVP
> >>www.InsideSQLServer.com
> >>http://blog.kalendelaney.com
> >> "Aamir Ghanchi" <aamirghan...@.gmail.com> wrote in message
> >>news:6b8c041a-2093-43c4-b294-3f4b908f36c3@.r60g2000hsc.googlegroups.com..=.
> >> > Hi,
> >> > When workinf on a SQL2005 Db through Sql Server Management studio, is=
> >> > there a way to determine in advance how many rows will be affected as=
> >> > a result of an Update,Insert,or Delete statement without actually
> >> > performing the query?
> >> > thanks "in advance"- Hide quoted text -
> - Show quoted text -
Subscribe to:
Posts (Atom)