SQL Server

Page 4232




  • Topics
    Replies
    Last post
  • How to use variables for server connections
    by Mr.Bean
    14 Replies
    Last post by Jamie Thomson
      • Hello, Today is day two of using SSIS and having some issues adjusting. In DTS I would simply populate my global variables via an Active X step or pass them in at the job line. I am having a hard time being able to do either or in SSIS. Really all I want to be able to do is pass in a server name to the Connection of an execute SQL task from a scheduled job line. Same goes for any variable
  • Troubleshooting Help
    by dgrm44
    14 Replies
    Last post by Phil Brammer
      • I need help. I have a SSIS package that connects to a ODBC database, it then does ETL from that database into a SQL 2005 database. I run the package using a Sql Agent job each night. However the package fails randomly with no apparent reason. I have setup logging and after viewing the logs I am no closer to solving the problem. Any Ideas how I can track this down Thanks.
  • Can a Result Set from SQL Script Task be used as a Source for Data Flow Task?
    by ssis_new_user
    13 Replies
    Last post by jwelch
      • I have a stored procedure that is executed via a sql script task that returns a full result set. I map this result set to a variable or object type. Is there a way to use this variable as a data source in a subsequent data flow task A.
  • "An error occurred during local report processing" for Preview
    by hipswich
    3 Replies
    Last post by hipswich
      • My report worked fine for a while, but suddenly I started getting the following errors for Preview: An error occurred during local report processing. An error has occurred during report processing. Index was outside the bounds of the array. I restarted VS, then rebooted my machine and the problem persists. Everything including the report posted to the server works fine. It i
  • Restore Database - Incorrect syntax near 'GO'
    by Bruce dBA
    7 Replies
    Last post by Arnie Rowland
      • Hello, is it something new in SQL 2005, that you cannot have a GO statement at the end of a restore database command If I run a statement like below, it fails on teh GO... Msg 102, Level 15, State 1, Line 5 Incorrect syntax near 'GO'. But if I remove the GO it works.... I coulda sworn a GO was ok to complete a batch with ANY SQL statements in it ! Am I doing something stugatz
  • Which is best way to deploy SSIS packages?
    by Saravana Kumar Natesan
    3 Replies
    Last post by jwelch
      • I have 9 Dimensions and 16 Fact Packages in my SSIS Project. All these 25 packages uses one source (SQLServer A - staging) and a seperate destination (SQlServer B - Warehouse) . I have completed my development. Now i want to move these packages to production environment. I have a Parent package to control all these facts and Dimensions. 1. Should I always change the Protection level of th
  • SUM returns incorrect value in SQL Server Mobile Query ... Bug??
    by AussieNoobie
    12 Replies
    Last post by Pragya MSFT
      • Hi all, I am a newcomer to Microsoft Database Technology and have appeared to come across an issue with the SUM function in SQL Server Mobile Edition. I am running Visual Studio 2005 and have created 2 tables: Orders and OrderLines which are set up in master detail fashion. The SQL Statement I create in the Query Builder is as follows: SELECT     Orders.Order
  • GAC issues with my C# app
    by winstonSmith
    2 Replies
    Last post by winstonSmith
      • not sure if this is an SQL issue or a development issue, but as im using c# and visual studio so il place this here for now. I wrote a small app to script out jobs from sql server. it worked fine, and then , without any changes it stopped working. I got the error: Could not load type 'Microsoft.SqlServer.Managment.Smo.AgentJobBaseCollection' from assembly 'Microsoft.SqlServer.Sm
  • SQL Server Agent Mail (SQL Server 2005 Database E-Mail)
    by actinium.ga
    1 Replies
    Last post by actinium.ga
      • Hello, I'm working with SQL Server 2005 (9.0.3152.00) and have activated the database e-mail feature. I have also created a profile and assigned two accounts. Sending a testmail via Management -> Database Mail -> Send Test E-Mail... has been successful (and the mail has arrived at the receipients). In the properties of SQL Server Agent I have activated the mail system "Database E-Mail&
  • SSMSE not Working on Vista (Even as Admin w Latest Patches and Updates)
    by Karl D
    14 Replies
    Last post by Karl D
      • I am trying to get SQL Server Managment Studio Express running on Vista Business. I've read many of the posts from a while back explaining how it needs to be run in admin mode, etc. I've also seen that SP2 for SQL server and Visual Studio 2005 Service Pack 1 Update for Windows Vista are supposed to address compatibility issues with the Vista OS. Windows update kindly installed both of these for me
  • Efficiency of a 'SELECT TOP' style GROUP BY query: FREETEXT vs. FREETEXTTABLE
    by Holf
    2 Replies
    Last post by Holf
      • Hi, Please have a look at the following two queries, the purpose of which is to find which ten users (represented by 'Username') have created the most records which contain the term 'foo': SELECT TOP 10 Username , COUNT (*) AS [Count] FROM Options WHERE FREETEXT (*, 'foo' ) GROUP BY Username ORDER BY [Count] DESC SELECT TOP 10 Username ,
  • Can't connect to MSDE
    by zhaounknown
    8 Replies
    Last post by DevOrDie
      • I have a server with SQL Server installed first, and MSDE installed later. Both are set to Mixed mode. The operating system of the server is Windows XP Sp2. I opened the port for SQL Server 1433, and MSDE port 1503(get from registry) in the Windows Firewall, and enable DISABLENETWORKPROTOCOLS=0 for MSDE. I can connect to SQL Server and MSDE in the local server, and can connect to th
  • sql query?
    by Mark223344
    6 Replies
    Last post by DaleJ
      • Hello, I have the following query; SELECT DateTime, TagName, Value FROM v_DiscreteHistory WHERE (DateTime = CONVERT(DATETIME, '2007-09-01 00:00:00', 102) AND DateTime <= CONVERT(DATETIME, '2007-10-01 00:00:00', 102)) AND (TagName LIKE N'PS006.Phase_Sequence') AND (wwRetrievalMode = N'delta') AND (Value IS NOT NULL) which produces the following;
  • Visual SourceSafe 6.0 and BIDS
    by DanUp
    1 Replies
    Last post by Edward Melomed
      • Does anybody know whether any good documentation exists (and where is it ) about the limits of, and more importantly, the how-to about, protecting AS 2005 Dev builds -- using Visual SourceSafe 6.0 -- in a multi-developer environment
  • 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
  • How to Connect to remote sql express from client comp/app??
    by MD5
    2 Replies
    Last post by MD5
      • Hi, I think this is a taff problem for me when I connect to remote sql express from .net application I use Connection String: Data Source=MYREMOTESVR\SQLEXPRESS;Initial Catalog=microDB;Integrated Security=SSPI;Persist Security Info=True;User ID=micro;Password=micro OR Data Source=MYREMOTESVR\SQLEXPRESS;Initial Catalog=microdb;Integrated Security=True;Persist Security
  • Data Conversion Numeric to date
    by Blackuke
    13 Replies
    Last post by Blackuke
      • I have some data which I am trying to put into a DM where I can use it as part of a cube (my first!!) I have hit a small problem with dates, I get it from the ERP system as a numeric field, and I need to convert it to a date format. The intension is to use this converted data with Named Calculations to derive Year, month Day ect. However I cannot seem to be able to convert and store (in SQL)
  • How can i get the 2nd, 3rd or N'th row from a table?
    by phokaia
    2 Replies
    Last post by Hunt Tsai
      • This would be a TOP Clause question. if we use TOP clause for example; SELECT Top (4) Col_A, Col_B FROM Table_A ORDER BY Col_A This query gets the first 4 rows according to the order of Col_A. How can i get only the second or the third row from this table Thanks for your helps...
  • Problem starting sql express
    by mrholtsr
    4 Replies
    Last post by mrholtsr
      • I am having trouble starting sql express. When it downloaded it automatically set the start mode to network service. I am not working from a network so I changed it to local service. Then it refused to start. I tryed system service and still it would not start. So I returned it to network service and now even that will not start. Can someong tell me how I can start sql. Thanks, Ray
  • For each loop and error handling
    by safddddddddddddddddddddd
    0 Replies
    Last post by safddddddddddddddddddddd
      • I have a "For each ADO Enumerator" that process row by row transaction in "For each container". I would like to create a process that rollbacks the transaction if there is an error and move the row to the error log and process the next row without stopping the process.. Is there somthing that I can configure in the "For Each loop " container How can I do this in F
  • Odd ADO connection string problem
    by DFrey1969
    8 Replies
    Last post by Il-Sung Lee - MSFT
      • I just elected recently to tinker with ASP (not ASP.NET) since I just upgraded my Windows XP Home machine with Vista Business that I received gratis from Microsoft for participating in some microsoft webcasts. Prior to upgrading to Vista I had already had Visual Studio 2005 Standard and SQL Server 2005 Express installed. Now I've installed IIS from the Vista DVD and configured it for ASP support.
  • Can't figure out how to get the right results
    by gc1848
    2 Replies
    Last post by Manivannan.D.Sekaran
      • I have some basic tables (i'll include just a couple relevant fields): Customers (customer_id, lastname) Addresses (address_id, city, state, createddate) CustomerAddresses (customeraddresses_id, customer_id, address_id) I want my resultset to contain each customer and their most recent address information. Didn't think this would be too tough but I can't get it right.
  • SQL Server Query performance issue
    by Visio User
    10 Replies
    Last post by DaleJ
      • I got two tables....looking for fastest query to get result without entire table scan. I got tons of records more than 100K in first table...more than 50K in second table. People Table pid name state 10 sam ny 21 amy nj 32 pete wy 23 lilly ca 90 jessi va City Table cid pid city 1 21 edison 2 32 me
  • Help with Calculated member
    by MichaelDugas
    3 Replies
    Last post by Bryan C. Smith
      • I'm trying to create a calculate member in SQL Server 2005 that will return a distinct count of clients year to date for all dates within my time dimension. I have figured out that if I create a measure that returns a distinct count then I can use the aggregate function and YTD function to get the distinct count YTD for any date. However, the aggregate function requires a slicer dimension (i think
  • what permission do I need to grant ?
    by sqldba2007
    10 Replies
    Last post by sqldba2007
      • hello, what permission do I need to grant to a user to let him to read a table in a linked server object Thanks