Recent update: 2008-3-21

Code Insight?

96 byte By JasminAzemovic at 2008-3-7
Hello Is there any plans to implement Code Insight in to SQL Server 2008? Thx

Management Studio "Katmai" - problem with fonts and colors

213 byte By JiriLichtenberg at 2008-3-6
I have tried to change font in SQL Server Managenet Studio Katmai . Set enviroment : Tools -> Option -> Enviroment -> Fonts and Colors - does not work . Regards Jiri Lichtenberg

SQL Server Connectivity Problem

914 byte By 小朱 at 2008-3-5
Hi all~I installed SQL Server 2008 July CTP on my Windows Vista computer (OS: Vista Ultimate).When I use SSMS to connect to SQL Server 2008, a error message shown: No process is on the other end of the pipe. I check the advanced information: Advanced Error InformationServer Name: ...

SQL Server Connectivity Problem

914 byte By 小朱 at 2008-3-3
Hi all~I installed SQL Server 2008 July CTP on my Windows Vista computer (OS: Vista Ultimate).When I use SSMS to connect to SQL Server 2008, a error message shown: No process is on the other end of the pipe. I check the advanced information: Advanced Error InformationServer Name: ...

Management Studio "Katmai" - problem with fonts and colors

220 byte By JiriLichtenberg at 2008-3-1
I have tried to change font in SQL Server Managenet Studio Katmai . Set enviroment : Tools -> Option -> Enviroment -> Fonts and Colors - does not work . Regards Jiri Lichtenberg </span>

don't find Management Studio after installed SQL 2008 CTP JULY.

147 byte By bill2600 at 2008-2-28
My OS is WinXP </font> I don't find Management Studio after installed SQL 2008 CTP JULY.</font> Why? Thanks! bill

Query execution history?

899 byte By JasminAzemovic at 2008-2-27
Any chance to get this feature in SSMS? http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124530 http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125147Also nice blog post about it: ...

SQL Server Management Console for SQL Server 2008

372 byte By pzn at 2008-2-26
I uninstalled SQL Server 2005, and loaded SQL Server 2008 on my XP SP2 pc. After everything installed, I'm still missing the SQL Server Management Console for SQL Server 2008. During installation, I ensured I did check client management tools to have the GUI interface to the 2008 SQL ...

don''t find Management Studio after installed SQL 2008 CTP JULY.

237 byte By bill2600 at 2008-2-25
<font face="Times New Roman"></font><font face=Arial size=2> My OS is WinXP </font> <font face=Arial size=2>I don't find Management Studio after installed SQL 2008 CTP JULY.</font> Why? Thanks! bill

Query execution history?

904 byte By JasminAzemovic at 2008-2-24
Any chance to get this feature in SSMS? http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124530 http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125147 Also nice blog post about it: ...

Error in Management Studio

475 byte By TimDBA at 2008-2-23
Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error: An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'. This ...

SQL Server 2008 June CTP Declarative Management Bug

873 byte By DanJonesMSFT at 2008-2-22
There is a bug in the SQL Server 2008 June CTP that causes Declarative Management to be inoperable. The fix is very simple. Launch a command line and run the following command: C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\sn.exe -Vr ...

SQL Server Connectivity Problem

928 byte By 小朱 at 2008-2-22
Hi all~ I installed SQL Server 2008 July CTP on my Windows Vista computer (OS: Vista Ultimate). When I use SSMS to connect to SQL Server 2008, a error message shown: No process is on the other end of the pipe. I check the advanced information: Advanced Error InformationServer Name: ...

Please help me...sql management studio 2008

476 byte By TimDBA at 2008-2-21
Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error: An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'. ...

Error in Management Studio

475 byte By TimDBA at 2008-2-20
Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error: An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'. This ...

SQL Server Management Console for SQL Server 2008

372 byte By pzn at 2008-2-19
I uninstalled SQL Server 2005, and loaded SQL Server 2008 on my XP SP2 pc. After everything installed, I'm still missing the SQL Server Management Console for SQL Server 2008. During installation, I ensured I did check client management tools to have the GUI interface to the 2008 SQL ...

don''t find Management Studio after installed SQL 2008 CTP JULY.

237 byte By bill2600 at 2008-2-18
<font face="Times New Roman"></font><font face=Arial size=2> My OS is WinXP </font> <font face=Arial size=2>I don't find Management Studio after installed SQL 2008 CTP JULY.</font> Why? Thanks! bill

JULY CTP (WORKSTATION COMPONENTS FAIL INSTALL)

2455 byte By SteveBouff at 2008-2-17
AMD ATHLON 64-BIT WINDOWS XP PRO X64 EDITION SQL SERVER KATMAI X64 BIT INSTALLTION (JULY CTP) I've been trying to install the WorkStation components from the JULY CTP. I previously had the JUNE CTP installed. The entire instllation of the database engine and integration services went fine. ...

Code Insight?

99 byte By JasminAzemovic at 2008-2-16
Hello Is there any plans to implement Code Insight in to SQL Server 2008? Thx

don''t find Management Studio after installed SQL 2008 CTP JULY.

237 byte By bill2600 at 2008-2-15
<font face="Times New Roman"></font><font face=Arial size=2> My OS is WinXP </font> <font face=Arial size=2>I don't find Management Studio after installed SQL 2008 CTP JULY.</font> Why? Thanks! bill

DatabaseDefaults Policy (not working?)

16181 byte By SteveBouffard at 2008-2-15
I created the following policy. It's a basic policy for enforcing database settings. I then created a database in violation of the policy and didn't generate an error. I also altered the database to violate the policy and still didn't get any policy errors. alter database test2 set ...

Error in Management Studio

475 byte By TimDBA at 2008-2-15
Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error: An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'. This ...

