I had installed the sample database " AdventureWorks ",but i couldn't find it in SQL Server Management Studio,and I noticed than it was installed into "Microsoft SQL Server 2005 Samples" directory,but not "Microsoft SQL Server" directory,what can I do to find the datebase.
I am a beginner,and learning sqlserver by using tutorials,someone help me?
many many thanks.
hi
COMPUTER-1
IP ::::: 129.100.100.5
COMPUTER NAME IS ::::: HASH
MEMBER OF DOMAIN
in this computer sqlserver express edition is installed, i want to remove this express becoz in configuration manager it show two SQLSERVER'S are running. when i browse from COMPUTER - 2 for network servers it show server name as HASH/SQLEXPRESS, but not the main SQLSERVER.
COMPUTER -2
IP::::129.100.100.142
COMPUTER NAME::: FEROZ
MEMBER OF WORKGROUP
can anyone help me how to connect these two computers and remove this express edition
iam new to sqlserver configuration
thanks in advance
waiting for eager reply
i am using sqlserver2005,in that i am not getting database mail even after enabling in surface area configuration of configaration tool.
what is the problem with my sqlserver.
Can any one help me ...
hi,
here i had created a database named "books" and it contains 8tables in sql server 2005. now i want to take a copy of this "books" database in another system which also have sql server2005 as a back end to asp.net. so where i can get this "books". i.e in which folder it will be saved. is it possible to svae this databse or have to svae each queries by which i created tables?
One can never consent to creep,when one feels an impulse to soar
RAMMOHAN
Arjang writes "Hi
As a developer I work on a development Database, and after adding fields to tables, altering SP's , Adding new tables etc. I need to apply the same exact changes to production database.
So far I have been doing this manually, but is it possible to get the list of all alteration from some date onwards as Sql Scripts and run them on the Production server?
Of course doing the alterations in Sql and keeping them in a file might seem like a solution , but it is a tedious process prone to human error.
Is it possible to turn on some database reporting feature that keeps track of modification's applied ?
Is there another way of visioning database structures and applying them?
Thanks"
Hi
Books online mention the existence of sample code for several custom tasks, including the one mentioned in the title. But, when I try to find this code in the location mentioned it is nowhere to be found.
I have run a search on the rest of my drive and come up empty.
Can anyone tell me where to find this?
Thanks
Im trying to use VB.net 2005 to write a sample app to access a DB. Are there any samples for this and any samples of how I go about making the DB in the first place?
View 1 Replies View RelatedI'm looking for a sample database for a big company, organization,... to build my db project as a part of my db system courses. Can anybody help me?
Thanks anyway.
for SQL Server 2005 express (no northwind or pubs sample databaes only adventureworks). Please correct me.
View 1 Replies View Relatedi have a query that uses the adventure works sample database am working on sql server 2000 can i install this sample database to this sql2000 server?
Best Regards
Hi
im a beginner in SQL. I installed SQL Server Express on my computer, but i didnt find any databases included. The institute where i go to learn SQL have plenty of databases, but students usually work on databases called AdventureWorks and GlobalToyz. I searched the web for these databases and found something but i still cant figure out what to do with it. So i was hoping if anybody could send me these databases with brief instructions on how to install it into SQL Server. Thanks in advance
I install the SQL 2005 Evaluation. I selected to install samples and documentation during the installation wizard. It finished successfully but I could not find the sample databases on the SQL Management Studio. Why?
Thanks.
Joe.
This question is for SQL Server 2000, SQL Server 2005, and SQL Server 2008.
I want to provide users a sample database with data and a database template which new databases created in an application will be based on. However, I don't want to use scripts to create database and other database objects and also don't want the data to be contained in other data store such as access database. I think about providing users with operating system files(mdf, ndf, log). My understanding is that database created thru attaching will follow the collation of the source. Is that a way to control the attaching so the database created thru attaching will follow the collation of the destination server?
If attaching is not a good way to handle my case, what are other possibilities?
hi,
i learn by practice and i would like an asp code using c# that connects to sql database can retrives information from a table.
can you please copy paste me some code or give me exact link a?
thank you
Hi all,
I have a problem...
I need a database file for a bank with info like customers, transactions and other bank stuff etc. It is for a university assignment. basically I just need to analyse, mine the data etc the info in the database
I have looked on msdn but none of they're databases are for a banking scenario.
Does anyone know of a sample bank database anywhere or does someone have one they could give to me ?
Thanks for your help in Advance
Peter
I created a database using SSMS, now I want to add sample data.
What are the methods of adding sample data from the server?
Do I need to use the SQL Server client or can I use the SQL command line or query window?
Thank you,
Goldmember
Does Any one have a SQL server sample database atleast with 50 mb ofdata or can anyone give me a link with I could download it?RegardsSathish S N
View 3 Replies View RelatedI am having trouble installing the sample Adventure database. I went to the following location:
http://www.microsoft.com/downloads/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
to download AdventureWorksDB.msi. Once I save that to my local machine I run the install and it completes with no errors. Unfortunately, I can't see any of the data in SQL Server Management Studio Express. I'm new to SQL Server Express so maybe its me, but I get the feeling that it was never added to the database. I'm still looking for SQLServerExpressSamplesOverview.htm to see if I am missing a step but I can't find it anywhere.
The install seems to have extracted database files but if I need to run some scripts by hand to create the database I don't know which order to run them in.
Any help would be greatly appreciated.
Hello, I am very new to SQL Server. I have downloaded the SQL Server 2005 Express from microsoft's website and installed it on Windows Vista. I have also downlaoded the sample databases like pubs, northwind from http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en and adventure works from the respective site. When i try to run the script of pubs and northwind, it generates error messages and it is as follows:
Msg 911, Level 16, State 1, Line 2
Could not locate entry in sysdatabases for database 'pubs'. No entry found with that name. Make sure that the name
is entered correctly.
Msg 262, Level 14, State 4, Procedure sp_dboption, Line 0
SHOWPLAN permission denied in database 'master'.
Msg 262, Level 14, State 4, Procedure sp_addtype, Line 0
SHOWPLAN permission denied in database 'master'.
Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #1: Cannot find data type id.
Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #1: Cannot find data type tid.
Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #1: Cannot find data type id.
Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #6: Cannot find data type tid.
Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #1: Cannot find data type tid.
Msg 2715, Level 16, State 7, Line 2
Column, parameter, or variable #1: Cannot find data type empid.
Msg 8197, Level 16, State 4, Procedure employee_insupd, Line 2
The object 'employee' does not exist or is invalid for this operation.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'authors'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'publishers'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'pub_info'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'titles'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'titleauthor'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'stores'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'sales'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'roysched'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'discounts'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'jobs'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'employee'.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'employee'.
Msg 208, Level 16, State 1, Procedure titleview, Line 4
Invalid object name 'authors'.
I think thess errors are mostly due to windows vista's new security features at the user level. However, I using my home computer and the admin privileges and in this case I shouldn't have any problem running it unless there's anything to be done on vista to work this.
I'll appreciate if anyone helps me installing the sample files.
Thanks in advance.
Regarding the code/db from the REAL project that just got released, I have no problem attaching the "REAL Sample V6" database, but the "REAL Warehouse Sample V6" database requires ENTERPRISE edition, because the default copy uses Partitioning (i.e. the PT version, although the document stated that the multi-table (MT) version is the default). I only have the STANDARD edition of SQL 2005, is there a workaround?
Appreciate any help.
Need help.After I installed MSDE. I opened a command prompt and navigate to C:Program FilesMicrosoft Visual studio .NET 2003SDKv1.1SamplesSetupAnd then I typed in: oSpl -S(local)VSdotNET -E -i instpubs.sqlI got the message:[DBNETLIB]SQL Server does not exist or acdcess denied.[DENETLIB]ConnectionOpen (Connect()).How can I fix it?The server 2000 is running and it's mixed login authentication.OS: windows server 2003Thank you,William
View 5 Replies View RelatedThe sample application provided with Access Database Synchronizer fires a "A request to send data to the computer running IIS has failed. For more information, see HRESULT." exception on my WinCE 4.2 device.
I debugged it with VS2005 to see what was going on and found that the problem resides in the line:
m_connDesktop.Pull("MSysObjects","SELECT Name FROM MSysObjects WHERE Type=1 and flags=0",accessSysConnectString,RDATrackOption.TrackingOff,"Err_MSysObjects");
It seems that connection m_connDesktop is ok but calling Pull method fails.
I've verified that SSEvAccessSync service is started when ActiveSync detects device connection and that firewall rules are correctly updated.
Also, i verified my System.mdw and i discovered that there is no "MSysObjects" table (only MSysGroupList, MSysGroupMembers, MSysUserList and MSysUserMemberships queries are there).
Do you think the problem is there?
How can i solve it without damaging System.mdw?
I cannot figure out what's the purpose of this line of code, can you help me?
Hi,
I'm working with the sample database called Adventure Works and I'm encountering data consistency issues :
If I sum the TotalDue for one particular territory, for one particular time window from the Sales. SalesOrderHeader table and if I try to compare the result to the LastYearSales and YTDSales from the Sales.SalesTerritory table, I don't get the same number, whatever I try. So did I miss something ?
How are the LastYearSales and YTDSales fields from Sales.SalesTerritory calculated ?
Thx,
Anissa
I'm looking for a sample Database that is well set up to learn from. Does anyone know where I can download one from?
View 1 Replies View RelatedI am working through the book ASP.Net Unleashed Second Addition. I am trying to open a simple database connection. (using the sample "pubs" db from SQL Server)I have copied the author's code exactly, but it just won't work. I keep getting this error:What am I doing wrong?????Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30182: Type expected.Source Error:
Line 5:
Line 6: Sub Page_Load
Line 7: Dim conPubs As SqlConnection
Line 8: conPubs = New SqlConnection( "server=localhost;uid=webuser;pwd=secret;database=pubs" )
Line 9: conPubs.Open()
I downloaded the SR2 - major mistake Now I cannot get into the sample databases I have on my machine. I can attach to the Servers, but they have SR1 and now I guess if I would make changes from my SR2, then they will be screwed up.
My error when I try to log into my machine (adventure works) is:
TITLE: Connect to Server
------------------------------
Cannot connect to LND620JORRIT.
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Is there any way to reverse SR2? Should I reinstall SQL 2005?
Help!
Anke
Hi all,
Can anyone give me a ready-made sample script to display a search reslut from a database?
My intention is to give a dynamic web page for the search in the BookStore website.
The result will show the following:-
First the picture of the book.
To the right of it, 'Title' field, below that, 'description' field
It should be created programatically as the contents are in the database.
I tried several ways, but could not succeed. I have the BookID, Title, BookPicture, and the Description fields
Thanking you in advance,
Tomy
hie
can i use sql server 2005 along with asp.net 1.1 as my front end ?
any idea of doing this ?
I have implemented a caching strategy using the sqlcachedependency and sql server 2005 backend using the broker service.This works fine and well when i am connecting to the SQL Server 2005 under service account that is in the role db_owner. In a production enivironment i am reluctant to do this so i created another service account that only has execute permissions on the stored procedures.When i use this limited service account for my ASP.net web application, the broker service does not send any messages to the web app to invalid the cache. When checking the event log and SQL profiler i get errors all relating to the user not having access to the SqlQueryNotificationService queue. So i did a lot of googling and tried running the grant scripts below with no luck using this limited service account. Keep in mind everything works fine if i use an account with db_owner priviledges. These are the grants i have tried based on numerious articles GRANT CREATE PROCEDURE TO three_d_ss_loginGRANT CREATE QUEUE TO three_d_ss_loginGRANT CREATE SERVICE TO three_d_ss_loginGRANT SUBSCRIBE QUERY NOTIFICATIONS TO three_d_ss_loginGRANT RECEIVE ON QueryNotificationErrorsQueue TO three_d_ss_loginGRANT REFERENCES ON CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification] TO three_d_ss_login These are the grants i have tried that does not work GRANT SEND ON SERVICE::SqlQueryNotificationService TO three_d_ss_loginGRANT RECEIVE on SqlQueryNotificationService_DefaultQueue to three_d_ss_loginCan some one suggest what i need to do to get sqlcacheddependencies to work with a sql2005 backend under a limited priviledged service account? ThanksJim
View 4 Replies View RelatedI have the following XML in an XML column in a SQL 2005 Database.<DeliveryList xmlns="http://schemas.adventure-works.com/DeliverySchedule"><Delivery SalesOrderID="43659"><CustomerName>Steve Schmidt</CustomerName><Address>6126 North Sixth Street, Rockhampton</Address></Delivery><Delivery SalesOrderID="43660"><CustomerName>Tony Lopez</CustomerName><Address>6445 Cashew Street, Rockhampton</Address></Delivery></DeliveryList>I need to query that column using the value method to retreive the addressof the first delivery. I come up with this,SELECTDeliveryList.value('data((/DeliveryList/Delivery/Address)[1])','nvarchar(100)')DeliveryAddressFROM Sales.DeliverySchedulebut it tells meXQuery [Sales.DeliverySchedule.DeliveryList.value()]: There is no elementnamed 'DeliveryList'I have tried every permutation of the path and I can not seem to get it towork? Any ideas?
View 2 Replies View Relatedhi,
I'm using custom authorization in reporting services 2000 to restrict the users. To do this we created a dll customauthorization.dll and placed it in reportserver bin folder and performed changes in rsreportserver.config, rssrvpolicy.config, and web.config files. Now its time to upgrade our servers to SQLServer 2005. Now in SQLServer2005 what new enhancements were done with respect to security and what all extra steps should i follow to perform the upgradation with custom authorization. Please give me suggestions how to upgrade my reports to SQL2005 so that my custom authorization still works.
waiting for ur valuable inputs
uday
Hello,I installed sqlserver2005_express on my PC (localhost) and I try to execute a sql query with ASP.NET.Here's my page :Dim mySqlConnection as SqlConnection = new SqlConnection("server=JOE10155SQLEXPRESS;Trusted_Connection=yes;UID=sa;PWD=xxxx;database=xxxx") Dim mySqlDataAdapter as SqlDataAdapter = new SqlDataAdapter("SELECT * FROM Entreprise WHERE (EntrepriseNr =999)", mySqlConnection) Dim myDataSet as DataSet = new DataSet() mySqlDataAdapter.Fill(myDataSet,"Entreprise")The problem is :System.Data.SqlClient.SqlException: Autorisation SELECT refusée sur l'objet 'Entreprise', base de données 'xxxx', schéma dbo'.if someone have an idea?
View 1 Replies View Relatedhello,
What are the requirements to install sqlserver2005 in my pc.I am using windows xp sp2 in my pc.
One of my friend said, windows server2003 is compulsory(to get data base functionality in sqlserver 2005 and other features) in local pc .Is it correct?
And i am not getting database features in xp sp2.
Can any one help me?