Answer Questions

• Choss_UK Problems with regard to connection string

  hi! I have 2 questions that needs to be clarified. I have Sub packges being executed from the main package. I am executin the Main Package with the Conn string set through the C# UI like string connect = @"TahoeDB;Data Source=SE413695\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Integrated Security=SSPI;"; jobCommand = new SqlCommand("xp_cmdshell 'dtexec /f \"" + path + "\" /Conn \"" + connect + "\" /Set \\package.Variables[User::ArchivePackageName].Properties[Value];\"" + name + "\" /Set \\package.Variables[User::ArchiveFileType].Properties[Value];\"" + type + "\" /Set \\package.Variables[User::ArchiveFlatFileConnectSt].P ...Show All

• AndyPham Linked Servers Dialog Error

  I freshly installed SQL Server 2005 Developers Edition (with SP1) on Windows XP (with SP2) but every time I right click on “Linked Servers” and choose “New Linked Server…” I get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Cannot find table 0. (System.Data) ------------------------------ BUTTONS: OK Details: =================================== Cannot show requested dialog. =================================== Cannot find table 0. (System.Data) ------------------------------ Program Location: at System.Da ...Show All

• Anterian Indestructible stored procedure

  I want to describe step by step what I want to do, what I am actually doing and what comes out of it in SQLEXPRESS. I managed to create a few stored procedures. Now I changed my mind on one of them. The idea I tried did not work, period. I want to modify it. The Object Explorer offers me this chance. I go to my database: hist_O for simplicity sake, click Programmability-->Stored Procedures--My Stored Procedure and then say: MODIFY. I see (much hated already) my stored procedure in the lookup window on the right. Its name is CreateTableO . It is not what it is suposed to be and I want to change the content. A sensible way to go about it is perhaps to click Ctrl+Shift+M . I do it and get a parameters window. I see Specify Values For Te ...Show All

• Alexei_shk Set filter to date Now()

  I want to set a filter to calculate the date range to be 1 year ago to last month. Is this possible ps. Im working with a AS cube. Well I guess you didn't say what data source you were using - it might not be analysis service, but regardless, you can make an expression or value out of Now() and put that in a filter. Correction its for a date range of the current year January- the month prior to excution, (So Now() minus one month). Can anyone help It's possible. Just create your mdx uniquename value off of the now function ie "[" & Year(Now) & Month(Now) & "]".... but what if the current date i ...Show All

• BilalShouman Please post setup and installation questions in the Setup forum

  This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum. Thanks When I run my setup.exe and get to the window for "components to install" the Reporting Services option is greyed out! Any ideas The only thing I can think of is that the person who gave me the software (he isn't a DBA, and don't even ask why I have to go through him!!) gave me the wrong files or downloaded some partial CD I'm lost! I've seen this previously where IIS hadn't been installed on the target server. Hope that Helps JB Where is the &quo ...Show All

• Leon Mayne rsLogonFailed and that's it for TFS reports!

  On our newly installed Team Foundation Server I cannot see reports. All I get is this error that the logon failed (when selecting e.g. "All Work Items" from Team Explorer og navigating directly to the report in a browser on the TFS server) Logon failed. (rsLogonFailed) Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) Now, I have googled and searched, but have been unable to resolve this issue. I have added my TFS reporting account to all sorts of groups and granted all sorts of rights (log on locally etc.) I have worked the various options of the http://localhost/Reports/Pages/DataSource.aspx ItemPath=%2fTfsReportDS tool (and TfsOlapReportDS) to no avail. For both data sources it is se ...Show All

• newtoc#484467 Encrypting Data using TSQL

  I need to find a way of encrypting and decrypting data from SQL server 2000. I need to do this as transparently as possible, which is why I need to do this if at all possible before my web application encounters the data. I know this is possible without 3rd party applications using SQL server 2005, as I have a working implementation already; however I need to do this with SQL server 2000 as upgrading is not an option. Using a 3rd party product to encrypt/decrypt is also not possible. Any help much appreciated. Matt Rose You can write a stored procedure on your own,either as a extended stored procedure or you make a call to a COM object. Both options are not very niuce, compared to buying a thrid party pr ...Show All

• robhare Simple (for some) 2 Table Summary Query

  ...but apparently not me, I'm very new with this T-SQL stuff and am seeking the advice of the seasoned pros at this forum. Description on my SQL-5 Environment: Table I Sales:       Prod_ID, Prod_DT, Sales_DT, Buyer_Name, Buyer_State Table II Repairs:   Prod_ID, Prod_DT, Sales_DT, Repair_DT These 2 tables are joined by the common key Prod_ID & also and share the product's production & sales dates. What I would like to do is produce a rate summary similar to description below. Production_YYYY, Production_MM,  Sales_Cnt, Repairs_Cnt, Repair_Rate((Repairs_CNT/Sales_CNT)*100) Important to remember that not all products experience repairs, so the basis for Sales_CNT ...Show All

