SQL Server

Page 4386




  • Topics
    Replies
    Last post
  • Server Upgrade
    by Lan
    1 Replies
    Last post by Arnie Rowland
      • We currently have a stand alone production server SQL 2005 STD + SP2 and plan to upgrade to clustered SQL 2005 Ent + SP2. What's the proper way to upgrade I want the existing server instance use Ent engine.
  • Date Picker in US Format after SP2
    by mharris
    4 Replies
    Last post by --dn--
      • Updated SQL 2005 to SP2 and Reporting Services Date Picker now has dates defaulting to US format (MM/DD/YYYY) instead of our previous English-Australian (DD/MM/YYYY). Both the clients and server are set to English Australian regional settings in the O/S and the reports are composed for English Australian language. Reports have correct format in Visual Studio development and re-deploying them had n
  • Flat File and uneven number of columns
    by CSIROSwan
    14 Replies
    Last post by gnieboer
      • Please leave feedback for Microsoft regarding this problem at https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=126493 Ok I'm sure it just me, SSIS has been great so far....but how can you import a straight CSV file with and uneven column count. For example: (assume CR LF row delimiter) The,Quick,Brown,Fox,Jumps Hello,World This,is,a,test "Normally&
  • Multiple Rows into One
    by Bill1234
    5 Replies
    Last post by Bill1234
      • ISBN Parent_ISBN Title FMonth Forecast SQL TABLE 043967XXXX 043967XXXX MY BOOK 200705 13.25 043967XXXX 043967XXXX MY BOOK 200706 88 043967XXXX 043967XXXX MY BOOK 200707 53
  • passing multiple values from parent to child package
    by Kevin Rodgers
    2 Replies
    Last post by Jamie Thomson
      • Starting with "How to: Use Values of Parent Variables in Child Packages" in the SQL Server 2005 Books Online ( http://msdn2.microsoft.com/en-us/library/ms345179.aspx ), it seems I need to create a separate package configuration in the child package (of type parent package variable) for each variable I want to pass from the parent to the child. Is that really so The XML configuration fil
  • How WCF can get new inserted SQL data ?
    by Serge Calderara
    8 Replies
    Last post by Remus Rusanu
      • dear all, I have a WCF service which is host in a console application for the time beeing. This service provide methods for retriving history data when request. So far so good. My WCF service need also to know when a particular table (ALARMS tabel ) gets updated with DELETE, INSERT, OR UPDATE. This because my client application (WinForm) need to refresh a datagrid binding to that A
  • Table Identity after updated
    by hoho
    9 Replies
    Last post by Kent Waldrop Oc07
      • Hello all, I fixed a after update trigger with sql server 2005 and I need to return the last identity updated in the table to insert it into another table. How can i get the last Identity updated in a table Please help .. Sms
  • Is there a way to show a user-friendly error when user did not select a required parameter ?
    by Btong
    4 Replies
    Last post by Btong
      • Hi all, I was wondering whether there is a way to show the user an error when the user did not select a specific parameter. In my case, I have two optional parameters. The user has to select either one to view the report. If the user does not select either one, I would like to show some sort of an error page indicating so. However, all i am getting is a complete blank with no report
  • missing value
    by vgvKarthik
    1 Replies
    Last post by Jamie MacLennan
      • hi, I am using time series algorithm.and my prediction query is like this SELECT PredictTimeSeries([Performance]) FROM [Stud_Model] The output is like this Date Perf 9/11/2006 90 10/11/2006 92 11/11/2006 93 12/11/2006 -- (no prediction) 1/11/2007 --(no prediction) I dnt know why there is no prediction after certail date Than
  • Splitting a comma delimited string
    by Krishna.S
    3 Replies
    Last post by Krishna.S
      • I have a string like say: '3:4:5:4,2:4:1,4:1:2:5:2'. Now I need to split the substrings delimited by commas. So my final output shall be 3:4:5:4 2:4:1 4:1:2:5:2 I did write a piece of code to achieve the same, but I feel its not so efficient. Can anyone suggest me a better way, if any My code is as follows: Declare @person as varchar(255), @cnt smallint,@loc smallint,@prevloc smallint, @str varc
  • Change reports language
    by laloivol
    9 Replies
    Last post by BobP - BIM
      • I'm using the ReportViewer to display reports in ASP.NET pages. The reports include dates that must be shown in its long format, but in spanish. Now, everything I'm working with is in english: my workstation and server OS, SQL Server 2005 and client browsers (I'm testing with IE and Firefox). I'm using FormatDateTime() to show dates, and I tried to change the UI culture to es-MX in web.config with
  • Stored Procedures and C++
    by Mojosound
    1 Replies
    Last post by Mike Wachal - MSFT
      • I am using Visual Studio 2003 (C++) and have inherited a data acquisition app. The existing app has CAdoDatabase and CAdoRecordset classes, but they do not seem to be complete. The throughput is pretty high and we switched from using recordsets for adding new data to using SQL insert queries. These are better, but still not fast enough. Some of our installs are for SQL Server 2000 and some are for
  • Database Snapshots Performance
    by Tremannike
    3 Replies
    Last post by Kevin Farlee
      • Hi, I'm developing a Data Mart and i'm experiencing a performance gap between my fact table and its snapshot. I create snapshot with the istruction: CREATE DATABASE DB_SNAP ON ( NAME = DB_SNAP_Data , FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ DB_SNAP_Data .ss' ) AS SNAPSHOT OF DB ; And it works. But executing queries on the snapshot result very "low".
  • database mail problem...Query execution failed: Error initializing COM
    by randyvol
    2 Replies
    Last post by Faeed
      • Hello - I'm having a problem sending the query set as an email text attachment. Test transmissions from Database mail working fine. Send simple messages with the sp_send_dbmail sproc works fine as well. It is only when I try and send a query result that things blow up. The query itself is working fine also, so I'm now down to think there is some esoteric problem with the sproc its
  • Bulk Insert -- Access denied issues
    by Vivek Uppal
    14 Replies
    Last post by Umachandar Jayachandran - MS
      • Problem: Insert a network file in the DB using BULK Insert Works for a local sqlcmd connection. Does not work for a remote sqlcmd connection. SQL Server is running on Machine 'WalRepTest'. User account for SQL Server Service: 'Domain\vivek_uppal'. This has admin privilieges on SQL Server machine and the machine hosting the file. I have 2 scenarios. Scenario 1 behaves as expected, Scenario 2
  • CTE in OLE DB Command Data Flow Transformation
    by Kyle Key
    6 Replies
    Last post by Jamie Thomson
      • I am trying to use a CTE in an OLE DB Command data flow transformation object. However, when I enter the cte and corresponding query in the SqlCommand field of the OLE DB command editor dialog, I get a syntax error. Can CTE's be used data flow objects I have been able to use them in an Execute SQL Control Flow Item, but not in any data flow item.
  • Can we create distinct values for document map on a particular level?
    by Helen999888
    2 Replies
    Last post by Helen999888
      • Hi, all experts here, Thank you very much for your kind attention. I am having a question about document map on SQL Server 2005 Reporting Services. I found one problem with the values retrived for the document level. That is, the values are not distinct, they are duplicate for the document level. Is it possible for us to get the distinct values for a particular document level Hope my questio
  • EXtract data from 10 identical oracle database into one
    by SAMINShanghai
    2 Replies
    Last post by jwelch
      • Please guide me urgently how to extract data in SSIS from 10 identical oracle database into 1 sql server database. There is a table which list all the 10 databases.
  • Slowly Changing Dimension Wizard
    by jrp210
    1 Replies
    Last post by jwelch
      • I have a Company Dimension table that consists of various sources. One source will provide me address information, another source will provide industry info, etc. I created a historical load package that will pull all of this together so that I have all the necessary data related to a company in one record. All is well. Since my company data is coming from various sources, how can I tell
  • When will come next CTP?
    by James Lim
    7 Replies
    Last post by David Beavonn
      • I really want to test "Block computation" feature because I have performance issues... Could anyone of MS tell it to me James
  • Microsoft SQL Server 2005 Driver for PHP CTP
    by Elisa Flasko - MSFT
    1 Replies
    Last post by bholub
      • The Microsoft SQL Server Driver for PHP Team is proud to announce the availability of the Microsoft SQL Server 2005 Driver for PHP CTP. This driver is a PHP 5 extension that allows the reading and writing of SQL Server data from within PHP scripts. The extension provides a procedural interface for accessing data in all editions (including Express editions) of SQL Server 2005 and SQL Server 2000. T
  • conversion error
    by sadie519590
    10 Replies
    Last post by sadie
      • Hi, can anyone please shed some light on this error: [OLE DB Destination [466]] Error: There was an error with input column "Price" (518) on input "OLE DB Destination Input" (479). The column status returned was: "Conversion failed because the data value overflowed the specified type.". The column "price" is a numeric (9) In the flat fil
  • msmdsrv.exe is taking 99% cpu
    by tee_user5
    14 Replies
    Last post by montechristo
      • I've tried rebooting the server, restarting services, etc, but that only seems to help for about 5-10mins. When the cpu usage was that high, I profiled the cube for a 3 minute period and no queries were being performed.   Is there a way to narrow down what (and why) might be causing that process to hog so much CPU time and making the whole server slow
  • Reply to 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,
  • Table and View permissions
    by Walker817
    13 Replies
    Last post by Raul Garcia - MS
      • I have a list of users that I want to restrict access to tables in a database. The goal is to allow the users to use select statements on the views instead of the tables. How can this be accomplished