MSDE Free For Commercial Use?
Apr 29, 2004also, how can i retrieve data ? no interface for that?
does it have stored procedure function?
also, how can i retrieve data ? no interface for that?
does it have stored procedure function?
Hi,
View 5 Replies View RelatedHello Everyone,I have been searching hard to get an answer on this question, I hope someone here can help me!Here is my situation:I am planning to build a website for them, that would be used for some event registration (by people outside my company). I also plan to use SQL Express Edition as the database backend for the site. Now this is where I have a question, can I use SQL Express and pay nothing? (It is free right?) There would be a maximum of 600 registrations over a period of 1 month. I don't expect more than 50 concurrent users. The administration side of the application would be used by internal employees (So, the application would be used by internal employees and external people). Where can I find more information about the license?I would be very thankful if someone can guide me on this.ASP_Newbie
View 3 Replies View RelatedI have developed some custom SQL reports that query a major software vendor's SQL Database, and I would like to sell them commercially.
The only problem is that I dont know how to protect them from casual piracy? Ideally I would like to tie them into a uniqueness of the database server eg the machine SID or similar but have no experience of this..
Can anyone recommend a way of commercially protecting the code pleaaaase?
Thanks!
I'm working on a server based ASP.NET app.
I'd also like to deploy it as a single user version.
Rather than rewrite it to .Net windows (at least initially), I'm thinking about having the user install Cassini and SQL Server Express on their machines, and run the app as a "local" web app.
Clearly, there are a lot of issues to consider.
One is whether to even think about using SQL Server Express for this.
So, two questions on that, initially:
Q1) Are there any licensing issues? I would direct the user to download directly from MS.
Q2) What would it take to get SQL Server Express and the application to start talking to each other once SQL, Cassini and the application files were installed?
> I'm assuming I would have to build "data base initiation" and "file create" procedures, etc., but what about just having the App find SQL, start it, and get it configured, etc for use. How hard would it be to proceduralize this so that it would look to the user like a "standard" application software installation procedure?
Any guidance on this would be appreciated.
Thanks!
Thanks,
View 1 Replies View RelatedDoes anyone know of such a task than runs under both x86 and x64? (I know a FileWatcher add-in but it was built using Beta verisons of VS.NET)
TIA,
barkingdog
Does anyone know if it is legal to use SQL Server 2005 Express in a commercial website? There is no need for SQL Server 2005 so the Express would do the job great.Thx, Viktor
View 2 Replies View Related1Is it possible to choose local user,(instead of local system) in sql setup service login and then use mixed mode
default configuration in report server or choose configure server later. I will be using a third party host using vista, unfortunately I do not have my own server ( I do not have a domain yet)
vista sql 2005 standard vs 2008. ultimate
2 What is the best configuration for a new aspiring asp.net ssrs developer.
3 Do I need to configure the server if I choose local user?
4. what is the best way to configure sql?
By the way what items
should I look forward in choosing a web host,(who is willing to give alot of help to developers) my interests include ssrs 2008 sql 2008 sql 2005
asp.net mvc, crystal reports, wcf infragistics. I am really interested in showing
examples in sql reporting services, crystal reports wcf , web services , infragistics
asp.net mvc intrigues me.......
I would like to get on a track to eventually use sharepoint services
Thanks again, I know I ask I alot of questions........
Hello,
I'm not sure if it's the setup I did wrong, but I can't seem to get my
text datatype in my database to store more than 900 characters.
I'm trying to setup a news database for my website, which will populate
the information into a datagrid. To test, I manually added a news
item in the database through the visual studio 2003 gui. I
immediately noticed a problem as the I was getting an error after a
long news item saying:
"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."
I couldn't find anthing to set the buffer limit and the datatype is
"text" filled with simple text in the column. As a further test,
I
simply entered 12334567890123... up to 900 characters and still
recevied the error.
I would appreciate someone leading me in the right direction on this one.
Thanks a lot.
I am trying to change the computer name of a machine running MSDE but I get an error when SQL Server starts. With regular SQL when I change the name of a computer I re-run setup and setup fixes this problem. MSDE can only be installed from unattended mode so I can’t rerun setup and fix the problem.
My question is "How do I change the name of a computer running MSDE with out reinstalling MSDE"
We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I can’t rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??
regards,
Manfred
I'm not sure if this is the correct forum for this this question but I'll give it a shot.
The only db development that I have ever done is in MS Access. I have a project at work that is being accomplished in VB and I need a db engine to use as the back end. Visual studio came with a copy of MSDE. Is this tool worth using or should I invest in mySQL? Are there any advantages to using MSDE over mySQL?
hi,
does any one know about a free T-Sql IDE with fully functional
intellisense ???????????
thanx in advance
San
I would like to make sure that SQL Server Express is completely free even for public institutions e.g. bailiff office. We (my office) want to use SQL Server Express 2005 at 9 computers for free, is it possible? Can you give me a full answer? Thanks!
View 1 Replies View RelatedSurely not everyone that uses SQL on a shared server has to buy their own copy of SQL Server?
Is there a free utility to copy it from the host to local? I am assuming that SQL management express can not do this (after searching the help for a while... annoying)
Good day.
I'm executing a stored procedure, before execution the memory used for sqlservr.exe in the task manager reflects about 50mb. but after the stored procedure is executed, the memory used by sqlservr.exe boosts up to 200mb and remains at 200mb even after execution. this causes my pc to slow down. how dow i reset the memory used by sqlservr.exe after executing the stored procedure? any help will be very much appreciated. thank you.
waling
Hello, I am 13 years old and trying to create a mmorpg(massively multiplayer online role playing game) and need a database so people can register, buy weapons, kill other people, etc. The only problem is, I only know javascript and html. I was wondring if anyone had free code for MS Server 2000 that users of my game register, and it records the users username, password, etc.
Thanks so much,
-tyler
Is there a Free GUI for SQL server that can control or edit any and all the records in it, and the tables?
View 2 Replies View Relatedxp_fixeddrives gives the free space on the server drives. Is there a xp which gives the actual size of the drive?
I need to calculate the %space used!
------------------------
I think, therefore I am - Rene Descartes
Greetings!
I'm not sure where to post this question but this place seams to fitt best.
I'm wondering about intellisense's that are free ang good for sql 2005 and 2008. I tried to google it and I tried to search for it in here but didnt find something good. I only find products that aint free and atm that aint an option actually.
So do any of you know some free goog intellisense for sql 2005 and/or 2008?
Thanks
I am looking for a free ms sql database for my programs, but i don't want to host it on my computer, because my web host does not allow servers to be run and people connecting to thme.
View 1 Replies View Relatedls_SQL = ls_SQL + " WHERE "
+ "Convert(varchar(10),"
+ dataSet1.Tables["Model_Criteria"].Rows[i]["table_name"].ToString() + '.'
+ dataSet1.Tables["Model_Criteria"].Rows[i]["column_name"].ToString() + ")"
+ " " + dataSet1.Tables["Model_Criteria"].Rows[i]["relational_operator"].ToString() + " "+ '''
+ ls_Value+ '''+ " "
+ dataSet1.Tables["Model_Criteria"].Rows[i]["logical_operator"].ToString() + " ";
I stored this sql in a string and i want to check whether this string is error free or not (syntax).
how i can do it. Please help it's urgent.
Hi I have a .net 2 website that works from a sql 2000 db. I am building a form that will allow the user to type in any search criteria and based on their input I need to produce some results (that’s the simplest way to put it)I will need to search various parts of my db to find similar sounding information, I was just wondering what is the best way to do this. I had the following thoughts1) Search columns using Soundex tsql function (but not sure how good this is?)2) Remove all noise words from user input (eg, and, or, the etc...) and then use a regular expression to search the fields in the dbAlternatively are their some third party components to do can do this for me Many thanks in advance
does anyone have code that shows how to separate individual words from a sentence.
e.g. i have a list of questions and answers in my database and have the following query for it:
SELECT question, Answer
FROM QuestionsAnswer
WHERE FREETEXT(Question, 'i want to travel around the world and learn about cooking')
so i want to extend the above query so that takes each key word (travel, cooking, learn) to find out how frequently that particular word appears in the question (for ranking purposes).
I know freetexttable does rank results, but they don't seem accurate enough for what i need to do.
HELP!!!
How do I find the available free space in the database, in the Database and the Log Segment
View 1 Replies View Relatedmade you look! Please read on....
Can anyone help? I require a method to retrieve the history behind the creation and changes made to database objects.
I don't mean when a user updates a table, but getting version numbers and dates changed of tables and stored procs etc.
Is there a way to do this?
Please reply
Hi, I have linked to 50 servers and use dynamic query (exec @sqlString8000)...
to get info about 1000 databases.
Now I wand to use xp_cmdshell to check each server C: fress space, how could I return the last 2nd line value to a global ##temp table?
<<5 Dir(s) 2,169,880,576 bytes free>>
<<NULL>>
thanks
-D
We have just release a free Online SQL Formatter
which can beautify different sql dialects for you on the fly,
and translate to other languages such as C#, Java,Delphi with many format options.
Try it here:
http://www.wangz.net/gsqlparser/sqlpp/sqlformat.htm
Hi All,
I was wondering if anybody has the script to view the free disc space. Currently I am using xp_fixeddrives stored procedure, but it is undocumented and might not be supported in SQL Server 2005.
Thanks.
I would like to know how to determine how big log and data space is, and how much of this space is free. I would like to create a script to warn me when less than 20% free space is left in log as well as data.
Ruud
Hi there
I'm having a problem free'ing a extended stored procedure DLL from memory, so I can delete the file/replace it and reload a new one into the DB.
Quote: Originally Posted by http://www.windowsitlibrary.com/Content/77/20/1.html
DBCC <DLL Name>(free)
This statement must be run before a DLL will be replaced and the operating system will let the file be overwritten.
I'm running the command in Query Analyzer and it seems to be "working" fine, but when I try delete the dll, it tells me another program is using it.
The only way I seem to be able to free the dll is to restart the DB.
Am I doing something wrong?
Thanks
SynAck
Can anyone recommend an OLAP tool for MS SQL Server 2005?
View 2 Replies View Related