Answer Questions

• katarn85 Integers in SQL Server

  I'm having a problem with the way integers are stored internally and how they are returned with a SELECT statement.  In the project I'm working on, I have to move data from an Excel file to a database so I'm using DTS and a group of stored procs to pull this off.  What happens is: DTS pull data from Excel into temp tables Stored proc pulls from the first temp table into a supertype table IDENTITY column assigns primary ke ...Show All

• GauravMatkar BEGIN TRAN . . . WITH MARK . . .

  Hallo All, Can somebody explain why the same function works different with MS SQL 2000 and MS SQL 2005 On both systems 2000 and 2005 I have 2x databases named ACCT and PROD (actually only a test environment). On both systems I try to execute the following statements: BEGIN TRAN TRAN_01 WITH MARK 'My TRAN_01' USE PROD INSERT INTO [PROD].[dbo].[_PROT]([STR_COMMENT], [R_NUM_T1], [R_NUM_T2]) VALUES('PROT_COMMENT', 1004, 1004) ...Show All

• ZAky Updating database

  Can someone please tell me what I am missing... I am trying to update a record with information a user types into a textbox. I am not getting any errors even when in DEBUG mode. But yet the Data is not getting updated. Any Help would be very much appreciated. T CODE: Protected Sub bUpdateSlsNum_Click( ByVal sender As Object , ByVal e As System.EventArgs) Handles bUpdateSlsNum.Click Dim myCommand As SqlCommand ...Show All

• lufa DTS Migration from SQL Server 2000

  I’m currently evaluating SQL Server 2005 to what advantages there would be to upgrading from SQL Server 2000. Our existing systems make much use of DTS so it critical for us to be able to run SQL Server 2000 DTS packages in SQL Server 2005.   Having installed the Enterprise SQL Server 2005 CTP successfully on a new Windows 2003 server and following the advice to install Legacy Components I find the Migration Wizard (under Legacy> D ...Show All

• GlynP problem with Display databound images in page header

  Hi all, I have a problem in displaying databound images in page header. I have done as is stated in the below article. ----X---- http://msdn2.microsoft.com/en-us/library/ms159677 (en-us,VS.90).aspx Adding a Databound Image to a Header or Footer You can use image data stored in a database in a header or footer. However, you cannot reference database fields from the Image control directly. Instead, you must add a text box in the body of the re ...Show All

• imrash Getting #Error details from deployed report

  I have a report that displays #Error for some field values when deployed on the server. Is there any way to get details on the error Thanks. Most likely the #Error comes from making a call into a custom assembly and insufficient security permissions for that custom assembly to be invoked. You can partially simulate the server environment, if you run the report in the stand-alone preview of report designe ...Show All

• DJONES Convert Rows into Columns... (Cross tab).

  Hi genius, I got the result set as shown below (By executing another query i got this). Month   Status   Count ===== ======  ===== April   I   129 April   O   4689 April   S   6 July   I   131 July   O   4838 July   S   8 June   I   131 June   O   4837 June   S   8 May   I ...Show All

• leifw (Urgent)web service and sql server 2005 database running in two different systems

  hi all, i have a requirement that web service running in one system and sql server 2005 database running in another systems which is not working currently. suppose i create end point in the system where sql server 2005 database is there,then its working fine. Actually for creating end point we should have windows server 2003 or SP2.Configuration part i dont have any hindrance. Can any one tell how to run webservice in one system with ...Show All

• MSTony How to check if row exists...

  Hello, I'm SQL Server 2005 newbie, could you be so kind and help me how to write the most efficient way stored procedure, which checks by PK if specified row exists, then updating the row, otherwise inserting new one. Thank you for your kind help. How do you determine which data to copy over How do you determine the "last" row If EXISTS(select 1 from MyTab ...Show All

• marsalaz Not in correct state to become principal

  I am using asynchronous mirroring. When I try to failover on the mirror server using “alter database xxx set partner force_service_allow_data_loss” (having disconnected the primary server from the network) it sometimes fails to failover (it reports that the database is not in the correct state to failover). I can re-connect the primary server, get them sync’d again, then unplug the primary and it will failover ok. Any ideas... or is this j ...Show All

• CccF No mapping between account names and security IDs was done.

  No mapping between account names and security IDs was done. I received the following when trying to deploy an 2005 analysis services package over an existing database: The following system error occurred: No mapping between account names and security IDs was done. We have redeployed this solution several times over the last week and have never encountered this ...Show All

• Kmc85 Transmission Queue problem

  " noWrap width="1%" bgColor=#b71c0c> 1. Yosi   29 Temmuz 12:19     secenekleri goster Gonderen: "Yosi" <yus ... @bizitek.com> - Bu yazar n yazd mesajlar bul Tarih: Fri, 29 Jul 2005 02:19:00 -0700 Konu: Service Broker Cevapla | Yazara Cevap Ver | let | Yazd r | Sadece Mesaj | Asl n goster | Kald r | Kotuye Kullan m Bildir I'm trying the service broker features of SQL Serv ...Show All

• Emrys Mydhrin XML Data Sources Extension

  Hello, My query string, <Query> <SoapAction>...</SoapAction> </Query> calls a webservice method that returns a dataset with the following xml representation: <ArtworkDataSet> <ArtworkDataTable> <Season></Season> <Name></Name> <ImageName></ImageName> </ArtworkDataTable> </ArtworkDataSet> ...Show All

• Ana Azevedo Problem accessing my local A:\ verses the SQL servers A:\ drive

  I am having a problem accessing my local A:\ drive, using the bulk insert command. The actual sql server pc thinks I am accessing its sql server's A:\ and not my local a:\ drive. I am trying to read in a simple CSV delimited ascii file into a sql table. Wow what a nightmare just to read a simple ascii file into a table. Unfortunatley I am writing a program in VB.net for an operator to import ascii data from floppy diskettes. I am using this c ...Show All

• Mark Freeman Database on server but SQLEXPRESS on local machine

  This is what I sometimes want: I have installed on a localmachine sqlexpress. Also my application is installed on the local machine. But for the night-backup of the database I want to put the database on the company server. Let's say the database is on: X:\data\mydatabase.mdf Why cant't I attach this database with the manager of sqlexpress Second: I have installed on local machine sqlexpress AND also the database Why can ...Show All