Answer Questions

• Sharpstyx How to Decrypt an Excel file within DTS

  Hello everyone, As the tittle says, I'd like to know if there's a way to decript an excel file from DTS and then save this change in order to manipulate the data inside it. If the file is protected, and you try to make a query over some sheet, you'll have an Exception saying that the file couldn't be deciphered. Any suggestion regards ...Show All

• Sql4088 Dimension and Hierachy

  Hi, I am new in AS2005 I builded a Dimension "ShipToState" with Hierarchy "ShipToState", "ShipToCity", "ShipToZip"... When I browse my cube from Excel I see "ShipToState", "ShipToCity", "ShipToZip"... as 3 different dimensions and a new dimension named "Hierachy".....I think I am doing some mistakes..... Someone can help Thx Mcrisf Thx for the answer.... but i would like to show to the user just only a dimension "ShipToState" and when the drill down to see the "ShipToCity" and "shipTozip"....the user is confused to see all these dimensions and also a hierachy dimension....wit ...Show All

• Stikstofman SQL Express does not allow remote connection within VB.Net Express

  I am new to VB.Net coming from a VB6 background using the VB.Net Express and have even loaded the SQL Express. The learning curve is not to bad until you get to dealing with connecting to db's. However, in trying to fill a grid with data, manipulate it and then update it has not been any fun either. There does not seem to be enough information out there dealing with these two as of right now. Anyway, trying to add a datasource connection for a grid has resulted in a real problem even using the connection wizard. I keep getting the same error that the default settings for SQL express does not allow remote connections. However, I thought that I have corrected that. Unfortunately, with VB express I cannot even seem to talk to my SQL 2000 ser ...Show All

• cobain81 sql server 2005 dev edition error - unexpected error while Updating Installed Files

  I am attempting to install SQL Server 2005 Developer Edition onto a Windows XP Pro SP2 machine, but unfortunately each time that I attempt to install I receive an error message in the summary log as follows: Product : Microsoft SQL Server 2005 Product Version: 9.00.1399.06 Install : Failed Log File : C:\Program Files\Microsoft SQL Server\90\Setup Last Action : InstallFinalize Error String : The setup has encountered an unexpected error while Updating Installed Files. The error is : Fatal error during installation. Error Number : 29528 There is probably a simple solution for the issue but unfortunately I am unaware of what it is I can’t tell if the issu ...Show All

• Harkernator select query from a stored proc when the values can be blank.

  Hi All, I think what am trying to do is quite basic. I have 3 paramaters@value1, @value2,@value3 being passed into a stored proc and each of these parameters can be blank. If one of them is blank and the rest of them have some valid values, then I should just exclude the column check for the value that is blank. For e.g if all my parameters being passed are non- empty then I would do this select * from tblName where column1 like @value1 and column2 like @value2 and column3 like @value3 else if I have one of the parameter being passed as empty, I should ignore that parameter like if@value1 is empty then my sql should be select * from tblName where column2 like @value2 and column3 like @value3 I don't want to do a dyanmi ...Show All

• robinjam long running transaction blocking queue

  Hello, I seem to be misunderstanding the way transactions work with service broker queues. We have developed and deployed a service broker application that 5 queues and a windows service for each queue on multiple servers (3 currently). Due to a last minute issue, we had to not use transactions when the services executed a recieve and I am not updating the code base to use transactions and am running into blocking issues. One of the services runs for 90 seconds (spooling to the printer) and all of the servers block on the receive operation for this queue. I thought that if I was receving messages from a single conversation, other receives against this queue would not block. Thanks, Jim Stallings ...Show All

• batfox Ask a question?why i always get the same result?

  when I use sqlserver 2005 do the prediction with Microsoft_Association_Rules. I found that I alwayes get the same result(same dataset) using the SQL statement such as: SELECT Predict([movies],INCLUDE_STATISTICS,10) From [Movie Prediction] NATURAL PREDICTION JOIN (SELECT (SELECT '12 Angry Men' AS [Movie]) AS [Movies]) AS t or SELECT Predict([movies],INCLUDE_STATISTICS,10) From [Movie Prediction] NATURAL PREDICTION JOIN (SELECT (SELECT 'Sport-100' AS [Movie]) AS [Movies]) AS t the result don't very by the parameter of movie name. wish expert give me some help. thank you! The most likely cause is that your model has not detected any rule having '12 Angry Men' or 'Sport-100' on the left hand side. In this ca ...Show All

• smudie SQL Server 2005 (2153) AV and down on SP prepare (recompile)!

  How I can resolve this problem ===================================================================== BugCheck Dump ===================================================================== This file is generated by Microsoft SQL Server version 9.00.2153.00 upon detection of fatal unexpected error. Please return this file, the query or program that produced the bugcheck, the database and the error log, and any other pertinent information with a Service Request. ...Show All

