View Complete Post
For handy database interface, is it good to use SqldataSources exclusively intead of EntLib functions?
Thanks for any feedback.
I downloaded the Adventurworks2008 database and the AdventureworksDW2008 database for practice with SSIS. I was wondering what the difference between the two databases is, because in the exercises im following it is stating that i will need to extract
data from the Adventureworks2008 database to the AdventureworksDW2008 database.
Is the the AdventureworksDW2008 an empty database and we are just extracting OLTP data to it? Please any help in clarifying this will be highly appreciated. Thanks!
Hello to forums :)
I have a simple question on design.
A company has several 'Worklocations'. Each location employs several workers. Every worker can be associated with multiple locations.
So, I have decided to create below tables. please letme know if there is a better way to design it
workerlocations (WID+LID => primary key)
Is this sounds right for you guys? let me know
Database diagram support object cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the database properties
dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, the add the database diagram support objects.
i do have a valid owner in the database Files tab.
any idea ?
I have SQL Server 2008, when I go into Server Management Studio and I right click on my database and choose properities. I see two things, I see Size of 200.13 MB and Space Available of .44MB. Does this mean my database can only grow by .44MB
more of data? If so, is there a way to change the max size? When I was looking at documents on SQL Server Express 2008, I saw a 10GB limit on each Database instance, so I was assuming SQL Server 2008 would provide me more than 200.5 MB?
I'd really appreciate any info/clearing up for me.
Exist is in other country
Please clear this confusion.
Thank in advance
When I create a diagram in MS SQL Management Studio 2008 Std (version see below) I have an ugly mis-rendering on every table on the printout. I have SP2 applied on the client (Managment Studio) and on the server. It looks like "a part of a window" is drawn
below each table.
1. Create new diagram
2. Add Table
3. print diagram to pdf printer or real laser printer
=> same result ugly printout with portion of a window under the table.
I went and used MS SQL Management Studio 2008 R2. And it worked (from another PC). Directly on the server using SQL 2008 Managment tools it produced the same distorted output.
This is annoying. What am I doing wrong?
Any tips are welcome
Microsoft SQL Server Management Studio 10.0.4000.0
Microsoft Analysis Services Client Tools 10.0.4000.0
Microsoft Data Access Components (MDAC) 3.85.1132
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3615
Operating System 5.1.2600
Running this on an SQL 2005 server
This tsql statement returns 6
Also, this tsql statement returns 6
select database_id from sys.databases where name = 'erm'
But this one returns 5 rows all with a&n
I posted a question before about 2 tables one with a foreign key being that the primary key from the first table. it was student and status
student table has id as primary key incremental identity and status has id as a foreign key from student.
I created the relationship in the diagram between the 2 tables. And I found out that when you create a new student the id is not populated automatically into the status table.
My question is then:
why do we want to create that relationship or others in the diagram? if it is not going to be automatically populated, I needed a trigger to do it.