SQL Server

Page 4155




  • Topics
    Replies
    Last post
  • Which SQL Server 2000 Edition should I install in at UAT environment
    by Lyn Duong
    3 Replies
    Last post by Lyn Duong
      • Hi, We have a suite of applications which go through the full product life cycle and I was wondering which SQL Server edition should be installed in every each environment from Proof of Concept -> Dev -> -> UAT -> Systest... Production is straight forward but I am just not sure about all the other environments. thanks Lyn
  • Error processing Cube - The syntax for ',' is incorrect.
    by RafOv
    1 Replies
    Last post by Darren Gosbell
      • Hi guys! Could you help me with the next problem: Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Query (1, 10) Parser: The syntax for ',' is incorrect. I have installed sql2005 sp2, but didn't get much Pls. help
  • Rerunning failed subscriptions
    by eksplorer
    0 Replies
    Last post by eksplorer
      • We're using RS2005 SP1. One of our users has subscribed to a report to run the 15th of each month. This past July 15 was on a Sunday and our servers were down for backing up & maintenance. Since the servers were down, the job never ran and the user did not receive the report they were expecting Is there anyway to have jobs that failed to run because a server was down automatically run w
  • SQL Server Data Migration and Synchronization
    by Ritesh581042
    8 Replies
    Last post by MohammedU
      • Hi, I need to move my database servers from one location to another. The issue is that I have over 200 databases to move and my clients can't afford a downtime. The collective volume of all the databases is over 2.5 TB and growing. I am thinking to copy these databases in batches over the WAN to the new location and replicate them using Transactional replication till I have all the d
  • Different Font size when browsing and printing a report ?
    by Aiwa
    2 Replies
    Last post by Aiwa
      • Hi all, Is it possible to setup different font size when a user is browsing or printing a report I have a lot of data to print on a report and i need tu use a font size of 7pt which is fine for printing but when the user is looking at the report on the browser a font size of 7pt is a bit too small and the bold doesn't work. Tia
  • Analysis Services - Step by Step: Errors related to feature availability and configuration
    by R Pham
    4 Replies
    Last post by rt
      • On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg: Errors related to feature availability and configuration: The 'Measure expressions' feature is not included in the 'Standard Edition' SKU. Is it because of my Standard Edition If it is, could I change the 'Measure expressions' some how to get by this msg and go on with t
  • SSIS Job Failed
    by renching
    14 Replies
    Last post by matilda16
      • I created a simple SSIS package. I build the package. I can run the package with no problem. However, when I schedule a job, the job always fail. Does anyone know what is the problem The error message of the job doesn't help at all. Here is the error message I got from job history: Date 5/19/2006 2:02:21 PM Log Job History (ssistest) Step ID 0 Server ABC Job Name ssistest Step Name
  • Creating a Mobile Application with SQL Server Compact Edition
    by salustrg
    4 Replies
    Last post by salustrg
      • Hello!! I completed that example that I pasted in the subject part and when I try to synchronize my mobile database, the data from the server appear in my pocket pc; but when i refresh the data on my pocket pc they do not show on the server. Can anyone give me a hand thanks
  • Use of a SSIS variable of type ˇ°Objectˇ± inside Script Component and Task Component
    by SabAlo
    3 Replies
    Last post by Cho Yeung - Microsoft
      • In a Data Flow, I have the necessity to use a SSIS variable of type ˇ°Objectˇ± inside Script Component and assign to it the content of 'n' variables of string type. On exiting from the script the variable of type object should contain something like in the following lines: AAAAAAAAAAAAAAAAAAAAAAAAAAAAA BBBBBBBBBBBBBBBBBBBBBBBBBBBBB CCCCCCCCCCCCCCCCCCCCCCCCCCCCC DDDDDDDDDDDDDDDDDDDDDD
  • How to debug CLR SP using Visual Studio 2005?
    by Alexey Yeltsov - MSFT TAP cust
    1 Replies
    Last post by Alexey Yeltsov - MSFT TAP cust
      • We know that automatic deplyment is currently broken. How does one debug the stored procedures in this case Thanks, Alexey
  • reporting and monitoring
    by redwood739
    2 Replies
    Last post by redwood739
      • Hey all I am new here and fairly new to SQL server. And yes i have a question, that maybe dumb. My boss wants me to reporting to him the health of the DB each week. So here are a few questions. 1. What really defines the "health" of a DB What elements should I be reporting to him 2. Is there any utilities out there that would be helpful or can SQL provide enough info 3. I am using 2005 s
  • SQL 2005 Query Analyzer
    by matthew schmitt
    4 Replies
    Last post by Arnie Rowland
      • I just installed SQL2005 Workgroup edition. How do I install Query Alayzer to go along with this
  • "Can't find PInvoke DLL 'dbnetlib.dll'."
    by hopjes
    1 Replies
    Last post by Ilya Tumanov
      • every time when I opened the connection from my windows CE4.2 device to sql server I got the error "Can't find PInvoke DLL 'dbnetlib.dll'. My OS is MS CE4.2, I've installed Compact Framework 2.0 and SQL client. It worked fine at OS CE5.0 but not at CE4.2. My application is working correctly, but when I started the connection I received this error. Any idea thanks, Jan
  • Number of reads in Profiler is not the same when running the same SP on different PCs
    by ALEXTT
    5 Replies
    Last post by ALEXTT
      • I'm running the same query on two different PCs and tracing results in Profiler on my PC. When executing the query on PC1 - the total number of reads is 200000. When executing the same query on PC2 - the toal number of reads is 13000. It is almost 15 times more reads when executing query on PC2. The executed query is same on PC1 and PC2. Any reason for this I'm trying to analyse that query
  • Problem when exporting data into Excel file from SSIS
    by Sandra2006
    3 Replies
    Last post by DouglasL
      • I have problems when exporting data into Excel file from SSIS. It all works fine with numeric columns but an apostrophe is attached at the beginning of each text cell. I tried using derived columns and data conversions but it didn't work. It seems to me that problem is in 'excel destination' task... I saw many people had this kind of problems too... Is there any solution possible Thanks.
  • adding a new data flow item calendar transformer
    by Joa666
    11 Replies
    Last post by Joa666
      • http://www.microsoft.com/downloads/details.aspx familyid=e603bde7-44bb-409a-890f-ed94a20b6710&displaylang=en#top I've downloaded this and installed it but i seems to fail to get this item into my data flow items list. i've read the readme.txt but i think the part where they explain the build is poorly explained. For example - Place gacutil.exe (packaged with Visual Studio) on the sys
  • Find and delete reversed key pairs.
    by pawel.krakowiak
    5 Replies
    Last post by pawel.krakowiak
      • Hi! I have a table with only two columns, which contain some city codes in the form of AAA, BBB. What I need to do is to find reversed key pairs in the same table and get rid of them so only one pair stays. In example, I have: AAA, BBB CCC, DDD BBB, AAA EEE, FFF FFF, EEE DDD, CCC AAA, BBB and BBB, AAA mean the same to me, so I would like to leave only one of the
  • Can I create a database schema from a DataSet and/or .xsd file?
    by hwatson
    3 Replies
    Last post by Ilya Tumanov
      • I have some questions about creating SQL Server CE databases. Based on my experiments and what I've read on these forums, it looks like there are a couple ways to create a database schema. I can edit the database schema via the Server Explorer in Visual Studio, or use an external program like SQL Server Management Studio and somehow convert those files to .sdf files. I find Visual Studio's buil
  • Can't reinstall sql server 2005 express
    by Dolin8
    11 Replies
    Last post by Dolin8
      • Hi I installed SQL server 2005 Express and it was successfully set up but I kept on getting error 26 when I try to connect to a database, so I remove all SQL programs from the control panel and reinstall SQL server 2005, but this time the set up stopped halfway saying "cannot start server". How can I successfully reinstall SQL server 2005 express
  • How to protect my parameters
    by Roy mm
    4 Replies
    Last post by Roy mm
      • Hello. I have a report with parameter called "parm1", that gets a value of "true" or "false" depanding on another parameter. When the report is runnig the parm1 value is "false". How can I protect this parameter from a change by the user I mean - the user can run the report and then add to the url "&param1 = true". Can I do anything against tha
  • Check to see if file exist on server
    by SBurden
    6 Replies
    Last post by SBurden
      • Hi Folks, I'm attempting to check to see if a file exists on our server before showing a link it. I put this function in the Report Properties: Code Block Function isFile(PathFileName As String) As Boolean Return isFile = System.IO.FileExists(PathFileName) End Function I chose a situation where I'm getting back two rows of data, one row is true
  • 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
  • Formating
    by AuliyaIkhsan
    2 Replies
    Last post by Kent Waldrop My07
      • how to format an integer in sql 2005 for ex: 1.09876 i want to format to 1.1 in access i can use : format(field,'0.0') as field1 thanks
  • sql cluster - fulltext error
    by Anonymous576168
    2 Replies
    Last post by Anonymous
      • We have a sql server 2000 active/passive cluster running on Windows Server 2003 and within the last 6 months have started getting the following errors which eventually cause the SQL Resource Group to failover. An error occurred in the configuration monitor for instance <SQL Server Fulltext>: 80070005 - Access is denied . SQL is at the latest service pack/hotfixes. (8.00.2187)
  • MSSQLServerOLAPService Stops
    by Brian312
    1 Replies
    Last post by clarkcj1
      • MSSQLServerOLAPService Service seems to crash rather sporadically during our nightly ETL with the error of: The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this de