Answer Questions

• BUET Freshman Converting @myString to @myInt

  Here's a fun one.  BOL says that using CONVERT or CAST to change a string into a number won't work. The following "works" and I'm assuming it is because the compiler can verify that the string value is in fact a number, even with the Unicode N: declare @col2      int select   @col2 = convert ( int , N '12345' ) ====================================== Here's what I need to work, or I need a creat ...Show All

• JoGo How can I sort on an aggregate

  My report groups up visits to an ER room so we can look for possible "medicaid abusers of the system". So if the have more than 40 visits in the last ninety day we need to look at there claims. What I did what for each Patient's ID I get a count of there claim's id (fields!claimid.value) and that count is in the PatientID group's header. Now I am having a terrible time getting the report to sort on the count of the claimids so that pat ...Show All

• aC#Dummy Log file - failed MSDE SP4 Installation

  Hi, I tried installing MSDE SP4 on a windows 2000 Server. Unable to deploy..getting error "The instance name specified is invalid" Then tried installing with the following; setup /upgradesp sqlrun DISABLENETWORKPROTOCOLS=0 /L*v C:\MSDELog.log The log files indicates; 1] SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-E141-427A-AB0C-D3605127224A} TempFolder is C:\DOCUME~1\thp-mgb\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D36051272 ...Show All

• winniecherian Can I Attach a database with SMO?

  I just developed a solution locally, I would like my installer to attach a database on the CD and then  modify the web.config,   I am interested in learning how to attach it programatically with SMO Thank       Thank you very much. I love ya.. just kidding. Here is a very simple example: using System.Collections.Specialized; using Microsoft.SqlServer.Management.Common; using Micr ...Show All

• Elmer_927 HELP - Cannot connect to SQL Server 2005 Express

  I've installed the SQL Server 2005 Express and also the MS SQL Server Management Studio 2005 Express But when i load the latter and try to connect to my database I get the below error message. TITLE: Connect to Server ------------------------------ Cannot connect to DEVCOMP\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 20 ...Show All

• tovvenki Copy data from one table to another

  On the OLE DB Source, I have as following: select field1 , field2 , field3 from table_source On the OLE DB Destination, I used fast load option with table lock checked, and check constraints to copy data to table_destination. Both table_source and table_destination have the same table definitions. After the dtsx package ran, the number of rows copy over to the destination is not same. I got different results from different runs. This ...Show All

• RLHayesxx Management Studio for SQL Server 2005 Standard

  I'm new to SQL Server and am just getting started with it. I received a copy of SQL Server 2005 Standard edition from the Launch Party here in Ottawa and successfully installed it on my server yesterday. I've look around the Internet, as well as the DVD for SQL Server Management Studio, but I have been unable to find it. The only thing that I have been able to find the the Management Studio Express which targets SQL Server 2005 Express. Can some ...Show All

• webmote Using SQLExpress Manager to Create Database

  I got this error message when I tried to use an alternative place for the data files, I have checked the permissions on the destination directory, and I can't see any reason why this would happen ============================================= Create failed for Database 'Database_1'.  (Microsoft.SqlServer.Smo) ---------------------------------------- For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft SQL Server&ProdVer= ...Show All

• CLM10270 Installing sql express on a sql standard server installed machine

  Hi, i have sql server 2005 standard installed on my machine. I want to work on express edition and learn about it but on the installation its gets stuck because a higher version is installed. If the express version is free why cant have both versions installed on my machine. Thank you. Sorry to have to contradict here, but there is nothing that should prevent you from installing Express and Standard on the same computer, many people do th ...Show All

• Abu S. Md. Ismail June CTP: Fantastic! Now...

  Ok, so I'm downloading the June CTP from Betaplace right now.  And of course I'm greedy :) Will this version interop with Vs.net 2005 b2   Is there a new Vs.net 2005 CTP coming Same old request as always :) Please let me know how did you find out the .net framework version for June CTP The actual version of .net framework in June CTP is 2.0.50215.312 and is ofcourse greater than the .44 in April CTP. ...Show All

• ekekakos AMO Connection

  I'm sorry for this newbie question, but I can't find any other help and I can't figure out how to solve this problem. Hope someone can help me: I want to connect to a SSAS Server in order to detect the databases. However, I don't know how to connect to the server in SSAS. Whenever I connect with server.Connect(string), I get this error message: I'm not much of a VB guy:) maybe it should be something like:    ...Show All

• David Navarrete Oracle Problems...

  I get: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'ODBC'. (rsErrorOpeningConnection) Get Online Help ERROR [HY000] [Oracle][ODBC][Ora]ORA-00604: error occurred at recursive SQL level 1 ORA-12705: invalid or unknown NLS parameter value specified ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Oracle][ODBC][O ...Show All

• Jerry8989 Data transformation services

  How to start "Data transformation services" using Remoting (over the net) What are you actually trying to do DTS is just a set of COM objects, tehre is nothing to start, there are objects which need CoCreated. ...Show All

• glenna Suggest Column Types

   Is there a parameter/ registry setting I could use to change "Number of rows" in "Suggest Column Types". Number of rows to scan is defaulted to 100. I believe the maximum rows you can set to 1000. If you try to set anything more than 1000, system will change from what ever you set it back to 1000. I came across this problem during testing. I was wondering anyone else came across this and how they resolved it! Thanks Sut ...Show All

• Kyle J. No TRIM function in 2005 - are you serious!?

  I cannot believe that there is yet another version of SQL Server without a TRIM function.  So for SQL 2005 (like I've done in 7.0 and 2000) my T-SQL will look like dog poo because I will have to write LTRIM(RTRIM(MyValue)) anytime I want to remove whitespace from both ends of character values instead of just writing TRIM(MyValue). Microsoft - how can you write LTRIM and RTRIM and not write TRIM in the same breath an ...Show All