Answer Questions

• Godhascometoearth TSQL Strored Procedure

  I am having an issue when trying to pull data from Oracle into a sqlSERVER TABLE. I'm running into an issue because I am using to much temporary space in Oracle because the return set is so large. New to sqlserver, but in Oracle the solution would be to commmit the insert after so many records have been retrieved. Here's the procedure I wrote I would think I need to add a cursor and a counter which be used to do a commit after so many row ...Show All

• gcryall SQL Server 2000 -- Taking over my memory

  I am running SQL Server 2000 on a desktop PC. Just recently upgraded my PC to 2gig of ram from 1 gig, in part, to try and fix the problem below. Didn't work. Have SP3 installed but not SP4 at this point. When I open up query analyzer and edit some code, regardless of whether I actually execute the code, SQL server eventually sucks up available and cached memory to the point that my system comes to an effective halt --takes forever to do a ...Show All

• Adrien Barr Importing Tables with Identity properties (uisng Import wizard)

  I am using the Import wizard to import a SQL2000 database to SQL2005 and noticed 2 problems: 1. all tables and views were selected; the tables were imported correctly but the views were created as tables, ignoring the "Create view" syntax. The SQL generated contains "Create table" syntax instead of "Create View". 2. when a table contained a column with an "identity" property, the data was successfull ...Show All

• happer SQL 2005 left join not working via OLEDB

  Hi After chasing around a problem I have closed it down to just the following - I have two simple tables in my database linkme linkme2 both of which have one column called [catalog-no] I have put one record in linkme select * from linkme -- pulls back one record correctly via .asp page and management studio select * from linkme left join linkme2 on linkme.[catalog-no] = linkme2.[catalog-no] -- pulls back one record in management studio and ...Show All

• HarrySimpson How do you connect to SQL 2005 Express database on Network Share

  Hello, Ho do I allow multiple users to share a database Background I have developed a Windows App in VS.NET 2005 which connects to a SQL 2005 Express database. Now I want to install the app and database on the network and I am getting an error "File 'file_name' is on a network device not supported for database files" What is the best way to get this working Thanks in advance, Phil ...Show All

• SimDim Import variable fixed length file

  I have a requirement to import a file of rows containing fixed length data. The problem is that each row can be one of 5 different formats (i.e. different columns) -- where the "type" of row is indicated by the first two characters of the row. Each row gets inserted into its own table. Could I use a simple Conditional Split to route the rows Or is the split for routing similiar rows Anyways, problems are never this simple... In a ...Show All

• ArvidG Help regarding passing parameters in SQL and Lookup

  Hi, 1) I am using exceute SQL tasks in my control flow. 3 variables have been defined at the package level.They are mapped to 3 parameters respectively in the Execute SQL task. When I try using these parameters in SQL error is thrown.Query is not getting parsed.My connection is OLEDB. Target and source are in SQL Server. Can anyone suggest a workaround 2) Before loading my target I need to define a Lookup . My requirement is if say c ...Show All

• Dinesh BCG Returning objects from CLR Stored Procedure

  Hello All I have a few questions about how to return a DataSet object from a CLR Stored Procedure as an output parameter: Can this be done  I am having problems at execution time with declaring an output parameter of the type "DataSet". "Cannot find type DataSet" message, compiler/build does not complain, error occurs at execution time. This seems like one of the most obvious ways to create a more object-oriented approach using the tec ...Show All

• pugs Flat file - row delimiter problem

  Hi, I'm trying to design this package where i take data from a source and need to transform it into a flatfile with some extra static information. I use a SQL script like this (ex.): SELECT ' BS0220131264202400000130001' + cast ( wa . perf_applicant_number as nvarchar )+ '000000000' + wa . perf_firstname + ' ' + wa . perf_lastname + CHAR ( 13 )+ 'BS0220131264202400000330001' + REPLICATE ( '0' ,( 15 - LEN ( wa ...Show All

• Bow50 Unabel to connect to SQL 2005 Analysis Services in SQL Management Studio

  I just installed visual studio 2005 and SQL sever 2005 standard edition. I experimented a bit, and I got the following messag when I want to connect to Analysis services in SQL Sever 2005 Management studio. When I click the connect button, I got the following message: " A connection cannot be made. Ensure that the server is running (Microsoft.AnalysisServices.AdomnClient). No connection could be made because the target ...Show All

• Stephen Toub - MSFT problem with sqlserver 2005 express

  I am using VS2005 with sql server 2005 express. I have database with atached datafile. when I am using Select command from created table, there is not case sensitive in the result. I mean I have in the table the row with value "Disp1" in col1, and when I am selecting with filter Where col1="disp1" , I amd getting this one row where value is "Disp1". I saw in server explorer window, that connection have parameter Case Sensitive, which value is Fa ...Show All

• djdekker SSI and other components don't install

  Hi I have installed SQL Server 2005 but Integration Services is just not there. I have uninstalled and reinstalled several times and in the process uninstalled an old version of Visual Studio.NET (manually because it wouldn't uninstall automatically) and Visual Web Developer, just in case they were interfering with Integration Services. No luck, in fact it got worse, now Analysis Services also does not work because it can't find devenv.exe! ...Show All

• 44332211 Problem with Report Pack for sharepoint's, rpdataextraction parser

  hi, when i try to execute the rpdataextraction parser, i am getting the following message - Unable to access site collection: User cannot be found. it will be of immense help for me if any one helps me on this or directs me to right resource. thanks hello, I have the same problem, so yesterday I found a possible solution for this problem, I'm trying to follow it: There are a french blog for ...Show All

• willis Internal Activation Best Practices?

  I am looking for an example of a SP that shows the best practices for internal activation In BOL this topic describes the typical patter for reading messages from a queue. What is the typical pattern for reading messages from a queue using an internally activated SP Do we still need to loop (considering the message arrival actually fired the sp) Any advice provided would be helpful. Thanks! I has b ...Show All

• DenemeTR Populate field with NT Login

  I need to know who is entering data in my SQL database. I use Access Project as a front end and would like to know if it is possible to have an 'ID' field auto-populate with a user NT Login. For example, if user checks a check-box or enters data in field, I would like an ID field next to the checkbox or data field to populate with his user ID. Any assistance is much appreciated! Thanks. Hi, Sytem_use ...Show All