SQL Server 2008 November CTP released
SQL Server 2008 November CTP released.
This is one of most significant public Community Technology Preview (CTP) releases for SQL Server 2008.
You can download it from.
Short list of the new features https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=7003
Please make sure you take a look at the Readme to avoid any known problems.
http://go.microsoft.com/fwlink/?LinkId=94485
You can post CTP comments, questions on Katmai Analysis Services MSDN forum http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1615&SiteID=1. Or just post it here if you feel like it.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
SQL Express 2008 November CTP - Come and get it
I've posted the pertinent links in the blog at http://blogs.msdn.com/sqlexpress/archive/2007/11/19/what-s-new-in-sql-express-2008-november-ctp.aspx.
Regards,
Mike Wachal
SQL Express team
SQL Server 2008 November CTP now available
Pertinent links are in the blog: http://blogs.msdn.com/sqlexpress/archive/2007/11/19/what-s-new-in-sql-express-2008-november-ctp.aspx
Regards,
Mike Wachal
SQL Express team
driver JDBC
I also am having this problem! if you get an solution,
send me an answer or add my msn: griciolli@hotmail.com
BUG in KB941649: the return from sleep doesn't work properly, if the power goes off
BUG in KB941649: the return from sleep doesn't work properly, if the power goes off
After I installed this patch KB941649, the sleep doesn't work properly if the power goes off, i.e. the computer doesn't boot when the power return on. Reproduction steps: 1. press the sleep button and wait until the computer gone to sleep 2. turn off the power 3. turn on the power ... and the computer doesn't boot, it doesn't return from hibernation, you have to press the reset button in order to be executed the return from hibernation properly.
Without the patch, everything works fine.
User Configurations
Hi,
I just downloaded Windows SteadyState and i'm have a hard time configuring the right user configuration. Can anybody please help me or send me a user account file (*.ssu).
Thank You,
JoshM321
Reply:
Hi JoshM321,
What do you want in your shared user profile?
Have you tired different restriction levels? If none of them meet your requirements, please list them first. Otherwise, it's too obscure to provide suggestions.
Best Regards,
------------------------------------
The Wizard stole my IDENTITY
Wizard Says:
Private Sub MarketLogFilesBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MarketLogFilesBindingNavigatorSaveItem.Click
Me.Validate()
Me.MarketLogFilesBindingSource.EndEdit()
Me.MarketLogFilesTableAdapter.Update(Me.EveMarketDBDataSet.MarketLogFiles)
End Sub
I say:
Private Sub MarketLogFilesBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MarketLogFilesBindingNavigatorSaveItem.Click
Me.Validate()
Me.MarketLogFilesBindingSource.EndEdit()
Dim command As New SqlClient.SqlCommand("SELECT @@IDENTITY", Me.MarketLogFilesTableAdapter.Connection)
Me.MarketLogFilesTableAdapter.Connection.Open()
Me.MarketLogFilesTableAdapter.Update(Me.EveMarketDBDataSet.MarketLogFiles)
Dim i As Integer = CType(command.ExecuteScalar(), Integer)
Me.MarketLogFilesTableAdapter.Connection.Close()
End Sub
Though this code may be totally wrong, it works. I spent many hours trying to find a way that didn't involve me writing my own Update commands, or more to the point, I was sure that such a simple task as retriving the last PK of record had to be in the wizards head somewhere. I am sure there is a simple way to do it, that I have so clearly missed, but for those of you who rely on the wizard, the above at least got me one step closer. It seem's in the auto-gen code, the connection is closed after the update command IF the connection was closed BEFORE the update command was issued.
IF ANYONE CAN FIND ME DOCUMENTATION ON THAT FACT, I WILL GIVE YOU ONE MILLION....
Thanks guys, keep up the great work, I love these forums - inspiration and knowledge -
Reply:
Okay, it looks like there are some misunderstandings here. I'm not sure you understand that the @@Identity value is generated on the server AFTER the TSQL UPDATE is execute. EndEdit simply posts the changes from the bound control to the underlying DataTable, it does not call the TableAdapter (or DataAdapter) Update method. If you choose to take this route you need to ask for the @@Identity (actually SCOPE_IDENTITY() is better) AFTER callin the Update method.
Take a look at my website.http://www.betav.com/Files/Content/whitepapers.htm or my book for a detailed explaination of this strategy. I think there are still open seats for my workshop in Vancouver, BC on the 26th (www.devteach.com)
------------------------------------
Reply:
Thanks for your reply - and the whitepapers
------------------------------------
printer connection issues with windows XP and vista
I replaced my old main desktop PC with a new desktop with windows vista home premium, this unit has printer connected to it. I have three PC's on my net work my office PC, kids PC, and my laptop. Now the office PC is the new one with windows vista. The laptop has widows vista also. the kids PC has XP. the network is set up and I can see all three pc's just fine and all computers. trnasfer files between them with no issues. Working on setting up the network printer works fine on my two vista systems. On my XP unit i can't even see the printer tried adding network printer it see's my systems but no options for printers. I installed that LLTD Hotfix with no luck. Also, my network is a wifi network.
Thanks Leon
BUG in KB941649: the return from sleep doesn't work properly, if the power goes off
After I installed this patch KB941649, the sleep doesn't work properly if the power goes off, i.e. the computer doesn't boot when the power return on. Reproduction steps: 1. press the sleep button and wait until the computer gone to sleep 2. turn off the power 3. turn on the power ... and the computer doesn't boot, it doesn't return from hibernation, you have to press the reset button in order to be executed the return from hibernation properly.
Without the patch, everything works fine.
Error 0x800705AD "Insufficient quota to complete the requested service." *PROBLEM SOLVED*
I see others have had this same problem and it's been know for almost this whole year. You can see my resolution here...
I'd be interested to know if this solves the problem for you or no.
Thanks,
Tom.
BIDSHelper v1.2 released - now with SSIS features
Accessing SPS2003 User's Database
Public Sub ShowGroupsByUser(ByVal LoginName As String) Dim oConn As SqlConnection = New SqlConnection(_SPSconnString), oCmd As SqlCommand = New SqlCommand While oDR.Read() GroupName = oDR(0).ToString End While End Sub
oConn.Open()
oCmd.Connection = oConn ',[tp_Login],[tp_Title],[tp_Email],[tp_Notes]
oCmd.CommandText = "SELECT 'Web'= (Select[Title]From Webs where ID = A.[WebID])FROM [WebGroupMembership]A, [WebGroups]B WHERE [Title] = 'Administrator' And A.GroupID = B.ID AND A.WEBID = B.WEBID AND [MemberID] =(SELECT [tp_id]FROM [UserInfo] WHERE [tp_Login]='" & LoginName & "')"
Dim oDR As SqlDataReader
oDR = oCmd.ExecuteReader
Private Function sIsSiteAdmin(ByVal LogIn As String) As Boolean
Dim oConn As SqlConnection = New SqlConnection(_SPSconnString), oCmd As SqlCommand = New SqlCommand
Dim oDR As SqlDataReader
Dim SQLSTR As String
oConn.Open() : oCmd.Connection = oConn
SQLSTR = "SELECT tp_siteadmin FROM [UserInfo]WHERE [tp_Login]='" & LogIn & "'"
oCmd.CommandText = SQLSTR
Return oCmd.ExecuteScalar
End Function
Public Function GetGroupsByUser() As Boolean
Dim SPS_Conn As SqlConnection = New SqlConnection(_SPSconnString), SPSCmd As SqlCommand = New SqlCommand
SPS_Conn.Open()
SPSCmd.Connection = SPS_Conn ',[tp_Login],[tp_Title],[tp_Email],[tp_Notes]
If IsSiteAdmin = True Then
SPSCmd.CommandText = "SELECT distinct 'Web'= (Select[Title]From Webs where ID = A.[WebID])" & _
" FROM [WebGroupMembership]A"
Else
SPSCmd.CommandText = "SELECT 'Web'= (Select[Title]From Webs where ID = A.[WebID])FROM [WebGroupMembership]A, [WebGroups]B " & _
"WHERE [Title] = 'Administrator' And A.GroupID = B.ID AND A.WEBID = B.WEBID AND [MemberID] =(SELECT [tp_id]FROM [UserInfo] WHERE [tp_Login]='" & AUTH_USER & "')"
End If
oDR = SPSCmd.ExecuteReader
While oDR.Read()
Dim GroupName As String = oDR(0).ToString
Dim oDR1 As SqlDataReader
Dim SPS_Conn1 As SqlConnection = New SqlConnection(_SPSconnString), SPSCmd2 As SqlCommand = New SqlCommand
SPS_Conn1.Open()
SPSCmd2.Connection = SPS_Conn1 ',[tp_Login],[tp_Title],[tp_Email],[tp_Notes]
SPSCmd2.CommandText = "SELECT [tp_Title],[tp_email]FROM [WebGroupMembership]A,[UserInfo] B " & _
" Where [tp_id]=[MemberID]And [WebID] = (Select [Id]From [Webs] where [Title] ='" & GroupName & "')"
oDR1 = SPSCmd2.ExecuteReader
While oDR1.Read()
Name = oDR1(0).ToString
Name = Name.Replace("'", "''")
Email = oDR1(1).ToString
Dim oConn1 As SqlConnection = New SqlConnection(_connString), oCmd1 As SqlCommand = New SqlCommand
' Response.Write("User:" + Name + " --- " + Email + "
")
Name = Name.Replace("'", "''")
oConn1.Open() : oCmd1.Connection = oConn1
SQLSTR = "INSERT INTO [Recipient]([Email],[FirstName],[BodyFormat])" & _
" VALUES('" & Email & "', " & _
"'" & Name & "', " & _
"'" & "1" & "')"
oCmd1.CommandText = SQLSTR
oCmd1.ExecuteNonQuery()
oConn1.Close()
End While
End Function
Private Sub AddAdminUsersToList()
Dim Name, Email, SQLSTR As String
Dim SPS_Conn As SqlConnection = New SqlConnection(_SPSconnString), SPSCmd As SqlCommand = New SqlCommand
Dim oDR As SqlDataReader
SPS_Conn.Open()
SPSCmd.Connection = SPS_Conn ',[tp_Login],[tp_Title],[tp_Email],[tp_Notes]
SPSCmd.CommandText = "SELECT [tp_Title],[tp_email] FROM [UserInfo] B Where tp_siteadmin=1"
Try
oDR = SPSCmd.ExecuteReader
While oDR.Read()
Name = oDR(0).ToString
Name = Name.Replace("'", "''")
Email = oDR(1).ToString
Dim oConn1 As SqlConnection = New SqlConnection(_connString), oCmd1 As SqlCommand = New SqlCommand
' Response.Write("User:" + Name + " --- " + Email + "<br>")
Name = Name.Replace("'", "''")
oConn1.Open() : oCmd1.Connection = oConn1
SQLSTR = "INSERT INTO [Recipient]([Email],[FirstName],[BodyFormat])" & _
" VALUES('" & Email & "', " & _
"'" & Name & "', " & _
"'" & "1" & "')"
oCmd1.CommandText = SQLSTR
oCmd1.ExecuteNonQuery()
oConn1.Close()
End While
Catch ex As Exception
Response.Write(ex.Message.Replace("<", "["))
Finally
End Try
End Sub
Exstanding SCE 2007 functionality
Hello
on the sce management server we can see all softwares running of the managed client systems. But we can't see graphical topology stracture of all softwares and data files of managed client systems on the sce management server.
for eample, we develope a tool which can display graphical topology stracture of all softwares and data files of managed client systems.
combining both (SCE 2007 and our own tool) the functionality of sce can exstand to meet our requirements.
Is it possible to do like this?
or
Any other ideas?
any help will be appr.... and txs...
Reply:
Hi,
Currently, we can view all installed software of clients via "Software Inventory" in "Essentials Reports" item under Reporting tab on SCE console. For now, SCE server does not provide the graphical topology function of all software and data files of managed clients on the SCE server console, this is by design.
Regarding if it is possible to develop a tool which can display graphical topology structure of all software and data files of managed client systems, I am not sure about that so far. And now, I am forwarding your comments to our related team to check if it be done.
I will keep you updated here. Thanks for your time and patience.
If there is anything unclear, feel free to let me know.
Sincerely,
Robbin Meng
Microsoft Online Community Support
------------------------------------
Reply:
Hi Robin,
Thanks for your reply.
I have a few more questions.
1. Graphical topology: In SCCM 2007 Forum, community support team told me that this is possible using sccm with sdk (need to write some scripting). Is there any thing similar way or some thing....?
2. Is there a way to change parameter values in a xml files of managed clients from SCE server?
3. lets assume that, a parameter value in xml file is R = 1200, unfortunately me or someone changed this value to 1300. in this case i would like to receive a error report about this issue. How do i make it possible by using Management Packs or any recommandations? Deatailed explanation please
thanks a lot in advance
------------------------------------
Reply:
Hi atmakuri,
Regarding the Graphical topology, please understand SCE 2007 is very different from SCCM 2007 and the monitoring function also diverse. Currently, I still cannot make sure if it is possible to create such a Graphical topology, may be it will be added in the next version or Service Pack.
Regarding the 2 and 3 questions, I am sorry to say we cannot modify the .xml from the client or server. The .xml is only a query result file that generated by the SEC server MP. Modify the .XML file will not affect the monitoring status of agent computer. Therefore, it does not make sense to modify the XML file.
For your reference, here is an MP related site:
Sample Management Packs
http://www.authormps.com/dnn/Samples/tabid/56/Default.aspx
Sincerely,
Robbin Meng
Microsoft Online Community Support
------------------------------------
Reply:
Hi Robbin,
thanks a lot for ur response
------------------------------------
Is Microsoft going to include KB940287 in a Cumulative Update?
Re: KB 940287 - Will it be in a Cumulative Update?
SYMPTOMS:
An error occurred while receiving data: '64(The specified network name is no longer available.)'
This message could not be delivered because the conversation endpoint has already been closed.
It has several workarounds. I've not been affected by this yet, but KB says it has a hotfix that has been out since July 2007, so it is curious that it has not been put into a Cumulative Update yet, at least as far as documentation in Knowledge Base is concerned. Does anyone know any more about this?
Paul
Reply:
------------------------------------
BizTalk Server Enhancement Request/Suggestion
The ability to add Pre-Build and Post-Build Events to BizTalk projects would be much appreciated.
InteractiveHeight in report
I want to report a bug in CTP SQL2008 (SSRS).
I did the DAT87-HOL Authoring Reports Using SQL Server 2008 Reporting Services lab during the IT Forum in Barcelona and found out that the putting the interactiveheight property of the report could not be set to 0 to enable soft page breaks. This worked well in SSRS 2005.Reply:
Hi Bugs
To be clear, setting InteractiveHeight to 0 will "disable" soft page breaks, not enable them. This is a scenario that should continue to work in SSRS 2008 as it did in previous versions. I was able to reproduce the problem in an in-house build of Report Designer. I have filed a bug on your behalf to get this fixed.
Many thanks,
Chris B.
------------------------------------
Reply:
For future reference, the best way to report bugs is via the MSConnect site, http://connect.microsoft.com. These go directly into our bug database.
------------------------------------
Windows Vista IE
I think the guy is saying "Had same trouble until I removed kb885523 t.v media adware, you can also try kb886590 t.v media removal tool...hope it helps you."
Anyway, I'm having a similair problem aswell and I've looked into those TV things and have found this I've not actually read through it myself but plan on doing so! Sorry I can't be of much help but I've only just found the problem occuring. When I fix mine I'll let you know what I did
unwillingness to resolve the issues or concerns at large
I find it distressing, that there are probably thousands of end users in the field experiencing the same issues as noted here, and that only a tiny percentage are aware of forums like this to seek answers and comparative views from others in the same scenario. Microsoft should address in its earliest state without waiting to see an industry wide failure before they react.
Reply:
Dear GlobalGood,
Thank you for your feedback. Could you please let me know your concern? I will do my best to address it.
If you are talking about the Network List Service issue, please understand that we are always following it up. I know that it is time consuming, but please understand the issue is related to third party product, I am doing my best to reproduce, test and trace the issue and trying to resolve it on our site. However, it still cannot be reproduced in my testing environment until now. As a result, I need your help to test and collect information so that we can identify the cause of the issue in a timely manner.
In addition, according to tims10000's update in your thread, there may be an update from AOL which can fix the issue. Please update the AIM and check if the issue can be resolved.
Sincerely,
Joson Zhou
Microsoft Online Community Support
------------------------------------
MOSS User Profile Import - Why can't I find Distribution Lists? Why is my AD Import failing?
Check out my posting on this on my blog:
http://calehoopes.blogspot.com/2007/11/moss-user-profile-import-why-can-i-find.html
This posting will talk about why you need to do an import before being able to use Distribution Lists with Audiences and how your User Profile Import could be failing because of the nature of your active directory domain name.
Enjoy!
Cale Hoopes
caleh@ascentium.com
http://calehoopes.blogspot.com
No comments:
Post a Comment