Answer Questions

• NBtech SQL Server Management Studio Express CTP - not working

  The SQL Server Management Studio Express CTP application is not working anymore after having done so for a day. No messages, nothing when I double click the icon. Everything else seems to be working OK. I have tried a de-install and reinstall with no success. Some of you who know where to start looking Regards TorB. I cleared the cache on both Explorer and Firefox.  I get the same results every time.  ...Show All

• Diml http://localhost:8080 does't work??

  Im trying to set up an reportserver in my newly installed 2005-enveriment. But i can't get the report/reportserver to work when i brows to http://localhost:8080 i get an treestrukture off the website, but not the site Do i have to reinstall my reportserver or are there anyone who can help me It have been working, but suddenly it doesent I don't know if my applicationspolls are correct insalled either I DID NOT UNDERSTOOD ANY OF ...Show All

• ZeeMan48 Data Access very slow in .net as compared to VB

    Hi, I have migrated my app from VB to VB.Net. A 3-tier app with remoting and COM+. I am experiencing a long wait time of about 3 times higher than what it would take in the VB App. I am using DataAdapter.FiLL method to fill the datatable. I have tried. Using DataReader ( Made the things worse ) Using BeginLoadData and EndLoadData Creating a Dataset and calling fill with the dataset so that the round trip to the midd ...Show All

• Dasbose Passing connection managers to subpackages.

  Is there a recommended way to pass the connection managers from the parent package to the subpackages I also noticed that the subpackages can't reference the same configuration file as I get error messages when I try to build the solution. After I changed the configuration file for each subpackage it worked just fine. Did I miss something or is this intended to work this way thanks Hi, when you say "passing th ...Show All

• CScs Insert into more than one table

  I have this select command SELECT intUserId FROM tblUser I want to insert every intUserId into tblUserBla,tblUserBla2 I know that i can do this INSERT INTO tblUserBla (intUserId) SELECT intUserId FROM TblUser But, how can i perform a insert into tow tables, in one statement But how can my trigger get my intUserId Thank you very much ...Show All

• Anonymous111111111111111 SSIS custom component will only partially update in VS causing debugging to fail

  When I try to debug the break points will always say the source code is different from the current version, but the custom component in the GAC has the new version number. The other strange thing is the toolbox will not reset to the original version meaning it will not remove the custom components. The funny thing is after I compile the custom components and restart VS the custom component runs with the new code changes. I can see the new fea ...Show All

• dnilepharaoh Copy Database from 2000 to 2005 using Copy database wizard

  I am trying to copy a database from 2000 to 2005 using the copy database wizard. I am a sys admin on both the source and destination server and am using the windows auth method and sql management object method. I am not copying any database objects. Following is the report: Any suggestions Performing operation... - Add log for package (Success) - Add task for transferring database objects (Success) - Create package ( ...Show All

• bcbs_tony Guids as primary keys

  Is it a good idea to use Guids as primary key. What is the impact on performance. Guids are random by nature that may have an impact on writing clustered index. Any comments or suggestions Yes, a GUID is bigger than an int, and it's not really readable, but it is still the best choice as a primary key, if you take following guidelines into consideration: . Do NOT create a clustered index on the GUID primar ...Show All

• chiefmsb OLE Db Destination task in ASYNC_NETWORK_IO wait state

  I have established an SSIS dataflow that should move 20,000 records from a source table to a target table.   Only new records should be added to the target table – existing records should be ignored.   The problem I am reporting occurs when the target table is initially empty (there are no existing records, so everything should come over).   I am using the Slowly Changing Dimension task to limit inserts to new records.   The ...Show All

• NewSQL2005 User ODBC From Access to SQL Connection Wizard will not come up.

  When I choose ODBC from the link tables wizard it just disapears. No error message at all just poof. Any one have any ideas Thanks Matt, the problem was solved by Robert Beaubien in another forum as I noted above. The problem occurs when Turn Office Plug-in On is checked in Norton Antivirus 2006. I recently upgraded to Norton 2006. I turned that option off, restarted it and Access and the ODBC connections ...Show All

• StephenBarclay "product level is insufficient" message during flat file import

  I'm using the import wizard to create a new table from a flat file source.  The table gets created but no data gets copied.  What's wrong   Here's the report: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Error)    &nbs ...Show All

• matvdl Registering assembly in SQL Server 2005

  Hi, I have created a C# stored procedure that has a typed dataset (XSD). When I try register that assembly in SQL Server 2005, I am getting the following error.  CREATE ASSEMBLY failed because method "add_InvoiceDTRowChanging" on type "InvoiceDTDataTable" in external_access assembly "SS.StoredProc" has a synchronized attribute. Explicit synchronization is not allowed in external_access assemblies. (Microsoft SQL Server, Error: 6213) ...Show All

• Jeff Ulrich Losing Oracle user name and password

  I have written a simple SQL Server 2005 package to pull some data from Oracle (using ODBC) and pumping it into SQL Server. When I run it from the server in debug mode in VS it works fine. When I schedule the job it errors out with "ora-01005: null password given; logon denied." The password is there. Has anyone experienced this Is there a security setting somewhere preventing me from saving passwords Is there a work around Thanks. ...Show All

• Ashish757 how do i get date into dd-mm-yy format??

  i have the following in an insert stored proc CONVERT(CHAR(8),GETDATE(),10) but this inserts 03-06-06. how do i get it to 06-03-06 Cheers, Craig Probably by setting the machine you're running on to run in a time zone where this format is standard my sp is as follows:- IF (@blnConsent = 1 AND @dteActualConsentDate <> NULL) --This is PC insert for YES consent where a ConsentDate is suppl ...Show All

• stevenng columns order in entities

  Hi friends i've report model with entities that depend on views. my question is , currently all columns in a entity in the same order as view has them. i mean if i have a view like below create view vname as select name,addess,status from mytable when i create entity based on this i get attributes in this order name,address,status but i want address,name,status how can i change it to alphabatical order i know i can change manually in model desi ...Show All