Answer Questions

• McWhirter how to start SQL Server 2005 Workgroup Edition

  i have SQL Server 2005 Workgroup Edition how to connect to it from vb.net 2005 because i try but no use thanks in advance. hi, depending on how you installed the SQL Server instance, you have to provide the appropriate name.. for a "default" instance, it's name will be (Local) or ComputerName; for a "named" instance, you have to add the InstanceName to the above definition, becoming something like ComputerName\InstanceName you can see the actual installed instances in several ways.. check the SQL Server Configuration Manager, in the SQL Server 2005 Services node... you should see something like SQL Server (MSSQLSERVER) <--- this is a default instance SQL Server (other names, like SQLE ...Show All

• phileb Insert trigger for bulk insert

  In case of a bulk insert, the “FOR INSERT” trigger fires for each recod or only once Thanks, This option may have issues with performance if you enable during the bulk load operaton during the otherside of triggers, refer to the books online about Controlling trigger execution when bulk importing data. HTH Once for each batch. Here's the specific text from Books Online "Triggers are fired once for each batch in the bulk copy operation. The inserted table passed to the trigger contains all of the rows inserted by the batch." Note that, by default, the triggers do not fire for bulk operations, you must specify the FIRE_TRIGGERS option in order to get triggers to fire for bulk operations. ...Show All

• danmbuen How to connect to Analysis Services with Excel 2007 Data Mining Add In?

  I downloaded a trial version of office 2007 and the data mining addin. I do not have an automatic connection to Analysis Services, so most functionality does not work. Is it possible to configure a connection with a trial version If so, does anyone know what the server name is and how to configure it I have all of the software installed on my laptop and it all works OK - by "home laptop" you mean a laptop that is not joined to a domain, correct After installing Analysis Services on your local machine, did you try to run the server configuration tool If that failed, can you try to run SQL Server Management Studio and connect Please let us know. If you did install and it seems ever ...Show All

• Mahmoud Gourar poor preformance usinng sql 2005 with access 2003 application

  we have run access 2003 application using SQL 2005 server and the data transfer rate is extreamly slow. we are using ODBC connection and the access apllication works very fast with SQL 2000. we have the tested the comptabilty of the application to SQL 2005 with Microsoft wizard and it had no problems. even when i run simple application on the sql 2005 server, it runs very slowly. i am using the MDAC clients ODBC component and the SQL Native Clients one. which eliminates the possibilty of network problem. what could be the problem Most likely the problem is improper indexing on the SQL Server side. Typically the driver used is not going to have a huge impact on overall performance. The simplest ...Show All

• CPedersen Creating a hierarchical view with recursion

  Say, I have a table with 3 columns =============== Col1, Col2, Col3 ============== r11, r12, r13 R21,r22,r23 R31,r32,r33 : : (rows) : I want to create a view that looks as follows ======================================================== Col1_2_3, Col1_2, Col2_3, col1, col2, col3 ======================================================== R11_r12_r13 r11_r12 r12_r13, r11, r12, r13 R21_r22_r23 r21_r22 r22_r23, r21, r22, r23 : : The idea being that col_1_2 appends the strings in columns 1 & 2, col2_3 for columns 2 & 3 and so on...How would I do that in a recursive manner so that it works for tables with any number of columns Can anyone please help You can create view based on only one query. Consideri ...Show All

