Answer Questions

• IamHuM Grrr SSIS... I think im going back to DTS...

  Why is SSIS so anal retentive I can perform a simple task in DTS in about 30 seconds. SSIS it was basically impossible... Its a simple 70 field flat file import... I did thing like telling it to guess the field length etc. Mind you I got this import to work on dts in under 30 seconds, so this SSIS package continues to error... Also these are all string fields. I tried to let it auto configure... that was laughable. Wrong columns all over hundreds of conversion errors and truncations. It couldnt handle a decimal import at all. I understand I could turn off all the "conversions" and errors. But why does this have to be sooooo painful its ridiculous. Mike, SSIS is alot st ...Show All

• Jason W158421 A Query on Outer Join.

  Hi. I want to know the difference between taking an outer join on tables and taking an outer join on the conditions that are defined between the tables. Thanks in Advance. Hi KeWin . Thanks a lot.       This seems a little confusing. Please do not mix ANSI syntax and legacy join syntax, since they don't work the same internally. The explanation is correct, but the examples may be confusing, since the latter, old legacy syntax should be avoided and never used at all. (for one thing there is no separation between the join condition and the were clause in it) A better example may be: Select e.name, c.model, c.color From employees e Left Join cars c on e.empID = c.empID AND ...Show All

• Gerhard Brueckl visual sourcesafe

  Hi, How is it possible to link the stored procedures in sql server to Source Safe The idea is that if anyone goes to sql server and wants to change a stored procedure, he has to check out/in, etc... Just like the way it is done is Visual studio with Source safe. Thanks sql server 2000 Query Analyser do not support VSS.. There are third party tools does this... Refer : http://support.microsoft.com/kb/818368 Madhu I think this article suits your requirement. Source control for stored procedures in SQL Server 2005 Thanks which version of sql server u have... i presume that it is sql server 2005... in that case In SQL Server Management studio -- ...Show All

• Nilavu Problem with Look up

  Hi all; I have created a SSIS package to import data from flat file to database table, which consists of Flat file Source -> Look up -> OLE DB Destination. I'm using Look Up in order to avoid duplicate records. My database table contain around 35,00000 s of rows. So when I'm running the package the above amount of data goes to Lookup cache, which require a large storage memory. So I'm not able to execute my package. I need to run the package in order to update my database. So is there any solution, in which I can check the duplicate records to get into the database and time consumption to run the package will be less. Thanks in advance... Andy Leonard wrote: Hi Sanidha, You ma ...Show All

• Josibe Multivalue Parameter SQL Server 2005 SP1

  Hello, I've installed SP1 for SQl Server 2005 and I noticed that the option "Select all" on a multi value parameter drop down (using web browser) is missing. Even if I can see it on VS 2005..... Anyone can help me Thank you very much. Where did you find this information in Books Online Can you provide a link I'd like to take a closer look, because we also use this feature (which is admittedly funky) extensively. Joe i believe there is also a hotfix available for this problem http://support.microsoft.com/kb/918222 Do you have a link to the hotfix michael I rely on the 'Select All' capability ...Show All

