Yukon for Administrators

January 13, 2004

Published: January 16, 2004

Please note:Portions of this transcript have been edited for clarity

Introductionxxxx

Moderator: Stephen_D (Microsoft)
Welcome to today's Yukon for Administrators chat. I will ask the hosts to introduce themselves.

Host: Michael (Microsoft)
My name is Michael Raheem and I am a Program Manager in SQL Server Tools Team. I will be happy to answer your questions with regards to Yukon tools.

Host: swynk (MVP)
Hi - I'm Stephen Wynkoop, SQL Server MVP and from SSWUG.ORG, the co-sponsor of this webchat.

Host: EuanG (Microsoft)
Hi I'm Euan Garden I am the Product Unit Manager for the Tools team in SQL Server.

Host: MarkA (MVP)
I'm Mark Allison, SQL Server MVP. I've been working with SQL Server for about 8 years.

Host: Rajesh (Microsoft)
Hello everyone !! My name is Rajesh Patel, beta lead for SQL Server.

Moderator: Stephen_D (Microsoft)
And... I am Stephen Dybing, SQL Server MVP Lead. Glad you all could make it today!

Start of Chat

Host: EuanG (Microsoft)
Q: bbogart: What are the performance ramifications of using CLR languages in functions, sprocs and triggers?
A: The best answer is it depends :-) When you have computational intensive operations or need to leverage the .Net framework, the CLR objects will be faster.

For data intensive operations sometimes T-SQL will be faster and sometimes CLR languages. We are working on Architecture Guidance for when to use what.

Host: EuanG (Microsoft)
Q: MikeG: Has the update clustering model for Yukon been announced yet?
A: All we are saying at this point is that we will support 8 node clusters in this release.

Moderator: Stephen_D (Microsoft)
Q: Is there a demo dl?
A: Not yet. There was one on the Resource CD that we handed out at the PDC and PASS, but the beta won't be available for download until later on sometime in the first half of this year.

Host: MarkA (MVP)
Q: kris: Tell me the recommendations for dba's for Yukon, to improve their skills, whether they need vb.net or c# knowledge?
A: It depends! :-) A good production dba should really learn .NET and either vb or c#. The reason for this is that developers will start to develop sprocs in .NET languages and you will need to QA them and support them. Development DBAs will certainly need to know .net in order to develop .net stored procedures.

Host: Rajesh (Microsoft)
Q: kris: Is there any major change in Standby server/log shipping?
A: Good question. We have new feature called database Mirroring. Database mirroring offers a substantive increase in availability over the level previously possible using SQL Server and offers an easy-to-manage alternative to failover clustering. Database mirroring works by maintaining a hot standby server. After a production server fails, applications can recover quickly by reconnecting to the hot standby server.

Host: Michael (Microsoft)
Q: Jingman: What about the MAPI compatibility in SQL Server cluster environment (Yukon)?
A: In Yukon, we ware planning to have a new SQLiMail subsystem that uses SMTP and it is cluster-aware.

Host: swynk (MVP)
Q: MikeG: Will I be able to cluster SQL Servers together and submit an update request to a cluster?
A: Yes, this is possible today.

Host: EuanG (Microsoft)
Q: kris: Will Yukon support any Load Balancing?
A: Yes but using a new technology called Service Broker.

Moderator: Stephen_D (Microsoft)
Q: To expand on bogart's question, will the Yukon CLR be multithreaded handling multiple apps at a time?
A: Yes.

Host: Michael (Microsoft)
Q: Will single table backup\recovery be supported?
A: No, Yukon will not be supporting single table backup/recovery.

Moderator: Stephen_D (Microsoft)
Q: Has the development team made any more progress on the replication changes outlined at PASS?
A: Yes. :-) But note that nobody from the replication team is here today.

Host: EuanG (Microsoft)
Q: et3: Will DTS move from VB/COM based platform to a .NET based platform?
A: DTS will still be available via COM but there are fully supported .Net interfaces as well.

Host: Rajesh (Microsoft)
Q: BusmasterJones: I understand that Yukon is still in private beta...how soon can we the "outsiders" get a copy of it? Is public beta the only/best way?
A: Beta2 time. Beta2 shall be available first half of this year.

Host: EuanG (Microsoft)
Q: Cole: When will Beta 2 be available? I heard early 2004!
A: First Half of this year.

