Database

FirstPrevNext

Re: i installed sql server 2005 it's giving error bhatted11-Sep-08 7:12 bhatted 11-Sep-08 7:12  When i installed sql server its giving error: sql server service failed to start:sql server books online:"how to view sql 2005 setup logfiles and sql server manually I have sql server configuration manager.How can i use this to create database and table.Please help me. install microsoft sql 2005 bhatted9-Sep-08 10:19 bhatted 9-Sep-08 10:19  Hi, I installed sql server 2008 .It installed but it has configuration not enterprise.I need to work in asp.net.so pls give me website where i can load. Thanks Re: install microsoft sql 2005 [modified] Wendelius9-Sep-08 10:40 Wendelius 9-Sep-08 10:40  mkalantri wrote: it has configuration not enterprise What does that mean? The version is not SQL Server 2005 Enterprise Edition or what? Enterprise edition is downloadable only as a trial version. If you want to actually use it, you must buy it. modified on Tuesday, September 9, 2008 4:56 PM Re: install microsoft sql 2005 bhatted9-Sep-08 11:12 bhatted 9-Sep-08 11:12  Hi, i downloaded it's giving error.it's trail based.I have MySQL but i am unable to connect MYSQL with asp.net.If you have idea pls let me know how to do it. Thanks Re: install microsoft sql 2005 Wendelius9-Sep-08 11:18 Wendelius 9-Sep-08 11:18  I'm sorry, but cannot help you with MySQL. Your original post was about SQL Server 2005 (or 2008, didn't quite figure out) which is a completely different product than MySQL. Re: install microsoft sql 2005 bhatted9-Sep-08 13:23 bhatted 9-Sep-08 13:23  I have MYSQL.I need to know how to connect to asp.net. Or I know how to connect sql server. so please hell me thanks Re: install microsoft sql 2005 Mycroft Holmes9-Sep-08 15:20 Mycroft Holmes 9-Sep-08 15:20  Try this link clickety[^] Never underestimate the power of human stupidity RAH How to set up an SQL Server makumazan849-Sep-08 7:15 makumazan84 9-Sep-08 7:15  Hi, folks! I've got a major question. How do I set up an SQL Server on my computer if I have 2 things: 1) Installed MS SQL Server 2005 2) an Access DataBase, which I want to port into a SQL Server, so other users/developers could connect to it, log in and perform their actions. I know, that this is a repeated question, and there have been such messages before. Therefore, any links or info will be appreciated. Thanks Re: How to set up an SQL Server Wendelius9-Sep-08 7:51 Wendelius 9-Sep-08 7:51  Don't quite follow you. If you already have a SQL Server instance you can use, start with How to Migrate from Access to SQL Server 2000[^] (this applies to 2005 also). If you don't have the instance or want to add another to your machine, run setup for SQL Server Mika Re: How to set up an SQL Server makumazan849-Sep-08 8:26 makumazan84 9-Sep-08 8:26  Sorry for being confusing. I'm doing my best, but these are my first efforts in SQL Server and stuff I have installed an SQL Server (at least I think, that I did, bc I have checked it during the Visual Studio installation process). Then, I have installed a MS SQL Management Studio Express. You are right: I need to migrate from Access to SQL Server. But on the other hand, I can't find the interface in the Management Studio to allow me to create my own database. Maybe, that is because I use Express edition? Management Studio tells me that I'm not connected to the server, but I don;t want to connect at the first place, I need to set the server, so other people can connect to me and use my database. Re: How to set up an SQL Server Wendelius9-Sep-08 8:35 Wendelius 9-Sep-08 8:35  No problem at all If I remember correctly, you don't have the option for installing SQL Server Express in Visual Studio, only Compact edition (single-user instance). So briefly the steps you should take: - download SQL Server 2008 Express Edition with Management tools - install it by running setup. This will install you a single instance - configure the instance using Management Studio - create a database that you will use for application - migrate your data from Access You can check if you have a SQL Server instance installed for example by looking at services in Control Panel. If SQL Server is installed, you will have a service called SQL Server (Instance name) Mika Re: How to set up an SQL Server makumazan8410-Sep-08 2:14 makumazan84 10-Sep-08 2:14  I've spent half of the day trying to install SQL Server 2008, but it wouldn't install. At the very end it shows me a table saying that "Database Engine Services Failed", and "Replication Failed" Re: How to set up an SQL Server bhatted9-Sep-08 10:21 bhatted 9-Sep-08 10:21  hi, how u loaded sql server.can u tell me the website thanks Re: How to set up an SQL Server Wendelius9-Sep-08 10:31 Wendelius 9-Sep-08 10:31  You might want to have a look at this http://www.codeproject.com/script/Forums/View.aspx?fid=1725&select=2681821&fr=616#xx2681821xx[^] Re: How to set up an SQL Server bhatted11-Sep-08 9:46 bhatted 11-Sep-08 9:46  hi, It's giving warning that The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online. My Ram is 256MB.IT's need 512MB.so what should i do. IF you have any website where i can load sql server 2002. Thanks SQL Serevr Agent 2005 Saiyed Alam9-Sep-08 5:32 Saiyed Alam 9-Sep-08 5:32  Hello friends may I know how to activate the SQL Server Agent of SQL Server 2005? Re: SQL Serevr Agent 2005 Wendelius9-Sep-08 5:38 Wendelius 9-Sep-08 5:38  Did you read my previous answer http://www.codeproject.com/script/Forums/View.aspx?fid=1725&select=2714087#xx2714087xx[^] Re: SQL Serevr Agent 2005 Blue_Boy9-Sep-08 5:55 Blue_Boy 9-Sep-08 5:55  Try a google search[^] I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. Select cellection of bit fields if is true ?? kindman_nb9-Sep-08 4:18 kindman_nb 9-Sep-08 4:18  Hi ... I have a table for eg called Forms (fid int , Read bit , Add bit , Del bit ) the problem that more than one row with the same Form like that : fid - Read - Add - Del 2 - True - True - False 2 - True - False - False 2 - True - False - True you can see that the form takes Add True and False in second row .. I want to select only one row but if I have Add col has two value True and False in another row then select True to be : 2 - True - True - True I'm using Sql server 2005 ,, can I create stored procedure do that ... really thanks ... jooooo Re: Select cellection of bit fields if is true ?? Manas Bhardwaj9-Sep-08 4:38 Manas Bhardwaj 9-Sep-08 4:38  kindman_nb wrote: .. I want to select only one row but if I have Add col has two value True and False in another row then select True to be : 2 - True - True - True Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good. Re: Select cellection of bit fields if is true ?? Blue_Boy9-Sep-08 4:48 Blue_Boy 9-Sep-08 4:48  Can you be more descriptive in your question? I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. Re: Select cellection of bit fields if is true ?? Wendelius9-Sep-08 7:58 Wendelius 9-Sep-08 7:58  You can create a stored procedure and handle this inside the procedure. However, your problem is in modelling. You should break the table to at least two table. Separate table for Forms and separate table for allowed operations. This way you can query what operations are allowed and those that are not allowed, are not listed. Mika Re: Select cellection of bit fields if is true ?? PIEBALDconsult9-Sep-08 9:21 PIEBALDconsult 9-Sep-08 9:21  Not sure what you mean, do you mean something like this?: select fid,max(cast([read] as int)),max(cast([add] as int)),max(cast([del] as int)) from Forms group by fid Re: Select cellection of bit fields if is true ?? kindman_nb9-Sep-08 13:43 kindman_nb 9-Sep-08 13:43  Thanks my friend .. what I mean that for eg .. I have users . every user is subscribe in group and every group has it's permission Read and Add and Del of all forms ... user A is subscribe in Group M and N for eg : customer form : Group M Read true - Add True - Del False Group N Read true - Add False - Del False then i want to select the permission of the user a from the table of permestoin .. you can see that the user has Add is true in group M and the same user has Add is false in group N i want to select True if i hase true or false of the same permissoin .. i hope if you see what mean jooooo Re: Select cellection of bit fields if is true ?? PIEBALDconsult9-Sep-08 14:12 PIEBALDconsult 9-Sep-08 14:12  Ah, OK, well what I posted should help.

Last Visit: 31-Dec-99 18:00     Last Update: 24-Apr-24 16:31 Refresh ᐊ Prev1...1055105610571058105910601061106210631064 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.