Posted by Erland Sommarskog on 09/23/06 09:43

mcaglar@cs.ucf.edu (mcaglar@cs.ucf.edu) writes:
> I had find the exact same solution at a different thread in this group
> and it worked, but thank you for your response. Interestingly,
> Enterprise manager does not allow to perform such action. I wonder if
> this was a bug or a design issue. Does anyone know if this peoblem is
> fixed on SQL Server 2005?

Enterprise Manager is not included in SQL 2005, neither is Query Analyzer.
Both tools have been superceded by SQL Server Management Studio. Whether
the GUI dialogs in Mgmt Studio would make this operation available to you
I don't know. In any case, the GUI are just wrappers on the T-SQL commands,
and you can always use T-SQL when the GUI does not expose a certain piece
of functionality.

--
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

• Next in forum: Master File not Accessible for Copying
• Prev in forum: Re: Insert trigger to populate other columns in same row
• Thread view: Re: Point in Time Backup (impossible for some points?)

[Reply to this message]