• snakeoooooo Where to put DISTINCT in a CTE?

  CTE's are surprisingly useful for paging data, but I'm running into a problem where I have to add a distinct clause. The idea is to pull topic records for a user's forum posts, but only one topic record even if there are multiple posts in the topic. Here's what I have so far: CREATE PROCEDURE pf_PagedTopicsByUser( @StartRow int, @PageSize int, @UserID int ) AS DECLARE @Counter int SET @Counter = (@StartRow + @PageSize - 1) SET ROWCOUNT @Counter; WITH Entries AS ( SELECT ROW_NUMBER() OVER (ORDER BY IsPinned DESC, LastPostTime DESC) AS Row, pf_Topic.TopicID, pf_Topic.ForumID, pf_Topic.Title, pf_Topic.ReplyCount, pf_Topic.ViewCount, pf_Topic.StartedByUserID, pf_Topic.StartedByName, pf_Topic.LastPostUserID, pf_Topic.LastPostName, ...Show All

• Daikoku How do variables work?

  After a couple hours of searching, I'm no closer to figuring this out than I was when I started. So... I have a foreach loop. It has a collection of numbers of type Double, but I've used int32, int64, etc. trying to get it to work. int32 would be ideal. This is mapped to User::accounts. Inside the loop is an Execute SQL task. All I want to do is the equivalent of "select @[User::accounts]", to be replaced in the future with an update query. That particular string doesn't work. I've mapped the variable to a parameter of type FLOAT and tried "select @accounts". That doesn't work. Do I need to declare something Not use parameters Neither the documentation nor the error messages (I got an "precision is invalid" e ...Show All

• kart Beginner's questions

  Hello, I have two database servers that I am interested in sending messeges between them. I am not interested in security or encryption at this point, only a simple message sending and recieving. Can someone please provide simple scripts for object setup (certificates, queues etc) and message send and recieve a link to such a script will be great as well. I am just a bit lost understanding all the new concepts (certificates, service, service binding.....) Thank you I. This means you had a typo in the BEGIN DIALOG statement and you actually used TO SERVICE 'TargetService, 3771F...' instead of 'TargetService ' , ' 3771F...'. You should see 'TargetService' in to_service_name column and ' ...Show All

• TusharSinha How do I install sqlcmd.exe in my SQL Server client

  I have SQL Server 2000 client installed in my machine and I need to call stored procedures thru sqlcmd utility. When I tried using this utility, I got an error message from command prompt sqlcmd command does not exist . I have osql utility in my client version, but i need to have sqlcmd utility. Please advice how do I install sqlcmd.exe in my SQL Server client SQLCMD was introduced in SQL Server 2005. For SQL Server 200, you can either use the OSQL.exe or the ISQL.exe tool. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• &amp;#40644;&amp;#36798; Unable to retrieve column information in Flatfile connection within foreach loop container

  Hello, I am getting very frustrated! I have got a Foreach loop container which I am processing files within a folder. I have a flatfile connection manager which I have set up using a test file and have updated the expressions attribute to be the package variable I set up in the collection for the loop container however everytime I run it I get the error: 0xC0202094 cannot retrieve the column information from the flatfile connection manager. I can only guess that it is either the variable being passed to the connection manager or the way I set up the connection manager. When I msgbox the variable in a script component before the dataflow step, the variable for the file seems fine. Any suggestions are REALLY appreciated. Yours Jayne ...Show All

• Tallman Different execution plan between stored proc and ad-hoc query

  We have just encountered a problem with a particular stored procedure which I would appreciate anyone's thoughts on. The proc in question contains a single select statement which simply joins four tables and filters based on two parameters. It normally runs in well under a second but t his morning we came in to find it was running in anything up to a minute. After investigation we found that it was running a clustered index scan on one of the larger tables (approx 10.5m rows) rather than using the appropriate index. However, when we took the select statement out and ran it as an ad-hoc query it was utilising the index and performing correctly. We tried recompiling the proc and also ran sp_updatestats on the database but we were s ...Show All

• Leonard Lee No idea if this is the right place to post... Need stored proc help

  Hello, I am trying to make a stored proc that will tell me if there are any rows in a table. The table name is a variable that I get at the start of the proc it is not sent in. What I am looking for in the table is sent into the stored proc. here is where the problem is, i can not save it. It does not seem to allow me to use the if exists with variables. I have tried it also without the + and with the + ' to create a string I cant seem to get it anyway I try. if exists (SELECT * FROM + @TableName + WHERE + @ColumnName + = + @SearchStr2) print 'got here ' +@TableName + ' '+ @ColumnName END Thanks for any help You need to build the entire query string in a variable, and then use the dbo.sp ...Show All

• Panish Multi-value parameter cannot be passed to SQL where clause (Oracle db)

  Greetings!! I have a problem with SSRS 2005 (simple rdl) on Oracle10g environment. PROBLEM Definition We have multi-valued list box , the selected values of which are being passed as parameters to Oracle 10g (back-end) from the report. I want to be able to pass these values as "WHERE......IN" clause in the main query in SSRS dataset window responsible for loading report. However, when I do that it throws error. I have tried all possible combinations i.e using IN operator with '@', ':' , '&' . Now when I did the same with SQL server as back end; it worked. Can you please help with the exact syntax of executing this successfully Sample Query used in sample SSRS data-set when SQL server ...Show All

• yaasiva How to change the color of a bar in a bar chart?

  I am having a problem setting the colors of the bars in a bar chart. It seems like it would be the simplest thing, but apparently it's not. The "series" is grouped on whether or not the value is positive -- if so, the bars are blue (by default) and if not, green (by default). I want to change it so the positive color is blue and the negative color is red. I found that I can change ALL the bars to one color by going to chart properties, Data tab, Values Edit, Appearance tab, Series Style, Fill. There I set the color to red and ALL the bars became red. But this is not what I want. I tried using a conditional statement like IIf(Fields!IsPositive.Value=True,Blue,Red) for the color, but (not surprisingly), it told me I hadn't ...Show All

• Mortsdeh How to show running totals

  I have a cube with many dimensions including one called WorkDate YMD. I also have a measure called Hours. At the moment I can see hours against any level of the WorkDate dimension, but I have a requirement now for running totals. For example, the data at the moment is this Jan 4 hours, Feb 5 hours March 6 Hours As well as the actual Hours the users now want to see the running totals. So the data will be Jan 4 hours, Feb 9 hours March 15 hours I know this should be easy as a calculated member in the cube using MDX and therefore visible in excel pivot tables but I cannot see how to accomplish this correctly ans easily. TIA Hi Neil. Thanks for the explanation. I provided very query specific solution to you ...Show All