Answer Questions

• TheViewMaster How can I deploy my my sql database files of my website

  Hi all, How can I deploy my website sql database files, which I have done using Visual web developer. (Visual Studio .net 2005) Connection srting all these are different in this VWD. < connectionStrings > < add name = " GoalConnectionString1 " connectionString = " Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True " providerName = " System.Data.SqlClient " /> </ connectionStrings > Deployment to a web site tends to be specific to the Hoster you are using. Generally, you need to consider the following: On the web site, don't use User Instances, that is a SQL E ...Show All

• Sebastien A SQL 2005 bug? not follow the order by sequence in view...but SQL 2000 does!

  I have a table: CREATE TABLE [dbo].[tx1]( [f1] [nvarchar](50) , [seq] [int] IDENTITY(1000,1) NOT NULL ) ON [PRIMARY] SELECT * FROM dbo.tx1 ORDER BY seq DESC go f1 seq zz 1003 uu 1002 kk 1001 yy 1000 create view vx1 as SELECT top 100 percent * FROM dbo.tx1 ORDER BY seq DESC go select * from vx1 yy 1000 kk 1001 uu 1002 zz 1003 The problem is one of misunderstanding. A view is a table, and a table is an unordered set. The sort by is used to resolve the top clause only. SQL Server returns rows in whatever order is best for it. If require rows ordered in the output the only way to do this is with an ORDER BY clause on the final SQL Statement. A few other threads ...Show All

• barkingdog Object Explorer fails to connect

  Hi First up - my apologies if this is not the right forum for this question. Please let me know if there is a more appropriate one for this question. I have come across an issue with my SQL Server 2005 Express Edition install. It has been running fine since the install (a few months back). And I can still interact (query, update etc) the databases just fine. However, SQL Management Server Studio Express has started to produce an error message when I attempt to connect the Object Explorer. The error message is shown below. I have tried to access the link shown in the error message but there is no information provided there. I can use SQL Management Server Studio Express to run queries on the databases so it would appear that ...Show All

• Samer Selo experience a hard time to connect to the database my dbase is sql express ed 2005

  hi to all , well i succesfully installed SQL server 2005 express edition in windows 2000 however when i am trying to connect my program thru ODBC im having a difficulty to connect. but based on my observation if i am not connected to the internet i cannot connect to my database but if i am connected to the internet i could access the SQL server 2005 express edition.i have read the hardware requirements for SQL server 2005 express edition i have upgraded the IE5 into IE6 SP1,windows 2000 SP4, even my memory to 1GB.but still i have the problem. my question is, do i have to maintain my connection to the internet for me to have a smooth SQL connection BTW, i badly need the answer.Bigthanks! -gae- Have a look at my screencas ...Show All

• Sergey Jmacov Data Conversion

  Hello, What will the Dataconversion do if I try to convert a source field to a datetime but the data is not a valid date Can I just skip the one field Thanks, Michael Hi Michael, Most likely, you will get a conversion error. If you open the UI for the data conversion, and hit the "Configure Error Output" button, you can set the error handling behaviour on a column-by-column basis. If you just want to skip that field, you could set the error behaviour for that column to "Ignore Failure". That column will be set to NULL. Let me know if you have further questions about this. Thanks Mark ...Show All

• joeydj is it possible to pass array to stored procedure

  Dear All, I am using sql2000, I want to know whether in stored procedure we can pass array. Or is there any other solution to pass array of records Please Guide Me thanks No... it is not posible to pass arryas to sp. BTW what is u r requirement , there are workaround for everything.. so pse specify u r requirement.. Madhu Moving SQL Server forum. Thanks. ...Show All

• Kim Ohrns Disappearing Precedence Constraints

  Has anyone seen precedence constraints disappear in a package after closing and opening again In this case, it's not package-wide. Only constraints inside one Foreach Loop container disappeared. Any idea what causes this to happen p.s: Yes, I did Save All. Most of these contraints were saved in the package for more than a week anyway. I have not seen that. Is your package under any source control software is that the case compare it against previous versions. A similar issue has been reported for many of us; but the problem was inside the Dataflow (when using VSS as source control)though.... Jamie, those guys must not realize how much progress these products have made in terms of ...Show All

• Rod454654 Why SELECT AVG(column) From Table is not working in Jet database?

  Hello, XPSP2 VB 2005 Express Jet/Access database One of the Forms of these application display a Jet database table. Why querries Min, Max, Avg do not work Thanks, Thanks for the promt answer. Impressive. Olympian heights. Public Class Form3 Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.Table1TableAdapter.Fill(Me.NewMDBDataSet.Table1) SumColumns(Me.NewMDBDataSet.Table1) End Sub Private Sub SumColumns(ByVal Table As DataTable) Dim HCMin As Single = 0.0 For Each r As DataRow In Table.Rows If Not TypeOf r(12) Is DBNull Then HCSum += r(12) 'MIN If (HCMin > r(12)) Then HCMin = r(12) ...Show All

