Re: How to set up an SQL Server - Database Discussion Boards

makumazan849-Sep-08 7:15

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 Smile | :)

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[^] Confused | :confused:

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.

Paradox to Sql Server Database

TheEagle9-Sep-08 2:23

TheEagle

9-Sep-08 2:23

Hi,
I have paradox database files which I need to migrate to SQL server database.I used the DTS and DataSources(ODBC) but I find the first selection :copy data from one or more tables disabled so I must use a sql query.But I don't know the tables names in the Paradox database files so What kind of query could I use?

I am too late but i will never give up

Re: Paradox to Sql Server Database

User 17164929-Sep-08 4:39

User 1716492

9-Sep-08 4:39

Have a look at see if this may help Paradox viewer 1.87[^]

modified 1-Aug-19 21:02pm.

datediff problem

imranafsari8-Sep-08 23:38

imranafsari

8-Sep-08 23:38

Hi,
I am using sql server 2005.
When I am finding difference between two date I am getting one day less
For example
select datediff(d , '2008-09-01' , '2008-09-05')
I am getting 4 days I want it to be five day as 1,2,3,4,5 that is it should start from date to todate

How can I do it

Please help
Thank you

imran khan

Re: datediff problem

ChandraRam9-Sep-08 0:08

ChandraRam

9-Sep-08 0:08

Add 1 to the result.

DateDiff gives you the interval between the two dates.

Re: datediff problem

Manas Bhardwaj9-Sep-08 0:21

Manas Bhardwaj

9-Sep-08 0:21