-
- How Extract the data of TFINF when doing text mining? Thanks
by jliu685
- 1 Replies
- Last post
by Jamie MacLennan
- How Extract the data of TFINF when doing text mining Thanks
-
- sp_changedbowner after Mirroring?
by MikeBlaszczak
- 2 Replies
- Last post
by MikeBlaszczak
- We're using Mirroring in our production environment, and we're pretty happy with it. After failing over, we find that permissions are not correct; especially if the mirror has become the primary and the primary has become the mirror. In particular, we find that we'll need to use sp_changedbowner to reset the ownership of the database. Why is this We'd like fail over to just work, and bring the dat
-
- [F4] properties dialog does not follow convention of defaultvalue <> bold, changedvalue=bold
by adolf garlic
- 3 Replies
- Last post
by Phil Brammer
- Just thought I'd point it out as something that needs fixing. This is inconsistent with every other MS product using the VS.net IDE framework. I'd post it on Connect but then I'd wait 2 months to get "won't fix - this does not 'fit' with the current Katmai schedule" i.e. if I'm lucky (based on the new improved 3yr delivery of sql) it might get delivered in 2011. Wow. Imagine if Xbox or P
-
- Error in mining accuracy chart
by Cspooner
- 1 Replies
- Last post
by Bogdan Crivat
- I ran a decision tree, clustering and neural network mining model across a dataset of about 200,000 records. I am trying to evaluate the accuracy of each of my models but I can't view the results.
I get the following error:
Failed to execute the query due to the following error:
XML for Analysis parser: The XML for Analysis request timed out before it was completed. Execution of the manag
-
- Oracle data source connection problem using Report Manager
by Limehill
- 1 Replies
- Last post
by Limehill
- I have an issue when using Report Manager for viewing reports that use a certain Oracle data source. When viewing the reports in Report Designer the reports display without problems. But when trying to display the reports with Report Manager, after deploying the reports to the Report Server, I now get the following error message:
blablabla....ORA-12705: invalid or unknown NLS parameter value sp
-
- viewing sql server
by hens
- 4 Replies
- Last post
by hens
- why can't i see SQL server 2005 the same way i see Visual Basic 2005 Express edition. i'm able to see VB by going under the all Programs menu and select it, when i try to find SQL 2005, i see configuration tools and some submenu of configuration tools. is that the way it is if not, how do i get SQL 2005 to open up like VB so i can play with it. Also, at home i do not have a server, do i have to ha
-
- Replicating Primary Key value onto the Foreign key value
by AngelinaPerez
- 11 Replies
- Last post
by DaleJ
- Hey Guys, I am just new to SQL Server. I have just created 2 tables Table1 and Table2. Table1 has a primary key (Table1.ID), which has been set on identity values.Both tables have different columns except the ID columns. I have also used Table1.ID as foreign key and primary key on Table2 as Table2.ID. I am just wondering guys if it is possible that when I enter or insert a data on Table1, can the
-
- Web Service Task IN SSIS
by Koteswara Rao
- 0 Replies
- Last post
by Koteswara Rao
- hi friends,
regarding the Web Service Task
i was created a asp.net with c# webservices one.asmx wich contains the 2 methods
1) no perameters(just like hello world)
2) with perameters:
sum(int a , int b)
{
return a+b;
}
until this step fine
in ssis Web Service Task i am giving the input permeters to sum method
whenever we select t
-
- Invalid Object Name
by thussain
- 3 Replies
- Last post
by Greg Y
- I have merge replication setup on MY SLQ server 2000 service pack 2 server.
I was having no issue with replication for the past three month however now I am getting this error when I try to update a record in the database.
In\valid Object Nmae 'ctsv_.....'
I am not sure what is wong with it. Any help or suggestion.
Thanks
Tanweer
-
- Cant log into remote server
by Stealth549
- 1 Replies
- Last post
by Jens K. Suessmeyer
- Hello everyone, I am having issues with connecting to
another database on the same network. I am creating a management system for the
company that I work for and I am currently working on the database side of it
and learning as I go along which means that I am fairly new but I think I have
got the basic concepts.
The system will have multiple databases at different locations.
The ide
-
- BIDS: reports with prompt
by Patricia_Lavish
- 2 Replies
- Last post
by Patricia_Lavish
- Hi anyone:
I'm actually developing a report with some dates on it. I want that when I run this report, a prompt (a window) appears requesting a date (or at least it could be good if a list appears and I can select one of them). Do you have any idea about how can I do that .
Thanks in advance,
Pat
-
- Importing Error
by Karna22
- 8 Replies
- Last post
by jwelch
- Hi all,
I am facing problem on importing csv data file into table,
For Ex:
csv file which has 2 columns & 4 records are as follows EmpNo EmpName 1 a 2 b 3 c 1 a I created new table called T4, structure of T4 is EmpNo Varchar(50) with Primary Key EmpName Varchar(50) disabled Allow Nulls Now I started importing csv data to T4 table,
-
- Convert datetime string. cant find the format i want!!!
by Craig G
- 8 Replies
- Last post
by Adamus Turner
- i need to be able to convert a datetime to the following format ddmmyyyy but cant seem to find the correct convert code.
looked at this but hasnt got the format i want. http://databases.aspfaq.com/database/what-are-the-valid-styles-for-converting-datetime-to-string.html
any help is greatly appreciated
Cheers,
Craig
-
- SQL OLE DB and IPv6
by mreddy
- 3 Replies
- Last post
by Raj Kasi - MSFT
- We have encountered a problem connecting from our client code to SQL Server 2005 using raw Ipv6 addresses.
A small client application on Windows Server 2008 using SQL OLE DB interfaces WILL connect successfully to the raw Ipv6 address of the SQL 2005 Server (also on Windows Server 2008) but the same client will fail to connect if run from a Windows XP or Windows 2003 Server box.
I have s
-
- MSSQL 2005 Server Startup Warning...
by MyoZaw
- 9 Replies
- Last post
by MyoZaw
- Hi,
I'm getting the following warning message whenever I open my SSMS.
"The file C:\WINDOWS\Microsoft.NET\Framework\\mscorlib.tlb could not be loaded. An attempt to repair this condition failed because the file could not be found. Please reinstall this program."
When I press "OK" button, then my SSMS is successfully loaded. And, I can use my SQL server without
-
- int vs varchar
by boyddt_mn
- 6 Replies
- Last post
by boyddt_mn
- I have a select query that is using a second select query in the where clause. independently they both work but when I put them together I get the following error message Syntax error converting the varchar value tblPorts.PortID and PortID2 are both int data types. Any help would be greatly appreciated. here is the query SELECT tblDeviceTypes.QueryTable, tblDeviceTypes.KeyColumn, tblPorts.DeviceID
-
- Conditional Split Task
by A.W.M.
- 5 Replies
- Last post
by Phil Brammer
- Hi All
I am trying to do a simple thing using Conditional Split Task. But I get this error everytime.
[Conditional Split [462]] Error: The expression "ColName1 == "AWM"" on "output "Case 1" (506)" evaluated to NULL, but the "component "Conditional Split" (462)" requires a Boolean results. Modify the error row disposition
-
- primary keys
by Yongpil
- 8 Replies
- Last post
by Mike Kim
- Hi there,
is there any way I can use INSERT so if I try to copy duplicate primary key data, it automatically skips the task and moves on to the next data
-
- Simple SSIS package, problems with flat file output
by Dallastower
- 2 Replies
- Last post
by Kez
- Hello!
I want to make a very simple package: Export all rows in a table to a flat file.
This package I can create pretty much by only using the wizards.
Now to my problems:
1) I need the output to have this format:
H20070920161522 DS3 Plastpall trippelkrage 40 1 E00000000003
H is a header post, in this case with date and time following.
D is a
-
- Autoexist when queying
by Gert-Jan van der Kamp
- 6 Replies
- Last post
by Deepak Puri
- Hi all,
I think it's a simple question but i can't seem to get it right:
I have a parent child dimension, with key Object, and an attribute Type. Every Object has a type, consider this example
Object Type -------------------- Top Model Child 1 Portfolio Child 2 PortFolio
When i run this query:
select time.month.members on 0, objects.object.members * objects.[type].members
-
- ODBC Connection Issue on Client Site
by Amir Ayub
- 1 Replies
- Last post
by Amir Ayub
- Hi,
It might be a basic question but could you please help me on that
Working Environment:
I have developed application on SQL Server 2005 and now wants to Run on Client Site, I am using access as a front end and SQL server 2005 back end through ODBC (System Dsn) which is working good. (user has been added on SQL Server and on Database)
Question:
1) Do
-
- reporting services variable datasources
by spastrana
- 2 Replies
- Last post
by Robert Bruckner MSFT
- I need to create a report with variable datasources. Any one knows the best way to do that
When I try creating variables on the select statement of the dataset it errors out.
I I trayng something like this: select * from @server.@database.dbo.errorlog but It does not recognize the variables. Any suggestions
-
- Exclusive access could not be obtained because the database is in use
by Li556035
- 12 Replies
- Last post
by Madhu K Nair
- Hi
I am trying to use sql server 2005 management stodio to restore a database. But I got this error message:
Exclusive access could not be obtained because the database is in use
Anyone know how to solve this problem
Thanks
Li
-
- Error on connecting to db where named instances are running
by Sailendra6
- 0 Replies
- Last post
by Sailendra6
- When trying to connect from SQL 2005 to SQL 2000,where there are named instances are present.
One instance is able to connect and on trying to connect to another instance throwing error as below:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP
Provider, error: 0 - The specified network name is no longer ava
-
- SQL Server 2005 does not work after OS upgrade to Vista
by Rahul Agrawal
- 14 Replies
- Last post
by Rahul Agrawal
- My instance of SQL Server Developer stopped working after upgrade of OS from Vista to XP. I have also installed SP1 & SP2. Still it is not working. The message that I get when I start SQL Server Management Studio is "The application cannot start."