Answer Questions

• Tomasz24311 SQL 2005 __Back-Up automatation__

  Hello, i need to make an ASP.NET webpage to administer a sql server 2005, So one of the user options in this page is -> Back Up Server DB So then i will run an script or something else to make the backup. Can anyone tell me someway to do this (suggest, links, docs, will be apreciated ;-) Thanks... Andrew Tara Kizer has an amazing DB Backup stored procedure you can view on her blog here; http://weblogs.sqlteam.com/tarad/archive/2004/08/04/1876.aspx You could then call this stored procedure from your asp.net web application. hth Barry Andrew ...Show All

• Espresso74 Installing sql express

  When I run the install script, I always get a warning that the hard drive (space ) won't support the install, but I have installed successfully with the new tools etc. and I still have 20 gigs left on my laptop. Why is this warning given thx, Kat Thank you for telling me how to get the error message... I'm learning something new everyday! Error message below: "The current system does not meet minimum hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online" Kat Do you recall that the original warning you saw was on the dialog where a bunch of other checks were being run Items such as memory, processor, pending reboot, and IIS ...Show All

• Shady Brady Web Synchronization wizard

  Thanks Mahesh, the above su ggestion did work. However, I have a new problem with SQL Server mobile subscription. I use SQL server 2000 and SQL server management studio from SQL 2005. After the Synchronization start, I have following error “The constraint cannot be removed because it is referenced by another constraint. [ Constraint name = specCategories ] HRESULT 0x80040E90 (25077) The SQL statement failed to execute. [ SQL statement = drop table "specCategories" ] HRESULT 0x80040E90 (28560) “ But there is no constraint for specCategories, it only has foreign key in table "Specs" Please help, I appreciate it. Eddie I split this thread from t ...Show All

• Venu g SQL server connection error and cliconfg

  Hi Folks; I had a problem with connecting to an SQL server remotely: ConnectionOpen(CreateFile()). Client unable to establish connection I then tracked the problem down to named pipes. I found a solution in cliconfg by changing the network protocol to TCP/IP however this is not satisfactory as the problem exists with dozens of computers and the lab administrator doesn't want to have to run this on ever single system. I made another attempt on the SQL server end by running SQL Server Configuration Manager for SQL Server 2005. I enabled "Named Pipes" and restarted the service. Unfortunately this did not resolve the situation. So is there something else I can do on the SQL server end or is there a command-line paramter f ...Show All

• ChetanD Connection Manager Keeps External Metadata information

  We have a Main package and which is calling 2 more other packages. The first package contains a connection and we are using a Dataflow task. The data flow task has OleDB Data source which is taking getting columns using a Stored Procedure. And the output we need to write in a Flat File. The second Package also contains the same(The same Tasks, Database and Stored Procedure Calling) The difference is in the stored procedure Parameters. Based on the different parameters Stored procedures returns the different Columns and Rows output. When we are trying to Get the second package output in OleDb Data source it shows all the columns which is the output of the First Package because it stores External Meta Data. So My understanding is the Connect ...Show All

• mdschwarz SSIS interview questions.

  Could some of the expert(s) list interview questions that might come up when applying for ETL/SSIS developer I or II positions. Thanks Jamie, Why is that Is it because they would not know vb.net or misuse variables in terms of scope or you are just kidding... :-) Thanks   Chris Honcoop wrote: LOL... its a joke...  There is truth that its likely harder to come from being a pro in DTS and "adjusting" to SSIS than just learning SSIS from scratch without knowledge of DTS. 10-4 on that! Jamie & Chris are dead-on with this sentiment. The biggest hurdle I've encountered at my job is convincing the DBAs (only a few of whom have even looked at SSIS) tha ...Show All

• Alpehans MDAC upgrade problem CompCheck reports 2.5 instead of 2.8

  I am running SQL server on a Windows 2000 server with sp4 installed. After installing SQL service pack 4 on the machine my applications began complaining that MDAC was version 2.5 sure enough CompChecker reports version 2.5. I have tried to install the latest version of MDAC (2.8) on the machine but no matter what I do CompChecker reports 2.5. I've tried reinstalling the SQL service pack I had no luck with that. Any help with this issue would be greatly appreciated. Did you try to install the MDAC 2.8 separately like Satya proposed The file cannot be changed as the Windows FileProtextion is enabled for them (as you already noticed). if you already tried to install the MDAC 2.8, did you get an error or ...Show All

• MShetty compression in SP2

  Hi there. I heard Paul Flessner at PASS talk about compression in SP2 for SS05 and results that showed like 40% compression on some SAP tables -- so that made me happy! When I looked around SP2 I think I"m seeing compression is a new data type that would act like a varying data type for numerics. Is this correct, or am I am I missing something (I asked folks at PASS, but not too many people seemed to know about this). Can you let me know how this works. 40% seems worth it, what do I have to do to get it going Should I use it Thanks... Thanks Adam..it would be easier if they referred to it as that :) I look at the BLOG...cheers This feature i ...Show All

• JCJCJC Problem with Parameter

  Hi , I am having a peculiar problem when i am using report parameters in a report. I am using report paramter to let the user select the month for which the report has to run, but the drop down has ordered the months in alphabetical order,for selection Is there any way I can set it to list it in the correct order Thanks in advance PMJ Hi Joel, thanks a lot it worked !!! Thanks and regards PMNJ If you are using an analysis services datasource, there is an easy way to solve this. Open up your Date Dimension. Select the Month attribute. Right-click and select properties. Set the "Order By" property to key. Build and deploy your solution. Refresh the project ...Show All

• Allen Razdow Add connction Fails in VS.NET with SQL Server Everywhere

  When I try to use the "Data Source Configuration Wizard" (Menu: Data\Add New Data Source...) and I try to add a new Connection to the "Northwind.sdf" database using Microsoft SQL Server Mobile Edition it fails with "Unable to find the requested .Net Framework Data Provider. It may not be installed." What's really strange about this is that if I click the Test Connection" button it states "Test Connection Succeeded." I've looked everywhere and I see that other have had the same problem but no one seem to know the solution. jc3 I faced the same issue, however in my machine.config the entry was not missing but preceeded by another one. < add name = " SQL Server ...Show All

• KlausLeth SP_Help

  I need to write dynamic SQL statment that will delete a code from a table but before you can delete that code...I need to find all the foreign key constraints (all the tables that references this table to either update or delete from them and then delete from this table last) I know how to get this information from SP_Help but i dont know how I can do this dynamically. Please help. Emadkb Hi why don't you enable cascade update/ cascade delete and this will do the job automatically. The following query will return all foreign key related tables for a given table (2005 syntax...for 2000 replace sys.sysforeignkeys with sysforeignkeys) : select object_name ( rkeyid ) parenttable , object_name ...Show All

• Netmaster0000 SQL Server performance being a problem.

  I'm porting over a C# web application from MySQL to SQL Server, and so far I've gotten it up and running, but the performance is just terrible! I'm using the following script to connect to the database... <source> string TheConnectionString = "Server=PETER\\SQLEXPRESS;Database=Frostwinds;Trusted_Connection=Yes;"; MySQLConnection = new SqlConnection(TheConnectionString); MySQLConnection.Open();</source> .. and takes seconds to complete. Any ideas why performance is soo bad Once you put it on Apache I'd say there's a fair chance that the problem is with your application and web server not SQL Server Are others having the same problem from IIS ...Show All

• AhXue Multi-Table IDENTITY

  Is there a way to associate IDENTITY columns from two different tables, so that new records created in either table will have mutually unique values That is, a new record in table A will be given value 1, and then a new record created in table B will be given value 2 (because value 1 was already used by the IDENTITY column in table A). Can this be done No, identity fields are only unique within the table. ...Show All

• TomHL running MDX as user

  When browsing a cube, you can browse using the credentials of a particular user or using any combination of roles. How can I do the same thing when executing an MDX query Is there some sort of "run as" type of clause in MDX It is connection string property EffectiveUserName. You need to be administrator in order to be able to use it. Unfortunatelly, in Management Studio it is not possible to set custom connection string properties. But you can use good ol' MDX Sample application from AS2000 distributive which works just fine with AS2005 and does allow setting connection string properties. Thanks for your answer, Mosha. Is there a way to set connection properties when executing MDX ...Show All

• pasha2k OLAP Services connection 8.0 Vs 9.0

  Microsoft OLE DB Provider for Analysis Services 9.0 ------ Microsoft OLE DB Provider for OLAP Services 8.0 I have both 8.0 and 9.0 installed in my box. I use Excel 2003 to connect to AS. I opened two excel files in one I used OLAP 8.0 to create connection to OLAP database which is in AS 2000. Connection was created as soon as I click OK in "Create New Data Source" window. When I do the same using OLAP 9.0 and create connection to same OLAP database in other server using AS 2005 it takes 2 mins to just create a connection after I clicked OK "Create New Data Source" window. I am just trying to figure out why Is there some thing which will slow down my query too. Hardware is almost same and those server runs only ...Show All