SQL Server

Page 2528




  • Topics
    Replies
    Last post
  • Trouble Installing Reporting Add-In for Microsoft Visual Web Developer 2005 Express
    by Philimon
    3 Replies
    Last post by Kampoln Cheewakriengkrai
      • Hi Folks I've downloaded & installed Visual Web developer Express and SQL Server Express and now I'm trying to install the Reporting Add-In available here: http://msdn.microsoft.com/vstudio/express/downloads/default.aspx It downloads just fine and, just as the installation progress bar is almost done and the status text says 'Registering Product', I get the following error messag
  • xquery query path without elements
    by lkh
    4 Replies
    Last post by lkh
      • The Demographics xml data type column in AdventureWorks. Sales . Store contains the row sample below. How would I write the path for Demographics.query() to retun all rows with AnnualSales >=300000 I'm using variations of this statement but can't find an example of a path without elements. SELECT demographics . query ( 'declare namespace AWMI="http://schemas.microsoft.com
  • Hotfix for Bug # 473675 (SQL Server could not spawn process_loginread thread)
    by sc_simsl
    4 Replies
    Last post by Ron Van Zanten
      • Hi, I get " SQL Server could not spawn process_loginread thread." errors. This is related to a bug in SQL 2000 and there is a hotfix for SP3a. I am running SQL2000 with SP4. I checked the fix list of SP4 & this bug is not fixed in this SP4. Can I apply the hotfix to resolve this problem on my server tia.
  • EXEC in WHERE clause
    by valentin tihomirov
    1 Replies
    Last post by Arnie Rowland
      • I wanted to have something like SELECT * FROM refs1 WHERE (EXEC ref_id) = this.id Should I turn the SP into a function
  • Linkserver connection fails between SqlServer 2005 and Oracle 10g
    by Jay87
    11 Replies
    Last post by Brian Matuschak
      • This is what I did: The instructions for changing the registry entries per previous MSDN postings were: For Windows 2000 Oracle 8.1 [HKEY_LOCAL_MACHINE\SOFTWARE \Microsoft\MSDTC\MTxOCI] "OracleXaLib"="oraclient8.dll" "OracleSqlLib"="orasql8.dll" "OracleOciLib"="oci.dll" Changed the regis
  • OUTPUT - help with please
    by sskaar07
    5 Replies
    Last post by sskaar07
      • I am using a dynamic t-sql string in proc1 to execute proc2, which returns an int variable named @Fatal_Error back to proc1. When I execute proc2 I use the syntax: EXEC @SQL @Params @SQL is the Proc Name (varchar) and @Params is the parameter string (nvarchar). If I include the @Fatal_Error variable in the dynamic creation of the @Params string the returning value fro
  • problem with Stored procedure
    by fahad11
    2 Replies
    Last post by fahad11
      • hi everyone... Iam new with stored procedure in Sql 2005 so iam facing a problem which i need to get the result of query to store in an sql output parameter here is my SP : ALTER PROCEDURE [dbo].[CheckUser] ( @Id nvarchar(50) , @Pass nvarchar(50) , @Exist int output , @Type char(1) output ) AS BEGIN SET NOCOUNT ON; -- Insert statements for proced
  • Creating an Windows Rdl on the fly using .net programming
    by p4Pratik
    14 Replies
    Last post by GregSQL
      • Hi, I would like to know that can I create an .rdl file programmatically based on the user selection (USING .Net programming) . Please help with some link / examples. P.S: I am giving very less number of static reports to the client. I want to give a more of a dynamic report , wherein in each case, I will give the user a selection criteria to select the fields fro
  • XML columns failing to Replicate
    by Grant_csi
    14 Replies
    Last post by Grant_csi
      • I am using Push Merge Replication. I am seeing some very disturbing behavior related to the xml datatype. An insert into a table with an xml value seems to consistently fail to replicate the xml value. The row is replicated, but the xml column is null. Also updates to an xml column do not always get replicated. Is this a known problem I cannot stress how big a problem this is for my busine
  • distinct query for table containing records more than 69347
    by dmouser
    2 Replies
    Last post by Louis Davidson
      • What would be the best way to avoid distinct clause in query to get the result.My Query looks like select distinct Col1 ,col2,col3,col4 from ABC where (1=1) group by Col1 ,col2,col3,col4 order by col1 ABC Contains records like Col1 col2 col3 col4 a 1 1 1 a 2 1 1 B 2 2 2 B 1 1 1 ; ; ; how is the performance of disticnt qu
  • Checking for records where One value is NOT in the other?
    by Seidel1
    2 Replies
    Last post by Jim Seidel
      • I am trying to display results in which a value in my first result table is NOT contained in the second result table. Any idea on how to do this . SELECT CUSTOMERID, CUSTOMER FROM TABLE1 WHERE CUSTOMERID NOT IN TABLE2
  • Property IsLocked is not available
    by Akhiris
    7 Replies
    Last post by BalochDude
      • I'm running Vista Ultimate x64 and when I tried to connect to my 2005 database using SQL server authentication it gave me an error. When I went to the management studio to check on the login it said this: TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Cannot show requested
  • Store currency and volume in database
    by matthamilton
    2 Replies
    Last post by Tom Phillips
      • We are creating an enterprise application for fuel, and I am fighting with my DBA about the proper way to store volume and currency in the database. We have 2 main arguments. The first argument is whether we should store costs in the database in $ and convert in the presentation layer, or to store the amount and currency in the database. We sell product from the US in dollar but depending on the c
  • Deploy Reports via Visual Studio 2005
    by Dave Byrum
    5 Replies
    Last post by Ryan Ackley MSFT
      • This seems to be a basic issue, but I am having a problem trying to deploy a report to Reporting Services. I have setup the deployment options under the properties of the Project. But each time I try to deploy a report, I get "The request failed with HTTP status 504: Gateway Time-out" When I try to connect to connect directly to the TargetServerURL via a web browser from my client
  • Question on Row Count Transformation
    by minority80
    13 Replies
    Last post by minority80
      • Hi all, i'm using Row Count Transformation downloaded from http://www.sqlis.com/93.aspx to generate surrogate key. in my data flow, i have OLE Data Source connected to Row Count Transformation connected to SCD. i've configured ok and the package ran without error. my problem is my surrogate key column won't generate the next increment number if i run the package the 2nd time and there
  • Installing Sql Server 2005 Enterprise on Windows XP pro
    by Rog123456888
    1 Replies
    Last post by georg.thomas
      • I am trying to install 2005 sql server enterprise edition on windows xp pro, When I get to the part where you pick which components to add, they are all grayed out except for workstation components and books. What did I do wrong
  • Need hand holding
    by Douglas_W_Roberts
    1 Replies
    Last post by Sam Lester - MSFT
      • Hi - Is there a resource I can go to that lists people who I pay to talk me through stuff like getting SQL Server Express installed, get some sample data input and then get that data into Excel I just cannot seem to get any help that works for me to learn SQL Server; the books are obtuse, the online help too indirect. Once I get something working I hope to enhance it on my own, but I have been stu
  • When to use a Nested Table?
    by Jeff Modzel
    2 Replies
    Last post by Jeff Modzel
      • Why would someone choose to model a problem with a case and nested table versus just using a case tables with multiple rows For example, a simple customer and product scenario where you could say: Mining Model DT_CustProd ( [Id] , [Gender] , [Age] [Products] Predict ( [ProductName] , [Quantity] ) ) But you could also model as: Mining Model DT_CustProd ( [Id] , [Gender]
  • SQL Server 2005 Install fails on Vista
    by CJSingh
    14 Replies
    Last post by Opal-SD
      • During the install, I get the following message: Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed. Microsoft .Net Framework 2.0 is either not installed on this system or is corrupt. I cannot uninstall 2.0, as its part of the Vista. I have tried repairing it. I tried downloading 2.0 and installing it, but it says that its allready installed.
  • error
    by guddu567568
    14 Replies
    Last post by guddu
      • hi i have one varchar field i m convarting that field to datetime in format of dd/mm/yyyy but i m getting eror select top 30000 CMS_Upload_Details_ID,Scheme_Code,DrCr, convert(varchar(10),cast(AdditionalField5 as datetime),103) 'ValDate' ,AdditionalField13 'dept_slip',AdditionalField14 'dept_dt',Cheque_No 'Instrm_No',Amount,CONVERT (varchar(11),Instrm_Date,103)Instrm_Date ,AdditionalFiel
  • Sub_Report on field details Table
    by MickaelT
    1 Replies
    Last post by mavericklbj
      • Hello, I'm French, so sorry for the faults. I want to make a report with a table who gives some figures of a family and elements of her subfamily. For example, for the Fruit family I have like subfamily the apple, the pear, the banana. I tried to make a table with a group but to aggregate some figures of the subfamily dataset, calculations are complicated. So I make two report:
  • Few questions on INDEXES.
    by DBLearner
    4 Replies
    Last post by Joe Webb
      • Dear Experts, I have few questions on SQL Server indexes. Example : There is a table Table1 with columns col1,col2,col3,col4,col5. Q#1 There are below non clustered indexes on the table Table1 1. IDX1 ON (Col1, Col2, Col3) 2. IDX2 ON (Col2, Col3) 3. IDX3 ON (Col2) 4. IDX4 ON (Col3, Col4, Col5) 5. IDX5 ON (col5) 6. IDX_PK ON (col1) is Primary key and IDENTITY. Does these indexes makes sense That
  • Not able to sort UDTs in DatadridView Control.
    by Manoj Shah
    0 Replies
    Last post by Manoj Shah
      • Hi All, I have deployed UDTS in SQLserver and i am dsplaying data in datagridview control of the table which contains columns of UDTs. Till time everthing is ok. But problem is All other columns sorting is working properly but UDTS column sorting by doing Columnheader click is not working and firing an exception like System.Data.DataException occurred Message="Type 'MCSTypes.AlarmS
  • how to use non-basic AscII character in Stored procedure parameter
    by JoneLee
    3 Replies
    Last post by Arnie Rowland
      • hi all, I have a stored procedure with a input parameter ( xml block). sp: spGetAddr @xmlText the style of parameter @xmlText looks like <Param RestricBy="UserName IN ('May a ', 'Bob')"/> If I use non-basic ASCII character, just like ' a ' in the parameter, the execution fails and I get 'The error description is 'An invalid character was found in
  • What version: Enterprise manager or Management Studio Express
    by dkingman
    3 Replies
    Last post by dkingman
      • This may be a dumb question but I have searched and haven't found an answer to it here yet. We are planing to get SQL Server 2005 for a specific purpose.We have several existing stand alone SQL Server 2000 database servers already. I have Enterprise Manager (2000) client installed on my PC. I recently installed SQL Server Express (2005) on my PC to get to know about new features. I have run into p