Help Me Gauge The Effort In My First Db Setup

Jan 1, 2004

Hello there... Happy New Year!

A client of mine, a group of 4 doctors, are interested in implementing a small office network in which they will switch to a digital filing system. I have recommended a Microsoft Server 2003 system, therefore the patient information will be stored in the SQL server.

I have never administered, administrated?? (see, I really need help here!) a database, but have built small databases from scratch in C and with Access, so I feel confident that I could set up a system for them. I need to have some kind of estimate, both a fee and implementation schedule. Can you help me get a handle on the scope of this?

Many thanks,
Bryn

View 2 Replies


ADVERTISEMENT

Reporting Services :: SSRS 2012 / Put A Title For A Radial Gauge?

Nov 26, 2013

I need to put a title for a radial gauge. I've tried to add a label, but it remains in the panel area.

Is it possible to add a title by using a gauge property without creating a text box outside this object?

View 7 Replies View Related

Alternative To This Clumsy Effort?

Jul 20, 2005

I have a little problem that I think I solved with a sledge-hammer andthought I'd post here to see if there was not perhaps a more elegantand probably quicker solution.Essentially I have a unique display condition on a table that mustreturn data in a certain way. The problem column in question is thesecond col of a compound PK which thus makes the data in this columnunique for any given col1 value. The problem is that regardles of whatdata is in col2, if one of the values is 'NO' ,then this MUST appearat the top of any resultset, query, or report that can be generated,otherwise standard alpha sort is fine (it is a varchar(30) field)My inelegant solution was to create a third column in the table, achar(1) that can only ever have 2 values, a '1' or a '0'. So allentries for col2 which are 'NO' get assigned the value 1, all othersare 0 so when you sort using this extra column based on any col1value, 'NO' always gets to go on top.Can I lose the extra column which is there purely for sorting/logicand thus is irrelevant to the table data or its meaning(<hangs head indue deference to normalisation>) It obviously works OK the way it is,but it makes all queries/sprocs cumbersome because they always havethe overhead of sorting an additioal column, or an inefficient indexwhere nearly all the values in a vital column are always '0' except teodd few, also all the updates and inserts need to be wary of changesor additions that are make a 'NO' value for col2 and thus reset or setthe sort column to a '1'.Some sample DDL and values below.CREATE TABLE [dbo].[tmpTest]([colA] [varchar](30) COLLATE Latin1_General_CI_AS NOT NULL,[colB] [varchar](30) COLLATE Latin1_General_CI_AS NOT NULL,[colN] [varchar](50) COLLATE Latin1_General_CI_AS NULL CONSTRAINT[DF__1] DEFAULT ('UNK'),[Reference] [char](1) COLLATE Latin1_General_CI_AS NULL DEFAULT('0'),CONSTRAINT [PK_tmpText]PRIMARY KEY CLUSTERED ([colA] asc , [colB] asc))ON [PRIMARY]insert into tmpTest (colA,colB,colN) values ('1','a','z')insert into tmpTest (colA,colB,colN) values ('1','b','z')insert into tmpTest (colA,colB,colN) values ('1','c','z')insert into tmpTest (colA,colB,colN,reference) values('2','NO','z','1')insert into tmpTest (colA,colB,colN) values ('2','a','z')insert into tmpTest (colA,colB,colN) values ('2','b','z')insert into tmpTest (colA,colB,colN) values ('2','c','z')insert into tmpTest (colA,colB,colN) values ('2','d','z')select * from tmpTestwhere colA='2'order by colA,reference desc,colB

View 1 Replies View Related

Best Method Or Is It Even Worth The Effort?

Jun 21, 2007

Hi,



I have a question regarding a project I am working on and I'm not sure what the best way to do it may be, I am new to SSIS and would like to gain some exposure using it, but don't know if this project is overkill or even possible using SSIS.



*** PROBLEM ****

Basically I have a large number of flat files each file contains different columns and data. What I want to do is import all of the data from the flat files into corresponding tables in SQL Server. The tables in SQL server are already defined with data structure to match each file. The first 10 characters of the flat file are also the same name as the SQL table. So it seems easy enough to just import flat file to table one by one, but I cannot figure out how to match the flat file structure to each table without setting up a task for each table (there are roughly 50-60 tables). Another reason I want to do it with SSIS is these flat files have to be imported on a weekly basis.

