SQL Server

Page 3862




  • Topics
    Replies
    Last post
  • 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."