sql server 2005 express

SQL Server Express

Index ‹ SQL Server

- Previous
  - 1
    - Changing SQL Server instance name Hi Is it possible to change the name of a SQL Server instance on a server running multiple server instances Or must the server be reinstalled Rgds Bertrand Tag: sql server 2005 express
  - 2
    - Add calculated row in the middle of dataset Hello all, I have a problem. I have a stored procedure that returns result like this: Code Snippet Date Category Daily MTD 05/01/07 Cat1 $111 $1212 05/01/07 Cat2 $121 $1412 05/01/07 Cat3 $131 $1312 05/01/07 Cat4 $141 $1312 06/01/07 Cat1 $111 $1212 06/01/07 Cat2 $121 $1412 06/01/07 Cat3 $131 $1312 06/01/07 Cat4 $141 $1312 I need to create report based on this sp but I need to add aditional calculation: Code Snippet 05-2007 Cat1 $111 $1212 Cat2 $121 $1412 Total %for Cat1 %for Cat2 Cat3 Cat4 Total %for Cat3 %for Cat4 SubTotal 06-2007 Cat1 $111 $1212 Cat2 $121 $1412 Total %for Cat1 %for Cat2 Cat3 Cat4 Total %for Cat3 %for Cat4 SubTotal I can't figure out how to add these calculation in the middle of dataset... Thank you. Tag: sql server 2005 express
  - 3
    - SQL Server Windows Auth for ETL called by CreateProcessAsUser Here's the summary of the steps we've taken to set up Kerberos. I. Force Kerberos authentication to SQL Server ( http://support.microsoft.com/kb/909801 ) 1. As domain administrator, set the following SPNs - setspn –a MSSQLSvc/dbhostname:1433 dbaccount - setspn –a MSSQLSvc/dbFQDN:1433 dbaccount where dbhostname is the hostname of the SQL server dbFQDN is the fully qualified domain name of the SQL server dbaccount is the domain account for startup of the SQL services 2. Remote connect to the SQL Server via SQL management console and execute “select auth_scheme from sys.dm_exec_connections where session_id=@@spid” to check Kerberos is used for authentication II. Force Kerberos authentication to IIS Server ( http://msdn2.microsoft.com/en-us/library/ms998297.aspx ) ( http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/kerbnlb.mspx ) 1. at IIS Server, run “aspnet_regiis -ga iisaccount” where iisaccount is the domain account for startup of the IIS services 2. Add iisaccount to the local “IIS_WPG” group 3. Ensure iisaccount has the following local privileges -Act as part of the operating system -Impersonate a client after authentication (granted via IIS_WPG) 4. Change the Application Pool Identity to iiaccount 5. Change the web “Authentication and access control” to Integrated Windows Authentication 6. run “adsutil set w3svc /ntauthenticationproviders negotiate, NTLM” to force precedence of Kerberos over NTLM 7. As domain administrator, set the following SPNs - setspn –a HTTP/iishostname iisaccount - setspn –a HTTP/iisFQDN iisaccount 8. Check Security folder under Event Log for Authentication Package=Kerberos for access to the web site. III. Enable constrained delegation between SQL and IIS ( http://msdn2.microsoft.com/en-us/library/ms998355.aspx ) ( http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerbdel.mspx ) 1. As domain administrator, enable “Trust Computer for Delegation” to “MSSQLSvc/dbhostname:1433 dbaccount” for iisaccount & iishostname (CIFS-common Internet File System service is required for access to file share) 2. As domain administrator, ensure all user accounts have “Account is sensitive and cannot be delegated” cleared 3. Define connection string to the SQL DB at the ASP.NET configuration 4. Use Windows authentication at the ASP.NET configuration and ensure impersonate="true" was set at web.config 5. Test connect DB via IE and a Kerberos connection from iishostname should be found by running “select * from sys.dm_exec_connections” via SQL management studio Tag: sql server 2005 express
  - 4
    - import rpt file to SQL Server 2005 hi, FahimatMicrosoftForum wrote: Thanks for your reply, I am currently doing like this, -- take comma delimited file. -- convert into rpt file using Excel -- manuall insert to Access database table. now I want to upgrade this process to -- SQL Server 2005 ( i know how to upgrade database to this engine) -- Insert rpt file to SQL table now ( from front end ), if you want to insert "files" into a database table, you can perhaps bulk insert them... or you can deal the task via client code, reading the files into memory and passing the resulting byte array to the Transact-SQL command specified for the INSERT INTO operation.. i hope my question is clear. absolutely not... at least not to me regards Tag: sql server 2005 express
  - 5
    - A connection could not be made to the report server http://localhost/ReportServer. Did you try filemon Here are some detailed steps to troubleshoot. http://tinyurl.com/3647cg Tag: sql server 2005 express
  - 6
    - create view on sql 7 from sql 2005 hi i need to create view in sql 2005 db from table in sql 7 db when i try to connect to the sql server i get this messeg: This version of Microsoft SQL Server Management Studio can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg) there is away to resolve this problam yaakov Tag: sql server 2005 express
  - 7
    - Check the size of individual table in the database See your other posting for my response. Tag: sql server 2005 express
  - 8
    - Maximum Value The first solution almost worked but it had the problem that when there was a code that only had one value, it got omitted. The second solution I have never done before so I'm having some problems implementing it. Tag: sql server 2005 express
  - 9
    - IE7 script error when opening Infopath forms Hi, I installed IE7 recently and it is giving me problems when I open Infopath forms to edit documents. I have a sharepoint website which contain links to these forms, when I click on the link it opens the infopath form. It was working absolutely fine when I used IE6. But now when I open the infopath form it gives me an error saying that A Runtime error has occured Line: 38 Error: Object Expected When I open it in the debugger it shows me an error at <body onLoad="onLoad()">. Could someone please advice! I appreciate a quick response. Thanks Tag: sql server 2005 express
  - 10
    - Still have Problems with (sometimes) Suspend Express Hi there, i have still some Problems with the SQL Server Express. Sometimes (not always) it seems that the SQL Server Express "sleeps" I write through my application every 60 seconds some values in a table , but somethimes it seems that the server is not reachable and i cannot wrote the data. but the phanomen are only happens for a record , the next time it works fine. (i check always for a open connection) if i cannot write the data , it seems that the connection is "away" and i reopen it. after that everything works i have also try with the sql server auto close to false but with no success. what could that be greetings Tag: sql server 2005 express
  - 11
    - Using full text search with keywords from a column Hi all I am trying to find a solution for using a full text search from a keyword column. The scenario is email subscription service, where the users specify keyword as a subscription parameter. The desire is to get all subscription data in one select statement. To see what I am trying to do please look at the example below: SELECT * FROM SubscriberTable st INNER JOIN DataTable dt ON {Some Condition} WHERE CONTAINS (dt.TextColumn, st.KeywordColumn) Any help is greatly appreciated Regards, Salavat Akhmediev Tag: sql server 2005 express
  - 12
    - Top 10 Chart grouped by Month Hello, I have a bar chart that I need to show the top 10 items by Month. What I get currently is a chart by month with the total Top 10 Items (rather than the top 10 per month). I have tried adding a scope onto my Value expression but that didn't help. =countDistinct(Fields!incident_ref.Value, "catGrpDate") Please Help! Tag: sql server 2005 express
  - 13
    - IIF and multi-valued parameters Hi i have a report that can show upto 8 charts, dependant on the selection(s) made in a multi-valued parameter. basically, the report gets loads of data back from DataCube. if the user has selected (for example) 2 categories in the multi-valued parameter (e.g. "beverages" & "confectionary") , the the first chart will show the results filtered for "beverages" and the second chart will show the results for the "confectionary" category. but i want to hide any charts that are not used - i.e. the user only selects 3 categories, i want to show 3 and hide 5 charts and am trying to do this with IIF in the FILTER properties of the chart so for each chart, i am checking to see if a Category selection has been made for that chart - and if it has, filter the results and display the chart. if no selection has been made, then filter the results for "XXXXX" (no data with this category) am doing this by trying to get the selected value or "xxxxx" if noting selected to hide the second chart when only one category has been selected, tried e.g. for the third chart =iif( Parameters!LOOKUPITEMCategoryDescription.count>2, Parameters!LOOKUPITEMCategoryDescription.Label(2), "xxxxx" ) doesnt work - gives an #Error as a reult But it works fine when there are > 2 categories selected also this works fine when there is 2 or >2 category selected =iif( Parameters!LOOKUPITEMCategoryDescription.count>2, "more than 2" , "not more than 2" ) it would appear that IIF is trying to evaluate the TRUE condition(Parameters!HydraCORELOOKUPITEMCategoryDescription.Label(2)) even though the condition is false !!! help please thx Tag: sql server 2005 express
  - 14
    - Keep TableRow Together Hi, Sorry to be long... So, it don't resolve completly my problem. For now, all lines are grouped, so this part is ok. I have 5 lines, each have "Can decrease to accommodate contents" checked. So when Hidden property is set to True, there is no blank line. But, the tablerow seem to have a static Height and no "Can decrease to accommodate contents". What could I do to get one or to simulate one Thanks, Marco Tag: sql server 2005 express
  - 15
    - howt to change ConnectionString in Context Hi, that is dedicated to your permission level. You will have to allow EXTERNAL_ACCESS for openeing another connection beside the context connection. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Tag: sql server 2005 express
  - 16
    - How do I manage this mess? Thanks! Say for example I have the following 2 database tables, the first one contains the old employee data, and has the fields shown below: oldEmployeeID FirstName LastName DateOfBirth HiringDate TerminationDate and another one containing the new employee data with similar fields but instead of oldEmployeeID, it is showing the newEmployeeID. During the conversion process, something were messed up and instead of putting in the original hiring date of the workers into the new employee database, the conversion date was put in, which, depending on the mood of HR ladies, could be any date, and at the same time, of course, new employee join the company, and we assume their hiring dates were entered correctly. On top of that, there are some employee who were terminated before the conversion took place but we still need to keep a record of that. And I created a third table, say, emplyeeAll with similar fields to the employee data tables. So here is what I need to do: if the firstName, lastName and DateOfBirth in the old employee data table and the new employee data table matches, I would assume they are the same employee, hence I would put the information for the employee obtained from the new employee data table to the employeeAll table, with the Hiring Date changed to the Hiring Date of the old employee data table (and do not copy the record from the old employee table to prevent duplicates), otherwise, I would simply copy and paste the data in new and old employee table to my employeeAll table. I know this is really confusing, but...well...hope you know what I am saying... Is it possible to have a SQL statement for all these If so, how should the statement looks like Thanks a lot! Regards, Anyi Tag: sql server 2005 express
