Answer Questions

• Arvindra Sehmi SSIS CAL licensing

  Hello, How does licensing of SSIS work on a CAL basis As far as I'm concerned there are no users of it per se cos its a back-end process. Therefore, do you only need one CAL Thanks Jamie   This is my understanding of licensing, don't quote me on it! SSIS is licensed separately from SQL Server only if you install it on its own machine. If installed with the main SQL Server instance, it shares licensing with that main i ...Show All

• Eric Frame Is the security roles in RS an "AND" or an "OR"

  Dear Anyone, I was wondering about the security in RS. Example: Group 1: Joseph, Joyce Group 2: Joseph, Sheira Report 1: Group 1 has browser only role. Group 2 has Content Manager role. Question: Will Joseph have both browser and content manager roles in report 1 Thanks, Group 1 and Group 2 ...Show All

• melendez a general query and db question

     Hello, I have a couple of general questions that don't require help figuring out as much as help pointing me in the right direction.   I have a table that has 3 columns. it basically contains links to outside urls that contains these columns URL     ID      description.   Now I was thining that since each url is different and that I want a easy way to check ...Show All

• SolPub how to load text file into a table?

  1 4/19/06 abc3100UD:Dcod25-uss1 PAGE 1 REPORT ON xxxx cs PREVIOUS DAY - PREV REP LOAN # BORROWER STAT STAT APP DATE INITIAL ORD DT LOANAMT CLIENTNAME 0 0123454681 xxxx, xxxxxxxxxx 10 9 06/04/05 abc 060418 $310,000.00 ABC temp plus 1 ...Show All

• Fred33 Temporary table vs. Table Valued function

  I need to return a table of values calculated from other tables. I have about 10 reports which will use approx. 6 different table structures. Would it be better performance wise to create a physical table in the database to update while calculating using an identity field to id the stored procedure call, return the data and delete the records. For Example: StrVal1,Strval2,StrVal4,IntVal1,IntVal2,FloatVal1... Or using a table-valued func ...Show All

• erikkl2000 BULK INSERT Format File Problems with SQLNUMERICAL in SQL-Server 2005 Express

  I'm trying to set up a BULK INSERT Format File for some data that I've been sent, which, according to the data documentation, comes in fixed-width format fields (no delimiters except for end-of-row 0D0A) in SQL-Server 2005 Express. The following is the first line... "7999163 09182003 56586 56477 3601942 1278 22139 1102 113 118 51450 1 1 63535647 10000 7999162 09182003 56586 56477 3601942 1279 22139 ...Show All

• Perro error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0

  hi, i'm using SQL Server CE 2.0 in my application. When i try to synchronize my database by calling replicator.Synchronize(); errors :   Initializing SQL Server Reconciler has failed. process could not connect to Distributor SQL Server does not exists and access denied. what i did right now is i try to register regsvr32 "C:\Program Files\Microsoft SQL Server CE 2.0\Server\sscerp20.dll" regsvr32 "C:\Labs\NorthwindTempFiles\sscesa20 ...Show All

• Damien Watkins - MSFT transaction context in use by another session error in c# sp from trigger

  I have a c# stored procedure that is being called from a trigger. When I execute it from management studio, it works just fine. But, when I update a record in the table that has the trigger that calls the sp, I get the error "transaction context in use by another session error". I've tried a few of the "fixes" that I found through searching, but so far nothing seems to work. What I've tried so far is... Removing the tr ...Show All

• Zoubidaman For Travis Lowdermilk

  I dont know if anyone mentioned this, but I would like to have the ability to disable objects in a Data Flow Task Thats a great idea. Thanks! Jamie - I apologize for posting in the wrong topic. The reason I think it would be cool to have the ability to disable a particular object in a Data Flow Task is: Scenario: Let say I have a Multicast that splits the data to into two different directions: Direction 1: ...Show All

• Algorith Inconsistent Errors Using Bulk Insert with a Format File

  As part of a c# program, utilizing .Net 2.0, I am calling a sproc via a SqlCommand to bulk load data from flat files to a various tables in a SQL Server 2005 database. We are using format files to do this, as all of the incoming flat files are fixed length. The sproc simply calls a T-SQL BULK INSERT statement, accepting the file name, format file name and the database table as input paramaters. As expected, this works most of the time, but peri ...Show All

• 　平 明? SQL Server 2005 CTP Release Candidate Sept - unexpected failure during setup wizard

  I always get the following message during the install - the setup fails - no error message found in the log file (summary.txt) TITLE: Microsoft SQL Server 2005 CTP Setup ------------------------------   There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.    ************************************************************************* ...Show All

• amou Connecting Sql Server 2005 from ASP?

  Hi We are planning to move over to SQL Server 2005 in near future. At the moment Website is on a seperate server then the Database. OS for both the server is Window 2003 and currently our data is on SQL Server 2000(on which everything works fine). Part of the testing process we tried to connect our website on SQL 2005 and it does not work at all. I get this ---------------------------------------------------------------- ADODB.Connec ...Show All

• shido SQL CE table creation with Mobile Query Analyzer help

  Attempting to create a table with SQL CE Query Analyzer... I can connect to the database without a problem, but whenever I try to create this table I am getting a DB_E_ERRORSINCOMMAND message. I am new to SQL CE and would appreciate someone looking over my CREATE command to see if they see any errors. Thanks in advance CREATE TABLE [Tmp_Equipment] (     [Barcode] [nvarchar] (50) NOT NULL ,     [fkEquipDefinitionI ...Show All

• mohsin649 AGGREGATE doesn't do MIN/MAX on textual columns

  Hi, Can anyone from MS exaplain why the AGGREGATE component doesn't allow you to select MIN/MAX when the column is DT_STR/DT_WSTR Thanks Jamie Phil Brammer wrote: Jamie Thomson wrote: Phil Brammer wrote: It'd be better to allow for the aggregate functions to work as they are supposed to according to the MS Transact-SQL documentation. W ...Show All

• mcassoc Problem w/ Data Flow Task of SSIS Package

  I have a Data Flow Task in an SSIS package that transfers data from a local table to a table on a remote server. The remote database is SQL Server 2000 and the local one is SQL Server 2005. The package in the designer runs great. But, when I setup the job for the server agent it fails with the connection. I get the following error: The AcquireConnection method call to the connection manager "server.name.here" failed with error code 0xC0202009 ...Show All