I have Text file that I want to import to my database How can i do it ? Thanks a lot (abs_absh)

When I try to Connect to SQL Server By Win App this Error happens But when I connect by Server Explorer In VS 2005 this connect to SQL Server 2005 Express Edition(My SQL Server Set to Mixed mode Authentication.)System.Data.SqlClient.SqlException was unhandled Class=14 ErrorCode=-2146232060 LineNumbe...

1. I have an issue regarding backup in Microsoft SQL SERVER 2000. I have a database with 700GB size. What could be the best solution(s) for backup. 2. I have 72 GB tape storage device, if I start the same 700 GB backupon 72GB tape device, will it be ask for the next tape after completingone ...

Hi everyone, I have an mdb file that I want to import using sql server 2005 express edition. I am using the Management Studio Express and have had no success. Thanks in advance

Hi, I have successfully set-up a DB mirroring. When the pricipal goes down, the mirror picksup and the other way around too. So the mirroring part is working great. However, when I use my web applicaiton (dot net 2.0), it is not able to connect to Mirror server. I get the following error: An ...

In Microsoft SQL Server Management Studio Express you can right click on "Stored Procedures" under a database in the object explorer and the resulting Context Menu offers a selection called "New Stored Procedure". If you select "New Stored Procedure", a Stored Procedure Template Document is ...

Hello All, I have a server with SQL Server 2000installed on it. I have created a tool that runs on a Pocket PC withSQL CE backend. Multiple clients would be using the tool on diferentPocket PCs. I would have to use Merge Replication for synchronizationand since the Pocket PCs would not have ...

Hi, Is this possible to receive notifications from Notification Service in my windows application written in Framework 1.1? I am using SqlServer 2K. I want to create a notification when number of rows in a given table reach a specific limit. I want to receive the notification in my application ...

When I try to un install SQL Server Express (VS 2005 Beta 2), which is not functional, I get an error message:The SQL Server System Configuration Checker cannot be executed due to WMI Configuration on the machine MACHINE_NAME Error:2147746132 (0x80040154).I ran the Windows Install Cleanup tool ...

Is there any freeware or features in SQL Server or Visio that can reverse engineer a data dictionary from an existing database? I had produce a ER diagram using reverse engineer function in Visio, but I still need to produce a data dictionary ...

contains(name,'"张三"') will not find the row in database with column named "name" and "张三" is sure there,but will find '张三一'，'张三二' why? name column is sure in the fulltext category and data population is finished!

(Cross post from newsgroup) Attempting to implement Windows authentication between trusted domains. . . I have a domain trust set up between two domains connected via persistent vpn: REMOTE and HQ sqlserv is: HQ\SQLSERV (SQL 2000 server) client machine is: REMOTE\MACHINE1 (SQL 2005 tools) I ...

I saw a posting or read a blog somewhere that mentioned custom WCF transport channels where created for interacting with ServiceBroker. Has anyone read or heard something similar? If so, where can I get them? Thanks. Phil

I had a merge subscription expire and now need to synchronize two disparate databases. How do I do so without overwriting the subscriber database with the publication snapshot? Thanks for any help you can give.

I need insert many dates from tables to XML file, I use T-SQL, everything is OK, but in one step I can insert maximally 4000 character in uni-code. Is there another way? Thanks' a lot. I use such sequence T-SQL: Declare @doc XML, @ixml nvarchar(4000) SELECT @ixml=(SELECT * FROM SAMPLE ...

I understand that the batchparse dll is supposed to be installed in both the 32 and 64 bit GAC. But on my machine, I can find neither. My installation of SQL 2005 was typical not custom. What did I miss? TIA

I am a SQL newbie. I have two connected databases that I work with in Visual Web Developer Express or Visual Basic Express. One is an ODBC master database that contains much table data and the other is my new destination sql express database. Where I was once very comfortable using the query ...

