Answer Questions

• dalterio Need Help on MS SQL Server (DataType related)

  Hi all, I am a newbie to MS SQL Server, and recently I downloaded the trial version of Microsoft SQL Server 2005. When I was using Microsoft SQL Server Management Studio, I found that I cannot decalre a variable as Bool (boolean) when I create table, nor can I declare a variable as bitvarying. Can someone tell me why is that Is there additional package that I need to have those variable type Or the trial version does not support Boolean type Thanks in advance! The data type for a true/false value is BIT, BIT is actually a stripped INTEGER with the values of 0 and 1. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Sarguna CreateThread - not enough storage is available... when processing dimension

  I was building a cube with a few dimensions, a lot of dimensions have built, but then at one point it failed with this error: The following system error occured from a call to CreateThread: Not enough storage is available to process this command. . I had about 110 GB free on the HDD when this happened. So not sure if this is related to the disk storage. However, the Analysis Server parameters include these memory settings: LowMemoryLimit: 75, 75, 75 TotalMemoryLImit: 80,80.80 This is by the way a Dev version of SQL 2005/ CTP SP2 ...Show All

• Jakein2006 external image not rendering when generated from aspx page

  I'm having problems displaying images generated by aspx pages from a report. It works fine if I point the external value to a static image on the web. I can paste the url to the page into IE and it generates the image with no issues. What am I doing wrong I used a textbox to verify that the correct url is being generated (= Parameters!MYPROJECT_URL.Value & Parameters!MYPROJECT_NO.Value). Are there any issues with generating external images with reporting services I have installed SP1 for MS 2005...shouldn't I see some sort of visual confirmation in Management studio when I click the Help Menu->about saying the version is MS SQL Server 2005 how do I verify that the upgrade was successful Chec ...Show All

• Biresh Singh How to retrieve the SQL query generated by processing a cube in ASSAS

  I have seen several posts which talk about looking at the underlying SQL for a cube in SQL Server 2005, but I have been unable to locate where you can do this. When I process my cube I do not see any SQL in the Process progress dialog box in the way you do with AS2000. I have tried running SQL profiler while processing but that didn't give anything either. Could someone help me out please Thanks In the processing progress dialog box, you should be able to expand the items listed and eventually get down to the detail of the SQL queries generated and executed. However, I find that using SQL Server Profiler works better if your source for the SSAS database is a SQL Server database. When you use ...Show All

• Frank S Performance of sqlserver drops few times per hour

  Approx. 3 times per hour sqlserver is writing data for 8 to 10 seconds. What it is writing i dont know, but the result of this is that the duration of executing queries is much larger then normal ( 10 times ). Normally the query takes up to 400 milliseconds, and during this writing problem, it takes 6 or more seconds. Sqlserver is not doing backups when this happens. Does anyone have any idea You can set the checkpoint/recovery interval. e.g. --chkpoint every 10 minute exec sp_configure 'recovery interval', '10' reconfigure with override go Great 2 answers and they both helped me :) Thanks people it was the checkpoint. Now i need to find a way to do more c ...Show All