**********************



Is it in my best interest to just create a stored procedure that basically loops through the files and imports the data? Or do you think using SSIS is the best solution? I have looked at SSIS a bit and thought maybe I could use the bulkinsert task, but it appears it cannot dynamically change due to column specs. I figured out how to loop through the flat files using the foreach task, but I could only get it to import into one SQL table. I also started looking at the dataflow task and thought about creating a script task, but I'm not sure if that would work before I spend a lot of time trying to figure that out.



Any suggestions or thoughts are appreciated.



Thank you

View 5 Replies View Related

Factors Affecting Effort Estimate For SSIS Package

Aug 30, 2007

Hi,

I need to estimate the effort required in writing some SSIS packages.
Could anyone provide some pointers to the various factors (E.g. number of tables, source, etc.) which influence the effort estimate for SSIS packages?

Thanks in advance.

Regards,
B@ns

View 4 Replies View Related

MDAC 2.8 Fatal Setup Error. This Setup Does Not Support Installing On This Operating System

Jan 5, 2006

I have XP Pro SP2 with MDAC 2.8.1022.  It had a problem so I tried to reinstall MDAC and got a Fatal Setup Error. This setup does not support installing on this operating system. I downloaded MDAC 2.8 1177 and get the same error.

I thought of uninstalling/reinstalling SP2, but this is a 2 month old Dell Latitude 610 with factory installed XP.  There is no Windows Service Pack 2 option listed in the Control Panel > Add/Remove Programs. 

There's some other strange things, so I wonder if they are related. 

1) I have Paul set up as an administrator account.  Some folders like MSSQL show that account with no permissions.  I grant all the permissions to Paul for that folder.  I come back later and the permissions are gone.

2) I deleted 20 files in Explorer, but 7 of them did not go away. I deleted those 7 again and they instatnly reappeared.  I deleted those 7 again and then they finally went away.

3) I get a slow reaction time for things like Windows Explorer and opening and closing programs. This is suprising since it has 2 gig of RAM and 2.3 Gig processor. Could it be a memory handling problem that's causing OS problems. Probably, the memory didn't handle the OS installation well and the whole system is compromised now.

 

View 12 Replies View Related

Setup And Upgrade :: 2008 R2 Setup UI Has Incomplete List Of Installed Features - Can't Uninstall RS

Jul 23, 2015

We're doing upgrades from SQL 2008 R2 to SQL 2014. This is blocked due to RS is installed but not configured. Our desired action is to uninstall RS and proceed with the upgrade. But when setuparp.exe is raised, it does not list all the features on the 'Select Features' page.  In fact, it only lists the last 2 shared features (SQ Client Connectivity SDK and Microsoft Sync Framework). However, all items appear to be listed on the 'Select Instance' page including RS. I've seen this issue on 2 of our SQL 2008 R2 Servers already.

View 3 Replies View Related

Setup And Upgrade :: Error Setup Account Privileges

Nov 15, 2015

I'm trying to install SQL Server Management studio 2012 on my Windows 7 (x64) standalone laptop.  When I click "New SQL stand-alone installation..." it runs a Setup Support Rules check and always fails "Setup Account Privileges". I've looked into the error and I keep getting that I need to change security rules but I don't have that option in window 7.  How do I get around this without having to resort to a computer running Windows Server?

I have Visual Studio 2013 premium installed along with Localdb v11.  I just want to connect and manage my database engine through SSMS when developing any application.

View 2 Replies View Related

Please Post Setup And Installation Questions In The Setup Forum

Nov 17, 2005

This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum.

Thanks

View 11 Replies View Related

Setup And Upgrade :: One Machine 6 IPs - How To Setup DNS For Server

Apr 24, 2015

I am running a number of SQL instances on my PC. Within the network, I have think server with various System Center components. For compatibility reasons, some features of System Center 2012 R2 had to be delegated to different SQL databases. My question is, because there is now more than one IP address on my system, and each instance of SQL is assigned to its own IP, is there a way to setup DNS and SQL so the namespace points to the desired IP address? For Instance:

MSSQL2008 instance is set to run on = 11.12.13.1
MSSQL2012 is set to run on = 11.12.13.2
IN DNS:
A Record: Mike-PC = 11.12.13.1
A Record: Mike-PC = 11.12.13.2