• victu Read Write Image data with Sqlceserver

  I was wondering if it is possible to read image data from a database in .net compact framework. Since cf does not have image.fromstream(memstream) to work with, I don't know how else to read the image from the database and then place it into a picturebox. Here is the code I have been trying out: Dim Img As Image ' Dim conn As New SqlCeConnection("Data Source = \My Documents\test2.sdf") conn.Open() Dim sql As String = "SELECT * FROM Dater" Dim cmd As New SqlCeCommand(sql, conn) Dim reader As SqlCeDataReader = _ cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection) While reader.Read() TextBox1.Text = reader.Item("name") Dim b(reader.GetBytes ...Show All

• achalk Cannot get SQL 2005 RS up and running

  I am attempting a migration to RS 2005. I restored the ReportServer and tempdb databases over to the new server. The config manager says the ReportService service is running. When I try to view the reports in a browser I get a report server is not responding error. Thanks Richard What is the error you are getting when you try to change it It would not recognize it. I reinstalled and now I get another error. Is something else corrupt should I reinstall everything (ack!) Error: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable ...Show All

• glavian Problem Doing SQL 2005 DB Restore

  I did a full DB backup that I am trying now to restore via the SQL Server Management Studio. I select "Restore" and then "From Device" and point to the bak file that I want to restore from. I then go into the Options page and check "Overwrite the existing database". Below that, shows the Restore the database files as RB_Data_Services_MSCRM RB_Data_Services_MSCRM_Log sysft_ftcat_documentindex When I then click OK I get the following error. The Media Set has 3 Media Families but only 1 are provided. All members must be provided. Any ideas as to what I did to do to be able to complete this restore Thank Rick Bellefond Michael, I did not ...Show All

• Samus Index not replicated to the device

  Hi, I have a table published on the SQL2K Merger Replication publisher. But when I add an index to the table it's not replicated to the device. I have checked the snapshot folder and the newly added index is already in the .dri file. Any ideas Cheers, Justin Justin, Replication supports a wide range of schema changes to published objects. When you make those schema changes on the appropriate published object at a Microsoft SQL Server Publisher, that change is propagated by default to all SQL Server Subscribers. However, Explicitly adding, dropping, or altering indexes is not supported. That is why you see the index is not replicated to the existing subscriber but it works with new subscribers. You don't need to drop ...Show All

• Jae String or binary data would be truncated. (only for 1700 character string?)

  I am trying to insert a row into a table of Microsoft SQL Server 2000. There are various columns. [SNO] [numeric](3, 0) NOT NULL , [DATT] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [DATTA] [char] (3000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [CODECS] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , The [DATTA] column is causing a problem. Even if I am trying to put only 1700 character string into [DATTA], the java code throws the following exception:- StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode 0 and SQLState 08S01, to a StaleConnectionException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection r ...Show All

• Twyford RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035

  RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035 PDA info: .NET CF 1.0 env-string... MS SQL client MS SQLCE 2.0 dev MS SQLCE 2.0 DESKTOP info: Microsoft SQL Server Management Studio Express 9.00.2047.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 6.0 Microsoft Internet Explorer 6.0.2900.2180 Microsoft .NET Framework 2.0.50727.42 Operating System 5.1.2600 copied an app from http://www.codeproject.com/netcf/PocketPCwithSQLCE/PocketPCwithSQLCE_Src.zip ...Show All

• donkaiser Printer control

  Is there a way to specify the tray to print a page from I am working on an invoice that needs the first page printed on special stock and any additional pages printed on normal paper (done now using printer codes). If it were a single invoice this could be handled at print time, but we print thousands of invoices (of varying page counts) at once. there is no way to set this from the printer itself, the only thing i could suggest as an answer for you is to change the default printer to set output to the tray you need. ...Show All

• Tom Sapp BULK INSERT using Exisiting Folder

  I am getting the following error when trying to point a Bulk Insert Connection Manager to an existing folder (rather than a file). Anyone else having this problem or know what i am doing wrong I find it interesting that is says file (below) when i told the connection manager to point to the folder. Thanks in advance. "Error: 0xC002F304 at Bulk Insert Task, Bulk Insert Task: An error occurred with the following error message: "Cannot bulk load because the file "c:\Folder\" could not be opened. Operating system error code 5(Access is denied.).". Task failed: Bulk Insert Task" James Bulk Insert Task uses FILE connections that point to a file wich contains data that you want to be loaded using BULK INS ...Show All

• lwfoon Backup Transaction logs

  Hi: I have configured maintenace plan to do a full backup of sql server at 5:00 Am followed by transaction log backup every 15 mts.The transaction log backup basically appends to existing backups so there is only one file of transaction log backup. I want to modify that the transaction logs backup only has transaction logs after 5:00 Am full backup.Right now the transaction backup has backup of all the transaction logs since i have scheduled. Thanks for your help. Ganesh > True as the backup of database also takes care of transaction logs and there is no problem of duplication in your case. Note that the portion of the transaction log which is included in a full backup is NOT a substitute for a log backup, nor ...Show All

• Darathar How to completly stop mirroring, eg disable the endpoints on the server

  We have tested mirroring with success. Now we want to completly disable mirroring, and have done this on all mirrored database. It seems though that the server stille maintains the mirror endpoints, hence you can do a "telnet localhost 5022". How can we disable the mirroring endpoints Martin Tan SQL DBA You would need to issue a drop endpoint statement for each of them. ...Show All