• DQM How to detect Backward Compatibility pack if it's already installed using C#?

  We have our custom install code using C# for a huge Client desktop application. We package SQL Express 2005 along with Backward Compatibility pack as this application was using MSDE before and at 11th hour management decided to pack SQL Express and backward compatibility pack. During installation we want to detect if the Backward compatibility pack is already installed to avoid overwrite. Can anyone suggest how to detect if Backward compatibility pack is already installed using C# I am sure there should be some registery keys to look for but don't know which. Thanks. Look up the SERVERPROPERTY() topc in Books Online - You'll probably find it in one of the values it returns. ...Show All

• mamatham Dynamic Textbox height?

  Hi, I often have a 'label' text box next to a 'data' textbox. If the data textbox expands how can I get the label to match it in height . I tried to set the height of one to the height of the other but got errors. Thanks, Thanks Jens, But at present this needs to stay free form. Dear, U can do it by using functioin.Your testbox and label size will be same. U can try this ="hello" & space(len(Parameters!SaleOrderNo.Value)) & "." In passed these parameter with in a lable(textbox). Parameters!SaleOrderNo.Value in a textbox. Hope this helps u. from sufian Dear failfield, I read ur question. ...Show All

• Bernd Wechner ssis help

  Hi, I am preparing for an interview it'll be very much help if any body could send me some preparation notes on SSIS. and also I want to know what type questions I can expect from an interviewer on SSIS. Thanks and regards. This thread has some inputs in 'what to ask' during a interview...with some luck your prospective employer will use them http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=964033&SiteID=1 ...Show All

• TheDesperado SQL Server 2000 Query slowing down in SQL Server 2005

  Hi everybody, I have a query slower in SQL Server 2005 than in SQL Server 2000. I have a database in SQL 2000, I put it on the same server, but with SQL 2005 and the query take 5 seconds instead of 0 seconds. The DB compatibility is SQL Server 2000 (I tried with 2005 and result is the same). Execution plan seems right and I tried to change some DB options without results. It is weird, when I remove left join on MandatsEx, it take 2 seconds. The view currentEmployeeLevelHistoric returns 45 000 rows and mandatsex has 0 rows. Here is the sample: Select ls.EmployeNiveau.pk_EmployeNiveauID as NoNiveau, IsNull(nullif(ls.Traduction.Description, ''), ls.TraductionDefaut.Description) + ' (' + ls.currentLevelHIstoric.NoN ...Show All

• fbalas using IF...Else Statement SELECT Statement

    Hi All, Can some one point me in the right direction in how to construct my SQL query within my cursor I Have got a cursor which i am using to iterate through a table, What i am trying to do is in my statement(used to open the cursor) is compare 2 tables (the one which my cursor is iterating) to see if there is a matching row in the other table (using  both tables ID's Like So: SELECT column_List FROM Table1 WHERE Table1_id = Table2_id     so for each row  my cursor checks if there is a corresponding match in  table2... but i would like to write to an error log and do other statements if there is no match  how do i add this condition to ...Show All

• Scott_P Flat file return NULL value

  Hi, I am facing problem while extracting data from flat file through query. It return NULL value for the column EmpID for the 3rd row ('x') i have a flat file for eg: EmpID, EmpName, ParentEmpID 1,test1,10 2,test2,13 x,text3,15 Below mentioned two type of query I tried 1) SELECT * FROM OPENROWSET('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=C:\','select * from test.txt') 2) SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=C:\;Extended Properties="text;FMT=Delimited"')...test#txt Pls help me out this issue Thanks for your reply my requirement is that from a perticular path i have to read the flat files and insert int ...Show All

• de_Stan SSIS Package Hangs in Data Flow, magically works after opening and closing components

  We're experiencing a problem where intermittently our SSIS packages will hang. There are no log errors or events in the event viewer. It will happen whether the package is executed from the SQL Job Agent or run from BIDs. When running from BIDs it appears to hang inside one of the data flows (several parallel pipes with sorts, merge joins etc...). It appears to hang in multiple pipes within the data flow component. The problem is reproducable, we just kill it and re-run, and it appears to hang in the same places. Now here's the odd thing: as we simply open and close some of the components in the pipe line after the place it hangs, a subsequent run will go further in the pipeline before hanging. If we open and close all the components af ...Show All