Answer Questions

• jrmartinez Please Help!!!

  I'm running Visual Studio 2005 (VB) with SQL 2005 installed. I tried to add a SQL database and it says SQL express is not installed. And here I was thinking that SQLexpress was only for VS express. I do not want to use that old crippled handicap SQL express database... how do I use the regular SQL database Thanks. Sql express work with vb professional... Sql server 2005 work with visual studio tea ...Show All

• JeremyKei Disable a container at runtime via ScriptTask

  Does anyone have sample code for me to look at to do this I see the container object, and the diable property, but how do you set the container object to the container instance you want to disable thanks in advance. Expressions on workflow are easier too. I don't think you can as this would come under the heading of changing the package at run-time, which is not allowed. Expressions, variables and configuratio ...Show All

• Qwickset Using MS Access 2003 Project with SQL Server 2005

  I continue to receive an error that states "The version of Microsoft Access doesn't support design changes with the version of Microsoft SQL Server your Access project is connected to. See the Microsoft update website for the latest information." I'm using Access 2003 that I ran a database through the Upzinging Wizard with a copy of SQL Server 2005. I have searched the Office Update pages and can't locate anything that helps, alt ...Show All

• DGK Update column with 8 digit random number

  How can I replace a field for each row in my table with a Randomly generated 8 number value The field is of type int that I'm updating unfortunately, I get the same number repeated with your code all the way down: UPDATE MASTER SET SSN = RIGHT( REPLICATE ( '0' , 8 ) + CONVERT ( VARCHAR ( 100 ), CAST ( RAND () * 100000000 AS INT )), 8 ) select top 100 ssn from master Results: 66081678 66081678 66081678 660816 ...Show All

• Bill Raleigh Full-text (containstable) stored procedure with high reads

  Hi, I have a stored procedure which uses the CONTAINSTABLE function and its seems to be doing a lot more reads and taking longer to execute in SQL Server 2005 (64-bit) as apposed to SQL 2K (32-bit).   The syntax I am using is CONTAINSTABLE(tablename, fieldname, text, 400).   In the SQL 2005 instance the stored procedure does 1426715 reads and take approximately 50-90seconds to complete while on the SQL2k instance it does 22 ...Show All

• xBoRISx Importing Foxpro Database

  I am new to SSIS and want to import a foxpro database from a CD into my SQL Server 2005 Database. Is there a basic tutorial that can help me navigate the import wizard or can someone provide the proper data source connection information to use Have a look at this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=76237&SiteID=1 ...Show All

• MTM FastLoadMaxInsertCommitSize for Data Flow Destinations

  Is there a way to programatically set (using expressions, variables) the FastLoadMaxInsertCommitSize property of an OLEDB destination in a data flow for Fast Load Operations. Basically, what I want to do is based on the # of records which are going to be inserted want to set the FastLoadMaxInsertCommit size. FastLoadMaxInsertCommitSize is not an expressionable property, so you can't use expressions, variables etc. to set it. Feel f ...Show All

• Mindaugas Luko?ius performance has been decreased after migration.

  Hi, I have migrated my database from sql server 2000 to sql server 2005, for migration i have backed up 2000 database and restored that into sql server 2005 databse. when we are running following insert query is 50% slower in sql server 2005. truncate table Table1 print getdate() INSERT INTO Table1 SELECT CONVERT(INTEGER,cust_id ), store_id, MAX(Buydate), COUNT(*) FROM Table2 (NOLOCK) GROUP BY cust_id, store_id print getdate ...Show All

• win- Executin SQL statement from variable in functions

  Hello  All Within my function depends on value forming a SQL statement As Example set @SqlString = 'select ' + @ColumnName + ' from ' + @tableName + ' where ' + @whereCond How can i execute this Statement. within function Thanks in advance RK I can change function to stored procedure  within storedprocedure how can i execute a dynamic SQL  My requirement is to open cursor with dynamic SQL. table name, ...Show All

• vegasrockstar SQL2005 equivalent of the data import task in SQL2000

  I had to upgrade to SQL2005 when my customer did so. Everything went OK until I had to load additional data to the datamart. The SQL2000 task to load data from flat text files was straight forward and literally took me seconds tyo set up and execute and has never given me problems. I have now spent 3 days straight trying to do the same in SQL2005 going in ever wider circles. I have got SSIS up and going, I saved a dtsx package that won't run wit ...Show All

• Mike Warren How to pass .net application's parameter to a TRIGGER?

  How can i pass my .net application's Userid to the trigger I have a audit trail trigger on myTable.  I dont know how to pass the userid (not the sql server user) to the trigger when a user delete a record from the application(.NET Application). The trigger saves the modifications on the table including the userid of one who does the changes. create table Logins ( -- Your system's user ID userid integer, -- SQL se ...Show All

• Rajesh Procedure call from 2000 to 2005

  Hi is it posible to make a procedure call from an SQL Server 2000 instance to a SQL Server 2005 instance. I believe this is posible by registering the 2005 instance as a linked server with 2000 but so far have had no luck with this Thanks Sorry about the last post. It will work only if yu are executing queries. for Stored Procedures you need to execute one more statement. The code block is SQL2005 S ...Show All

• dougde How to uninstall SQL Server 2005 Sept CTP and install SQL Server 2005 April CTP?

  I installed the following components in my laptop in this order: 1. .NET Framework 2.0 Redistributable Package (x86) (From microsoft website) 2. SQL Server Express 2005 September CTP 3. Visual Studio 2005 Beta 2 Version (I have the DVD for this) I realised that SQL Server Express 2005 September CTP is not compatible / does not work with Visual Studio 2005.  Visual Studio 2005 can only be used together with SQL Server Express 2005 APRIL CTP ...Show All

• Anjana Mazumder MSFT Install of SQL express edition with vs2005 pro

  I was able to install and use the vs 2005 for the first time today, and it was so far, so good! However, I would like to know more about how it setup my SQL 2005 Express edition when I installed the full package of vs2005.  What I would like to specifically know  --  if the instance is using my Windows Authentication, or what the "sa" password might be. When installing vs2005, it automatically installed SQL Express 2005, without p ...Show All

• Paola80 OLE DB & SQL

  Does anyone know why SQL doesn't work properly in my OLE DB component Underlying DB: DB2 Provider: IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider If I insert some SQL I get get a preview of the data but it errors when I run it. [OLE DB Source [1]] Error: An OLE DB error has occurred. Error code: 0x80040E00. [DTS.Pipeline] Error: The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. The ...Show All