Answer Questions

• kawano1h return columns for different sql bases

  I want in one query return columns from tables where exist in different sql bases. In MS Access can link tables from many defferents sql bases or other MSAccess bases and finally can make a simple query where return columns from tables where exist in different bases. How can i have the same functionality in Visual Basic .Net 2005 (or Visual Basic 6.0) If you are using SQL Server, you can use Linked servers (see http://msdn2.microsoft.com/en-us/library/ms188279.aspx ) or for a one time query to another database, you can use the OPENROWSET T-SQL directly in your SQL query (see http://msdn2.microsoft.com/en-us/library/ms190312.aspx ) Regards, Uwa. ...Show All

• EWANAME Peer-to-Peer Transactional Replication and deadlock

  Hi all, I have implemented Peer-to-Peer Transactional Replication only for two servers.Everything works fine but in highlevel of concurrency some updates are rolled back due to deadelocks(Never comes without replication).Is there any type of document which can guide me to avoid deadlocks (under Peer-to-Peer Transactional Replication env). Hi, Do your system do DML on different node and is there any DDL operation involved Just want to get an idea what your concurrency pattens look like. What deadlock error message do you see To troubleshooting, you may want to turn on trace flag 1204 and 1222 so you can know what actually cause the deadlock. Thanks, Peng Replication in general ...Show All

• ReneeC ADO Connection to MSSQL Server 2005... Need help

  Hi, at first a few things about my system: I use Visual Studio 2005 Pro on WinXP SP2 and I have recently installed MSSQL Server 2005 Express on my system. I want to establish a connection to the MSSQL Server from C++ (not .NET) using ADO. For this I use the following connection String: Open(L"Provider=SQLNCLI;Server=FREECASTLE;Integrated Security=SSPI;DataTypeCompatibility=80;MARS Connection=True;",L"",L"",ADODB::adConnectUnspecified); This works. But this is not exactly that what I wanted, because here just my Windows Authentication is used. I want to be able to pass username and password for users that are allowed to access the SQL Server. Here my first confusion begins: I have the option to pa ...Show All

• thukralz Data Mining Wizard (Not Responding)

  I am trying to create a new mining structure, but when launching the wizard the "Data Mining Wizard" stops responding where the dropdownlist with the algorithms should appear. The bizarre thing is that I can access the cube and the datawarehouse just fine using the same setup, it's just the mining wizard that doesn't work. I am using SQL 2005 standard & Visual Studio 2005 Team Suite (and yes I have reinstalled SQL 2005) - no change. Are there any logs that might shed some light on this strange behavior, or is this a known issue Hi Chris The behavior of the algorithm selection wizard page is to retrieve the list of algorithm from the deployment server. If the query times out, it reverts to a list of cached ...Show All

• Brent-GPTX Automatic failover... help

  Hi there, We've recently set up a Principle, Mirror and Witness configuration with the Mirror and Witness in a separate building to the Principle. All three are part of the same domain (DMZ) and are different servers, the buildings are connected via a fiber optic cable. All servers and SQL Server instances are logged in with the same domain admin account DMZ\esAdmin. Mirroring is all set-up and the databases are synchronized. Every once in a while some (not all, normally 6 out of 15) databases will switch roles and become active on the mirror. The SQL Server mirroring monitor job then reports: Date  25/01/2007 12:37:01 Log  Job History (Database Mirroring Monitor Job) Step ID  1 Server& ...Show All

• aaks An attempt to attach an auto-named database ....\aspnetdb.mdf failed

  I've installed VWD 2005(Beta 2) and MS SQL Express and also followed the aspnet tour at http://beta.asp.net/guidedtour2 . After trying new webcontrol (login control) and trying to execute the page, I've got an error such as below: An attempt to attach an auto-named database for file c:\inetpub\wwwroot\Demo\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An attempt to attach an auto-named database fo ...Show All

• Damien fromOZ Create a column in RecordSet with the Record Count...

  Hello I'm reading a XML file and the next operation need a column with the row count. I don't want to know how many rows there is in the recordset, but, the row count of each record. How can I implement this tkx in advance Paulo Aboim Pinto Odivelas - Portugal That issue was discussed here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1074253&SiteID=1 ...Show All

• bes7252 "where" statement in list

  I have one dataset and two lists with one table in each list. the two tables should get their data from the same dataset. but the tables need different "where" statements. in the dataset I only can define one "where" statment. it is possible to displace the "where" statment into the two lists they should access to the dataset with their own "where" statement. @ Gerhard when I use two different datasets, my report would totally have 32 datasets. if I use one dataset for two tables my report will only have 16 datasets. @ Adam Thank you, the parameters pane was the right hint. the parameter "usernr" had the data type "string". I changed it into "integer" and now it works. but I had to do one more ...Show All

• mNilysg table script creation error: "Property AnsiNulls is not available for UserOptions"

  I just recently upgraded my DB server from 2000 to 2005, and now I can't script any table creation scripts.  I can edit tables using SQL Management Studio just fine, can edit stored procs, etc.  But when I try to script to a new window using management studio, I get the error below.  Note that my tools were upgraded at the same time, so I'm not sure if the problem is with the Tools, with SMO, or an underlying problem in the database.  Any ideas Here's the error text: TITLE: Microsoft SQL Server Management Studio ------------------------------ Script failed for Table 'dbo.EditorialRepeatMap'.  (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00. ...Show All

• rKarthik SQL Server not visible

  I can't seem to make the SQL Server visible to anything other then SQL Server Tools. (management Studio, etc.) Neither Visual Studio 2005, or Administrative Tools/Data Sources can view or connect with my SQL Server. I need help, Thank you. Hi, I have the same problem I have Visual Studio 2005 and the 2005 SQL Server Express ed. installed. I can’t see the SQL server from any other tools than the configuration tools for the server and the SQL Server management studio. In Visual studio, i can’t see the SQL server at all! When selecting SQL Connection, there are no servers to select from and no databases either I don’t know if the databases are empty, when they were installed with ...Show All

• AlucardHellSing Error when changing the length on DataReader Source

  Hi, I am trying to import data from Oracle RDB into SQL Server 2005 using SSIS. Created a ODBC data source to connect to Oracle and used DataReader Source component and ADO.net to connect to the ODBC data source. Under the Component properties tab, the SQL Command looks something like this. Select ID, ADDRESS, REVISED from ADDRESS The data type for the source columns are Integer, Varchar(30) and DATE VMS. Now when I look at the Input and Output properties window, The External columns has the following data types. ID - four-byte signed integer [DT_I4] ADDRESS - Unicode string [DT_WSTR], length = 0 REVISED - database timestamp [DT_DBTIMESTAMP] The Output columns has the following data types ID - four-byte signed integ ...Show All

• Deepu_a integratedSecurity issues with Microsoft SQL Server 2005 JDBC Driver

  I am using Microsoft SQL Server 2005 JDBC Driver to connect to SQL Server 2000 database, I am using the following connection URL boolean iSecurity = true ; String connectionUrl = "jdbc:sqlserver://machine_name:1433;" + "databaseName=dbname;integratedSecurity=" + iSecurity; I am getting the following error. com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. How do I resolve it I have the following set VMOPTIONS = -Xrs -Djava.compiler=NONE -Djava.library.path=C:\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\auth\x86\sqljdbc_auth.dll Any help will be highly appreciated. Regards Arup Hi Arup, Try the followi ...Show All

• eddy2705 Yes it does

  We keep a database of events that are classified by severity. I've got a good, efficient query that gives me the grand total for these events. And I have a bad slow query that breaks down the information into daily totals. My fast query will count the totals for 3213586 events in 4 seconds. The slow daily query takes about 60 seconds for each day. Please help optimize my slow query! ------ Database schema is: Column Name Data Type Length Allow Nuls 1 msrepl_tran_version uniqueidentifier 16 0 0 [time] GMTtime (int) 4 0 0 msec int 4 1 0 offset GMToffset (smallint) 2 0 0 type nameType (varchar) 15 ...Show All

• suryany SSIS Check pointing - Is it possible to override the point at which the package restarts on custom condition

  I have created a package that use SSIS check pointing for failure-retry mechanism. I knew that when this package fails, on restarting the package it starts from the task where it got failed. Is it possible for me to override this on a custom condition and start the package at an earlier task where it executed successfully Ex: Check pointing is enabled. FTP task e Write to Staging Table e Write to Target table. Assuming I am downloading XML file through FTP and writing to a table. FTP Download is successful. Read from XML file and write to Staging table task failed because of downloaded file is not a well formed XML. Here, FTP task is completed successfully; it failed only in ...Show All

• Philippe Monnet Sql 2000 the query run 1/Seg and Sql 2005 the query run two minute

  Query to follow wheel in less of one minute in the same bank that I have in Sql 2000 and delays almost 2 minutes in the 2005 query: select 'REAL' , 'CP AVULSO' , CP . NUMLANCAMENTO , CP . CODECLI , CP . OBS , isnull ( CPC . VALOR , 0 ), CP . DTVENCIMENTO , CPC . CENTROCUSTO_ID from CP , CP_CENTROCUSTO CPC where CP . NUMLANCAMENTO = CPC . NUMLANCAMENTO and CP . CODECLI = CPC . CODECLI and year ( CP . DTVENCIMENTO ) = 2007 and month ( CP . DTVENCIMENTO ) = 01 and CP . NF + ' ' + cast ( CP . CODECLI as varchar ( 20 )) not in ( select NF + ' ' + cast ( CODECLI as varchar ( 20 )) from NFC_CAB ) and CP . ISTRUE_FALSE = 1 and CP . VALORPARCELA ...Show All