The December CTP From The SQL MSDN Developer Center
Dec 26, 2006Hi
Is this an upgrade for sql server 2005 express.
If I already have Sql server 2005 express must I still download
the whole file.
Rgds
Rob
Hi
Is this an upgrade for sql server 2005 express.
If I already have Sql server 2005 express must I still download
the whole file.
Rgds
Rob
As I am begininng to believe that is the only edition I am going to be able to run on my Vista Utlimate os.
Standard does not install server components.
I believe SQL Express was working as installed with Visual Studio 2005, but I need the use the tools that SQL Express does not contain.
Thanks,
_Greg
Can I install SQL Server 2005 Developer Edition on XP Media Center Edition?
Thanks.
I am running the Office Professional Plus 2007 RTM with all options enabled and SQL 2005 Developer Edition on my local box. Based on the system requirements listed on the download page for the Office 2007 Data Mining Add-In, I've also verified that I have the correct CTP of SQL 2005 SP2 and that .Net 2.0 Framework is installed. Finally, I've verified that my local instance of SQL Server is configured correctly to allow temporary data mining models.
In Excel, all of the Table Analysis tools seem to work fine, and most of the options on the Data Mining ribbon also work; however, all of the options under "Data Modeling" on the Data Mining ribbon return the following error when I try to use them:
"Could not load file or assembly 'Microsoft.DataWarehouse, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependents. The system cannot find the file specified."
I've tried uninstalling everything and reinstalling, but I still get this error when I try to use the Data Modeling options.
Right now, I'm only working against the sample data provided when the data mining add-in is installed.
Any ideas on how to resolve this issue?
Upgraded SQL 2005 to Dec CTP sp2. Had previously run Nov CTP and installed the Sharepoint add-in. Had that all working.
Now trying to add the Dec CTP sharepoint add-in. But it won't complete. Keeps rolling back and then ending with dialog '.... setup was interrupted'
Anyone else seeing problems with this Dec CTP install?
Hi,
if I try to install SP 2 using SQL Server authentification (sa) it fails. The following lines appear in the file "Hotfix.log":
01/03/2007 14:08:23.859 Authenticating user using SAPWD
01/03/2007 14:08:23.875 Validating database connections using Windows Authentication
01/03/2007 14:08:24.171 Pre-script database connection failed - continuing to wait for SQL service to become responsive to connection requests
... repeated 60 times ...
01/03/2007 14:13:33.625 The following exception occurred: SQL Server reagiert nicht vor der Skriptausführung Date: 01/03/2007 14:13:33.609 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllinstance.cpp Line: 1411
Why does it try to use Windows Authentification although I have told it to use SQL Server Authentification (Windows Authentification has been disabled in this Database Instance)?
I am running the Office Professional Plus 2007 RTM with all options enabled and SQL 2005 Enterprise Edition. Based on the system requirements listed on the download page for the Office 2007 Data Mining Add-In, I've also verified that I have the correct CTP of SQL 2005 SP2 and that .Net 2.0 Framework is installed. Finally, I've verified that my local instance of SQL Server is configured correctly to allow temporary data mining models.
In Excel, all of the Table Analysis tools seem to work fine, and most of the options on the Data Mining ribbon also work; however, all of the options under "Data Modeling" on the Data Mining ribbon return the following error when I try to use them:
"Could not load file or assembly 'Microsoft.DataWarehouse, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependents. The system cannot find the file specified."
Please help. Thanks.
Help, I'm trying to burn a CD using Windows Media Player 10. I keep getting the message-interface not registered. I tried to download WMP, and it says it cannot because there is already a more recent version already installed. Should I uninstall WMP, and then reinstall it. If so, how do i do that, I cannot find it on the control panel!
Thank You for your help
I have a requirement to add new calendar columns from Jan to Dec in an existing SSRS report based on certain conditions.
The report uses a simple query at the moment.
SELECT [PROJECT ID]
,[PROJECT]
,[STATUS]
,[ACTUAL START]
,[ESTIMATED END]
FROM Projects
The requirement to add the new calendar columns is based on the following conditions:
1. If the Status value is “2” then for each Month in the current year, shade in green for the particular current month
For example, if for a particular Project for month/year of April 2015
Year/Month(Actual Start date) is < = April 2015
and Year/Month(Estimate End date) > = April 2015, then April should be shaded green.
2. The logic needs to be repeated from each month in the current year.
3. Some Estimate and Actual dates run from previous year, or into next year, so year also needs to be taken into consideration.
find the DDL and sample data below.
CREATE TABLE [dbo].[Projects](
[PROJECT ID] [nvarchar](255) NULL,
[PROJECT] [nvarchar](255) NULL,
[STATUS] [nvarchar](255) NULL,
[ACTUAL START] [datetime] NULL,
[ESTIMATED END] [datetime] NULL
) ON [PRIMARY]
insert into Projects
values('1','TFD','2','2015-01-31 00:00:00.000','2015-12-31 00:00:00.000')
insert into Projects
values('2','JUH','1','2015-02-01 00:00:00.000','2015-02-27 00:00:00.000')
insert into Projects
values('3','REFFD','2','2015-01-31 00:00:00.000','2015-11-30 00:00:00.000')
[code].....
how to rewrite the existing query to add new calendar columns in the report and then in the SSRS output shade green based on the above condition.
(Spam Removed)
View 1 Replies View RelatedHi another sql 2005 question I hope someone has tried this
Okay I want to load data center 2003 with two nodes
Can I set up SQL 2005 and utilize all 8 processors for SQL (As a Cluster)
I know you get DB mirroring and log file shipping ,that is not what I want
We will set up a DR soloution if the above works
So basically
Windows 2003 Datacenter across two 4 64bit Server 4GB ram each
once loaded can I install SQL 2005 and utilize the processors across both platforms
Thanks
Hello,
I have a BIDS project with 14 reports, all formatted the same way. On one report, any text box or image that is placed in the center or right of center in the form, shifts very far to the right of the tables and charts when it's rendered.
The text box placed at the top left of the form stays put. This is really wierd.
Has anyone ever heard of anything like this.
I have a couple of screen shots if you have a place I can put them.
Thanks
Dan
Hi, hope someone can help...
I'm trying to install SQL Server 2000 on my XP Media Center laptop and keep getting the "this operting system is not supported message"
Any ideas?
Many thanks....
Hi,
This is my first post. I am trying to install SQL express on my PC but it keeps on having this error:
"encountered an unexpected error in datastore. The action is setdialogs..."
I have searched far and wide for a solution to this problem. Some solutions worked for others, but none worked for me so far.
I don't have a previously installed sql version on my laptop. But just to check, I followed the steps in using msiinv.exe to detect any previously installed software. I am pretty sure that there was no sql server entry in the output file.
I have all the requirements, installed (.net framework 2.0,etc). I have all the latest Windows updates (except XP SP3).
My laptop is well above the minimum requirements for sql express ( Core 2 processor, 2 gigs ram, 7Gigs free space).
I have the Protected Storage service running (which I found out was required to install sql server).
I even followed the directions to fix Cryptograhical services.
I am runninng out of options here.
Thank you for your replies.
Here's my log:
[code]
Microsoft SQL Server 2005 Setup beginning at Fri May 30 11:20:48 2008
Process ID : 564
c:487084033731d74b14setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2008/4/30 11:20:48
Complete: LoadResourcesAction at: 2008/4/30 11:20:48, returned true
Running: ParseBootstrapOptionsAction at: 2008/4/30 11:20:48
Loaded DLL:c:487084033731d74b14xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2008/4/30 11:20:48, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "564"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2008/4/30 11:20:48
Complete: ValidateWinNTAction at: 2008/4/30 11:20:48, returned true
Running: ValidateMinOSAction at: 2008/4/30 11:20:48
Complete: ValidateMinOSAction at: 2008/4/30 11:20:48, returned true
Running: PerformSCCAction at: 2008/4/30 11:20:48
Complete: PerformSCCAction at: 2008/4/30 11:20:48, returned true
Running: ActivateLoggingAction at: 2008/4/30 11:20:48
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00E4CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "564"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2
[/code]
I have designed plenty of reports in VS 2005 and have been deployed on the reporting server. I have been designed one web page which shows UI through which user can access which ever reports he/she wants. I have kept some buttons on UI. When button is clicked appropriate report accessed and displayed on the browser.
Problem is that, report width is about 40 - 50 % of the screen and report viewer shows the report on the left align of the screen. I just want to show the report at the center of the screen. Also, any property I can use to set the report size in the proportion of screen in Percentage(%).
I use my Pocket PC XDA O2 mini for 2 years already and I don't have any problems when I sync it with my previous laptop which has Window XP operation system.
A few months ago, I bought a new laptop with Window Vista operation system, I could not sync my O2 mini with my PC. Then, I download Windows Mobile Device Center but my computer still could not recognize my O2 mini. My O2 mini has window mobile 2003 Second Edition Version 4.21.1088 operation system. Please let me know if you have any advices.
Thanks.
Hello all. I'm giving serious thought on changing gears withing the IT world. For several years I have been a software developer who has been fortunate enough to have been involved in the needed databases. From just sketching out tables for the DBA to doing the database from the ground up and maintaining it during production. Along the way I've known that I didn't do as quality of a job as a knowledgeable DBA would do but given the situations I made do just fine.
I am considering switching gears to the database side only, coding as secondary. Since I am basically familier with most aspects of SQL Server in a general way, I am looking to take that knowledge and become a "Professional". What I am looking for is a few books to help out. Maybe a "Become a DBA for Software Developers" or something. I know that mining these and other forums are very valuble but I'd like some other training materials as well.
Have I been clear enough on what I am looking for? I don't quite feel like I have.
Basically, what would you recommend for a good software developer who is looking on switching to becoming a good database person?
I'd like to stay in SQL Server for now, since that is what they use here and it would give me an opportunity to practice.
Also, do you see value in the studying process for certifications in this area?
I can't tell if the SQL Developer install upgraded the service, but left the SqlExpress version information, or if I'm still really only using SqlExpress.
Also, my intended target is SQL Enterprise, so if I am using SQL Express am I asking for trouble when I go to move the database over? Are the database formats compatible?
I've poked around trying to search for this answer for a while and haven't turned anything up. Maybe I'm searching on the wrong terms...
Thanks,
Geoff
My company is migrating all their servers to a new data center and I get to specify what we need for the db servers.
We've got a 22 prod servers (mainly physical) with a couple of TB of data on sql 2000 to 2012.
We expect to move to sql2014, and consolidate and virtualise where ever possible.
But I'd like start with specifying an overall architecture for this: some Best Practices to guide the build at a server and an installation level
There are conflicting postings everywhere about this. I built a small site using VWD and SQL Server Express, but need to convert to Sql Server 2005 Developer because the DB will exceed 4Gb. Tried to install and could not connect or use from VWD. Tried to uninstall, got into large mess with the byzantine uninstall process, and have now started with a clean machine.
I installed SQL Server 2005 Developer first, then installed VWD Express 2008 without installing SQL Server Express. VWD won't let me connect to an existing database, won't let me add a new database and doesn't even show the Database Tools option under the Tools menu.
Is there someone with specific knowledge that can provide any enlightenment? Would be much appreciated.
I have been trying to straighten out the select statement(underlined) in the procedure below but no luck. It is at the link below:(User-Specific Paging from ASP.NET)http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenethowto05.aspI think the "author" messed up during the copy and paste. Someone please help out. I really need its correct version. Thanks.blumonde // The BindData method constructs a SQL query that uses nested SELECT TOP // statements (as described earlier) to retrieve a specified page of data.//public void BindData(){ SqlConnection myConnection = new SqlConnection(_connStr); String strCmd = ""; StringBuilder sb = new StringBuilder(); sb.Append("select top {0} CustomerID,CompanyName,ContactName,ContactTitle from (select top {1} CustomerID,CompanyName,ContactName,ContactTitle from Customers "); sb.Append("as t1 order by contactname desc) "); sb.Append("as t2 order by contactname asc"); strCmd = sb.ToString(); sb = null; // Set pseudoparameters: TableName, KeyField and RowIndex strCmd = String.Format(strCmd, _pageSize, _currentPageNumber * _pageSize); // Prepare the command SqlCommand myCommand = new SqlCommand(strCmd,myConnection); SqlDataAdapter sa = new SqlDataAdapter(myCommand); DataSet searchData = new DataSet("SearchData"); try { myConnection.Open(); sa.Fill(searchData); MyDataGrid.DataSource = searchData; MyDataGrid.DataBind(); } finally { myConnection.Close(); } CurrentPage.Text = _currentPageNumber.ToString(); if ( !Page.IsPostBack ) { using (SqlConnection conn = new SqlConnection(_connStr)) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT Count(*) FROM Customers"; conn.Open(); _totalRecords = (int)cmd.ExecuteScalar(); _totalPages = _totalRecords / MyDataGrid.PageSize; TotalPages.Text = _totalPages.ToString(); } } else { _totalPages = int.Parse ( TotalPages.Text ); } if (_currentPageNumber == 1) { PreviousPage.Enabled = false; if (_totalPages > 1) NextPage.Enabled = true; else NextPage.Enabled = false; } else { PreviousPage.Enabled = true; if (_currentPageNumber == _totalPages) NextPage.Enabled = false; else NextPage.Enabled = true; }}
View 32 Replies View RelatedHi
I have installed the MSDN SQL 7.0 final release on 2 Win NT (1 server and 1 Wkst)
When I launch DTS, I CAN export/import ACCESS <--> SQL and vice versa
I CANNOT export/import SQL7 <--> SQL7
I have this error messsage :
"The licence for installation of Microsoft SQL Server
on your source and destination connections does not permit the use
of DTS to transform data. refer to your licence agreement for more
information"
any ideas why ? Is there any limitation with MSDN CD ?
Hello,
I recently got me a new laptop with Vista preinstalled. All good and well, but when I try to install a program vital for my profession, I get an error (OS not supported for this program). In the install I can configure what components to install, one of them is MSDN 2000. My question is, will SQL Server Express take over what MSDN can't on Vista (and thus running the program needing the MSDN 2000), or will windows XP be the new OS on my brand new laptop in the future. Love Vista, hate the compatibility.
Where is the list for forums,
When i started to write for Sqlserver, i never searched or looked for forum. Same did when i was working with the c#.
Now I have to find the correct forum. So where is the list of those forums, thanks.
Why are there 2 RS forums on MSDN
This is the other one
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs
This one has a worse UI
Hello,
Using VS 2005 SP1 beta and SQL Server 2005.
I am trying to learn how SQL CLR works by using this example:
http://msdn2.microsoft.com/en-us/library/5czye81z.aspx
When I press F5, I get this error:
A .NET Framework error occurred during execution of user defined routine or aggregate 'InsertCurrency':
System.Data.SqlClient.SqlException: Must declare the scalar variable "@CurrencyCode".
Do I need to declare @CurrencyCode in the Test.sql script?
Thanks for any suggestions,
Tom
Are there any limits to the number of user that can connect or anything like that with SQL 2000 (MSDN Vs)?
Thanks!
I have a developer who built an application using the SSE 2005 December CTP and I would like to bring the db's into the official SSE 2005 released version. I have attempted the following:
1. Create the db's in the released version, detach and re-attach the CTP db's. I got an error telling me they were incompatible.
2. Installed CTP version on one server, backed up the db's and then attempted to restore the db's on another server running the official released version of SSE 2005. Got an error attempting that too.
3. Installed the Management Studio for SS 2005 Developer edition thinking that I could connect to the two seperate instances of each server and like I could in EM 2000 run the transfer wizard to move the db's and data from one server to the next. Problem with this is that I can't get an object browser connection established. I have TCP/IP all config'd correctly, too.
Any other ideas where I can go with this at this time?
Thanks in advance.
Bill
the msdn article explains how to input new data to a databse and return the primary key of the inputted row. It works perfectly. However, it explains how to insert a value, but there is a problem. It seems to set the value to be submitted in the VB code, instead of having the value be the user's input in the textbox. Look for the following line in the code below: newRow("ClientFileNumber") = "ClientFileNumber" It inputs "clientfilenumber" instead of what is actually inputted in the texbox. Does anyone know how to bypass this, to not have the words "clientfilenumber" inputted?Dim sqlconn As SqlConnection = New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Client.mdf;Integrated Security=True;User Instance=True")
Dim catDA As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM Orders", sqlconn)
catDA.InsertCommand = New SqlCommand("JobInsert", sqlconn)
catDA.InsertCommand.CommandType = CommandType.StoredProcedure
catDA.InsertCommand.Parameters.Add("@ClientFileNumber", SqlDbType.VarChar, 50, "ClientFileNumber")Dim NewJobNumber As SqlParameter = catDA.InsertCommand.Parameters.Add("@Identity", SqlDbType.Int, 0, "OrdersID")
NewJobNumber.Direction = ParameterDirection.Output
sqlconn.Open()
Dim catDS As DataSet = New DataSetcatDA.Fill(catDS, "Orders")
Dim newRow As DataRow = catDS.Tables("Orders").NewRow()
newRow("ClientFileNumber") = ""catDS.Tables("Orders").Rows.Add(newRow)
catDA.Update(catDS, "Orders")
sqlconn.Close()
Response.Redirect("control_page_copy.aspx?NewJobNumber=" + NewJobNumber.Value.ToString())
I was hoping I can get some help regarding subject mater located athttp://msdn.microsoft.com/library/d...des_02_92k3.aspMyTable has 23 fields with 100,000 records.Field1 nvarchar 90Field2 char 6Field3 varchar 8000Field4 nvarchar 200Field5 nvarchar 200Field6 nvarchar 200Field7 nvarchar 200Field8 nvarchar 200Field9 char 30Field10 char 30Field11 nvarchar 200Field12 nvarchar 200Field13 float 8Field14 datetime 8Field15 datetime 8Field16 datetime 8Field17 nvarchar 200Field18 nvarchar 200Field19 varchar 8000Field20 nvarchar 200Field21 nvarchar 200Field22 nvarchar 200Field23 varchar 8000Data Types:nvarchar = Variable-length, Storage is 2 times the # of characters enteredchar = Fixed-length. Storage is n bytesvarchar = Variable-length, Storage is actual length in bytes of data enteredfloat = Is float Fixed-length?, my precisions are 15 digits so 8 bytes.datetime = Is datetime Fixed-length?, Storage is 8 bytesI need the following blanks filled in for me, please :-)Num_Rows 100,000Num_Cols 23Fixed_Data_SizeNum_Variable_Cols 16Max_Var_SizeNull_Bitmap Int(2 + ((23 + 7) / 8)) = 5?Variable_Data_SizeRow_SizeRows_Per_PageFree_Rows_Per_Page 100 (no clustered index created)Num_PagesTable Size
View 2 Replies View RelatedIf we purchase a new MSDN Professional subscription, does it come with SQL Server 2000 developer license?
View 3 Replies View RelatedHi all,
An internal licensing review is being carried out at my site for the first time since I joined. I have been asked to confirm that development SQL Server instances have been installed from MSDN installation disks and production instances from non-MSDN disks. I understand that serverproperty('licensetype') will show me this information in SQL Server 2000, and I am (perhaps incorrectly?) assuming that a result of "DISABLED" means MSDN was used for the installation.
In SQL Server 2005, i believe the installation does not record the necessary information in the registry, meaning serverproperty('licensetype') is of no use.
Is the question i've been asked impossible to answer? Is there any way I can find out if MSDN disks (or network copies of them) were used to install a SQL Server 2005 instance?
Many thanks.
James
We use MSDN SQL 2000 , the enterprise edition for our development servers,
which have always had 2GB RAM.
Now they are bringing in a Win 2003 Enterprise with > 12GB RAM .
They want SQL SERVER 2000 to use AWE memory up to 12GB . Is there any limitation
on MSDN Ent. Edition using more memory.?