Answer Questions

• threehappypenguins Can't Connect with Remote Sql server.

  Hello All , I had installed Sql Server 2000 on Windows server 2003 enterprize Edition. But when I Try to connect it with Remote, 'Sql Server doesn't exists' message appears.. anybody know what may be the reason You can connect using IP Address without any problem and for that ensure to add an entry on the client network utility on your client's machine. Also refer to KBA http://www.sql-server-performance.com/faq/sqlviewfaq.aspx topicid=12&faqid=143 which helps to resolve any issues you might get. Moving this thread to the SQL Server forums. My question was slightly wrong.. I want to connect with sqlserver 2000 with Ip address. ----my installments are 1. Micros ...Show All

• GRoston sqlcmd - empty serverlist

  At the end of my rope here ... I was using SQL Express 2005 without trouble, until one day I couldn't access my database. I spent a day hunting down the issue without success. I uninstalled and reinstalled SQL Server many times, each time hoping it would somehow help ... I can access SQL Server just fine through SQL Server Management Studio Express. I can get in by typing "sqlcmd -S {my machine name}\SQLEXPRESS". However, I am working on a FoxPro application, and I cannot connect using FoxPro. It doesn't even seem to recognize the existence of SQL Server on the machine. Also, when I log in using sqlcmd, and type ":serverlist", I would expect my SQLEXPRESS instance to show up. It doesn't - the list of servers is empty ...Show All

• bdkf13 & character in Select statment

  Hi Folks If I wrote this in QA what does it mean Declare @X INT Set @X = 2 Select (@X & 8) What & do in this select statment Thank you Oh, Thank you both I got it. Thanks Hi, & is a bitwise operator it perform a bit operation on the operands. bit value of 2 is 01 & for 8 it is 1000 and after bitwise calculation it comes out as 0 Shallu is Right, but i would like to add somthing to it The & performs the BITWISE AND operation like in this case Binary of 2 is 0010 Binary of 8 is 1000 now both of these performa AND operation bit by bit 0010 1000 (AND) --------- 0000 (Result) --------- ...Show All

• Bill Henning CRI Designer Adornment class - host WinForms controls?

  Hi, I'm developing a CRI and in design mode I would like to have some controls on my adornment windows. Is there a way to use WinForms controls here instead of redefining the wheels... Thomas That is one possible solution. You don't have much flexibility to dynamically change the appearance of your adornment, but you can intercept mouse movements and clicks. You can create a dialog that is invoked by clicking in the adornment. -Albert Sorry, using Winforms controls in adornments is not supported. -Albert So what do you propose for more complicated UIs The properties dialog as the only solution Thomas ...Show All

• Oleg63 Manually changing flat file source has no effect

  I have a data flow that reads from a flat file source, goes through one data transformation component to change from unicode to normal text and writes the data to a SQL Server table.  This has been working fine throughout development using a specific source file as input.  I have now manually changed the path and name of the input source file in the connection manager to point to a new file and the task continues to process the old text file. I open the connection manager and check its properties and preview the data and it all looks fine - it is finding the new file.  I also edit the flat file source component and preview the data and it shows the data from the new file.  I run the data flow by right-clicking and se ...Show All

• Susand Scheduled Jobs

  Its not possible to schedule jobs via Express is it Like I have a process that connects to an Oracle system grabs the data... plays with it some and then inserts it into the MSSQL 2005 server... We need this process to run say every 2 hours... Express cant do that cant it hi, in addition to Jens answer, you can perhaps have a look at "third party" solutions, both commercial and free, like http://www.valesoftware.com/products-express-agent.php and http://www.codeproject.com/useritems/SQLAgent.asp to implement scheduled features.. regards another possible solution (thats free) is to create a small batch script that calls sqlcmd and does your sql processing. this batch file could then be scheduled using windows ...Show All

• Lucian Wang Integrate more than one SSIS packages into one package

  Hi I'm new to SSIS field. I'm importing data from flat files to sql server 2005 through SSIS packages. I have around 30 packages which transfers data from flat files to corresponding database tables. I want a single package that will run all the 30 packages by running that single package. Like in a single stored procedure we can run multiple stored procedure, I want the same solutions for my packages. Is there any method which can solve the above issue Please kindly guide me . Its urgent. please reply soon. Thanks in advance. Is there any better approach to integrate packages into one package My target is to create a single package , by running this ...Show All

• Trisha2006 About Sql Statement

  I am writing Procedure in SQL Server 2000, and i am giving three inputparameters ie: Account number and from date and to date.but in will give input to procedure as account number or from date and todate. So in select command how can i write, ie i will give input any one ie accno or ftomdate and to date. i will write sql query which i write but it is giving error Select * From Mf_Tran_Reg Where mft_fundcd= 'RMF' and mft_purred='P' if @Folio = '' begin and mft_procdate between @Fdate and @tdate end else begin and mft_accno= @Folio end Hi Majid, CREATE PROCEDURE SomeProcedure ( @mft_accno INT = NULL, @Fdate DATETIME = NULL, @tdate DATETIME = NULL ) AS Select * From Mf ...Show All