Hi! I have VS2005 RC1 and SQL Server 2005 September CTP installed on the same machine. I'm writing some pretty simple C# stored procedures and I'd like to be able to debug them with with the VS2005 IDE. However, something's not working. When I set a breakpoint and I run the code (F5), it ...

How do I get the identity for a row I just inserted? When using @@identity and there are triggers inserting rows into other tables I get the wrong id. I know sql2000 has scope_identity but I'm stuck with sql7 for legacy reasons.

I have an InterBase 5 database, which has been registered as an ODBC System Data Source in my Windows 2000. When I try to add it as a linked server in SQL server 2005, the Add Linked Server page make me so frustrated. I can select the ODBC driver, but I don't know how to specify values for the ...

I am using Analysis Services 2005 and I need to create a new measure “y”, for which I have to take the logarithm of another calculated measure "x".i.e. y= ln (x) (where x is another calculated measure within the cube).In AS 2000, there is the function LOG available, and in AS 2005, it somehow ...

After upgrading to SQL Reporting Services SP2, we now get an error every time we try to run any of our reports. The error is"An unexpected error occurred in Report Processing. (rsInternalError) Index was outside the bounds of the array."Anyone have any suggestions?I looked in the Report Server ...

Hi Guys, I kindly ask for your help with regards to my DM project. I am working on a project that is related to the field of agriculture and that has as an objective to find the "optimal values" of the operating conditions that affect the outcome (the amount of meat produced i.e. the ...

I have done this twice now. I am sure I will do it again. I have a date dimension. Among other things the dimension contains columns for a meaningless id and raw date. If I want to translate a date to a the meaningless id for storage in a fact table, I use a look up component. All fine and ...

Hi all,I am trying to restore and SQL 2000 database into a new SQL 2005 database. I performed by SQL 2000 backup and created a blank database FERS_Production in SQL 2005. FERS_Production was the original name of the database in the SQL 2000 instance.I have tried giving the new database the same ...

Hi, Background: I'm on a Pentium 2.4 with 1024 mb Memory and 160 Gb harddrive, running XPPro with SP2. I started a project in VS2005Beta2 with Sql2005Beta. When the RTM versions came along I ungraded to VS2005Pro, and tried to upgrade the SqlDeveloper. This ran amuck, but I could still access ...

I start with 3 servers, in High Safety mode with witness. I disconnect the network cable for the witness. Then I remove the witness from the mirroring session: ALTER DATABASE db1 SET WITNESS OFF I reconnect the witness network cable. Now I cannot add the witness back to the mirroring session ...

Hi all, I′m a real SQL rookie and after two days of intensive research and reading of dozens of articles and web pages a bit confused about all that knowledge concerning database technology ... and I only want to do something very easy ... Now, my question is, how can I produce a diagram from ...

hi allin the wireless application, if i use RDA to pull data from SQL server 2005 database.do i need to code a exernal class for the PDA to connect to the sql server.RDA pull data trough what medium, wireless or active sync, if i wanna pull data through wireless what should i do.By the way, how ...

Hello, I have multiple linked servers setup to go to various data sources. All data sources are basically the same ... just different data for the different locations. Currently I have different subscription classes and associated matching rules for each linked server. Is there a way that I ...

I have been trying to apply SP4 to my downloaded and installed evaluation version of SQL Server 2000. On the Analysis Services, I get an error that states "You must install Analysis Services before you can apply a service pack." When I try desktop engine, I get a "The instance name specified is ...

I am wanting to put my stored procs in vss. The configuration that I am looking at is Sql Server 2005 Sql Server Management StudioVSSI have not been able to find anything that gets me going, so if someone has a link or some links, please just redirect me and I will continue digging.What I ...

Hi - I'm trying to install June CTP on Win2k3 SP1.Setup failed when trying to start services for configuration.In log files I found the following Computer type is AT/AT COMPATIBLE. Bios Version is INSYDE - 1 Insyde Software MobilePRO BIOS Version 4.00.01 Current time is 11:26:54 08/30/05. 1 ...

(Cross post from newsgroup) Attempting to implement Windows authentication between trusted domains. . . I have a domain trust set up between two domains connected via persistent vpn: REMOTE and HQ sqlserv is: HQ\SQLSERV (SQL 2000 server) client machine is: REMOTE\MACHINE1 (SQL 2005 tools) I ...

Hi all I am using internal activation on a queue to process the messages, should an error be encountered I call stored procedure A in the same database to log the error. Part of the processing in stored procedure A is a call to stored procedure B in another database (on the same server), ...

Hi,We are using VSTO 2005 and developing an Ms-Office Excel application which has to work both in Online and Offline. When the user connects to office LAN network then the data that the user will use data comming from our centralised database. This is for online scenario but when the user is in ...

I store the xml info below in the XML field in SQL 2005, I hope to query all the Folder node with XQuery. The result I hope to get <Folder Name="Root" Id="a6dce8fe-749c-4e38-ab2f-3d03d9711b3d"> <Folder Name="Card" Id="b8dcf8fe-749c-4e38-ab2f-6d03d9711b8j"> ...

I need to update our applications install program so it installs the latest SQL DMO. I've downloaded the "Microsoft SQL Server 2005 Backward Compatibility Components" MSI from http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en.This ...

I want to delete a parent record.Is there a simple call I could make that would tell me if there are dependent child records, without me having to hard code in all the child tables and manually calling each child table one at a time.A .net framework call that that returned a Yes/No to a "Are ...

Most content management systems I've seen have data from a database, and fixed template and background information held in ASP and XML files. Surely it would be easier and more centralised to have everything stored in a database? I've created a simple content management system that does this ...

Hi, I would just like to know if there's a simple way of querying a time disregarding the date. I mean, I want to query all employees that spends time on the office after 5pm. I don't care about the date, I just want the time... Im currently achieving this by using DATEPART function and ...

<span>How can I use <font color="#000000" size="2">AttachDbFilename in DbNameDataSet.xsd to access the database in the same directory as the exe file (i.e. the application using it)?</font></span>

Here is the scenario: 3 different company dimensions, "Billing Country","Receiving Country","Main Country" There are three companies in these dimensions: Canada, USA, Denmark. Now, in actuality there are more countries, but we'll keep it simple in this example. This makes the possible ...

I have report parameters configured to use date pickers...but they don't show up when I run the report. I see the date picker controls when I preview the report in design mode, but they don't show when I open the report in a browser. Any thoughts?It could be unrelated, but the error I get ...

I am doing a data mining project using the census bureau data set. The data set is a pdf, so I saved it as a text file, I imported as a flat source file and am trying to create my data source? But am having trouble with this? Please help?

Hello,I can gain access to and execute my package using the Application and Package objects. I am handling the events of the Package object and can even see the OnPipelineRowsSent event when it fires to deliver the rows to the Datareader destination. How do I gain access to those rows for use ...

Hi all, I am working with SQL Server2000 and I have done a horrible thing here.We here have an script that delete all data from all user tables of a database, and I run it in the master DATABASE.As we don't made backups of this database, now somethings of the database aren't working.Here is ...

I'm trying to distribute an application but I face a little problem. I want to install the .net framework and SQL Server Express while my app installs itself in the host PC. Also I would like to let SQL server express prepared for remote conections, all of this in a single install project and ...

The database in Mirrored server is always in the state of restoring only. the database in mirrored server is restored with norecovery then we started mirroring. the status of mirroring is successfull and is synchronized. but the Mirrored server is always in the state of restoting not allowing ...

Hi all, I′ve installed SQL Server Express 2005 as part of the installation of Visual Basic Express 2005. When I tried to run the Starter Kit "WebLogAnalyzer" comes the following error message: "Warning 1 The referenced component 'Microsoft.ReportViewer.Common' could not be found. " Now I′ve ...