• Charles Tam Need help in starting out

  Hi Everyone: I am just starting out on SSIS, and have the following business challenge that I would like to solve utilizing SSIS. There are two SQL Server data stores, one would be the source, and other would be the destination. I need to grab some data from store 1, and insert that data into store 2. Here are my questions: 1) Before i move the data to store 2, i have to check some criterias by callin some sps, and then the end result would need to be inserted into the destination database. Can anyone tell me how would i setup the control flow, to accomodate that in SSIS 2) Can someone email me a sample package that does something similar I just need a starting point so i can build the design of my package. Basically i need to ...Show All

• GinaK Create a calculated member on one measure.

  I have a Version dimension which is used to break out the Net measure by 'Actual' or 'Budget'. Net is the only measure I'm using. By not using the Version dimsion. The net is incorrectly totaled by both values. Both are not used together. 'Actual' and 'Budget' are the only two members of the Version dimension. I want to add a third member which subtracts 'Budget' Net measure from the 'Actual' Net measure and call it variance. A caculated measure isn't working for me because obviously subtracting Actual - Budget doesn't work so well. Can anyone help me with that I see what it's doing. Its showing up in the Version_Heirarchy on the same level as 'All', not as a sibling of 'Budget' and 'Actual'. It's unusable there. How can I ad ...Show All

• Boman SQL CE Trouble in Visual Basic 6

  I use SQL Server 2005 Compact Edition RC1 with Visual Basic 6.0. connection provider that i use is Microsoft.SQLSERVER.MOBILE.OLEDB.3.0. for database management i use SQL Server Management Studio. some query can't execute in visual basic but in sql management studio, that query can run very well. for example: 1. select KodeSatker, KodeSatker + ' - ' + Nama as Nama from TMSatker where len(kodesatker)=3 order by KodeSatker 2. Select a.kdprog, a.nama, b.kodesatker + ' - ' + b.nama as SKPD, a.nonurusan from TMProgram a left join TMSatker b on substring(a.kdprog, 1, len(a.kdprog) - 2) = b.kodesatker 2 query above can run in sql management studio, but in visual basic 6.0, that query have an error. error msg:run time error '2147217887 (80040e21)' ...Show All

• sql2005 user shrink tempdb

  I have a sql2000 server that has a 24 /7 uptime. The tempdb size is increasing rapidly. it was 4 Gbs and i restarted the sql server to shrink the tempdb size which worked fine. but now after 1 week then tempdb size is almost 1.5gbs. Is there anyway that i can shrink the tempDb without restarting it. Asking the users to stop using for a certain timeframe after every month or so seems like a hassle for the users. it's documented here. http://support.microsoft.com/kb/307487 hai guys... i've got the identical case but different problem. it's still about shrink tempdb. my office sql server have job schedule in every 3 hours for shrinking tempdb. I'm sure it's not the good practice. Then I've got ...Show All

• oswaldorb Cube deployment issue SSAS 2005

  Hello all, I got an issue with deploying my cube. I am new to SSAS 2005, and I cannot find the option to define which account to use with deploying. I managed to choose the server for deployment, but strangely enough, no user can be selected, so when it deploys, it throws an error stating the standard windows login isn't valid (wich is correct, but I do not want to use standard windows login). The only thing I can find wich is remotely connected with this problem is the following: http://msdn2.microsoft.com/en-us/library/ms166576.aspx But nothing about a login or something like that. Please help, I am totally clueless. I made a database + tables, I defined it  ...Show All

• ChrisHelt Auto hide not working properly

  When I start Management studio for the first time on boot the Auto hide (Pin icon) does not work. I have to pin it first and then unpin it to make it work. Initially I thought it happens only on my machine but same thing I tried on couple of other machines. Happens only with Object Explorer not with Properties pan. All these machines have good primary 1GB RAM and processing power Intel dual core CPU 1.60 Gz. It is very minor issue but little annoying! Anyone else experienced similar behavior Using MS SQL Server 2005 EE Thanks for taking the time to enter the issue. When you enter an issue through Connect it automatically creates a bug in our tracking database. We can then communicate with ...Show All

• champa DTS: single SELECT from 2 databases possible?

  Just wondering, in DTS, can I run a SELECT script that selects from 2 different databases (both on the same server) I can run this in Sql Query Analyzer, but in a DTS, it doesnt accept my database name prefixes: SELECT a.something FROM DB_ONE.dbo.product a, DB_ONE.dbo.mp_brand b, DB_TWO.dbo.lk_pcat_cutover c WHERE a.PCat <> c.Pcat (where DB_ONE and DB_TWO are the 2 different db names) I have one connection to DB_ONE... does this mean I cant access DB_TWO when using this connection I want to try and avoid using a temporay table for storing DB_TWO's data in DB_ONE... Is this possible Thanks, Andre Dont know if this is the one and only answer, but by changing the datasource to the MASTER db, it then allow ...Show All