SQL Server

Page 2966




  • Topics
    Replies
    Last post
  • DTS old style and Dynamic Properties Tasks
    by Jezza101
    4 Replies
    Last post by Jezza101
      • Im using embedded SS2000 DTS packages in SSIS. These legacy packages use Dynamic Properties Tasks to pick up connection settings from a named ini file. The name of that ini file needs to change occasionally. To date the only way we have of doing this is resetting all the dynamic properties to point at the new ini file. Unfortuntely there are a lot of connections and properties and there is no budg
  • Help plz - need query to get the following kind of output
    by Hari prasad 101405
    4 Replies
    Last post by Hari prasad 101405
      • i want result to be in the required format given below: here is the result column A ---------------- 5 7 10 14 22 30 .... i want output to be in this form with a single sql statement: column A column B ---------------- ---------------- 5 2(difference b/n the current record and the next record) 7 3 10
  • RAISERROR does not cause SQL task to fail - why?
    by BlackCatBone
    7 Replies
    Last post by Matt Masson - MSFT
      • Greetings, I have a stored procedure with a TRY / CATCH block. In the catch block I capture information about the error. I then use RAISERROR to "rethrow" the exception so that it will be available to SSIS. I execute the stored procedure through a SQL task. I observe that SSIS reports the SQL task succeeds (the task box turns green) when RAISERROR is invoked. If I comment
  • Moving Average using Select Statement or Cursor based?
    by djun_kang
    14 Replies
    Last post by Kent Waldrop Jl07
      • ID DATE(dd/mm/yy) TYPE QTYIN COST_IN_AMT COST_OUT_AMT(MOVING AVERAGE) 1 01/01/2007 PURCHASE 10 1000 2 01/01/2007 PURCHAES 5 1100 3 01/01/2007 SALES -5 *TobeCalculated 4 02/01/2007 Purchase 20 9000 5 02/01/2007 SALES -10 *TobeCalculated 5 02/01/2007 purchase 50
  • Grouping
    by mahima
    1 Replies
    Last post by mahima
      • Hi, I have a stored procedure which is returning results in the following format: No.of substances Count 1 29 2 89 3 876 .. .. 15 56 16 89 Now i need to display like this: No.of substances Count % 1 20 2 89 ..
  • Problem with "phantom rows"
    by sadie519590
    14 Replies
    Last post by sadie
      • Hi, I am seeing something strange. I have a data file that has 6 rows that looks like: ABC, "OPENING BALANCE", 1234, etc ABC, "CLOSING BALANCE", 1235, etc ABC, garbage data, etc XYZ, "OPENING BALANCE", 1234, etc XYZ, "CLOSING BALANCE", 1235, etc [][] -- weird box things that shows up in my flat file conn mgr I have a scrip
  • SQL Express Help Files
    by fb301
    1 Replies
    Last post by Euan Garden
      • Where do I find the Help files for SQL Express. When I click on help it says, help is not available.
  • Design question - Foreign key indexes
    by John Hennesey
    3 Replies
    Last post by JohnHennesey
      • A rather elementary design question - is it a good idea to index foreign keys in fact tables I understand this will slow down inserts/deletes/updates, but when the cube is processing will it speed up processing time Does the cube generate all dimension members then query fact tables for them Does it query fact tables with group by's on participating dimensions I see example cubes that have thi
  • ADO Error: an insufficient number of arguments....
    by EssCee
    10 Replies
    Last post by EssCee
      • Im currently using Access 2000 which is connected to a SQL database. I have a query (Or View) that runs every month. The problem i had was i had to manually make some changes every month to get to the data i needed so i changed this View into a Function with a parameter so i can input the detail(s) i need and it will run correctly - this works so far but the original View was also used within othe
  • Replication looking for errant sysserver links
    by El Rap
    4 Replies
    Last post by El Rap
      • We have replication successfully running but when I tried to set up a new test instance on completely different servers (Server A to Server B, say) the push agent to create the susbcription on Server B complains 'Could not find server 'Server C' in sysservers. Execute sp_addlinkedserver. . . .' Server C was never configured as a subscriber for the publication in the first place. What
  • When to reindex?
    by Bobo1234
    2 Replies
    Last post by pdxJaxon
      • We have a fairly large database (320 tables, 70GB+) on SQL 2000 where reindexing using 'dbcc dbreindex' currently takes almost 3 hours. We are reindexing all tables and dbreindex takes up 80-90% of the system cpu making any other job slow. All indexes are setup with a fill factor of 70%. As the database grows we would like to minimize the time spend on reindexing. One approach could be to use t
  • Calling CLR stored procedure from within a CLR table-valued function giving errors
    by kajester
    2 Replies
    Last post by Sergei Almazov
      • We are trying to create a TVF that executes a CLR Stored Procedure we wrote to use the results from the SP and transform them for the purposes of returning to the user as a table. Code Snippet [ SqlFunction ( FillRowMethodName = "FillRow" , TableDefinition = "CustomerID nvarchar(MAX)" , SystemDataAccess = SystemDataAccessKind .Read, DataAccess =
  • Scheduling an automatic backup
    by thaenu
    14 Replies
    Last post by thaenu
      • Hi , I am using Microsoft SQL Server Management Studio Express 9.00.3042.00. I want to take the database backup daily at specific timing for instance, 8:00am daily. How can I take it automatically It should be take the backup on daily basis without my interference. with programatically Can anyone help me i neeed answer with clear example or screen shots. Thanks in advance
  • Emailing Report
    by shah_hs
    4 Replies
    Last post by jwelch
      • I need to export a view into excel and mail to my manager daily morning. Is there a way i can automate this process. I know how to convert view to excel but i need a better solution to automate this process with emailing to my mgr. Please suggest a better approach of doing this. Thanks,
  • Documents in VLDB
    by Ike Ross
    11 Replies
    Last post by ggciubuc
      • Hello All, I have been experimenting with SQL Server 2005 partitions. I loaded a terabyte of information into 2 tables. The first holds the document information and the second holds the actual binary document (in this case pdf). Most of the documents are about 1 megabyte in size, but the largest is 212 megabytes. SQL Server has no problem storing the blobs. The problem oc
  • Scheduled Backup suddenly started giving errors
    by Anand Anjaria
    3 Replies
    Last post by Vidhya Sagar
      • Hi, I have scheduled full backup daily at morning 6:00. It was running fine till yesterday. Suddenly today morning it failed giving following error.... I have executed maintenance plan manually and again it gave same error.... 10/19/2007 11:03:10,FullDBBackup.Subplan_1,Error,1,*****,FullDBBackup.Subplan_1,Subplan_1,,Executed as user: ****\SYSTEM. ...9.00.3042.00 for 32-bit Copy
  • OLEDB Access PB
    by plab
    2 Replies
    Last post by Subhash
      • Hi I definite a source OLEDB MS Access and my fields of the type ˇ°Textˇ± are seen in type of field DT_WSTR (Unicode) instead of DT_STR. I do not include/understand why and like then, I must integrate them in fields varchar and not nVarchar, I do not find the solution thank for your solution
  • Maximum number of users (licensing)
    by ooDavid
    1 Replies
    Last post by Arnie Rowland
      • I need a small SQL server for up to 10 users. If I understand the EULAs and FAQs correctly, there is no limit on the number of users imposed by the SQL Server 2005 Express license. If so, then the number of users is only limited by the OS's license so all I need is SQL Server 2005 Express (free), Windows XP Pro (10 users limit) and no CALs for either Windows or SQL Server. I'd be thankful if someo
  • Scheduling sqlcmd script in sql agent
    by mdewaard
    3 Replies
    Last post by Arnie Rowland
      • Is it possible to schedule a sqlcmd script within sqlagent That is without running a cmdexec Thanks,
  • measure group not showing any data inspite the facttable having data
    by techie234
    2 Replies
    Last post by techie234
      • Hi, I could successfuly deploy and process the cube. But when I go to the 'Browse' tab of the cube and drag and drop a few dimensions and measures I don't see any data. I even used simple MDX queries and even that returns 'NULL' facts. I have set the 'unknown' member as visible in the time dimension because some of the dates in the fact tables are null. Any thoughts on this would be greatly
  • How do i change collation?
    by SteveS
    9 Replies
    Last post by Caddre
      • I created a new server registration under my SQL Server Group. After creating the registration via EM, I looked under properties and the collation is SQL_Latin1_General_CP437_CI_AS. It needs to be Latin1_General_BIN because this is the collation order in the production server. Please bear in mind that I am not a DBA and this is all new to me, but unfortunately I'm the one who has to fix this. Plea
  • connecting to sql server from mobile device
    by kamisama
    11 Replies
    Last post by Anonymous
      • How can I connect to sql server from a mobile device the server is on pc and my app is on the device. I want to perform commands and stored procedures which will be performed online on the pc and get immediate results. is there any way of achiving that
  • Scheduling report delivery for the first WORKING day in the month?
    by Martin Smith
    1 Replies
    Last post by David Leibowitz
      • Has anyone figured out a good way of doing this The only suggestions I have seen along these lines involve scheduling the job every day and then manually editing the SQL Agent job that is created. However the problem with this is that it completely removes the ability for non programmers to set the schedule themselves using the web interface. Any ideas
  • Pivot Table Bug with AdventureWorks
    by David Beavonn
    4 Replies
    Last post by David Beavonn
      • A user pointed out an odd bug / inconsistency that occurs when using Excel pivot tables. Depending on how attributes are related to each other, Excel does some odd things when cross joining attributes from the same dimension on an axis. Example 1. "Correct" cross join of attributes: Connect to AdventureWorks from Excel pivot table. Drop in "Internet Sales Amount".
  • Pivot Select
    by Lunarpc2
    5 Replies
    Last post by Arnie Rowland
      • Hi, I'm able to get Pivot to work but I'm having trouble limiting the record set. I want it to select only records from this FiscalYear. I have a table with a field called CurrentBudgetYear that I use as a control. So FiscalYear should equal CurrentBudgetYear but my results include all FiscalYears. SELECT ProjNo, TaskCode, [1] AS P1, [2] AS P2, [3] AS P3, [4] AS P4, [5] AS P5, AS P6, [7] AS P7