SQL Server 2005 Express (no sp) is 53.5 MB
http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en
SQL Server 2005 Express SP2 is 36.5 MB
http://msdn.microsoft.com/vstudio/express/sql/download/
That's a diff in size of almost 20 MB. How can the SP2 be so much smaller?
My company wants to redistribute SQL Express with our product. I have not been able to figure out what is redistributable. Is it just the SQL Express package (SQLEXPR.exe) or is one also allowed to distribute the advanced package (SQLEXPR_ADV.exe)?
Thanks!
Hi,
We have over 1000 terminals running CE 4.2 on an x86 cpu currently using SQLCE 3.1.
We have just upgraded to VS 2008 and found the projects have been upgraded to reference SQL CE 3.5 - this is great, as we wish to use things like TOP etc.
However, all the distributable packages only include CAB files for CE 4.2 for the ARM Processor, or CE 5.0 for the x86. Is there a CAB package available for CE 4.2 for the x86 CPU? (please...)
Even just the relevant .DLL files would be fine as we repackage them ourselves anyway.
Thanks.
Hi.
I've been tasked with creating an installer that will either install SQL Express or connect to an existing SQL server.
Then I'm to run an .sql script to initialize a new database.
I'm using SSEUtil.exe as there will be no SQLCMD if the existing SQL server is on a remote machine.
Can I package SSEUtil.exe into my installer? Is this legal?
If not, is there a standard SQL Server client I can use to achieve this?
TIA,
lushdog
Does the Redistributable Package need to be installed when when calling reports in remote mode? If so, does it need to be installed on the SQL server where reporting services is installed or just on the web server that calls the reports or both? Also, since the SQL server has the reporting services version of Visual Studio, does that version of Visual Studio need to be updated to SP1?
View 3 Replies View RelatedIs SSMSE Redistributable?
View 1 Replies View RelatedHi
Everyone. I see that Visual Studio 2005 SP1 is out and includes an updated
ReportViewer control. Is there an update to the ReportViewer
Redistributable with those same fixes? Our product installs this
redistributable silently, and we render reports locally (i.e. RDLC), so
installing the full Visual Studio service pack would not help us (and installing just the assemblies would not either, since the Redistributable install seems to do other things "under the hood."
Thanks for your help!
Erik
I wrote program which connect to some remote MS SQL Server 2005, create SSIS package and store it to drive. Also it have ability to load SSIS package from drive, connect to server, load the SSIS package to specified server and execute it. Obviously, I used references to SSIS dlls in program. Question is - is SQL2005 necessary to be installed on computer where I execute the program? Since the program works with remote SQL Servers, I think what only some dlls is necessary for the program. Is it so?
View 12 Replies View RelatedHi,
Can any body tell me whether SQL Express with advanced services is availabe as a redistributable so that i could package it up with my application. Basically i need to supply different reports with my application for which i dont want to use any Crystal Reports type of thing. Moreover i also want such kind of reports available on the net. Please tell me how can i do that?
Regards,
Wasif Ehsan.
I noticed that Microsoft gives license to redistribute SQL Server Express as part of an application (though we have to register for this - http://www.microsoft.com/sql/editions/express/howtobuy.mspx).
So we would like to take advantage of this, and redistribute SQL Server Express 2005 as part of our WinForms application (using the method described http://blogs.msdn.com/sqlexpress/archive/2006/09/20/763956.aspx or http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/emsqlexcustapp.asp)
My Question is: If we perform a silent install on the client machine (included with the installation of our application), are our end-users required to register Sql Server Express in order to use it? From this page (http://msdn.microsoft.com/vstudio/express/register/) it appears that in order to use an Express version for longer than 30 days, one is required to register it. However, requiring our clients to register their version of Express kind of defeats the purpose of our using Express as our database format. We need a database that we can distribute with our application, that the end-users can use without having to register.
So is the redistribution license enough (in order that the end-users do not have to register their individual copies)? Or will the end-users also have to register their copies (in which case we probably cannot use SQL Express)?
Where do I find the setup files needed to redistribute sql server express installation files? I downloaded the SQLEXPR_ADV.EXE but the files disappear as soon as you cancel the installation.
I need the sql server setup files to package with my program fr distribution.
THANKS SO MUCH
Can somebody please help answering this question?
I'm planning to consider writing a SSIS package for a new project that requires downloading large chunk of data and transform into the diverse databases such as MS SQL or Oracle depending on the Client's Datbase.
For the clients having SQL Server installed at their end, i had no issues in deploying this package on their server and run it in their licensed instance.
What should be the case for others having Oracle database? Wouldn't installing the SQL 2005 client tools install the necessary run-time services for running SSIS packages? What i understood from the MSDN library (http://msdn2.microsoft.com/en-us/library/ms403355.aspx) is that there's no run-time support available for running the SSIS packages (unlike DTS run-time support) in production environment!
Would that mean that it requires a SQL Standard edition, at minimum, (as Integration Services is OOTB from Standard Edition onwards) to be installed at the production site to run this package?
If so, the client wouldn't be ready (which is fair too) to buy the new license just to run this package. Is there any work-around/suggestions for this case?
If not, can somebody please point me to the right location where i can download the run-time support for running SSIS packages?
Any thoughts on this is highly appreciated.
Thanks for your time.
~Sagar
I am trying to resize a database initial log file from 500M to 2M. I€™m using€?
ALTER DATABASE <DBNAME> MODIFY FILE ( NAME = <DBLOGFILENAME, SIZE = 2 ) "
And I'm getting "MODIFY FILE failed. Specified size is less than current size." I tried going into the database properties and setting the log file to 2M, but it doesn€™t keep the changes.
Any help with this process?
I am doing drillthrough from ReportA to ReportB via the Date field on ReportA. In Report Manager, all is well. However, when run through a custom app using asp.net and the report viewer control, the behavior was erratic. sometimes it would work. sometimes it would merely bring up the ReportA again and i would have to click Date again and then it would work.
a coworker recommended the Report Viewer fix http://support.microsoft.com/kb/933137. Since the redistributable was not present in Add/Remove programs on my test box, i installed the full version. I then started up the .net app in debug and ran ReportA and drilled through to ReportB several times and could not make it fail. I was happy.
Since the redistributable was not present on the production box, i installed the full install there as well. However, the erratic report viewer behavior continued.
I decided to try runnign ReportB directly instead of via the drill through from ReportA. ReportB had always run perfectly on its own. When i try to use the graphical date selector control, the results are different depending on the machine I use.
1. If i am using my test box, and i run ReportB directly via the app in debug mode, i get a runtime error indicating Microsoft JScript runtime error: Object required. It then points to Reserved.ReportViewerWebControl.axd at the GetObjectPosition(obj) function.
2. If i am using my test box and go out to the live production website, i get the same runtime error.
3. If i am using another machine and go out to the live production website, the data selector control merely seems to refresh the report. This is the same behavior i get when using the production server and going out to the live website.
The redistributable has been uninstalled from both the test box and the production box. This did not change the behavior described above.
All of the Microsoft.ReportViewer items in C:Windowsassembly indicate version 8.0.0.0.
Any help would be grand. Also, please let me know if I should cross post this in the .Net forums.
Thank you.
I installed sql 2005 a while back. Then I recently found out my file system was fat32 (I don't understand why the hardware people did this...) and I had to convert to NTFS. Naturally the sql service no longer worked so I uninstalled inorder to reinstall now I can't reinstall it I keep getting this message
native_error=5039, msg=[Microsoft][SQL Native Client][SQL Server]MODIFY FILE failed. Specified size is less than current size.
I'll try to post the full log in a new post.
Hi folks,Can anyone enlighten me here? I'm trying to use a SPROC which, when supplied with an int, looks up the table and returns certain columns from it. I'm using a SqlCommand, here's my codebehind: ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ SqlCommand dataSource = new SqlCommand("retrieveData", new SqlConnection(dbConnString)); dataSource .CommandType = CommandType.StoredProcedure; dataSource .Parameters.AddWithValue("id", poid); dataSource .Parameters.AddWithValue("title", title).Direction = ParameterDirection.Output; dataSource .Parameters.AddWithValue("creator", creator).Direction = ParameterDirection.Output; dataSource .Parameters.AddWithValue("assignee", assignee).Direction = ParameterDirection.Output; etc, etc... And the SPROC:------------------------------------------------------------------------------------------------------------------set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[retrieveData] @id int, @title varchar(50) OUTPUT, @creator varchar(50) OUTPUT, @assignee varchar(50) OUTPUT, @contact varchar(50) OUTPUT, @deliveryCost numeric(18,2) OUTPUT, @totalCost numeric(18,2) OUTPUT, @status tinyint OUTPUT, @project smallint OUTPUT, @supplier smallint OUTPUT, @creationDateTime datetime OUTPUT, @amendedDateTime datetime OUTPUT, @locked bit OUTPUT AS /**SET NOCOUNT ON; **/ SELECT [title] AS [@title], [datetime] AS [@creationDateTime], [creator] AS [@creator], [assignee] as [@assignee], [supplier] as [@supplier], [contact] AS [@contact], [delivery_cost] AS [@deliveryCost], [total_cost] AS [@totalCost], [amended_timestamp] AS [@amendedDateTime], [locked] AS [@locked] FROM purchase_orders WHERE [id] = @id; ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ The id being passed in is definately not null, and is set to a value of an item I know exists. The resulting error is:
Exception Details: System.InvalidOperationException: String[1]: the Size property has an invalid size of 0.Line 63: retrievePODetails.Connection.Open();Line 64: retrievePODetails.ExecuteNonQuery();[InvalidOperationException: String[1]: the Size property has an invalid size of 0.] System.Data.SqlClient.SqlParameter.Validate(Int32 index) +717091... ... Can anyone see anything I'm missing? Thanks,Ally
Using C#, SQL Server 2005, ASP.NET 2, in a web app, I've tried removing the size from parameters of type NCHAR, NVARCHAR, and VARCHAR. I'd rather just send a string and let the size of the parameter in the SP truncate any extra chars if need be. I began getting the error below, and eventually realized it happened only with output parameters, as in the code snippet below.String[3]: the Size property has an invalid size of 0. par = new SqlParameter("@BusinessEntity", SqlDbType.NVarChar); par.Direction = ParameterDirection.Output; cmd.Parameters.Add(par); cmd.ExecuteNonQuery();What's the logic behind this? Is there any way around it other than either finding out what the size should be, or assigning a size larger than would ever be needed? ThanksMike Thomas
View 6 Replies View RelatedI have one db test with one .mdf and .ldf file...mdf file size is 100mb and for some reson i removed all the tablesfrom that .mdf file and transfer it into new secondary file so all thetables moved into secondary file now i want to reduce the first .mdffile from 100 mb to 50mb is that possible,it's showing 90mb is free.Please reply
View 1 Replies View RelatedI want to know encrypted data's size for designing database field size.
For example, cardnumber varchar(20) Encrypted by Triple_DES and PassPhrase, How match size does need to encrypted data store field.
I think the size does not depend to PassPhrase char length.
Regards,
Yoshihiro Kawabata
I am getting error to run stored procedure using executenonquery method. The Stored Procedure is having OUTPUT parameter.
ExecuteNonQuery statement is called using SqlHelper.
Error : String[18]: the Size property has an invalid size of 0
Just wanted to know what is a general rule of thumb when determining log file space against a database's data file.We allow our data file for our database to grow 10%, unlimited. We do not allow our log file to autogrow due to a specific and poorly written process (which we are in a three month process of remove) that can balloon the log file size.Should it be 10% of the Data file, i.e. if the Date file size is 800MB the log file should be 8MB?I realize there are a myraid of factors that go against file size but a general starting point would be nice.ThanksJeff--Message posted via http://www.sqlmonster.com
View 4 Replies View RelatedThe Tabular model is showing 19 GB on disk, but it is acquiring around 40 GB in memory.
View 3 Replies View RelatedHi,
An MSSQL DB running SAP indicates a smaller DB size (MMC & SAP) than the actual physical size. The difference is about 8 GB.
A lot of records were deleted before this. Did they remain in the DB as NULL values or something ?
Does anyone know what the reason for this could be ? And how to clean this up ?
Thanks in advance,
Paul
Hi,
i use this script that show me the size of each table and do the sum of all the table size.
SELECT
X.[name],
REPLACE(CONVERT(varchar, CONVERT(money, X.[rows]), 1), '.00', '') AS [rows],
REPLACE(CONVERT(varchar, CONVERT(money, X.[reserved]), 1), '.00', '') AS [reserved],
REPLACE(CONVERT(varchar, CONVERT(money, X.[data]), 1), '.00', '') AS [data],
REPLACE(CONVERT(varchar, CONVERT(money, X.[index_size]), 1), '.00', '') AS [index_size],
REPLACE(CONVERT(varchar, CONVERT(money, X.[unused]), 1), '.00', '') AS [unused]
FROM
(SELECT
CAST(object_name(id) AS varchar(50)) AS [name],
SUM(CASE WHEN indid < 2 THEN CONVERT(bigint, [rows]) END) AS [rows],
SUM(CONVERT(bigint, reserved)) * 8 AS reserved,
SUM(CONVERT(bigint, dpages)) * 8 AS data,
SUM(CONVERT(bigint, used) - CONVERT(bigint, dpages)) * 8 AS index_size,
SUM(CONVERT(bigint, reserved) - CONVERT(bigint, used)) * 8 AS unused
FROM sysindexes WITH (NOLOCK)
WHERE sysindexes.indid IN (0, 1, 255)
AND sysindexes.id > 100
AND object_name(sysindexes.id) <> 'dtproperties'
GROUP BY sysindexes.id WITH ROLLUP) AS X
ORDER BY X.[name]
the problem is that the sum of all tables is not the same size when i make a full database backup.
example of this is when i run this query against my database i see a sum of 111,899 KB that they are 111MB,but when
i do full backup to that database the size of this full backup is 1.5GB,why is that and where this size come from?
THX
Here are my scenarios:
We have an application with replicated environment setup on sql server 2012 . Users will have a replica on their machines and they will replicate to the master database. It has 3 subscriptions subscribed to the publications on the master db.
1) We set up a replica(which uses sql server 2012) on a machine with no sql server on it. After the initial synchronization(used replmerge tool) the mdf file has grown to 33gigs and ldf has grown to 41 gigs. I went to sql server management studion . Right click and checked the properties of the local database. over all size is around 84 gb with little empty free space available.
2) We set up a replica(which uses sql server 2012) on a machine with sql server 2008 on it. After the initial synchronization(used replmerge tool) the mdf file has grown to 49 gigs and ldf has grown to 41 gigs. I went to sql server management studio , Right click and checked the properties of the local database. over all size is around 90 gb with 16 gb free space available.
3) We set up a replica(which uses sql server 2012) on a machine with sql server 2012 on it. We have dropped the local database and recreated the local db and did the initial synchronization using replmerge tool. The mdf file has grown to 49 gigs and ldf has grown to 41 gigs. I went to sql server management studio , Right click and checked the properties of the local database. over all size is around 90 gb with 16 gb free space available.
Why it is allocating the space differently? This is effecting our initial replica set up times.
It is possible to find table size and in that table each row size.
View 4 Replies View RelatedHi, I have a problem importing data from SQL Server 2000 'text' columns to SQL Server 2005 nvarchar(max) columns. I get the following error when encountering a transfer of any column that matches the above.
The error is copied below,
Any help on this greatly appreciated...
ERROR : errorCode=-1071636471 description=An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unicode data is odd byte size for column 3. Should be even byte size.". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider)
Many thanks
Hi,
I am using
exec sp_helpdb
go
dbcc sqlperf(logspace) for
getting database size and log size. Is this gives the correct
database size and log size or Is there any other way to get the logsize and database size by means of query analyzer.
Thanks in Advance.
Seenu. S
I have a SQL Server database that is showing 2853.44 mb in size but when Iexport the data into MS Access the size is less than 1 mb. Can anyone tellme how to reduce the size of my SQL Server database so that it's less than15 mb?Thanks in advance! Rob
View 5 Replies View RelatedWhy is it that lately our full backup (.bak) file size is more than 2x the size of the actual database file size (.mdb)?
View 9 Replies View RelatedI have a log file that is approximately 50 GIG. I backed up just the log and the file size of the .bak is 192 GIG . Why is this? Shouldn't it be closer to the 50 GIG.
Normally I wouldn't let log grow this much. But we are in process of getting new server up and running and don't have backups going yet. They are working on getting that up and running this week.
So I did a log backup to give me back some log space for now but was concerned when I saw the size of the .bak file.
When I view media contents of the backup device it shows one tranaction log back up and size of 192 GIG.
What is up with this. I know in SQL 2000 the log backup files where never this big. they were about the size of the log itself.
Any ideas?
Stacy
Hi!
I'm using SQL Server 2000!
How to know then Data files size and Log files size by Store Procedures or Sql query?
Thanks!
Hi all,
I need your help in fixing SQL error. I have a SQL table which has more than 50 columns. 5 of them should hold 1000+ character text. I allocated nvarchar(2000) for each of those fields. But Iam getting an error when Iam trying instert the text from C#.net application.
Error Message is:
System.Data.SqlClient.SqlException: Cannot create a row of size 8739 which is greater than the allowable maximum of 8060. The statement has been terminated. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at UsefulFunctions.DataBase.ExecuteSql(String Sql, ArrayList arrParam) in D:ProjectsUsefulFunctionsClass1.cs:line 395 at racf2.RacfTicketClose.Btn_Close_Click(Object sender, EventArgs e) in d:documents and settingswwwwwwwwwwwwwwinhousesecurity
acf2
acfticketclose.aspx.cs:line 167
But When I copied complete row(from table) in to MS word file and check the character count, it's not 8739. It's only 3457.
Do you guys have any idea , why am I getting an error and how to fix it.
Thanks in advance.