If I want to use MSSQL2008 by specifying Mike-PC as the DNS name, how would I do that with 100% accuracy? If there is another way to get the job done, I am more than willing to approach this differently.

View 3 Replies View Related

SQL Setup

Apr 9, 2001

Hello everyone

I know this is discussed very often, but please indulge me.
I have two hardware/software configurations for the SQL servers,
(1) NT4 + SQL7 on 2HDD's (C/D-drive) and,
(2) NT4 + SQL7 on 3HDD's (C/D/E-drive).
What will be the best configuration for SQL regarding:
a. RAID,
b. placement of the OS,
c. placement of the data & log files(devices),
d. local(hdd) backups

Regards
George

View 1 Replies View Related

SQL Setup

Jun 29, 1998

Hello!

I`m new to SQL Server, so excuse this if it`s a well-known
problem with a well-known solution.

I tried setting up SQL Server 6.5 (the box but not the
docs or install claims it`s an
upgrade product) but the install hung at "Setup is now
installing the initial SQL Server configuration" for over
10 minutes. That is, the install kept processing
something but did not appear to be coming to an end until
I killed it. This happened repeatedly, and on a second
server, too.

I then installed 6.0 (over 6.5!), and was able to install
6.5 over 6.0. However, I`m not able to install the 6.5
docs.

SQL Server appears to run (although I`ve not tried any
DB stuff).

Any suggestions? Should I uninstall and start over?

best, paul

View 2 Replies View Related

Setup

Mar 7, 2007

Hello,
This is the present setup.
Server A --> sql server 2000
Server B --> sql server 2005

On my machine I point to an instance name of sql server 2000 to use. i.e.
sqlserver2000Serverinstance1
On my local machine I have installed sql server 2000 and can use the enterprise manager. Have the Admin rights.
I have setup a daily backup job on sql 2000...

On server B, I installed sql 2005. Restored the sql 2000 backup onto sql 2005. And now I have the sql 2000 database in sql server 2005.

Now I can use the sql 2005 by refering to the serverB name (Not an instance).

In Server A, the applications are using a login name (sql authentication) i.e. username, password.

Questions
1) How do I install sql 2005 on my local machine (Remember that I have sql 2000)

2) If I should run the setup for sql 2005 on local machine, then during the installation, do I give it an instance name or should this instance name be done on the server i.e. server B ?

Thanks

View 3 Replies View Related

DTS Setup

Mar 23, 2007

Hi All

Iam new to SQL and using sql2000. I have created a DTS which works as I want, but I am abit concerned about the way set-up.

My source is a Lotus notes view and my data is going to a sql table. Now when I click in 'EM/DTS/MyPackage' and then rhs click 'design package' and look how the source is being extract after double clicking the source db I get a mini window labelled 'Execute SQL Task Properties'. In the bottom part of this window their is a line labelled SQL Statement. In here there is a syntax for creating a table, exactly the same as my created table ie. the destination table. I really dont understand why this syntax is appearing here.

Please can you help.

Many Thanks

View 1 Replies View Related

DTS Setup

Mar 23, 2007

Hi All

Iam new to SQL and using sql2000. I have created a DTS which works as I want, but I am abit concerned about the way set-up.

My source is a Lotus notes view and my data is going to a sql table. Now when I click in 'EM/DTS/MyPackage' and then rhs click 'design package' and look how the source is being extract after double clicking the source db I get a mini window labelled 'Execute SQL Task Properties'. In the bottom part of this window their is a line labelled SQL Statement. In here there is a syntax for creating a table, exactly the same as my created table ie. the destination table. I really dont understand why this syntax is appearing here.

Please can you help.

Many Thanks

View 1 Replies View Related

Sql Setup

Aug 8, 2006

I need help with SQL Server 2005 Setup.

View 1 Replies View Related

Tables Setup

Jun 16, 2006

How would I set up a sql server database based on the following problem? I will be creating a poll based on 9 dimensions that compare two companies.
honda yamaha               performance        features        reliability        conformance        durability        serviceability        aesthetics        safety        other perceptives
The values stored would be 1 or 0 so the values can be totalled. The user will be using a web pageand will select a radio button per dimension for either honda or yamaha. Would this work?
tbl_companiescompanyid    int pkcompanyname  varchar
tbl_resultsresultsid  int pkp          int --performancef          int --featuresr          int --reliabilityc          int --conformanced          int --durabilitys          int --serviceabilitya          int --aestheticssf         int --safteyop         int --other perceptivescompanyid  int -- fk to tbl_companies.companyiduserid     int -- fk to tbl_users.userid
tlb_usersuserid    int pkusername  varcharuserip    varchar

View 2 Replies View Related

Can't Connect To Db After Web Setup

Nov 17, 2006

I have an asp 2.0 app that connects to a database in another city.
When I test this app through VS2005 is connects and works great. After I created a web setup project it goes bad.
I ran the setup on 2 different computers, including the dev machine, both start ok and bring up the applications main menu, but when I choose a menu item that is supposed to bring up a datagrid from the sql server I get an error saying it's not a trusted connection.
Any advice on where I should start looking? It's got me beat.
Thanks.

View 4 Replies View Related

SQL Server Setup

Feb 2, 2005

Hi Everybody,

I was trying to install the SQL Server on my machine and I successfully did it because the server is running. I can get into the Enterprise Manager (without password) and I'm able to create new databases. Except, I can not log into those databases with the userid that I also created with full access. It must be somekind of security issue but I can not figure out what. The message says: "Unable to connect to server local - SQL server does not exist or access denied". If I look at my SQL service manager my server name is "NEWONE" , which is also my computer name. So, I'm not sure what's wrong. I tried to log in with the 'sa' account it doesn't work either.

I would appreciate any help you can give me.

Thank you,

Laszlo

View 1 Replies View Related

Creating SQL At Setup

Feb 16, 2005

I must install web applications on many servers
how can I create a MS SQL database at setup ?

thank you

View 4 Replies View Related

Setup MSDE200A

Jun 8, 2005

Hi can you help me with this problem with msde
 
I have installed MSDE200A and i didn’t gave any password(setup BLANKSAPWD=1).
My configuration code for the connection with msde is:
  <appSettings>
     <add key="DSN" value="Initial Catalog=dyt_mac;Data Source=localhost;Integrated Security=SSPI;"/>
  </appSettings>
 
When i try to connect with the database this error occurs:
 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
 
Thank you!

View 1 Replies View Related

Setup Error

Oct 28, 2005

hello everyone,it's first time for me to write here and also to use SQL.While i was installing SQl 2000 i got Setup Message said:" Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only client component will be available for installation."Hope to know what's wrong, and please guide me.Thanks alot

View 6 Replies View Related

Setup /t RegistryRebuild

Jun 23, 2001

Hi all

I have a client application which is running winnt4 sp6, sql7 sp1, gives the following error.

Msg 18458, Level 14, State 1, Server Microsoft SQL Server, Line 0
Login failed- The maximum simultaneous user count of 5 licenses for this
server has been exceeded. Additional licenses should be obtained and
registered via the Licensing application in the NT Control Panel.

I have found in technet article no Q180364, which ask to rebuild the registry of sql server. Was wondering anybody had the same experience. I can't shutdown the server more than 30 mins.

Any guidence or suggestion ?

Thanks in Advance

Jaya.

View 1 Replies View Related

Replication Setup

Jun 7, 2000

I need to replicate a database which will be updated both sides.Table doesn't have the primary key,and already has data.Please advice which replication will suit and what are the limitations.URGENT!!
Thanks!

View 1 Replies View Related

Best Hardare Setup For SQL 7.0

Jun 2, 2000

Hello all,

What is the hardware configuration for mssql 7.0 in order to achieve best performance. Some people suggest that

1. Dual Processors
2. 1G memory
3. RAID Controller
4. 2x9.2 GB RAID 1 for o/s and log files
5. 3x182. GB RIAD 5 for database

Your input is much appreciated.

Sui S

View 1 Replies View Related

Setup SQL DB- Newbie

Feb 2, 2000

Ok I have installed SQL 7 on my NT4sp4/MIIS box.
Can someone please tell me how to add a SQL DB to my website? and can I do this remotely?

Amy

View 2 Replies View Related

Security Setup

Dec 16, 1999

We are working on a new Payroll server. Our payroll department wants to lock out MIS and SQL Admins as much as possible. What we would like to do is allow the SQL Admins to still perform admin tasks such as backups, audit tracking, etc, while not being able to get into the tables. Also, we would prefer to do this security at the database level, rather than the server level. Any thoughts on this?

Tim Davis

View 3 Replies View Related

How To Setup SQLAgentMail?

Aug 24, 2000

Hi,

I'm trying to setup SQLAgentMail but received no message.

I have setup my SQL SERVER:

- using Domain Administrator to start SQL SERVER
- using Domain Administrator to start SQL SERVER AGENT
- created a mail profile called Test which has mailbox point to my domain user email account when I logged in my SQL SERVER machine as Domain Administrator
- setup Test as the mail profile in the Mail Session of the SQL SERVER AGENT PROPERTIES

I have clicked the Test button in the Mail Session and it return with the message "Successfully start (and stopped) a mail session with this profile."

But I don't get the testing email in my domain user email account.

Thank you in advance for any help.

View 3 Replies View Related

Replication Setup Under 7.0

Oct 12, 1999

I did setup to have a Desktop SQL Server running on Windows NT workstation in a different domain across the internet create a pull subscription to a transaction publication that is immediate updating that I have published on my NT SERVER in my domain. It never got any further than creating the subscription -- I got the following error on the pull:shared agent job history:

The job failed unable to determine if the owner (domainusername) of job
SQLServername-databasename-pubname-SQLServername2-databasename2 - 0 has server access (reason: Could not obtain information about Windows NT group/user 'othernameIdon'tunderstand'(SQLState 4200000) (Error 8198)

View 6 Replies View Related

Replication Setup Under 7.0

Sep 14, 1999

I have a question:

I want to be able to do bi-directional transaction based replication
between a 7.0 SQL server running on Windows NT 4.0 server SP5 and an NT Workstation 4.0 SP5. Can this be done or would it require that both
machines to be NT Server based? The reason I asked is because previously under 6.5 I was able to install the SQL operating system on Windows NT Workstation and now it looks like I can only install the Desktop version under 7.0. Will this give me the type of replication I am looking for?

View 1 Replies View Related

Setup Failed!

Jun 10, 2004

I am getting the below error message while trying to install sql 2000 on win2k sp3 server.


Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=AFSIESBAK;UID=sa;PWD=;database=mast er

Specified driver could not be loaded due to system error 126 (sql server).

driver={sql server};server=AFSIESBAK;UID=sa;PWD=;database=mast er

Specified driver could not be loaded due to system error 126 (sql server).

driver={sql server};server=AFSIESBAK;UID=sa;PWD=;database=mast er

Specified driver could not be loaded due to system error 126 (sql server).

SQL Server configuration failed.

################################################## #############################

12:09:16 Process Exit Code: (-1)
12:09:28 Setup failed to configure the server. Refer to the server error logs and C:WINNTsqlstp.log for more information.
12:09:28 Action CleanUpInstall:
12:09:28 C:DOCUME~1ADMINA~1LOCALS~1TempSqlSetupBinsc m.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
12:09:28 Process Exit Code: (1060) The specified service does not exist as an installed service.

12:09:28 C:DOCUME~1ADMINA~1LOCALS~1TempSqlSetupBinsc m.exe -Silent 1 -Action 4 -Service MSSQLSERVER
12:09:28 Process Exit Code: (0)
12:09:28 StatsGenerate returned: 2
12:09:28 StatsGenerate (0x0,0x1,0xf00,0x300,1033,303,0x0,0x1,0,0,0
12:09:28 StatsGenerate -1,adminafs-ies)
12:09:28 Installation Failed.

View 3 Replies View Related

Setup MS SQL7 On XP Pro

Oct 4, 2004

can anyone tell me how to setup ms sql7 on xp pro. i tried to run the setup CD but it always installed client part only, not the server

Many thanks

View 3 Replies View Related

Best Way To Associate One To Many Setup...

May 8, 2008

Hi. We're trying to setup a new case management system and I'm having a problem trying to store some of the information. I think I know how to go about it; however, I'm not sure if it's right.

We have two tables: Cases and Clients. The cases table stores relevant case information like case number, case type, etc. The Clients table stores information like name, address, phone number, email, etc.

What is the best way to associate these two tables together? I'm assuming I need a third table. Right? Thanks!

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved