SQL Server

Page 5386




  • Topics
    Replies
    Last post
  • Cannot insert duplicate key
    by Dan Crowell
    5 Replies
    Last post by Danny Crowell
      • I am using SQL Server 2000. I have a table (tbDupes) with duplicate records. I want to populate another table (tbUnique) with unique records. My tbDupes has about 50 columns and three of them make up my primary key in tbUnique. I thought I could get unique records by using the following SQL statement. Code Snippet INSERT INTO tbUnique SELECT * FROM tbDupes I rec
  • Pagination in SQL????
    by prashant_victory
    1 Replies
    Last post by Manivannan.D.Sekaran
      • Hi, I have found the follwing article on internet. This article states two keywords LIMIT and OFFSET using which we can implement the pagination type of functionality in MySQL or PostgreeSQL, http://www.petefreitag.com/item/451.cfm But is there any way using which we can implement pagination kind of functionality in SQL. LIke first time if i set 0 thenm it fetch the records from 1-10 then if i set
  • ALTER LOGIN syntax problem
    by stratoblue
    5 Replies
    Last post by stratoblue
      • I typed the following in sqlcmd: 1> ALTER LOGIN [BUILTIN\Administrators] WITH DEFAULT_DATABASE=master 2> GO And I got this error: Line 1: Incorrect syntax near 'LOGIN'. Can you help me find the problem Thanks
  • Executing Remote Stored Procedures in Triggers
    by pandya
    2 Replies
    Last post by pandya
      • Hi, I've been scratching my head over this problem for quite a while. I have two SQL SERVER 2005 servers running on the same network, lets call them ServA and ServB. ServB is configured as a linked server on ServA as LinkedServB. On ServA, there is a database called DatabaseA, in which there is a table called TableAA, on which I wrote a trigger on delete. In that trigger, I want to update a table,
  • User limit on using the sql express edition
    by estherlaihk
    7 Replies
    Last post by js06
      • Hi all, I am going to create an application with backend SQL server 2005 express edition, I would like to know is there any limitation on the numer of users that use my application Thanks & Best Regards, Esther
  • what is different in the version I downloaded this week from the version I downloaded in March?
    by TheMarcus
    2 Replies
    Last post by Jens K. Suessmeyer
      • I ask because I was testing a Source Control solution that uses SQL Express for its database component, and when I tested it in March it worked fine, but now I can't get the Source Control software to recognize that the database is there. It creates it just fine, it just can't seem to look inside the database instance. I've tried manipulating ports, assigning permissions, browser on, browser off,
  • linked server Login timeout expired error
    by Rashid nizam
    1 Replies
    Last post by oj
      • Hello All, My application is dependent on two databases one is on sql 2005 machine and other is on sql 2000 machine. A linked server is establish between these two using sql account which has appropriate rights on both server's databases. application works fine but after some time it crashes and if i see error from sql profiler i get the error OLE DB provider "SQLNCLI" for link
  • Error trying to design script (Script Component)
    by Alonso Villanueva
    14 Replies
    Last post by ktheman
      • Hi everybody: Maybe somebody around here can help me out with this one. I applied SQL Server 2005 SP 2 to my local environment (win 2003 server) about two weeks ago week and last week I noticed an error when I tried to edit the script components of some previously created packages. I am not 100% sure that SP 2 is the cause but that's the only thing that has changed recently. Well, this is my error
  • Union All Component silently changes Output field length
    by Frommon - MCAD
    5 Replies
    Last post by KER
      • To simulate problem do follows: 1. Add Script source component. 2. Add 2 string output collumns: F1 length 50, F2 length 110 3. Add Union All component connected to Script source component 4. Add Script transformation component connected to Union All component 5. Mark F1 and F2 as input collumns 6. In the Input and Output section of the script transformation component check that
  • Making the year field 2007 to a 07 instead?
    by mrmallis
    2 Replies
    Last post by mrmallis
      • Hi In my matrix cell I have a cell with the following Expression: =Fields!monthname.Value & " " & Fields!Year.Value In one of my datasets I have a SELECT CAST(FCYB.cyb_yearname AS int) AS 'Year' ... amongst other things. Now, how do I make 'Year' to say 07 instead of 2007 What is the proper way to do it In the expression or in the SQL code Thanks
  • Customise Report Parameters in Report Manager
    by iliketoeaticecream
    1 Replies
    Last post by Mike Schetterer -- MSFT
      • Is it possible to add custom controls in for parameters in report manager I have a parameter that requires the user to click a button and select a bunch of things in another form. How can i do this in reporting services I also would like to change the layout of the parameters toolbar, ie. make text boxes smaller widths, show/hide parameters based on other parameter values. I know i could write
  • Error loading package
    by disenfranchised
    8 Replies
    Last post by ZigaP
      • Hi there all... We've just started using SSIS packages, and everything seems to be going ok. I've recently set up a couple of jobs which just run an SSIS package every 5 minutes to collect data. These run fine 90% of the time, but intermittantly produce an error. When using a SSIS task in the job it simply reported "Could not load Package." I have changed these to use DTExec
  • Stored Proc with select statement and nolock behaving Wiered
    by Snehalata
    4 Replies
    Last post by Manivannan.D.Sekaran
      • Hi, I have one stored proc with simple select on a table having composite primary key. And I am using Nolock option. Just for one particaluar Foreign key it is returning the values in reverese order. To be more clear TABLE1 Filed1 Filed2(Fk) Combination of Field1 & Filed2 is Primary key here. I am querying on Field2 Select * from Table1(NOL
  • How to Create Assembly function using dll files in SQL Server 2005???
    by Pratik Kansara
    11 Replies
    Last post by nielsb
      • Hiiiiiiii all I have to make a user defined function in c# as the class liberary and create a dll file, now i want to use this function in SQL Server 2005 as a part of CLR Integration I have tried like this CREATE ASSEMBLY abc FROM 'C:\abc.dll' WITH PERMISSION_SET = SAFE but it gives me incorrect syntax error so plzzzzz anyone help me wht to do in
  • Problem in Chart
    by V.M.Senthil
    1 Replies
    Last post by GregSQL
      • Hai all, I am generating chart using the Sql Reporting services.I have done 2 charts. when i am clicking one chart it will navigate to another chart.It is happened in reports. when i used in UI page(web Page). when click the chart it is not navigating to another chart.The same chart will appear when i click the chart. Can u guys help me soon to solve this problem.. Thanks In advance.
  • Understanding ROLAP
    by Kevin Dente
    14 Replies
    Last post by Mosha Pasumansky
      • We are looking at adding a real-time aspect to our SSAS cube set, to allow reporting against a relatively small but constantly changing data Our initial thought was to use ROLAP partitions and dimensions - we were under the impression that the queries would always be satisfied from the underlying relational tables. However, in our explorations we are finding that understanding to be incorrect - SS
  • Insert Syntax
    by Hossam Abdel Wahab
    6 Replies
    Last post by DaleJ
      • Hi all Execute insert normal insert script Insert Into () select * from... I need to monitor how many record inserted in target table, anyone can help
  • allowing null values
    by CSharpCoder
    9 Replies
    Last post by estaup
      • I have a flat file that I'm reading from and loading my tables with. In that file I have a column that has numbers (2000,1999,1998 and so on) and the column that they are being loaded into is defined as an INT. The issue I'm running into is that the first 50 or so rows in the flat file is empty for this column so I'm getting an error message. If I put numbers in that column in the flat file it wor
  • SQL Server and Hyperion Essbase
    by Shahab03
    2 Replies
    Last post by Shahab03
      • I just found out that SQL 2005 SP2 comes with 'Microsoft .NET Data Provider for Hyperion Essbase' . I was wondering if its possible to use it outside of reporting services Thanks Shahab
  • Report Page Width with Dynamic columns through parameters
    by Will579428
    4 Replies
    Last post by Will
      • I found the following paragraph while searching on here: ************************************************************************ You could easily set up a parameter for each column and then display that column conditionally based on the parameter. For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the w
  • Visual Studio 2005 The remote connection to the device has been lost. Please verify the device connection and restart debugg
    by Jim Ward
    14 Replies
    Last post by CraigHunterFXA
      • Basically I've been using Visual Studio 2005 for a few weeks now moving a Pocket PC project from 2003 to 2005. When I hit the Start Debugging Button every time until today the project would rebuild and deploy to my pocket PC allowing me to debug etc but now I get The remote connection to the device has been lost. Please verify the device conection and restart debugging. I used to get this
  • linking 2 or more cubes
    by cherriesh
    2 Replies
    Last post by Matt Carroll
      • hi, im new in analysis services 2005. is it possible to link 2 or more cubes together thanks, cherriesh
  • help with reporting services
    by john.vong
    10 Replies
    Last post by Leslie Askew
      • I installed sql express with advanced services on a local network computer named 'Tester'. For service accounts I used 'network service' and 'mixed mode' for authentication. I would like to publish database reports using reporting services. when i open a web browser on the machine with sql express and type in the url: http://localhost/reports or http://localhost/reportserver the web pages work fin
  • Analysis Services Calculations
    by Techquest
    6 Replies
    Last post by James Todd - Australia
      • Is it possible to group/ arrange Analysis Services Calculations in cubes into separate Folders In other words similart to measures which can be grouped in to folders I would want to know if we can group these calculated meassures into folders. Thanks
  • EXEC sp_readerrorlog 1;
    by Worf
    1 Replies
    Last post by KeWin
      • Hi, EXEC sp_readerrorlog 1; usually gives me errors from days ago without the errors from today. When I look at the error logs in the Enterprise Manager, the first errors I see are indeed the ones appearing in my list which I retrieved from the sp_readerrorlog 1; but when I scroll down to the bottom, I can see the logs from today. So, why is it that the logs from today do not appear