• SimonStevens Parallel execution of source SQL commands

  Hi, we're accessing a SQL Server as a source for some SSIS packages using quite complex SQL commands. We have dataflows getting data from up to 10 queries. The problem is that SSIS starts all these queries in parallel using up all the memory of the server (the source SQL server, not the server SSIS is running on). So the queries are very slow. Is there any way to force SSIS to start the queries after each other I already browsed the web for some answers on that and I'm not very optimistic... Maybe the only solution is really to feed the result of the query in raw files and process them later... Thanks, Thomas, I'm sorry, I misunderstood. I thought you meant the queries were all in seperate data-flows. Now I understand y ...Show All

• Snake86 Cannot connect from SQL2005 Server to SQL2000 Server on our LAN

  Hi. Probably a simple problem, but I just can't sort it. We have recently setup a new SQL2005 server (32 bit) on our LAN. We have several other standalone SQL2000 Servers on our LAN. When I click connect from the Management Interface in SQL2005, and search for database engines, I can see all our other SQL2000 Servers, except for one... which happens to be the one I need to get to. It simply doesn't appear in the "Network Severs" list. Have checked all network settings. Windows Firewall is completely disabled on our network, ports needed are open, user login has access rights which are the same for this server as all the other ones I can see and connect to. In fact, the SQL2005 server can see and talk to this SQL2000 serv ...Show All

• xRuntime Placement of sys.conversation_endpoints and sys.transmission_queue

  Is there any thought going into moving these two tables to a file group that we can control Putting this in Primary with the rest of my system tables is quite problematic, and hinders my ability to manage space usage on my files. Traditionally, we didn't have to consider a primary file group that could grow to large proportions, but now with these two tables it can. If a large volume of messages gets sent through and the system can't keep up, then these tables and my primary file group will grow sometimes enormously. Operator error, the issue should be still active. There are no plans to support this in the near future. Rushi I agree and have raised a suggesti ...Show All

• kymaita Granting UPDATE for only certain columns in a table

  I have tried using the SQL statement shown below to grant UPDATE permissions for a single column in a single table to a user with db_datareader privileges. grant update (col_1 ) on trs . dbo.table_1 to calc When I then run a SQL script that has an UPDATE for col_1 on trs.dbo.table_1, I get an error message Msg 230, Level 14, State 1, Line 2100 UPDATE permission denied on column 'col_2' of object 'table_1', database 'TRS', schema 'dbo'. Why is the error message referring to "col_2" when my SQL statement is trying to update "col_1" When I performed the "grant" I did it with an account that has db_owner, db_securityadmin, and db_ddladmin privileges. This worked in SQL Server 20 ...Show All

• Charles Tam How to filter Profiler trace by dbid in 2005?

  Is there any way to filter a SQL Profiler trace by dbid This was a feature of earlier versions, but I can't figure it out in 2005. Thanks! Hi there. From the Profiler GUI, create a new trace, move to the Events Selection tab, click the Show all Columns check box (this is important, as the filters box will only show columns that are selected in the interface), then click the Column Filters button in the lower right corner of the box, you should see the DatabaseID option about 1/3 of the way down the list box on the left...click it, then set the appropriate value in the text box in the lower right of the screen... HTH, Aha! This is one of those 2 step processes. Thanks a lot! ...Show All

• tjams Patching for W2k3 SP1 server w/SQL Server 2005

  Is the correct procedure for SUS patches to a server running SQL Server 2005, to set the client to download only and then manually shutdown SQL Server, apply patches, reboot, and restart SQL Server Do SQL Server 2005 patches download through SUS or is it manual SP only, except for hotfixes Thanks, Tom I don't have much experience with SUS, but the hotfix patches will take care of the services for you. SP2, which has publicly released quite yet, shows a list of processes in use to allow you to shut them down before patching. This will eliminate the reboot need. Thanks, Sam Lester (MSFT) ...Show All

• leclerc9 trying to drop user from sql server 2005

  Hi there. In my master database there is a user called cadmin, im trying to drop this user. I have already deleted the login for this user, however when I try to delete the user from the master database I get an error message saying that this user cannot be dropped because it owns a schema in the database, when I right click this user I can see the schema that it owns but I cant uncheck the schema can anybody please tell me what I have to do drop/delete this user. Im using sql server 2005 Thanks in advance. See if the user is a database owner, you will change the database owner first if he owns the db. Then you will be able (in addition to the other post about removing schemas or changing the ow ...Show All