• peterfajardo Excel pivot table

  Hi, I have several pivot tables in Excel that access data to a SQL 2000. We install SQL 2005, we change the ODBC from the 2000 server to the 2005 server. Now when we try to run the pivot tables I've got the following message: "User 'public' does not have permission to run DBCC TRACEON" Any idea on how to fix this problem Thanks, Arty Looks like a change in SQL 2005. Our SQL Drivers send dbcc traceon(208) to server if client is MS Query for backwards compatibility reasons (turns on support for old quoted identifiers). SQL 2000 allows this, SQL 2005 requires you to be sysadmin. I can't see any other way to work around this. Yes, copy and paste the code in Tools -> Macro -> ...Show All

• Dylan Beattie Need Help on this SQL Statement

  Hi All, sqlLstProds="Select * From PRODUCT_DEF "&_ "WHERE productID IN(Select productID From PRODUCT_DEF WHERE (IDProductCriteria = 5) AND ([Value] = '"&getSession("ModelID")&"')) "&_ " Order By IDProduct, IDProductCriteria" I have the above SQL Code in an ASP page. This queries the Product_Def table, however there is also a table called Product_sType, the primary key in that table is productID which corresponds to productID ub the Product_Def table. I need to add to the query a where clause, where active = 1 active 0 is obviously discontinued products, how would I do this So basically, it's somewhat of a join of some sort, like select * from Produc ...Show All

• enric vives Error: 18456 Severity: 14, State: 10

  I have SQL 2005 Expess installed on Windows Server 2003 SP1. My application is running as a service and is set to depend on SQL Server instance... During the startup my app attempts to connect to the databes and it fails to do so, after 30 retries (1second appart). SQL Server log has this error msg: Error: 18456 "Severity: 14, State: 10" Once the server has started, I cam manually start my application and it then sucesfully opens a connection to the database. What does this error mean Srdjan Are you saying that you get login failure errors after the database is started up The log excerpt from your previous message doesn't show that. Can you post your errorlog from beginning up to and including ...Show All

• Gulden Please Help

  I want to sum the value of a column that i'm creating in my data flow. After a derived column thats a column of numbers that i need to hve the value of the sum of all rows. I've tried to use the aggregate transformation but it doesn't work because after this transformation you loose all the columns except the one you sum. I'm lost. The best way would be to catch the sum value into a variable. I know thats problably easy to do but i can't seem to get it done. Thanks Adriano Coura (Brazil) Sure let's take it from the top. I've a oledb source, derived columns, and a flat file dest. After i got the records from the DB, the derived columns create format the value column into the shape that i can sum. OLEDBSOURCE ----> DC -----> DC ( ...Show All

• Herru Perdana SQL Agent Job error message, help!

  I've just created a Maintenance Plan with Maintenance Plan Wizard, after I hit the Finish button and the SQL Server Management Studio start executing the wizard, it said something has conflict with the new maintenance wizard. Next thing I know, there's this DB Backup agent in SQL Agent Job (in SQL Server Management Studio); and I can't delete it although I'm able to disable it. Can someone help Here's the detail of the error message I received every time I tried to delete the job agent: Drop failed for Job 'DB Backup'. (Microsoft.sqlServer.Smo) Additional information: - An exception occured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) - The DELETE statement conflicted with the REFERE ...Show All

• dave234 Single to Multi-value parameter passing

  Hello, I am creating a drill through report in which I am selecting a single month from the main report. When I pass this month, I would like the secondary report to select all the preceding months (i.e to set YTD for secondary report) e.g. Primary Report - March selected from the drop-down Secondary Report - Jan, Feb, March should be selected. Any help will be appreciated. FYI - I am using an Analysis cube as my data source Thanks If you want to just display the month/year in the drop-down that is fine, but it is probably easiest to actually store and operate off of a full date from the first report (i.e. 1/1/2006, 2/1/2006, etc.).  This simplifies your filter in the seco ...Show All

• yema2001 Configure Report Server with SQL Server Express with Advanced Services.

  I am having trouble with SQL Express Reporting services. When going to http:/localhost/reports I get the following error message: "The report server is not responding. Verify that the report server is running and can be accessed from this computer." In configuring the Report Server Virtual Directory, it would not let me set the name as "Report Server", so I named it "Report Server2". I have tried uninstalling .NET framework v2 and reinstalling, but this does not help. Any ideas By default, Express Advanced installs Report Server to a name instance, so you should be trying to get to http://localhost/reports$sqlexress . A default installa ...Show All