Microsoft SQL Server 2008 CTP, February 2008
Mar 7, 2008
Hi all,
New to this so please be patient and please help.
I have developed an SQL 2005 Express command line option install for our company which has been working seamlessly for the last 18 months.
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
I downloaded the €śMicrosoft SQL Server 2008 Express CTP, February 2008€? from http://www.microsoft.com/downloads/details.aspx?FamilyId=749BD760-F404-4D45-9AC0-D7F1B3ED1053&displaylang=en
I simply replaced the 2005 file €śSQLEXPR.EXE€? with the 2008 file €ś€?, recompiled the installation and tested only for it to fail. I than read the 2008 books online and noted the change in command line options.
http://www.microsoft.com/downloads/details.aspx?familyid=19DB0B42-A5B2-456F-9C5C-F295CDD58D7A&displaylang=en
http://msdn2.microsoft.com/en-us/library/ms144259(SQL.100).aspx
I then changed the command line to suit the Microsoft 2008 books online, recompiled the installation and tested only for it to fail once more.
Interestingly I tested the install from the default GUI and at the point of adding the €śsa€? login credentials it fails to allow the installation to proceed. Strangely by selecting the windows authentication credentials, €śnext€? than €śback€? it now allows me to add the €śsa€? login credentials and continues to install correctly as required.
I hope I have explained this clearly enough.
1. Is this a bug in the €śMicrosoft SQL Server 2008 CTP, February 2008€? installation?
2. If so is this causing the command line install options to fail?
3. How do I obtain a version of €śMicrosoft SQL Server 2008 Express€? that will work installing from the command line?
Thanks in advance.
View 1 Replies
ADVERTISEMENT
May 9, 2008
hii installed SQL Server 2008 February CTP but i cannot found SQL Server Management Studio for 2008 i also try to connect through SQL Server 2005 Management Studio Express but error message "You can only connect with 2000 or 2005". So if i want to learn 2008 How???????
View 5 Replies
View Related
Mar 31, 2008
There are a few features in the new SQL Server - Reporting Services that I really need in production. I have tested everything and it works great. I am running the CTP version since Microsoft is saying they aren't releasing the release version until 3rd quarter 2008.
Since Microsoft won't sell SQL 2008 until 3rd quarter, can I run the CTP in production until the release and then purchase SQL 2008?
Jim
View 1 Replies
View Related
Sep 25, 2007
Hi,
I'm trying to install Microsoft Dynamics 10.0 with SQL 2008 Dev but when launching the utilities this returns the following error message:
******************************************************************
Your current SQL Server is not a supported version.
Req: Microsoft SQL Server 8.0
Act: Microsoft SQL Server code name "Katmai" (CTP) - 10
You need to upgrade to SQL Server 8.0 before continuing.
******************************************************************
Any ideas could help or has this if anyone knows been desinged not to work with GP10 currently?
Assad
View 7 Replies
View Related
Mar 27, 2008
Pls tell me about the adjact difference between sql server 2005 and sql server 2008.
Why to upgrade for Sql Server 2008
View 1 Replies
View Related
Apr 18, 2008
Does anyone know if the "Microsoft OLE DB Provider for Oracle" in 64-Bit Windows exists in SQL Server 2008 64-bit? It only existed in 32-bit SQL 2005, which was a big problem. Needed for Linked Server creation. We do not want to use OPENQUERY calls with the native Oracle 10G driver, too many coding changes.
Thank You
View 6 Replies
View Related
Feb 25, 2008
Hello!
Recently, I set up server with Windows Web Server 2008 RC1, SQL 2008 Express beta, .NET 3.5, IIS 7.
I'm running ASP.NET web application with SQL database. Everything works fine until the first application state on the server expires. After that, any postback that starts a new application state on the server and connects to the database, results in the following error:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
Is this a bug that will be fixed in release of Windows / SQL or am I doing something wrong?
Many thanks for help,
Jan
View 1 Replies
View Related
Apr 23, 2008
Hello - does anyone have experience w/SQL Server 2005 in a virtual environment? I'm considering this for a production environment but not sure if performance will suffer. Our databases will have a lot of writing but not too much reading. A SSRS solution is currently the only app. connecting to the SQL db. Max users to server at any given time will be very low (~10 users max). But the databases are pulling in data from other, outside multiple data sources on a daily basis.
Any pointers to documentation or any advice?
Thanks,
A Brown
View 1 Replies
View Related
Feb 11, 2008
I watched and followed the Intro to VB 2008 Express, but in the final part of the video, when you add a database, i did everything as the video says, still i get:
An error occurred creating the form. See Exception.InnerException for details. The error is: Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Ive tried the fix stated in another forum, the one about changing the "Target CPU" but the option doesn appear, what does appear its the "Platfrom" dropdown list, but its fixed to "Any CPU" and dont have any more options.
Ive also downloaded Microsoft SQL Server Compact 3.5 ENU and "re-installed" and selected repair, followed the steps, rebooted and still nothing.
The problem persists, any ideas, please?
View 6 Replies
View Related
Dec 23, 2007
when I try to make a sqldatasource with visual studio 2008 and SQLServer 2008 . I found that there are a message that the visual studio 2008 can support only SQLServer 2005 and SQLServer 2000how to make my visual studio 2008 support SQLServer 2008
View 1 Replies
View Related
Jun 10, 2008
Hello all,
I just wanted to share my happiness with the Microsoft's release of the new version of SQL Server 2008, MS SQL Server 2008 RC0.
You can download and install the evaluation versions from Microsoft Downloads.
http://download.microsoft.com/download/2/0/c/20cf6e18-0448-4e7b-8d8c-60a3c4802671/Download_Instructions_ENU.htm
I liked the new logo very much!
Eralper
MS SQL Server Articles
View 1 Replies
View Related
Jun 4, 2007
The best mail today was, witout doubt, the one from Grant Dickinson at Microsoft telling that SQL Server 2008 June CTP is available from the SQL Server (http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx) pages at Microsoft. :)
It's time to play. :cool:
View 9 Replies
View Related
Apr 23, 2008
Hello,
I just installed SQL Server 2008, i'm not certain if I am missing a step or theory...
just ran a simple command:
USE master
GO
For some reason, the process simply keeps on running.
Correct or incorrect statement, the results shouldnt appear any longer than a few seconds...
Does anyone know why this is taking a lot longer than it should?
View 3 Replies
View Related
Oct 2, 2007
I would like to buy SQL server 2008 book. I need it badly. would you please tell me where I can find it? thanks. and I look forward to hearing from you as soon as possible.
thanh
View 5 Replies
View Related
Aug 28, 2007
I just downloaded the SQL Server 2008 CTP. Anyone here check it outyet? Thoughts?
View 1 Replies
View Related
May 19, 2008
Anyone here aware of Sql Server 2008 RTM availability date.
View 1 Replies
View Related
Jan 2, 2008
I pray I am in the right forum.
I went to MSDN Products Keys and Downloads and found that they offer Sql Server 2008 as a free download for MSDN Pro subscribers. At least this is my inpression as to what is going on. I think it comes on 4 or 5 DVDs.
I am using Sql Server Express Edition with Advanced Features. I want to be honest and say that I most likely do not use these "advanced features" because of the nature of my work. I do not have this customer/product canonical setup. I store numerical data as well as stocks info. It is all for myself. I understand that the "advanced features" include reporting services but so far I have never used them.
This is my dilemma. I want to stay abreast with the progress and use the most current software. If I download the full SqlServer it will kill my machine with the enormous surface area. I do not need even systems databases, let alone Nowthwind. I create my onw DBs.
Do they have an equivalent of Sql Server Express for 2008?
What would you advice me to do?
Thanks.
View 1 Replies
View Related
Jun 4, 2007
Katmai becomes "Microsoft SQL Server 2008 I dont know dose people know about it? Never mind, I hope
this cool link will make you hapy:
https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395
The name for the next release of SQL Server becomes "Microsoft SQL Server 2008" which has been
code-named as SQL Server "Katmai". The first public CTP of Katmai will be available for download from
http://connect.microsoft.com/sqlserver. Download link will be live on 2007.06.04 Monday morning at
8:30am EST.
PS: Becuse I did not find any SQL Katmai forum group I post it here. Hope you dont mind.
View 1 Replies
View Related
Mar 21, 2008
Has SQL Server 2008 been released already? If not, what is the expected date?
View 1 Replies
View Related
Jun 18, 2008
I was wondering if this is normal. I am creating a website in VS 2008. I created a SQL db and am using SQL server express.
I can go into SQL server managment studio express and open the DB when I start my PC. I can still access the DB when I start VS 2008 and my project but when I run the project I can not access the DB any longer even when the project is not longer running and I'm in design mode. Even if I close VS 2008 I still cannot access DB through SQL server managment. The only way I can access the DB again is if I restart my PC.
Is this normal?
I am running Vista Ultimate.
Thanks,
Ty
View 3 Replies
View Related
Feb 11, 2015
what is the use of check sum in sql server:
ex: RESTORE DATABASE [XXX] FROM DISK = 'XX.BAK' with check sum
View 1 Replies
View Related
Apr 15, 2015
IdIncident IDIncident Description
2853459140511
2861733118512
2861733118601
2869113140511
2872349118512
2872349118601
2895400140511
2900999140511
2914574140511
2923590140511
2925735274503
2925735274504
2925735274511
View 9 Replies
View Related
May 15, 2015
have done inserting into files using BCP ,but is it really possible to bcp data from one table to another?
View 6 Replies
View Related
May 27, 2015
I have .mdf and .ldf file but .ldf was damaged when I try to attach this data base with out .ldf with this 3 method:
------method1
USE [master]
GO
CREATE DATABASE [eOrganization] ON
(FILENAME = N'E:FarzinDatabaseeOrganization.mdf')
FOR ATTACH_REBUILD_LOG
GO
-----method2
USE [master]
GO
CREATE DATABASE [eOrganization] ON
( FILENAME = N'E:FarzinDatabaseeOrganization.mdf' )
FOR ATTACH
GO
--------method3
USE [master]
GO
-- Method 1: I use this method
EXEC sp_attach_single_file_db @dbname='eOrganization',
@physname=N'E:FarzinDatabaseeOrganization.mdf'
GO
I got this errors:
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'eOrganization'. CREATE DATABASE is aborted.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'eOrganization'. CREATE DATABASE is aborted.
Msg 3456, Level 21, State 1, Line 1
Could not redo log record (150978:161:48), for transaction ID (0:12118066), on page (1:94206), database 'eOrganization' (database ID 5). Page: LSN = (150974:24:3), type = 1. Log: OpCode = 2, context 1, PrevPageLSN: (150976:147:3). Restore from a backup of the database, or repair the database.
Msg 3313, Level 21, State 2, Line 1
During redoing of a logged operation in database 'eOrganization', an error occurred at log record ID (150978:161:48). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.
I don't have any back up from this data base and I have to attach this .mdf.
View 3 Replies
View Related
May 30, 2015
There is a column for Name with data type varchar 50 the input data is like Alok Kumar, Sunita kuamri, Rohit Gupta Like that. The column contains the data as Combination of First name and second name.I would like to write a select query for selecting first part of name like Alok, Sunit, Rohit and so on only, ignoring the second part of name.
View 3 Replies
View Related
Apr 15, 2008
Hello,
Does anyone knows if SQL Server Express 2008 is already available for download? Where can I get it?
Thanks,
Miguel
View 1 Replies
View Related
May 20, 2008
What’s new in SQL Server 2008
SQL Server 2008 will be released in 2nd quarter of 2008. SQL Server 2008 will also be part of a joint launch with Windows Server 2008 and Visual Studio 2008 on February 27, 2008 in Los Angeles, CA. If you are interested in SQL Server 2008, you can download the latest CTP today.Here is a list of some of the new features available (excerpts from Microsoft’s white paper)
Transparent Data Encryption
SQL Server 2008 enables encryption of entire databases, data files, and log files, without the need for application changes. Encryption enables organizations to meet the demands of regulatory compliance and overall concern for data privacy. Some of the benefits of transparent data encryption include searching encrypted data using either range or fuzzy searches, more secure data from unauthorized users, and data encryption. These can be enabled without changing existing applications.
External Key Management
SQL Server 2008 provides a comprehensive solution for encryption and key management. To meet the growing need for greater security of information within data centers, organizations have invested in vendors to manage security keys within the enterprise. SQL Server 2008 provides excellent support for this need by supporting third-party key management and hardware security module (HSM) products.
Enhanced Auditing
SQL Server 2008 improves compliance and security by allowing you to audit activity on your data. Auditing can include information about when data has been read, in addition to any data modifications. SQL Server 2008 has features such as enhanced configuration and management of audits in the server, which enable organizations to meet varied compliance needs. SQL Server 2008 can also define audit specifications in each database, so audit configuration can be ported with databases. Filtering of audits to specific objects allows better performance in audit generation and flexibility in configuration.
Enhanced Database Mirroring
Automatic page repair. SQL Server 2008 enables the principal and mirror computers to transparently recover from 823 and 824 errors on data pages by requesting a fresh copy of the corrupted page from the mirroring partner.
Improved performance. SQL Server 2008 compresses the outgoing log stream in order to minimize the network bandwidth required by database mirroring.
Enhanced supportability
SQL Server 2008 includes additional performance counters to enable more granular accounting of the time spent across the different stages of Database Management System (DBMS) log processing.
SQL Server 2008 includes new Dynamic Management Views and extensions of existing views to expose additional information about mirroring sessions.
Hot Add CPU
Extending existing support in SQL Server for adding memory resources online, Hot Add CPU allows a database to be scaled on demand. In fact, CPU resources can be added to SQL Server 2008 on supported hardware platforms without requiring application downtime.
Performance data collection
Performance tuning and troubleshooting are time-consuming tasks for the administrator. To provide actionable performance insights to administrators, SQL Server 2008 delivers more extensive performance data collection, a new centralized data repository for storing performance data, and new reporting and monitoring tools.
Extended Events
SQL Server Extended Events is a general event-handling system for server systems. The Extended Events infrastructure is a lightweight mechanism that supports capturing, filtering, and acting upon events generated by the server process. This ability to act upon events allows users to quickly diagnose run time problems by adding contextual data, such as Transact SQL call stacks or query plan handles, to any event. Events can be captured into several different output types, including Event Tracing for Windows (ETW). When Extended Events are output to ETW, correlation with operating system and database applications is possible, allowing for more holistic system tracing.
Backup compression
Keeping disk-based backups online is expensive and time consuming. With SQL Server 2008 backup compression, less disk I/O is required, less storage is required to keep backups online, and backups run significantly faster.
Data compression
Improved data compression enables data to be stored more effectively and reduces the storage requirements for your data. Data compression also provides significant performance improvements for large input/output-bound workloads such as data warehousing.
Resource Governor
SQL Server 2008 enables organizations to provide a consistent and predictable response to end users with the introduction of Resource Governor. Resource Governor enables database administrators to define resource limits and priorities for different workloads, which enables concurrent workloads to provide consistent performance to end users.
Plan Freezing
SQL Server 2008 enables greater query performance stability and predictability by providing new functionality to lock down query plans, enabling organizations to promote stable query plans across hardware server replacements, server upgrades, and production deployments.
[url=http://blog.360.yahoo.com/blog-U6QwcZ0gavd_Vlnx6XULPcA1?p=75]Msdes[/url]
[url=http://www.bloglines.com/blog/Asia-Registration?id=8]Fexon[/url]
[url=http://journals.aol.com/mamaliya/AsiaDomainNameRegistrationLi/]Asia[/url]
View 1 Replies
View Related
Jan 9, 2008
Dear All,
is there any free download of sql server 2008 download avialable in the net?
i've googled a lot.....it is taking to the download of sql server 2008 CTP.....even after downloading finished, i'm getting error while installing error...
the error is kernel32.dll
please provide me links
Vinod
Even you learn 1%, Learn it with 100% confidence.
View 2 Replies
View Related
Jun 15, 2007
Hi,
Can you please tell me links to SQL Server 2008 documentation on MSDN? I read SQL Server 2008 CTP is released today. I'm very much interested to know more about it. Thanks in advance.
Cheers,
Gopi
mgopinath.blogspot.com
View 1 Replies
View Related
Mar 5, 2008
Have noticed some issues in Sql Sever 2005 SSIS configuration, as documented in the forums here.
Does Sq; Server 2008's SSIS config still have these problems, or is it more stable? : )
View 4 Replies
View Related
Apr 8, 2008
Does anyone know if the SSIS packages developed in SQL Server 2005 is compatible with SQL Server 2008? What are the new features in SQL Server 2008 ETL layer? Thanks in Advance.
View 1 Replies
View Related
Apr 24, 2008
Hi
I have an existing application that programmatically builds SSIS 2005 packages.
I'm trying to get to working with the February CTP of SQL Server 2008. Having changed all the 2005 references to 2008 references and things like IDTSComponentMetaData90 to IDTSComponentMetaData100, my application compiles okay now, but hits a problem when it tries to create a Data Flow task.
The code which worked fine before (and seems to still be the recommended way in Books Online is):
Code Snippet
Dts.TaskHost myMainPipe = (Dts.TaskHost)container.Add("DTS.Pipeline.1");
However, this now produces the exception:
Cannot create a task with the name "DTS.Pipeline.1". Verify that the name is correct.
Should I be using a different moniker now? I took a stab at "DTS.Pipeline.2", but that didn't make a difference.
Thanks,
Andrew
View 10 Replies
View Related