Answer Questions

• Jitendra Kumar Mehta SQL Enterprise manager not opening

  I had SQL Server 2000 installed on my server. I was testing an installshield installation package for my application, when i un-installed it SQL Enterprise manager doesn't work any more. it gives 2 Blank messages, then gives error 1114: general error, and doesn't open correctly (the registered SQL Server don't exist any more) and when i try to register a new server, it gives error message and doesn't allow me to add registration. I re-installed SQL Server (new instance) and still the same problem occurs. i tried re-installing my package in order to re-register the missing components, still the same problem occurs. Any one can help with this Hi Kamel, Did you go to Control Panel uninst ...Show All

• NetPochi temp table naming

  I have a procedure that creates temp tables. I made the temp tables local - using # instead of ## - but I still get a 'table exists' error, when I run it from 2 qa sessions at the same time. I am deleting tables at the begining of the proc and again at the end - using IF EXISTS(SELECT name FROM tempdb.dbo.sysobjects where name = '#Archive_In')DROP TABLE #Archive_In Is this expected behaviour   I thought using # would make it local to the connection If this is expected, how do I make it work   I thought SQL used the spid or something, appended to the end of the table, and maintained that reference No, it's not new in 2005. It is, however, an undocumented system procedure. We recommend that you do not use und ...Show All

• donbox5 conditional formatting in reporting services (2005)

  I am new to reporting services and am unable to get cell colouring conditional formatting to work in of a report. Basically I need to have the following: >-5% = "Red" Between -5% and -1% = "Green" 0% = "White" Between 1% and 5% = "Green" >5% = "Red" Here is what I have tried to use: =iif((Fields!TrueUpPercQ1.Value >0 and Fields!TrueUpPercQ1.Value <=0.05) or (Fields!TrueUpPercQ1.Value < 0 and Fields!TrueUpPercQ1.Value >=-0.05), "Green", iif(Fields!TrueUpPercQ1.Value =0, "White","Red")) Any ideas Thanks Iif would work, but I think switch would be better Try this...you h ...Show All

• mruniqueid RetainSameConnection bug or feature???

  We desperately require the RetainSameConnection to be set to True on our ADO.NET - ODBC connection manager. Unfortunately RetainSameConnection always defaults back to False when you open the package. * Is RetainSameConnection supposed to work for the ADO.NET - ODBC combination * Is it a bug that it defaults back to false for the ADO.NET - ODBC combination Quick responses much appreciated! Kristian Details: SSIS with SP1 ConnectionManagerType: ADO.NET:System.Data.Odbc.OdbcConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 Provider: .NET Providers\ODBC Data Provider Connection String: Driver={iSeries Access ODBC Driver};system=AS400;dbq=GAPFILES;dftpkglib ...Show All

• KDR88 ScriptComponent with multiple ReadOnly variables

  I'm having trouble with a script component in which I'm trying to use two ReadOnlyVariables. If I use only one of the two variables, everything works without issue. If I use both of the variables (as part of a comma-delimited list) I get the following: The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created. I don't believe the variables themselves are the problem. Both are scoped to the package level and I can use either of them if I have it as the only variable. Seems bug-like, but thought I'd get some ideas before pursuing t ...Show All

• georgeob Odd FMTONLY statements

  Hi, I recently started using ADO for connecting to a remote SQL Server from Delphi. Prior to this I used BDE (Borland Database Engine). I noticed that all SQL communication seemed slow – only half the speed of using BDE! I ran a trace using the Profiler (from MS SQL Server) and noticed that ADO generated roughly twice the amount of traffic compared to BDE. Every SQL statement (SELECT, INSERT and UPDATE) send from my application was preceded by the exact same statement encapsulated in ‘SET FMTONLY ON/OFF’. -Example Start- SET FMTONLY ON SELECT * FROM TabelVersion SET FMTONLY OFF SELECT * FROM TabelVersion -Example End- Why are these odd statements being passed to the server ...Show All

• MeniB inserting records - mswebtasks error

  SQL Server 2005 on a Windows XP PC If I "Open" a table and try to insert a new record, I get an error: The data in row 100 was not comitted. Error Source: .Net SqlClient Data Provider. Error Message: [Microsoft][SQL Native CLient][Sql Server] Invalid object name 'msdb..mswebtasks'. SQL web Assistant: Could not execute the SQL statement. press ESC.... Any ideas thanks John Thankyou for the triggers comment. There was an old dis-used trigger hiding in the background ! thanks John Brilliant! I'd been rebuilding indexes many times thinking I had a corruption. I too had old triggers hidden I didn't know about. ...Show All

• R Raghu Batch Jobs

  Is there a forum, documentation, link, or anything that talks about batch jobs, what they are, how to create them, run them, etc Basically, everything I need to know about batch jobs thx, Kat If you don't need anything else on this thread, feel free to mark the answer as complete. What do you mean by batch jobs Do you mean Jobs that are executed by SQL Server Agent If so, I would recommend to get a book about SQL Server administration which dives deeper into the sense and the functionality of SQL Server Agent. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Hi there - Whenever most DBAs talk about "batch" they usually just mean a set of SQL statements. If you save t ...Show All

• Bill Cumming dtexec over the network

  Hi All, I'm trying to execute DTExec from a workstation and I got some help from a different group without luck maybe someone here can help me. This is what I try so far. 1. My package run in command line from my sql box using dtexec with parameters. 2. Set the package with DontSaveSensitive and import into IS under MSDB with the same option setup. 3. Set package role to public. 4. Share DTS folder with everyone permission just for testing. 5. Execute the package from a workstation using //sqlServerbox/DTS/BINN/dtexec /dts "msdb/mypackage" /SER "MySQLServer" /set \package.variables[myvariable].Value;"myvalue1,myvalue2" (myvariable is string and I can pass multiple values separate by commas) 6. Still g ...Show All

• Mitch Walker - MSFT How to combine MAx statement with specific search?

  Hello everyone! I've got a table (of "Persons") with 2 columns: "Age" and "Name". I make a procedure that get the MAX of "Age" of the table, like this: SELECT MAX (p.Age) MaxAge FROM Persons p But I'll like to add a new column to my result table. That column corresponds to the "Age" of a person 'X'. 'X' is its 'Name' and i will pass it by parameter to the procedure. Something like this: SELECT MAX (p.Age) MaxAge, --The highest age of the table p.Age ConcretPersonAge -- The age of the person X FROM Persons p That should returns a single row result table with the max of all 'Age" and the 'Age' of the person 'X'. Anyone can help me to do this Thank you to everyon, and a ...Show All

• DKB Find first free number

  I have a table Col1 Col2 1 1000 2 1001 4 1003 5 1004 7 1006 I want to find the first free number from first column. Now It should return 3. After inserting a row with col1 = 3 it should return 6 and after inserting a row with col1 = 6 it should return 8. Is it posible In general, you need to relate the table to itself looking for Col1 + 1. There are lots of variations on that theme. The challenge is to get a meaningful result from an empty table. Here are a couple of examples, you will likely get others as well. Select Top 1 Col1 From MyTable Where Col1 + 1 Not In (Select Col1 From MyTable) Order by Col1 Select Min(Col1) From MyTable t1 Left Join MyTable t2 On t ...Show All

• Jane2006 Exporting Data from Database to a csv file

  Hi, How do I export data from my database table into a Comma separated value file format. I am using SQL Server 2005 with vb.net Thanks you can try bcp.exe. HI baroo, Now I have the same task but I can't find out how to do it...I also have to transfer csv to SQL,although I did it but I don't know how to export data from SQL to a csv file... Did you solve it If so could you also explain me how to do it Thanks, Can Hi Greg, Thank you for the reply,I am writing a program in VB Express (SQL server express 2005) and I have to do it through coding...I tried data reader writer.writeline but it didn't work out... ...Show All

• ShurikAg Trigger security/permissions

  Hi, I'm not sure if this is the right forum, but I believe it's the closest to my question (if not, please let me know). I am wondering if it's possible to perform an INSERT to another table in another database from within a trigger. For example: CREATE TRIGGER inserted_mytable ON mytable FOR INSERT AS DECLARE @rc INT SELECT @rc = @@ROWCOUNT IF @rc = 0 RETURN INSERT INTO [OtherDB].[dbo].mytable2 SELECT * FROM inserted Both mytable and mytable2 have the exact same structure. What appears to be happening is that the INSERT statement locks up the mytable database. Is there a permissions problem here, or is this just not possible Thanks, Jeff Tolman E&M Electric Thanks for your ...Show All

• Jamie Thomson Absolute Beginner in SQL 2005 EE, needs help.

  Hi everyone. Using C# 2005 EE with SQL 2005 EE I am really new to SQL, got qns here. Can my program with SQL database run correctly on another com using win xp home edition, with only C# 2005 EE installed Is it compulsory for every table in a database to have a primary key Can I extract a data from a specific cell in a database table(click button get data) How do I go about doing it (the simplest n straight forward method) Many Thanks in advance. Regards, dragoncells.     dragoncells wrote: I assume you are telling me that if my application has a SQL database than I must have SQL server 2005 EE installed on that computer for it to work. You don’t need to h ...Show All

• Andy Morton query file directory

  Can anyone tell me where I can set the default query file directory for sql files in the new query editor of 2005 In 2000 (query analyser) this option was under the tools - options - general tab. ...Show All