SQL Server

Page 5874




  • Topics
    Replies
    Last post
  • DISTINCT COUNT WITH NULL VALUES (GRAND TOTAL)
    by freadomfee
    14 Replies
    Last post by Deepak Puri
      • Hello, I have a DB of professors and information related with them. I created the cube, it consist of: Measures: Measure group Professors: Amount of projects (COUNT proj_id) Amount of pulications (COUNT pub_id) Amount of e_books (COUNT book_id) -------------- Measure group Projects: Distinct amount of projects (DISTINCT COUNT proj_id) -------------- Measure gr
  • Cannot Login
    by VBNewbie
    2 Replies
    Last post by Madhu K Nair
      • VB express and SQL express are on the same desktop. I have an application in VB that works fine.The issue I have is if I go into SQL Management to work on the DBand then close SQL Management Express. When I go back to execute my VB application I get a message like this " Login failed for "user name" file is in use by another application". If I reboot my system and then run the
  • SQL Server dropping comma in German language
    by Gubbs
    3 Replies
    Last post by Arnie Rowland
      • All, I've a VB6 application that writes data to a SQL Server database using ADODB in the VB6 code. My market has been the United States. My application is written for the English language. I've a new user in Germany. Unfortunately, every number that contains a decimal is now stored in the SQL Server database with the decimal dropped. For example, 29.15 gets stored as 2915. I've done some searching
  • Maximum length of an expression
    by Helen54999
    4 Replies
    Last post by Helen
      • Is there a maximum number of characters in an expression thx Helen
  • AMO Role Creation
    by cherriesh
    3 Replies
    Last post by Darren Gosbell
      • Hi, I have just created a role using AMO. I'm supposed to see this role in the Analysis Services Project once I open it, right But I cannot. I tried executing again my codes, and it prompted me an error, which means that it was created successfully. Error: Another 'Role' object has the 'TestRole' name. Why can I not see that in the AS Project By here is my code:
  • Proclarity analytic Views without using sharepoint
    by Moe Min
    3 Replies
    Last post by Moe Min
      • Hi All, May I know there is any way to show the proclarity analytic views or reports in a web portal without using sharepoint server If there is no way, can u brief me how to create proclarity analytic views and how to show those views in web portal ( browser) by using sharepoint server What kind and what version of SSAS , proclarity , and Sharepoint do I need to use I
  • static variables in a SQLCLR stored proc seem to get reused from execution to execution of the sp
    by db042188
    3 Replies
    Last post by nielsb
      • after moving off VS debugger and into management studio to exercise our SQLCLR sp, we notice that the 2nd execution gets an error suggesting that our static SqlCommand object is getting reused from the 1st execution (of the sp under mgt studio). If this is expected behavior, we have no problem limiting our statics to only completely reusable objects but would first like to know if this is expected
  • Add list as parent for rectangle in rdl
    by leshan01
    0 Replies
    Last post by leshan01
      • Hi! I have a report designed with all the tables in the rectangles on the rdl. Right now, I need add "list" control on the top of those rectagles(including all the tables) so all the rectangles have list as parent I don't want to start over to just for adding the list. I was trying to edit report xml file to add the "list" on the top of rectangles but the compiler c
  • Printing in Reporting Services hangs
    by VPDJ
    14 Replies
    Last post by CodingVeteran
      • Please Help!!! We have never been able to get the printing to work on any of our reports using SQL Server Reporting Services 2005 SP2 in our production environment. Without this feature of printing a report, we cannot go live with SSRS at all. We have tried adding the SP2 after a clean install on a new server -- yet we still have this problem. I read a few some posts about uninstall the old Active
  • MICR Font Issue When Exporting to PDF
    by tjams
    14 Replies
    Last post by jhknys
      • Hi, I'm using Reporting Service to print checks. Everything seems ok when I design and deploy and view the reports. But when I try to export to pdf, the MICR font I'm using does not work. I've tried a couple of different MICR fonts from the web and they either get replaced by a standard font or disappear altogether. I would love to know why that is. Thanks in advance, Tom
  • Stored Procedure adding new row
    by NubNub
    6 Replies
    Last post by NubNub
      • hello i am trying to write a stored procedure that add a new row to a table, this part i can do using INSERT. I then want to access the ID for the row i have just add, which is the primary key for the table and produced by a auto number. I will then use this value combined with a string to produce a report number which i will put back in a field in the row i just added, and i also need t
  • Member Property length limitation
    by Abhishek Patnaik
    6 Replies
    Last post by Abhishek Patnaik
      • I have a member property in a shared dimension MSAS 2000. The length of column from which this member property fetches value is nvarchar(2000). But the OLAP cube is reading only 255 characters ONLY. Is this a common limitation If yes, what is the alternative to increase its length to grater than 255 Any help will be greatly appreciated. Thanks.
  • SQL Server 2005 Evaluation Install Error
    by jackwc
    12 Replies
    Last post by Jin Feng - MSFT
      • I downloaded the SQL Server 2005 Evaluation setup .exe. When I wen to install it by clicking "SQLEVAL.EXE", I received an eror stating "There is not enough space on Drive C:\ to extract this package. I have over 50 gig of available spac eon my C drive. What gives When I downloaded the .exe, I had the Norton AntiVirus Auto-Protect enabled. Could that have caused it Also, 2 days
  • Custom Control Flow Item Issue
    by MojoRobbins
    8 Replies
    Last post by MojoRobbins
      • I've been using Konesan's FileWatcher control-flow item successfully in design-mode on my PC, which runs the package on a remote server. I have installed the Konesan's FileWatcher on the remote SQLServer machine. I then imported the package to the server (Files System folder). I then select the package, right-click 'Run Package', then Execute, and receive the error: "Erro
  • Move distribution data/log files to another drive
    by rjrlane
    2 Replies
    Last post by rjrlane
      • I haven't found the definitive answer on how or if this can be done without removing replication. I'm thinking ALTER DATABASE modify_file is the way to go. Anybody know if this will work or a better way to go about it Thanks
  • Data Source and Connection Manager
    by jh0483
    9 Replies
    Last post by Zadoras
      • Hi all, I don't really understand the difference between the "data source" and the "connection manager" in a SSIS solution. I tried to create a data source (if I understood correctly, I will ba able to share that connection between all packages in the solution), then I create a new connection manager inside a package. But when I make a modification in the data source, nothing c
  • Query Execution failed for dataset error / the syntax for " " is incorrect
    by madu
    3 Replies
    Last post by Francesco De Chirico
      • Hi, Am totally new to MDX Queries. I got this error while previewing a report that we had made. It goes like this -- Query execution failed for dataset 'some_dataset'. Parser: the syntax for 'some_character' is incorrect. What was figured out was this error shows up only for those values in a particular dropdown list which are multiword. Eg : My Company Technology and not for those
  • Month's end
    by Constantijn Enders
    2 Replies
    Last post by Mosha Pasumansky
      • Hi, I am working on a cube that contains month standings and month totals. This works fine if I select one month. It goes wrong when I do a year to date selection because it sums up the month standings. How can I make a cube that does sum up the month total but only returns the last month standings. With regards, Constantijn Enders
  • Backup File Name
    by Imran Hasware
    2 Replies
    Last post by Imran Hasware
      • Dear all, On scheduling the online backup for SQL server 2005 with SQL server management studio, how the backup filename can be automatically change for everyday. I mean the backup filename be automatically generated every day. Thanks Imran Hasware
  • CONTAINS and WHERE Clause Combination taking too long
    by waqaramin
    3 Replies
    Last post by Jens K. Suessmeyer
      • Hi, I have a table with 3 columns and 20 million records. first 2 columns have VARCHAR(4) data type and third column is VARCHAR(5000). I put 3rd column under FULLTEXT and implement a normal INDEX on 1st column. Now when i try to search SELECT TOP 20 col1, col3 FROM tbl WHERE col1 = '1234' AND CONTAINS(col3,'"market*"') I am facing following problems 1- It hang for like 1
  • stored procedures, compile or not
    by JohnSLG
    6 Replies
    Last post by edburdo
      • I am writing stored procedures to retrieve data from an OLTP application that will be adding several hundred thousand transactions a day. The user will be presented a screen to select up to a dozen or so search criteria; date range, color, size, processing plant, etc. They may select all criteria, one or two, or none. Currently I am creating a stored procedure "on the fly" by replacin
  • Add connection error: 40
    by thrinker
    1 Replies
    Last post by spottedmahn22
      • Hi i just reinstalled windows, and installed visual studio .net 2005 and the Sql server. But when im trying to add connection, select my computer at Server name, type a databasename then pressing OK i get this message: An error has occured while estabilishing a connection to the server. When connection to SQL server 2005, this faliure may be caused by the fact that under the default s
  • is it possible to connect to SQL Express without network?
    by Ocherk
    3 Replies
    Last post by Arnie Rowland
      • I have notebook, client server application and sql express sp2 on this notebook. Also, I know domain user login/password, but I don't know any local user name/password and I don't know any sql server user name/password. Domain user is not a local administrator on this notebook. When notebook connected to the office LAN I am working good with my app-> my sql express as a domai
  • Cannot completely install/remove SQL Server Express
    by BGood
    2 Replies
    Last post by BGood
      • I cannot use, remove, or reinstall Microsoft SQL Server 2005. Although Microsoft SQL Server 2005 and Microsoft SQL Server Setup Support Files appear in ControlPanel-ARP, when I attempt to remove Microsoft SQL Server 2005, the workstation component remains. If I try to download and reinstall Microsoft SQL Server Express from the Microsoft website, the download does not install completely as describ
  • Transaction log backup error
    by JulieShop1
    6 Replies
    Last post by Sue Hoegemeier
      • I've created 2 new jobs in Microsoft SQL Management Studio - one for full backup of database, and another - for backup of tran logs. The full backup is scheduled to run once every morning, and it runs just fine. However, tran log backup, which is scheduled to run every hour, has some problems. Sometimes it runs successfully 3-4 times and failing after that with this error: Executing the query &