- Next
  - 1
    - LEFT JOINING two INNER JOINS My regrets if I came off 'too strong'. Yes, it will work as you have presented the code. If you examine the execution plan, you will see that both INNER JOINs occur, and then there is a LEFT JOIN between the sets. It is acceptable. However, I would clearly leave documentation (Comments) in the code since most folks will not have seen this particular permutation, and won't understand what is occurring. There definitely is a different result than just the 'normal' INNER JOIN ... ON INNER JOIN ... ON LEFT JOIN ... ON INNER JOIN ... ON It is clearly acceptable if it provides the resultset you desire. Tag: sql server 2005 express
  - 2
    - index replication from DB2 I misread your posting... I think that's the question for DB2 Replication forum. Regards, Gary Tag: sql server 2005 express
  - 3
    - Flat file to table - rows out of order There are many factors that influence the order in which rows are returned. The most obvious being the presence of indexes. Other possible causes may be the number of processors, what data is cached, datafile placement, datafile fill factors, hard drive configuration. There are a million and one things. These same factors that affect the retrieval of data can also affect the insertion of data. Hopefully you can see how the order in which data is retrieved can be affected. There is no concept of order in a database table. Period. -Jamie Tag: sql server 2005 express
  - 4
    - SQL Server install That could be permissions related covered below by Microsoft and Partners. http://www.iis.net/articles/view.aspx/IIS7/Deploy-an-IIS7-Server/Installing-IIS7/Install-IIS7-on-Vista http://msdn2.microsoft.com/en-us/vstudio/aa972193.aspx Tag: sql server 2005 express
  - 5
    - stored procedure parsing comments incorrectly For a second time I encountered a strange problem with a stored procedure, which is simply not parsing and executing correctly. On both occasions the problem occurred with pretty long stored procedures - the one I have now is 2000 lines long. The first time I saw this I was working on SQL Server 2000, now I have a SQL Server 2005, but the database is in SQL Server 2000(80) compatibility level. The problem is that a regular SQL comment is sometimes merged with the line under it. --some comment some SQL code is parsed as --some comment some SQL code You can see how this can be a huge problem. From what I know the contents of a sp are stored in the system table syscomments, which splits the longer stored procedures into several records. I am wondering if there isn't a parsing problem when putting together a longer stored procedure. Perhaps if a "new line" character happens to be at the records split it is ignored and the two lines of TSQL get merged. My "fix" has been to readjust/remove the comments, add additional empty rows in between or just split the stored procedure into several smaller sps. I will appreciate your feedback if you know more about parsing the stored procedure from the database engine or if you have a better work-around. Tag: sql server 2005 express
  - 6
    - Using XML Source in SSIS vs Script Source to parse xml files. Hi I am having a huge xml file with nested section. i also have a xsd file for that xml. i have a destination table where the data from the xml should be loaded into. i am using the xml source transformation. But o get all the data i need to use multiple merje joins to get the data in a single row which i can insert into the destination.i was not quiet convinced with using so many joins. so i tried using the script source transformation where i am using xml objects to get the node and dynamically construction the data row. and the output is then inserted into the destination. on comparing the two approach the one using the script source is working much faster than the xml source transformation. i wanted to know is there any limitaion using the script source to parse through xml files. also i would like to know any other better way of getting the data from xml source without using the joins. Hari Tag: sql server 2005 express
  - 7
    - Select Time, WHERE @filename BETWEEN @theEndTime AND @theCurTime It works. I did like this! SELECT @state = STATE , @theState = CONVERT ( char ( 20 ), STATE_TIMESTAMP , 20 ), @id = ID , @filename = FILENAME FROM DELIVERY WHERE SUBSTRING ( FILENAME , 21 , 4 )+ '-' + SUBSTRING ( FILENAME , 25 , 2 )+ '-' + SUBSTRING ( FILENAME , 27 , 2 )+ ' ' + SUBSTRING ( FILENAME , 30 , 2 )+ ':' + SUBSTRING ( FILENAME , 32 , 2 ) between @theEndTime and @theCurTime ORDER BY ID DESC ; END I want to use SUBSTRING but start count from the end of the string. Anyone know howto Tag: sql server 2005 express
  - 8
    - Radio button By custom applications I meant WinForms or web-based applications you write. You can use the ReportViewers controls to render reports in custom .NET-based applications. Tag: sql server 2005 express
  - 9
    - Transfer object task error. Hi, i am trying to transfer objects from SQL Server 2000 DB to SQL 2005 DB. i have copy schema to true and i am only copying tables. when i have tried first time it worked fine but in next time it start to give error. here is the error description. [Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=-1071636471 description=An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}". Thanks, Haroon Tag: sql server 2005 express
  - 10
    - MIgrating Existing WorkFlow Data using SSIS Hi, I have posted the same query in the WF group too. Thought I'll post the same here. We have an existing application which has some WorkFlow Data. We need to migrate this data using SSIS. Now the problem here is that we have our Workflow facade class which inturn calls the WorkFlow Runtime. We have created the methods which will create the new WorkFlows. TO add this DLL in our SCript Component Reference, we added a strong name to my Facade.dll and deployed it to GAC. The system.WorkFlow DLL's are also present there. Everytime I run this Package, I get the following error "System.IO.FileNotFoundException: Could not load assembly...". What am I missing Thanks Soni Tag: sql server 2005 express
  - 11
    - OLAP Error - Excel Pivot I was wondering what service packs are you guys running for both SQL2005 and AS2005 Tag: sql server 2005 express
  - 12
    - Cannot connect to SQL Express from WEB Application on internet Hi, I have installed SQl express 2005 SP1 and then configured it to accept remote connections which works within my internal network. I can connect other client stations within our internal network. However, when i try to connect to the database using a VB.net web application, the application cannot connect to the database. I have a hardware firewall which configured to foward port TCP 1433 and UDP 1434 to the SQL express server. I have also carried out a telnet communication to ports 1433 and 1434 and able to communicate on port 1433 and get an error message cannot connect to host on port 1434. What am i doing wrong Thanks Tag: sql server 2005 express
  - 13
    - plain text mails How can I set the default body_format in database mail. I would like to send a warning with plain text format (from the alerts), that i'll get on my mobile phone, but the message's format is html... always...and I don't get the sms-s. Tag: sql server 2005 express
  - 14
    - The Device is not ready error when Executing package on the server Jennifer LaMacchia wrote: I have the same problem. I am able to successfully map a drive but as soon as I attempt any file manipulation I get the "device is not ready" error message when running from SQL Scheduled job using xp_cmdshell or if running from SQL Management Studio in a query window. The commands work fine outside of SQL in a regular command window. Have you tried using the UNC form of the path \\server\path\file Tag: sql server 2005 express
  - 15
    - Unable to install SQL Server 2008 on Windows Vista Hi, After some tries, I could manage installing the client tools as well. But you have to first uninstall the SQL2005 client tools. Because clients tools are not supported for a side by side installation. So I uninstalled the workstation components of sql2005 then restart and then finish the process by running the \tools\setup\sqlrun_tools.msi You can read my post on http://www.kodyaz.com/blogs/software_development_blog/archive/2007/06/10/567.aspx for how I completed the installation of Katmai Client Tools I hope this helps you too. Eralper Tag: sql server 2005 express
  - 16
    - Query Plan in SQL Server 2005 SP2 What you describe is exactly my situation. I have NO, REPEAT NO, control over the SQL query which gets generated by the report writter. The user's can select any number of values for the IN clause. Some work, some don't. To MS, I would point out the EXACT same query runs in 10 seconds on SQL 2000 SP4 and I cancelled the query under SQL 2005 SP1 after 1 hour. So it is definitally a problem with SQL 2005. This needs to be fixed. I have no work around, except the have the user select less items and run the report multiple times. Tag: sql server 2005 express

james b

i have been using SQL Server Management Studio Express 9.00.2047.00 and saw that there is now a sp2. i was wondering if i had to uninstall my current version to use the sp2 or could i install over my existing version

thanks to all

Re: sql server 2005 express

Euan Garden

SPs are additive so install over the top

Re: sql server 2005 express

Madhu K Nair

to elaborate little bit... service packs are nothing but the enhancement,bug fixing done after the release of RTM version of the product or last service pack. So you need to have a baseline installation of the product and you can apply service pack on that baseline installation, no need to uninstall the installation.

Also refer this link : http://support.microsoft.com/kb/913089

Madhu

Re: sql server 2005 express

james b

also i was wondering, that i have been reading that with this sp2 for sql server 2005 express you are able to use the dts wizard, is this true i have a few databases in access that i would like to import into sql, would i have to create the tables first in sql then import or will the import also bring the tables & structure in

thank you to all

Re: sql server 2005 express

Mike Wachal - MSFT

I answered this in your other post at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1575114&SiteID=1&mode=1.

Mike