Answer Questions

• jaimeBetancur Licensing for a web server

  What kind of license do I need to run a single web site on a web server that needs SQL server to operate it's a public site that runs DotNetNuke but it's the only site on that box. *BUMP*.. Still need to know what kind of SQL license I need to run a web server with one website that requires a SQL server. If you want to use anything more highlevel than SQL Server Expr. you have to either license every single user (which is compli ...Show All

• Justin-Josef Angel SQL Server 2005 basics

  I have used SQL server 2000 running queries and ran some basic queries for creating database. I installed Microsoft SQl 2005 and now I a bit confused. Where can I find my Query analyser and Run the query and execute it. 2000 had a simple and neat designs for simple execution but what about SQL 2005. Any suggestions Its a silly question but I need to run one project and I am not able to run SQL. Any help apprectaied I tried going to this ...Show All

• Raghavendra Naik SQL DB Connection or Query Problem?

  The best way to state my question/problem is to describe the sequence of events that I am seeing. Here goes: 1. I have a SQL Server 2000 database hosted on a remote server. 2. My web server is also hosted remotely and has a connection to the sQL database. 3. I go to my website (like any other user) and view an ASP page with a recordset. The page returns fine for 8 to 10 requests and then errors and returns a timeout. 4. I call my h ...Show All

• pbert78 How to reduce the time when using a variable

  Hi, I have a table with column value like '123 345 678 143 648' like that. What I need to do is I have to take each code value and put it as a new record in another table. So, if I say 'Select substring(column_name,1,3) from table' then it is very fast (fraction of second). But since I need to take each code and the # of codes in each record may vary, I am using a while loop to take each code and so I delclared a variable @i and now my select ...Show All

• _carlos Should I uninstall SQL Server Management Studio before...

  ...installing SQL Server Express Advanced Or before installing the Toolkit Or should I just leave it there and everything will be ok Thanks! It is probably a good idea to uninstall SSMSE first. There is a known problem where uninstalling SSMSE will cause a failure in Visual Studio, this is documented in the readme and in a KB artilce. You need to make an update to the registry to address the pr ...Show All

• hoogli Search with %t%y% => Error, %ty% => ok...

  Hi! I have a problem with a Select statement: In a ordinary table there is a column called NAME. I want to make the following search: SELECT * FROM TableName WHERE NAME LIKE '%t%y%' this should give me all entries that have a "t" and a "y" in the NAME column. However, it gives me no entries. If I instead run this search: SELECT * FROM TableName WHERE NAME LIKE '%ty% it gives me the correct result. Since the wildca ...Show All

• Everett McKay SSIS issues

  1. After loading package into msdb, how to schedule package as sql job in SSMS Possible to do it same way as in sql2k EM or should do it in Visual Studio 2. How to save package into msdb directly in Visual Studio 3. I have sql2k5 developer edition installed on two win xp boxes. I can connect to SSIS without problem, but got following error on both boxes when click on msdb: TITLE: Microsoft SQL Server Management Studio -------------------- ...Show All

• pdmahaf Unable to restore DBs in SQL Server 2005 from Express

  Hi all, I'm unable to restore DBs (I've created in SQL Server 2005 Express) in SQL Server 2005. The error I get is (copied): TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'D_EDTIMD027SW'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft SQL Server&ProdVer=9.00.1187.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplate ...Show All

• superporky Help with setting Algorithm Paramteres

  I was walking through the Text Mining example - which at one step required me to set Algorithm Parameters - MAXIMUM_OUTPUT_ATTRIBUTES=0. When I tried that the project would not build giving an error - Error (Data mining): The 'MAXIMUM_INPUT_ATTRIBUTES' data mining parameter is not valid for the 'XYZ' model. I was getting the same error when I tried to set it for Microsoft_neural_netowrk - Hidden_Node_ratio. When I do a properties from "set ...Show All

• whattapain Using equal operator in transact-SQL for ntext datatype column

  Hi, I've a problem with using equal operator in transact-SQL for ntext datatype column. (SQL Server 2000) I'm using the following SQL command text. use Northwind Select * from Categories where Description ='Seaweed and fish' If I use 'like' operator intead of '=' then the qurey retuns correct value. Any idea about this Any help is appreciated. Regards, Julia From books online, index ...Show All

• Krishna Paripurnam Logging - What events are relevant to everyone?

  How is everyone using the logging features of SSIS What events are relevant to day-to-day operation Currently we are logging all events except for Diagnostic to a SQL table, and then using event log reporting. What would be the appropriate events used for a production environment Andrew, There's no right or wrong answer to this but I use: OnPreExecute OnPostExecute OnInformaiton OnError OnWarning I haven ...Show All

• prudhvi How Can I Do This Better in SQL 2005?

  I have two tables, one contains ids(very small, less than 100) and the other contains history(very large, over 1000 mil); table a (id int) table b (id int, contact_datetime datetime, id2 int, id3 int) I need to pull latest contact date and other id fields from table b fastest possible. in 2000, I did following sql query, select a.id, b.contact_datetime, b.id2, b.id3 from table a inner join table b on b.id = a.id where b.c ...Show All

• Yassir Zoheiri Cross Walk Report Issue

  We have crosswalk report displaying matrix of rows and columns. The report doesn’t show up correctly in Report Viewer Control. Anyone noticed this before About the half of the Crosswalk report gets cut off When we checked source of rendered report, there are lot of incorrect HTML table cell rendering such as no closing tags. This issue occurs only when we view report in report viewer control. It appears fine when we export or print previ ...Show All

• vidya2002 Thesaurus support in SQL Server Full Text service

  Hi,   I’ve been trying to add keywords to the thesaurus used for SQL Server 2005 Full Text services but do not seems to get any improved results. For example, I have a catalogue of article titles which contains titles such as ‘CRM’ and then some others use the words ‘Customer Relationship Management’, the ideal solution I would have thought was SQL Servers thesaurus support, I’ve been though and added the values:   ...Show All

• w4t4fAk I need SQL Server2005 Standard Edition with my SBS2003R2

  How can I get the SQL Server2005 Standard Edition when I upgrade my SBS2003 to SBS2003R2 I'm no expert on SBS but it looks like upgrading to R2 gets you SQL Server 2005 Workgroup if you're on SBS Premium. Upgrading from Workgroup to Standard would probably entail purchasing SQL STD and then doing the install. But I have no idea if this would be a good idea or if it would even be supported by SBS. You shoul ...Show All