DatabaseDefaults Policy (not working?)

16181 byte By SteveBouffard at 2008-2-15
I created the following policy. It's a basic policy for enforcing database settings. I then created a database in violation of the policy and didn't generate an error. I also altered the database to violate the policy and still didn't get any policy errors. alter database test2 set ...

Error in Management Studio

475 byte By TimDBA at 2008-2-15
Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error: An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'. This ...

Please help me...sql management studio 2008

476 byte By TimDBA at 2008-2-14
Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error: An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'. ...

Please help me...sql management studio 2008

515 byte By TimDBA at 2008-2-14
Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error: An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'. ...

Error in Management Studio

475 byte By TimDBA at 2008-2-13
Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error: An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'. This ...

SQL Server Management Console for SQL Server 2008

412 byte By pzn at 2008-2-13
I uninstalled SQL Server 2005, and loaded SQL Server 2008 on my XP SP2 pc. After everything installed, I'm still missing the SQL Server Management Console for SQL Server 2008. During installation, I ensured I did check client management tools to have the GUI interface to the 2008 SQL ...

Mgmt Studio: List versus Details view

237 byte By BobJ0101 at 2008-2-12
So now all the Details views have the "Policy Health State" column. Great. But when will we be able to add other columns to the details views? Or at least put back what SQL 2K used to show in details views? Pretty please?

JULY CTP (WORKSTATION COMPONENTS FAIL INSTALL)

2455 byte By SteveBouff at 2008-2-11
AMD ATHLON 64-BIT WINDOWS XP PRO X64 EDITION SQL SERVER KATMAI X64 BIT INSTALLTION (JULY CTP) I've been trying to install the WorkStation components from the JULY CTP. I previously had the JUNE CTP installed. The entire instllation of the database engine and integration services went fine. ...

DatabaseDefaults Policy (not working?)

16181 byte By SteveBouffard at 2008-2-10
I created the following policy. It's a basic policy for enforcing database settings. I then created a database in violation of the policy and didn't generate an error. I also altered the database to violate the policy and still didn't get any policy errors. alter database test2 set ...

Tools installation issues.

683 byte By JeffreyBecker at 2008-2-10
I've downloaded the June CTP of SQL Server 2008 & I'm getting the following error when I go to install the tools: This installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid ...

Where Resource Governor is?

301 byte By paolod at 2008-2-8
Good morning,in first documentation a system performance monitor called "Resource Governor" is often quoted; anyway, I installed Katmai Developer Edition CTP and I'm not able and find, neither in BOL nor in Management Studio or tools.Can anyone tell me where is it located? ...

Stored Procedure Scripting (SQL Server 2005 db)

481 byte By JimKlein at 2008-2-8
I connected to a network SQL Server 2005 database and tried to script a couple of stored procedures. All I got was USE [STA]. I am running on Vista Ultimate (I know it has other issues). Is this a Vista issue only? I will try this on my WIndows 2003 Server VPC tomorrow when I get back to work ...

How enabling DMF affects speed of table creation

26666 byte By AlexeyYeltsov-MSFTTAPcustmr at 2008-2-7
Perf hit is expected, but looks like currently it's quite a lot. Say I can create ~500 tables and views (250+250) per second without DMF. Once I enforce naming conventions (tbl% for tables and vw% for views), the rate of object creation falls to 3 objects per second. Seems like a pretty ...

How enabling DMF affects speed of table creation

18766 byte By AlexeyYeltsov-MSFTTAPcustmr at 2008-2-7
Perf hit is expected, but looks like currently it's quite a lot.Say I can create ~500 tables and views (250+250) per second without DMF.Once I enforce naming conventions (tbl% for tables and vw% for views), the rate of object creation falls to 3 objects per second.Seems like a pretty high ...

How to install Management Studio for Katmai

552 byte By Muenchner at 2008-2-7
Hello ALL,I have a issue installing Katmai on my PC.On the PC a MS SQL 2005 Dev. Edition is already running.I tried to install Katmi, the Installation was properly finished, but I do not have the ManagementStudio installed.I tried to run th Man. Studio of MS SQL 2005 with Katmai - not possible, ...

<Never mind, self-ansered> DMF - is it by design that database can't subscribe to Def

678 byte By AlexeyYeltsov-MSFTTAPcustmr at 2008-2-7
If by design, I can't really understand why we would not allow that...[EDIT]Answered this myself... BOL says: Declarative Management Framework policy groupA user-defined group to help manage policies. Users can classify policies into different policy groups. A policy belongs to one and only ...

Relationship Policies - Conditions

322 byte By KlausAschenbrenner at 2008-2-6
Hi!Is it possible to include several conditions into a single policy?ThanksKlaus Aschenbrenner http://www.csharp.at http://www.csharp.at/blog ...

Run Policies /Surface Area Configuration - Bug

809 byte By KlausAschenbrenner at 2008-2-6
Hi!I've created the "Off By Default Policy" as described in BOL (ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/41c3022d-ab13-443e-ac64-ba1d64584f79.htm) for SQL Mail and Database Mail.When I then activate SQL Mail and Database Mail through Surface Area Configuration ...

Policy Management - Enabling a policy

718 byte By KlausAschenbrenner at 2008-2-5
Hi!I've followed the "Create the Off By Default Policy" lesson in BOL (ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/98fde3c5-297c-4d95-981e-95700bbf5ccd.htm). But as soon as I want to enable the created policy I get the following error message inside SQL Server ...

SQL Server 2008 June CTP Declarative Management Bug

865 byte By DanJonesMSFT at 2008-2-5
There is a bug in the SQL Server 2008 June CTP that causes Declarative Management to be inoperable. The fix is very simple. Launch a command line and run the following command: C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\sn.exe -Vr ...

SQL Server Katmai

Site Classified