Host: MarkA (MVP)
Q: dkPGH: So is the transition difficult for existing apps?
A: The only answer to this is to test applications when the public beta comes out. Microsoft works hard on making SQL Server backwards compatible, but there is no substitute for good regression testing.

Host: swynk (MVP)
Q: Tommy: Do you see the Beta release of Yukon as a solid foundation to begin developing applications or are there too many changes slated before final?
A: Typically the betas are feature-review tools, not low-level final API and development tools. Frequently the calls (or responses to those calls) will change, and I'd highly recommend you not develop final projects against a beta product. That said, working with the Beta will give you a leg-up in knowing the evolution of the product.

Host: EuanG (Microsoft)
Q: AspiringGeek: Are there any hard-copy primers available yet to get used to the interface? For example, I'm no slouch with DTS, but I was surprised at how tough it was for me to get going!
A: If you got the beta through the formal beta program there are updates on beta place, we are also working on tutorials for beta 2, and it making it easier so you don't need the tutorial :-)

Moderator: Stephen_D (Microsoft)
Q: How can I get the beta?
A: Keep your eye on http://www.microsoft.com/sql/prodinfo/betanominations.mspx.

Host: Rajesh (Microsoft)
Q: kris: How can I get the beta?

Q: mroach: Can you provide an estimate as to when the Yukon beta will be available to MSDN subscribers?
A: Beta2 will be next beta you can get. Rough estimate availability for MSDN should be shortly after beta2 is available for download.

Host: EuanG (Microsoft)
Q: curwiler: Just wondering if the .NET framework will need an update to run with Yukon?
A: It depends what you have installed, Yukon requires the Whidbey version of .Net Frameworks which is the next generation after 1.1.

Host: Rajesh (Microsoft)
Q: ibgone: Will database mirroring work without clustering enabled?
A: Yes, database mirroring will work without clustering.

Moderator: Stephen_D (Microsoft)
Q: There has to be some way we developers/db admins can get our hands on beta to play with it and give input?
A: I'm sorry, but unless you attended either PASS or the PDC, you'll have to wait for the public beta.

Host: EuanG (Microsoft)
Q: MikeG: Still no word on the update cluster capabilities <sigh> back to Oracle
A: What features are you looking for? We are adding 8 node support and Database Mirroring has a much faster fail over than Clustering does.

Host: Michael (Microsoft)
Q: Enterprise Manager is a great tool that we've all come to know (and love, mostly). What features are lost and gained by moving to the Workbench?
A: Our goal is to have all Workbench support the essential Enterprise Manager functionality in Workbench and support the new Yukon object types. In Beta 2, you will see a lot of EM feature to come on line.

Moderator: Stephen_D (Microsoft)
Q: Is there any improvement in the SQL optimizer engine...or most of stress was given on integrating with c# etc?
A: Lots of improvements, to many to list in detail here...

Host: EuanG (Microsoft)
Q: TVN: Any noted concerns regarding security when using CLR like user impersonation?
A: We have designed security in from day one and the model is too rich to explain here, I suggest looking for http://www.sqljunkies.com and MSDN for articles.

Host: swynk (MVP)
Q: TVN: is sqlmail smtp enabled ...
A: Yes, but requires MAPI to work with SMTP.

Host: EuanG (Microsoft)
Q: bbogart: follow-up re CLR performance: What sorts of demands will CLR make on server resources, particularly memory, that we have not had to deal with in previous versions?
A: Great question, we could have a chat just on this subject. The performance characteristics will be different when using SQLCLR, but you will be able to use the same tools to diagnose and investigate them. That's been one of the goals, so profiler, perfmon, the new system tables etc.

Moderator: Stephen_D (Microsoft)
Q: I should clarify this question "Will I be able to submit an update to a SQL Server cluster and if one fails have another server commit the same transaction?"
A: Not without resubmitting the query.

Host: Michael (Microsoft)
Q: mroach: Will you be able to have different database use different "SQLiMail" accounts, as opposed to the existing situation where all databases use the server level MAPI profile?
A: Yes. The profile security feature of SQLiMail allows you to grant access to database users and roles.

Host: swynk (MVP)
Q: DBDon: Will there be a MSDE version of Yukon? Has the license agreements been worked out for it and if so, will it include any admin tools?
A: Yes, there will be an MSDE version of Yukon but the license and feature set have yet to be announced.