• naguaramipana date parsing

  Hello, I have a source with two smalldatetime fields, the first field contains 8/1/2006 12:00:00 AM, and the second field contains 8/10/2006 7:57:00 PM. I would like to have the date from the first field and the time from the second field. No chance of changing the source system to do this for me. What I have so far works, except the time portion is converted to 19:57:00 instead of 7:57:00 p.m. Any Ideas My expression is below. (DT_STR,2,1252)DATEPART("month",FIELD1) + "/" + (DT_STR,2,1252)DATEPART("Day",FIELD1) + "/" + (DT_STR,4,1252)DATEPART("Year",FIELD1) + " " + (DT_STR,2,1252)DATEPART("Hour",FIELD2) + ":" + (DT_STR,2,1252)DATEPART("Mi ...Show All

• JH. Combining records/Foreach Loop

  I'm working on a data migration that requires combining rows/values from one table to update rows in another table, and I can't figure out if I need to do a nested FOREACH or something else. Here's the example. I have a table called Health that has a unique child record, key is childID. I have another table called Concerns that has multiple records for each child. The Concerns table structure has several Boolean fields that need to capture and retain a true value, no matter what the value is in the next record, i.e. once a field is true, it's always true. Then those values need to update the child record in the Health table. So if the Concerns table has the following records for a child: ChildID, DentalConcern, VisionConcern, H ...Show All

• alexsk8 SP2 failed only on the Database engine and now won't restart

  I have a clean SQL 2005 Ent. x64 SP1 clean with no user db's.....applied SP2 and everything showed "Success" except the Database Services (Error 29534)...... Time: 02/22/2007 08:29:50.134 KB Number: KB921896 Machine: TORCA8 OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790) Package Language: 1033 (ENU) Package Platform: x64 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: Cluster Installation: No ********************************************************************************** Prerequisites Check & Status SQLSupport: Passed ********************************************************************************** Products Detected Language ...Show All

• TheRolle Dataset Distinct Query

  I am trying to build a report with a prompt to select building. It all works fine except I in the prompt building is list as may times as there is data for it. I want it to only display once, but not effect the other data is there a way I can query this I have my 2 datasets and my parameter set up to display building to select from. My issue is I get multiple values in the Select Value Prompt. It will pull the correct data I just want to clean up the Select Value Prompt. Example: of prompt list Building 1 Building 1 Building 1 Building 2 Building 2 Dataset 1: Select Building, First, Last From Table Dataset 2: SELECT Building, First, Last From Table WHERE (Table.Building = @Building) ...Show All

• Chris Beiter - MSFT determining last entry ID in table

  Not sure if this is the right place to post this but hopefully someone can help me. I would like to determine what the last automatically incremented ID is in a table I need to return it as a variable to a VB.NET program but I'm not sure what the SELECT statement would look like for this. Any help would be greatly appreciated. Is this the last ID generated in the session on the table or across all sessions You should use SCOPE_IDENTITY() to get the identity value generated in a scope. IDENT_CURRENT gives the last value at the table-level so if you have concurrent transactions on the table then you have no guarantee that you will get the one from your session. So can you explain what you are trying to do actually Are you doing an ins ...Show All

• Repi3 Need Transact-SQL code

  Is there any transact code for sql server that I can type out to view all of the relationship Definments of the current database or even an individual table. Moving thread to T-SQL forum. Please take a look at the INFORMATION_SCHEMA views in SQL Server 70/2000/2005 or the system catalog views in SQL Server 2005. There are also system stored procedures like sp_helpconstraint, sp_helpindex, sp_help that will give you similar information. Search in Books Online for these SPs or views. Yes. (sorry about my poor english) Making an "simplest" answer, point to the system tables sysindexes (index), sysreferences (fk) and syscomments (views, tr, sp). ...Show All

• Andrew Todd performance tuning on high volume server

  I am looking to improve the performance of my sql server databases. I currently have a dual location system, the database server setup is basically a quad xeon with 4gb at my office and a double xeon with 4gb at a remote webhosting location. There are separate application/web/intranet servers at each site. The two databases servers are replicated with the local server publishing to the remote server. The relational database holds circa 26 million records, growing by a volume of 10,000 per day, there are approximately 50,000 queries performed per day. My theory is that the replication of the two databases is causing a slowdown; despite fast network connections (averaging 200ms between servers) the replication seems to place a ...Show All

• arby99 SQL Server could not configure 'instance' as a Distributor.

  SQL Server could not configure 'SQL01' as a Distributor. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: Property LoginSecure cannot be changed or read after a connection string has been set. (Microsoft.SqlServer.ConnectionInfo) I have had a good look through the forums and have found several ideas about permissions on the DATA folder to no avail. I have also not changed the sa user it is still sa. Unfortunaley all the things I have found haven't worked. Have you got any ideas They would be greatfully received. Ben I managed to fix this by installing the latest service pack for SQL 2005. Ben Looks like ...Show All

• justsnafu Why do I need to reference the server name now but not in MSDE 2000?

  With SQL 2000 and MSDE 2000, I only had to put a "." for the server name in a connection string. Now with SQL Express 2005 I have to acually reference the server instance name ".\SQLEXPRESS". Why is this Also, when running the command line tools for running scripts, I have to include the parameter "-S MACHINE\SQLEXPRESS" in the command line where as before I never used the -S parameter at all. Anyone know why I am curious because it is going to cause an impact on our upgrades for the client. My only answer to these questions is that there is no SQL Agent running anymore. Thanks in advance, Scott But I chose default instance when I installed SQL Express. ...Show All

• LouArnold Does MS plan a GUI

  Hello all, We are planning to base a product on Microsoft SQL-2005 Notification services. However, one of the required properties from this software is to provide the client administrator a user interface to configure the Instance Configuration File (ICF) and Application Definition File (ADF). Working with XML files will not do for us, once the responsibility is delegated from a developer to an administrator. Before going into the process of writing such an application from scratch, I would like to know if Microsoft has such an enhancement on the SQL-NS roadmap, and if so, when it is scheduled to. Does anyone have any thoughts or knowledge Thanks Ziv G. Ziv, Dr ...Show All