Answer Questions
coldie how to get Alias name in columns and mapped column from views
hi we are looking for mapping between views and table that make the views so if we take example of nortwind database in sql and create view as create view v1 as SELECT dbo.Orders.OrderID AS [new orderid], dbo.[Order Details].ProductID AS [new productid] FROM dbo.Orders INNER JOIN dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order Details].OrderID as in above case we have used alias for orderid as "new orderid" and productid ...Show All
ploskikl SSIS: Inserting unknown members from fact table
Looking up surrogate keys in a dimension table and adding these to your data flow is easy when there is a match in your dimension table for every key in your fact table. However, I am puzzled by how to manage the data flow when no match can be found for a specific key in the fact table when doing the lookup AND I then want to insert this unknown key as an unknown/inferred member in the dimension table. The problem is further complicate ...Show All
Francois Babin Query Question. On the right track, I think...
Hi. I have a large "view" I'm working with, between 250-280 fields [not sure exactly]. Within this view there are a few fields with similar information. For example, LocationID corresponds to the Address, City, and State, but those three are seperate fields. I also have a field with the most recent date and time that the address was used. There can be multiple records for any address if the address was used more than once in any ...Show All
Clint Stotesbery How to import text file(no space, no symbol, no column) into mssql
t he text file format use the length of character to define the field for example, 0001130130HAUT BAGES AVEROUS 03 9 chars <0001130130> is a field 1 char <H> is a field 20 chars <AUT BAGES AVEROUS 03> is a field one record by one record store in db no space, no symbol, no line break between each record ---------------------------------------------------------- I try bcp method, but some error happens. Please give me s ...Show All
DavidC&#35;2005 increasing maximum of tables to greater than 256 ?
Hi, I am submitting a query to SQL server and I'm hitting an error--> Too many table names in the query. The maximum allowable is 256. I CAN find a work around by breaking things up, but, isn't there a way to increase this limit of 256 tables Seems kind of a lowball cieling for SQL Server. The issue is use of several tables recurringly as part of multiple sub queries, not nested mind ...Show All
matthew.tech cannot generate ResultSet code
I am using Visual Studio 2005 and SQL Server mobile edition. From Visual Studio I went to Data->Add New Data Source. From there I created and added an SQL server Mobile database. I want to use result sets instead of data sets. A file was added to my profect called: "databaseNameDataSet.xsd". In the properties for that file, when I change the Custom Tool property to MSResultSetGenerator, I get the following error: Failed to generate ...Show All
morur Backup of Log fails.
It appears that the data is backing up fine but logs do not. Obviously something has changed but I cannot see what. I have plenty of space and privs but the backups fail with the below errorlog. If anyone can point me in a new direction I would greatly appreciate it. 2005-12-31 08:22:34.16 spid11 Analysis of database 'CEMS_PRO' (7) is 100% complete (approximately 0 more seconds) 2005-12-31 08:22:34.25 spid5 &n ...Show All
begginer666 Migrate from SQL Server 2005 to MS Access 2000
I need to migrate some tables from a SQL Server 2005 full version (trial) database to a MS Access 2000 database. The situation is that a search program is available online (with SQL Server database) and also as a CD based desktop version ( that uses MS Access 2000). I have made corrections to the text contents of the online SQL Server DB and would like to make a MS Access 2000 database version for desktop application, rather than have to manuall ...Show All
ndo Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance
No wonder Microsoft is giving it away for free. It’s not worth anything. I am very disappointed in this version of SQL server. I decided to start learning VB so I downloaded and installed VB 2005 express edition and SQL 2005 express. I tried to build a personal website using the starter kit. I kept getting the following error message, for which I have seen numerous postings on this forum. “Failed to generate a user instance of SQL Server due ...Show All
Rudolfh Bantim SQL Server 2005 June CTP Install Issue
When trying to install SQL 2005 June CTP to a Windows Vista Beta 1 install I am receiving the following error during the configuration portion of the installation: TITLE: Microsoft SQL Server 2005 CTP Setup ------------------------------ SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Connection was terminated [1236]. Refer to server ...Show All
Daniel21 Poison Message Sample in BOL
Hi, We've been trying to diagnose a problem with service broker's poison message detection and tried to run the sample script in BOL to see how it solved the problem. It appears the example doesn't seem to work correctly, IF (@messageTypeName = '//Adventure-Works.com/AccountsPayable/ExpenseReport') &n ...Show All
Andrew Whitechapel Remote Connection problems, I've read many a thread on this and nothing has worked!
Hi, I am trying to enable remote access on a SQL Server 2005 standard edition instance. I have enabled it in the properties using the Management studio and have enabled it under Sql Server Surface Area Configuration under "Database engine". But it didn't work. I know for a fact that my connection string is correct (I tested it on the actual machine) So I checked everything again and I noticed in the Sql Server Surface Area under ...Show All
MTEJEDA Issue installing SQL Server Express on Visual Studio Beta 2
Hi, I have installed VS 2005 Beta 2 (Team System) using a DVD available from MS TEch Ed. This also installs SQL Server 2005 Express edition along with other tools. This installation is done on a vpc. However when I try to install SQL Server Express Manager over this installation, I get "The installer package could not be opened. Contact the vendor to make sure to verify that the Windows installer package is valid". Is there a solution to get thi ...Show All
Shreya Installing Problems
I have similar problems to others when installing the SQL Server Express version. I also get the errror msg about prior versions of .NET, Visual Studio, etc. I have removed everything, etc. about 4 times each.....can someone please tell me what gets installed in what order. At one point, MS said to install .NET 2.0 however on the SQL support page, it says that it installs it automatically.....ughghghgh thanks in advance. ...Show All
mcsherry Linked servers
Does SQL Server 2005 Express support linked servers Distributed partitioned view is not supported by SQL 2005 Express, but I couldn't find any document explicitly saying that linked servers are not supported. An easier way to find out would be to try to add a linked server. HTH. You can add a linked server in SQL Express. A good SQL Express 2005 overview, including what is no ...Show All