Answer Questions

• timesscar SQLserver2005Express post-install problem

  Hi I have installed a single instance of SQLserver2005Express on a stand alone PC running WinXP Pro. Do you always have to be logged in as a Windows [XP] administrator to work with SQL Server databases Because when I'm not it SQLserver Management Studio won't allow me to open any database. Also, do all databases have to be in the default data folder location [in my case this is: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data] ...Show All

• Juliana Low Need help with a simple query

  Hi Everyone: I am new to SQL, and I would like to request if someone could provide me with a query that could do a find and replace in a column in MSDE. I have an image path column in a table, the current image path is set to /images/xxxx.gif I would like to add another folder so the image  path looks like this --> /images/imagesA/xxxx.gif The problem is i have 4500 records to update, so I cannot do this manually, so my quest ...Show All

• DanGav Sum is negative - showing #Error

  I have a SSRS (reporting services) 2005 report. In one of my table fields I have the expression below. I want it not to show #Error when the sum of this expression is negative, rather provide a negative sum if that's the case. (SUM((IIf(Fields!New_Old_CC.Value = 0, Fields!PDC.Value, 0) + IIf(Fields!New_Old_CC.Value = 1, Fields!PDC.Value, 0) + IIf(Fields!New_Old_CC.Value = 0, Fields!CC.Value, 0) + IIf(Fields!New_Old_CC.Value = 1, Fields!CC.Value, ...Show All

• Bob Black How do create table from Excel (based on Excel column name) and import data from it?

  l've the following situation, l've some excel files controlled by Vendor which changing frequently. The only thing does not change is the header name of each column. So my question is, is there any way to create a new table based on the excel file selected including the column name in SSIS So that l can use the data reader as source to select those columns l am interested on and start the integration. Thanks. Regards, Yong Boon, Lim p/s : The ...Show All

• Eudora Connection String to connect to SQLServer Express?

  Hi I've been trying to get DotNetNuke to connect to a SQLServer Express database but no luck. I've had no luck with info from their forums... The connection string I'm supposed to use is: <add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient" /> I ...Show All

• EP User dynamic SQL function for string (or value) combining from relational table into a flat view

  Hello! Here's my question: I have three tables; 1. Event table IDEvent     Date                 Description 1              10.01.2005       test 1 2              10.01.2005       test 2 3              18.01.2005       test 3 2. Customer table ID ...Show All

• Daqing Unable to connect client to Server

  I think I'm having a problem with the OBDC connection to the SQL Server. I get an error message in the application log: SQL Server ODBC driver support error. Any ideas I have tried unloading and reloading the client software and also with the .NET 1.2 and tried 2.0 and nothing.... HELP Can you uninstall and re-install sql server native client please Are you using regular ODBC or SQLNCLI I got it to work :) I had uninstall and reins ...Show All

• Frosty1_4me Standby Restore

  I'm setting up log shipping and am running into an issue with applying the transactions logs. This is my 5th server that I'm setting up and I take a backup of the source database, restore it with replace on the standby server. Then I take a log backup, copy it over and try and restore on the standby server, but the LSN#'s are off. It tells me it's too late for the log and try an earlier.. The timestamp on my backup is 11:43 and my tran ...Show All

• senaka Failure installing SQL Server 2005 SP 1

  Windows XP Pro SQL Server 2005 Express SQL Server 2005 Standard I installed the service pack for SQL Server Express first. Then I tried to install the service pack for SQL Server. I got the error message, "A recently applied update, KB913090, failed to install.", while it was upgrading the Setup Support Files. Jonathan Allen Log follows... 04/22/2006 10:52:34.781 ========================================================= ...Show All

• kieseennaam Handle TEXT FIELDS in Recordset Using ASP

  hi there, I have a problem when i tried to get data from mssql server using recordset in asp language. For example, i have table containing 5 fields. One of them is  text field and the rest are varchar. here i list the table structure (table name: Info ): Field Name                          Field Type &n ...Show All

• Slaine Apache and SQL Reporting Services

  Hi Everyone, I'm pretty new to reporting services so this might be a dumb question.... A client of mine has asked me to use reporting services to create reports for them but they have apache web servers!!!! Is this even possible I've seen tons of documentation on reporting services by now but none that says you can use it with Apache The Apache servers all have .NET 1.1 installed and working but I'm not sure if that's enough to get thi ...Show All

• Waiman Li connecting to sql server 2000 from sql server 2005 management studio

  My web site is hosted by a third party, and the back-end is a sql server 2000 database. I was routinely running queries over the internet against the database using Query Analyzer. I just installed sql server 2005. Is it possible to run a sql query against a table in the sql server 2000 database from within sql server 2005 management studio I haven't found anything in the docs explaining how to connect to sql server 2000. Any help would be appre ...Show All

• Martín Misol How reliable is Microsoft's type4-JDBC driver for MsSQL Server????

  Hai Friends,     I am using MsSQLServer in the backend and java in the front-end.      How reliable Microsoft's type4-JDBC driver for MsSQL Server     I am very afraid as its only a beta version and version 1.0 and my project is a commercial one.   Is there any other better type4-JDBC driver for MsSQLServer available -which i can get for no cost-free of cost.   ...Show All

• Dion Le Roux Transfer SQL Server Objects Task doesn't work with schemas

  The task has a fault if you try to copy a table with a schema like [test].[table1] The error says Error: 0xC002F363 at Flyt til DM, Transfer SQL Server Objects Task: Table "table1" does not exist at the source. Even though i just selected it from the table list minutes before. Just confirming what you already know and putting my vote in for this to be fixed. It seems to only work if ...Show All

• tapir How to create a new SINGLE file .mdf in SSMS?

  It is easy to create a new .mdf in VS "add new items" or via the connection GUI. How do I do that in the full version of SSMS(connecting to the SSE instance of course) What about if there was no SSE, only a full version server instance. I know I can attach an existing .mdf, but what about creating a new one   Thanks for the reply - Steve.. As soon as I get some time to look into this ...Show All