Host: MarkA (MVP)
Q: AspiringGeek: MarkA_MVP, your comment regarding the big reason to learn C# is right on track. I can't keep up with my developers as it is, writing inefficient code that has to be re-written. I shudder when I think about the procedural detritus they'll throw at me…
A: I agree. A common mistake I think will be developers insisting on using .net languages for data access, when they should really have their set-based thinking cap on, and using T-SQL.

Host: Rajesh (Microsoft)
Q: BusmasterJones: Published "rumor" of XML datatype. Will this allow updates to a particular node of the XML document? If so, with what overhead?
A: Yes, you can update a particular node of XML datatype column. Performance depends on design and size of document. An XML datatype best practices white paper will be available to improve performance and better use.

Host: EuanG (Microsoft)
Q: Harv: Is there any improvement in how optimizer generates query plan when using hyperthreading?
A: There have been numerous improvements in the optimizer, too many to list here.

Host: swynk (MVP)
Q: helloworld: Are there new utilities like SQL Query Analyzer to build store procs, triggers?
A: Yes, the workbench and integration that you can already see in Visual Studio are great examples of the integrated approach to where things are going.

Moderator: Stephen_D (Microsoft)
Q: Are there changes to store procedure/view/triggers performance?
A: Yes, lots of changes, but we don't have any hosts who are part of that team and have the expertise to answer.

Host: Michael (Microsoft)
Q: I hope Yukon supports online dbcc reindex for 24X7 databases, but how effectively?
A: Our goal in Yukon is to support online index operations effectively.

Host: Rajesh (Microsoft)
Q: BusmasterJones: Rajesh_MS - Is there a link for Beta2 signup?
A: Keep your eye on http://www.microsoft.com/sql/prodinfo/betanominations.mspx.

Moderator: Stephen_D (Microsoft)
Q: Will Yukon/SQL2K run concurrently on the same box?
A: Yes, using at least one named instance.

Moderator: Stephen_D (Microsoft)
Q: Any new built-in roles? I would love to hand out some DBCC authority without handing out SA to devs!
A: Yes, there are lots of more granular permissions.

Host: MarkA (MVP)
Q: bbogart: Does Yukon provide the ability to compress and or encrypt database backups?
A: No. There are/will be third party products that can hook in and do this.

Host: EuanG (Microsoft)
Q: TVN: How scalable is Yukon on single server?
A: Yukon is currently in early beta so should not be used for performance assessment but we have done a lot of work on performance throughout the release and more scaleable is always a goal in a given release. With the addition of 64 bit SQL2000 the capabilities of a single box even today are highly impressive. In one of the SQL Server labs we have a 64 way 64 bit test machine with 1/2 TB of RAM and its not maxed...

Host: Michael (Microsoft)
Q: Does Yukon allow 'hiding' databases and tables based up role?
A: The new security layer on top of Yukon meta-data allows you to control who could view object definition.

Host: swynk (MVP)
Q: SirFish: What types of performance increases are you seeing in OLTP and OLAP sql2k dbs upgraded to Yukon?
A: While there are increases, it's so early in the beta process that quantifying them right now is pretty tough. As more code goes into production/final release, it should be easier to get data on these enhancements.

Host: EuanG (Microsoft)
Q: DBDon: System Specs for Yukon?
A: They will be higher than SQL2k for some aspects of the product (most of the tools are written in .Net so require a higher spec machine than the SQL2k tools).

Host: Michael (Microsoft)
Q: kris: What are the major advantages of using Workbench instead of Enterprise manager?
A: There are too many to list here! For example, SQL Workbench is an integrated environment for authoring and management all SQL Server products. All dialogs are non-modal, scriptable and resizable.

Host: swynk (MVP)
Q: Festeron: How much support can a DBA provide without Visual Studio software?
A: Visual Studio is not required.

Host: EuanG (Microsoft)
Q: MikeG: To be completely blunt that feature is the single biggest advantage Oracle has over SQL Server. I just wanna see it resolved.
A: Thanks for the feedback, I'll take it back to the cluster team.

Moderator: Stephen_D (Microsoft)
Q: Will there be a new version of Enterprise Manager or will all control be through the currently named "Work Bench"?
A: Workbench replaces Enterprise Manager.

Host: Rajesh (Microsoft)
Q: JMcDaniel: Are my Extended Stored Procedure modules going to have to be rewritten in .NET or will they still work with Yukon?
A: They will continue to work, but we highly recommend that you use and take advantage of new .NET programmability features in Yukon.

Host: MarkA (MVP)
Q: DBDon: Does Yukon have a 'Query Analyzer'?
A: It is called Query Editor and is integrated directly into SQL Workbench.

