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!
Hi all.Running SQL2K SP4 on W2K3 Standard, SP4.I have just refreshed a database on one server with a backup fromanother. The database had existed previously on the target server, andI am just refreshing its contents. I used the following approach1) From the target server, create a SQL script with users and roles2) From the source server, back up the db3) Transfer the file4) Restore the db, checking the location of the data and log files toensure correctness5) Remove orphaned users6) Run in the users/roles script generated in step 17) Run in a canned script containing object-level grants.I've done this dozens of times in other databases, but something alittle unusual has occurred here:My dbo user is orphaned. Normally it's associated with the 'sa' login,but at this point there is no associated user.I can see why this has happened - on the source db, the dbo user hasbeen associated with a non-default login.And, many of the objects in the db are owned by dbo.The only viable option I see is to change the ownership of theseobjects, drop dbo, re-add it with the association to sa, and reassertthe object-level grants.But what I would prefer is some way to change the association of thedbo user, to associate it with 'sa' without the need to drop andrecreate.Can anyone suggest an alternative strategy to associate a login and auser after-the-fact?Thanks much for all input!BD
I'm wondering if there is a way to associate a job or task of some kind (i.e. SQL Agent job or SSIS package) with the generation of a report?
I have a need to provide an on-demand report that somehow initiates the updating of its data source prior to generation. In other words, I'd like the report to do *something* that can start an external process (external to the report) and wait for that process to complete before proceeding with the report generation.
As you can probably tell, updating the data source is expensive. It is normally scheduled along with a scheduled report, but I'd like the report to be runnable on demand when that is (rarely) the need, and I'd also like to guarantee the data source is updated when the scheduled report runs, which I can only do if I can somhow create a dependency between the updating process and the report generation.
Any ideas?
(The only way I can see to execute code synchronously from the report is to build a custom data processing extension/provider, which is fairly absurd.)
Hello, im brand new to these forums, scrolled through a bit of the forum(mainly trying to figure out how to go about what im about to ask) and it seems like a good forum...anyways onto my question.
i am in need of ideas/know-how on how to structure a database like such:
its an online motorcycle accessories website, and this is the information i need to store in the db(basically these will be my tables in the db)
bike manufacturer bike name products
now my main question is how would i structure those tables so i can get this effect.
each product in the product table needs to have a bike associated to it, 99% of the time it will be more than one bike associated to it, so how would i go about doing that?
originally i had set it up with the bikes name being different columns in the products table with a bit type set to 1 if that product was available for that bike and 0 if it wasnt available. however as you are probably already thinking that isnt the best way to do that.
Currently a 2005 login has been granted sysadmin because I can not figure out how to grant the same login the SqlAgentUserRole. I thought I would use SSMS but there must be a trick. The role only exists in the msdb database, which the login has not been granted explicit access to. And the login does not appear in the list of Role Members or its sub windows. This should be real easy and intuitive . . .
i begin for Data mining ( analysis manager - sql server 2000) i create some mining model with Microsoft_decision_ trees or Clustering. it's oK but now i want to create a model to know "If customer 1 has product A in their basket, what products should I recommend ".
i read and see that "Microsoft analysis manager sp1" have support association rules. i install pack 4. but i don't see anything else . how i create a model with association rules.
Hi all, I've had this issue in the past but dealt with it in a way that I don't think is correct:
Let's say I have a database on Server1. On Server1 I create a login and a user on the database. Now I have User1 with a login authorization on Server1 as well as a user within my database. If I detach that database now, and re-attach it on a different server, User1 exists. Of course, on the new Server2 User1 does not have authorization to login. I've deleted the existing user in the database and then re-created a login on the server, cascading through with the GUI setup to re-create the user within the database, too. Of course this gets ugly if the user has objects within the database. If I create a server login with the same name as the database user the login is not associated with the user too, correct?
I'd like to know the way that I can create a server authorization tied to the existing database user without dropping that database user, preferably within Enterprise Manager.
I'm currently running SQL Server 2005, and have been exploring the feasibility of grouping users to use a default file group and data file. This would be to group a set of users to have their new tables reside in a specific data file. I only see mechanisms for moving an already existing objects into a file group or to set the entire databases default file group--not a user level association or dynamic assignment of the default for that user, script, etc.
It's not looking good.
I'm looking for confimration that it's not possible or leads on doing so.
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.
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.
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.
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.
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.
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
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?
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 ?
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.
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.
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
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.
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 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.
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
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.
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!
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?
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.
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)