Host: EuanG (Microsoft)
Q: kris: For Monitoring Performance/activity, is there any new feature or tools added?
A: We have really re-vamped Current Activity, we are working closely with the MOM team and we are working on some other utilities for Beta 2 and beyond for Monitoring.

Host: MarkA (MVP)
Q: Jags_2000: Does that 3rd party Log Explorer (Lumigent?) still have use in Yukon?
A: You will need this if you wish to view the internals of transaction logs. I am not sure if Log Explorer will support Yukon - you will have to contact them.

Host: Michael (Microsoft)
Q: curwiler: Sure would be nice to have the MAPI requirement removed from the SQL mail features...
A: Your wish has come true! There will be a new mail subsystem in Yukon that does not require running MAPI on the server

Host: EuanG (Microsoft)
Q: Tommy: How do we find out the named instance of our Yukon server?
A: The same way as you can in SQL 2000 ( SQLBrowseConnect etc) plus we added a new WMI provider and new managed object model called SMO.

Moderator: Stephen_D (Microsoft)
Q: Are updates automatic in Yukon, or do we still have to download service packs?
A: We haven't determined that yet.

Moderator: Stephen_D (Microsoft)
Q: Does a DBA have the ability to regulate resources taken by Yukon or does it take the 'Kill em all' approach of previous versions?
A: It takes the 'Kill em all' approach. :-)

Host: EuanG (Microsoft)
Q: Harv: Do we have any other type of indexes available in Yukon except binary, like reverse, bitmap etc.?
A: The most obvious new one is XML indexes.

Host: Rajesh (Microsoft)
Q: kris: Whether Yukon will support Better stored procedure encryption?
A: Obfuscation of stored procedures will be supported in Yukon. We are looking to improve on our obfuscation mechanism as well.

Host: Michael (Microsoft)
Just for clarification, Yukon will ship with two mail sub-systems: SQL Mail and SQLiMail. SQLMail still requires running MAPI on the server, but the new SQLiMail subsystem does not require running MAPI and uses SMTP or sending email.

Host: swynk (MVP)
Q: kris: What are the major changes in Backup and Restore?
A: The focus is on making the db more available, keeping it online, faster, more specific recoveries, etc. Specific changes are pretty fluid (and too many to list here unfortunately), but there are great changes coming.

Host: Michael (Microsoft)
Q: SirFish: follow up on MAP/SMTP - since it's got CLR, can we just use System.Web.Mail in and SP to bypass MAPI constraints?
A: You could do that. But a better option for you would be to leverage the new SQLiMail subsystem to by-pass MAPI.

Host: EuanG (Microsoft)
Q: Tommy: Is the idea of the CLR integration to take the database development into the VS.NET development environment?
A: Yes and no, you can develop in VS but you can also develop in notepad and use the SDK compilers. The idea is about choice, we want to allow you to write objects and extend the server using languages which are familiar and where many people already have the skills. Rather than forcing you to use a database language or _one_ other we allow you to use any compliant .Net language. So far we have shown VB.Net, C#, MC++ and Borland Delphi. Hopefully there will be many more.

Host: Rajesh (Microsoft)
Q: sql_dba_guy: Will it be possible to assign priorities to either users or session? Some things are ok to run slow, but others need to have priority over everything else.
A: We have a dedicated admin connection but in general, for processes we do not set priority.

Moderator: Stephen_D (Microsoft)
Q: Why u r not responding to questions on partitioning,locking,indexes etc that are fundamental to rdbms and only replying to CLR and clustering when u know that rdbms are for set based queries and not to write procedural logic in CLR:)
A: Because we don't have anybody from the engine team here, and so don't have the in-depth knowledge necessary to give good answers to those questions.

Host: swynk (MVP)
Q: BusmasterJones: With CLR support, are there additional prerequisite installs that require separate licensing to use CLR?
A: Sorry, but it's just way too early to address licensing - it's not at all established at this point.

Moderator: Stephen_D (Microsoft)
Q: The delay to second half of 2004 pushes Yukon beyond the two year Free Update window. How will you keep customers happy, if they bought SS2K thinking that Yukon would be free?
A: We understand the issues involved here and are working on them, but I don't have an answer for you, yet.

Host: EuanG (Microsoft)
Q: curwiler: Sounds to me the .NET stuff is really more of a replacement for building code that XPs do now?
A: Yes it does and more, you can write rich new types, triggers etc in .Net in Yukon. We also provide a safe secure, modern execution environment, with a rich development IDE option.

Host: Michael (Microsoft)
Q: Tommy: How do we find out the named instance of our Yukon installation?
A: Try executing SELECT @@SERVERNAME.

Host: Rajesh (Microsoft)
Q: dkPGH: Does Yukon provide Upgrade Wizards for 2000 DBs?
A: Yes, it will.

Host: EuanG (Microsoft)
Q: RHale[ScooterStore] : EuanG_MS => Please inform us where these improvements are listed not that they aren't listed here.
A: Sorry but we are not talking about all features yet or in this chat, there will be other chats. The SQL Server team is 1000 people and the few of us on the chat can't answer for the entire product :-) Look out for more Yukon chats and articles.

Moderator: Stephen_D (Microsoft)
Q: Pubs and Northwind are getting quite tired. Any new, more complex sample databases coming?
A: Yes, look for adventureworks.

Host: EuanG (Microsoft)
Q: Tommy: Will there be storing of datasets in Yukon?
A: Not natively but you could stream in the XML into the XML datatype or to write your own datatype using SQLCLR :-)

Host: Michael (Microsoft)
Q: cedcas: Does Yukon allow "hiding" of DATABASES based on login?
A: Yes. There is a new security layer on top of Yukon meta-data allows you to control who could view object definition.

Host: swynk (MVP)
Q: jdperrenoud: Will it be possible to sp_detach, sp_attach replicated databases (publisher or subscriber) in Yukon?
A: No, but there have been/are discussions about making it similar to backing up and restoring replicated databases.

Host: EuanG (Microsoft)
Q: Harv: Are we releasing both 32 bit and 64 bit version of Yukon?
A: Yes we will be releasing 32 bit and 64 bit at the same time.

Moderator: Stephen_D (Microsoft)
Q: Is a 64 bit version for the AMD Opteron processor in the plans? I know they are working on the OS still, but even in 32 bit mode it works great with databases?
A: We're not commenting on platforms at this time...

Host: Rajesh (Microsoft)
Q: cedcas: Has any of the existing "SQL XML Support in IIS" been expanded (template, url queries and things)?
A: Yes there are enhancements for example, new features like native SOAP support, Native http support, Xquery support over XML views etc.

Host: EuanG (Microsoft)
Q: Cole: What parts of VS is required for the Reporting Services of Yukon?
A: Yukon will include everything you need to design reports; you will not need to buy any other products.

Host: Michael (Microsoft)
Q: jdperrenoud: Will DTS be fully supported in Yukon for 64 bit?
A: Unfortunately this question falls under the platform question. We're not commenting on platforms at this time...

Host: swynk (MVP)
Q: Festeron: swynk: Your VS answer was blunt - can I examine, troubleshoot, and profile CLR code with the Workbench?
A: You can't *edit* in the workbench, but you can review. You can edit in notepad, etc. - your tool of choice. For creating routines and such, there is no requirement in Yukon for Visual Studio. Hope that helps clarify.

Moderator: Stephen_D (Microsoft)
Q: Is there any improvement in transaction handling when using extended stored procedure?
A: No.

Host: EuanG (Microsoft)
Q: skullleader: Was wondering about the new Analysis Services. It looks more like a .net application then an admin console
A: There are 2 large new tools, SQL Workbench is the new Admin Tool and BI Workbench is the new Development tool, so yes it is dev focused but there will also be an admin experience.

Moderator: Stephen_D (Microsoft)
Q: Please tell me that Try/Catch error handling is a high priority.
A: Yes. It's in and working.

Host: Michael (Microsoft)
Q: gci: Currently in EM, any change will rebuild a table. Will this get any smarter such as only altering a table (on large tables this is critical).
A: We are aware of this issue and will try to address it in the Yukon timeframe.

Host: EuanG (Microsoft)
Q: BusmasterJones: This is picky, but are the refreshes automatic on Workbench -- rather than manual in EM?
A: Not in Beta 1 but they will be by RTM.

Host: Michael (Microsoft)
Q: Phil: Can you connect to Yukon with 2000's EM?
A: No. You can only use SQL Workbench to manage a Yukon server.

Host: Rajesh (Microsoft)
Q: Audie_Wright: MSFT is boasting a new ETL toolset. What are the major enhancements? DTS is "very" limited when compared to other ETL solutions.
A: So many nice features to list...for example complex control flows, control flow debugging, many DTS tasks additions and enhancements, enhancements on transform, wizards, error reporting, runtime error handling, transfer store procedure, etc.

Host: swynk (MVP)
Q: Tommy: Will you be able to specify exactly what data types are logged in transaction logs in order to minimize sizes of these logs?
A: Not sure what you're asking. Are you saying specific data types, or specific columns?

Host: EuanG (Microsoft)
Q: Audie_Wright: I would have to agree with Harv. I am a Sr. DBA on both SQL Server & Oracle. SQL Server needs enhancements in partitioning, indexing (bitmaps, etc), and other scalability enhancements like RAC.
A: We are adding partitioning of tables and indexes, more details at a later date. We have some index enhancements but this is not the right forum to discuss and we have added Database Mirroring which is a great availability feature for a DBA.

Host: swynk (MVP)
Q: BusmasterJones: Ok, most of the panel is MS and can only say so much...where is the best website to get breaking "off the record" Yukon info?
A:http://www.sswug.org - of course. Get on the newsletter and we'll keep you informed.

Host: EuanG (Microsoft)
Q: aRNIE: I haven't seen a response to the question of MSDE. Will there be a MSDE/Desktop version of Yukon?
A: Yes there will be a version of MSDE for Yukon, we have not announced the detailed plans but we have put a LOT of work into it, watch out for Beta 2.

Moderator: Stephen_D (Microsoft)
Q: How can we send our suggestions or current problems to YUKON development team if it not too late already :)
A: Suggestions can be sent to sqlwish@microsoft.com There are private newsgroups for beta customers with problems, or you can post to the public newsgroups or sqljunkies.com.

Host: EuanG (Microsoft)
Q: Tommy: Where is the Yukon development team located and are there any teams in Santa Clara California?
A: The majority of the team is based in Redmond although we have a small number of folks scattered all around the world.

Host: swynk (MVP)
Q: Tommy: swynk: I would not make such a big assumption that people would rather develop in notepad than the VS.NET IDE... I would rather see a ton of integration with VS.NET than very little just because someone at MS thought developers would rather us.
A: Actually, was just trying to point out that VS isn't *required*. :)

Host: Michael (Microsoft)
Q: dkPGH: Can we use new Workbench to connect to 2000 DBs?
A: Yes, you can use SQL Workbench to manage SQL Server 2000 and SQL Server 7.0.

Host: EuanG (Microsoft)
Q: Tommy: EuanG_MS: SQLCLR??? Are you telling me that there are two CLRs? A SQL CLR and a .NET CLR? I thought that a dataset was a data type... and... it is a datatype that MS wrote. How could it not be supported?
A: Sorry my bad, SQLCLR is what we call the integrated CLR running inside SQL Server, its the same version of the CLR as runs outside the server. Dataset is not a SQL Server Datatype, not all .Net Datatypes are stored natively inside the server.

Host: EuanG (Microsoft)
Q: gaastra: EuanG_MS says 'you can write rich new types, triggers etc in .Net in Yukon'. Will there be a kind of universal kill switch for all these as well. i.e. deny all CLR'whatevers' on an entire database?
A: We have been considering this, watch for Beta 2.

Host: EuanG (Microsoft)
Q: Tommy: sqynk: I would not make such a big assumption that people would rather develop in notepad than the VS.NET IDE... I would rather see a ton of integration with VS.NET than very little just because someone at MS thought developers would rather us
A: Don't get us wrong, VS.Net provides GREAT integration, but it's not required. I know which way I'd rather write these objects :-)

Host: EuanG (Microsoft)
Q: dkPGH: Can we use new Workbench to connect to 2000
A: Yes, and SQL7 but only for SQL Servers (Workbench supports Analysis Services, CE, NS etc as well).

Moderator: Stephen_D (Microsoft)
Thanks for joining us today! You've asked some great questions. We'll finish the final questions that we're working on, but unfortunately, it's time to go.

Host: MarkA (MVP)
Thanks for your questions, I need to go now. See you on http://ls.sswug.org :-)

Host: swynk (MVP)
Thanks everyone - hope to see you on www.sswug.org - have a great day!

Host: Rajesh (Microsoft)
Thank you!! It was nice chatting.

For further information on this topic or about SQL Server, please visit the following:

Newsgroups: SQL Server Newsgroups

SQL Transcripts: Read the archive of past SQL chats.

Website: Visit the Microsoft SQL Website