Answer Questions

• Riko Partitioned View not updatable ???

  Hi There Ok i have searched on this error and seems to be a bug or maybe i am missing something. All i need to know is can this be done or not, am i making a mistake I have created 2 tables. -------------------------------------------------------------- Table_A_Jan ( Col1 int not null, Col2 datetime not null, Col3 char(5) not null, CHECK (DATEPART(mm, Col2) = 1), CONSTRAINT [PK] PRIMARY KEY CLUSTERED ([Col1], [Col2], [Col3]) WITH FILLFACTOR = ...Show All

• Codeine SQL Server 2005 Standard Installation Problems

  I had a working copy of 2005 Standard (from the launch cd). I installed it before IIS on a brand new laptop. I installed IIS later. Now SQL Server does not run and the SQL manager cannot connect to the database. I have Windows XP Pro SP2 Build 2600. Now I can uninstall or reinstall SQL Server. I have tried with IIS installed and removed. When I try to reinstall I get a hang on with "Detecting IIS" on the screen. If I try to unins ...Show All

• Thomas Lai Is there a way around using MAX Statement on Report

  I have a report that due to being unable to find a successful solution across the web relies on me using a value in a box as shown below; =MAX(Fields!budgeted_net_rent.Value) The problem I now have is that I have another field on the report and want to a =SUM on it and it tells me that you can't do that unless it is a header or footer and something about being part of an aggregate function. How can I fool SSRS into placing the value f ...Show All

• ro4ub Replication Trigger Problem (SQL 2005): Assistance Please

  Our company is wanting to replicate a bunch of data down from our central server to tablet PC's. We really do not have anyone on staff with solid experience in replication, and have hit an error that we cannot seem to find any information whatsoever on. Here is the problem: When setting up a publication to replicate certain tables, we stop being able to do any updates on the tables. After some research, we were able to narrow the problem i ...Show All

• stevejones76 Persisting Package Variables

  I was able to write successfully a Script Task to set the values of several package variables. But when the execution completes, the variables still contain values which were specified by default. What I want is a method of persisting the values assigned to a variable through a script. I believe this was possible in DTS The variable is not saved, because you have not saved the package. There is no way to do this really, so for anythi ...Show All

• Christian Willumsen SQL SERVER database DIAGRAMS problem...

  Hi all,  i m trying to create database diagram but as soon as i click on DATABASE diagrams it gives me the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database ...Show All

• Evgeny Popov Getting sample databases in Management Studio

  How to get sample database AdventureWorks and AdventureWorksDW deployed in Management Studio. I selected to install sample database entire feature on my local hard drive and I can see it did installed all the .mdf,.ldf,.dim,.cube and the rest in C:\Program Files\Microsoft SQL Server\90\Tools\Samples\ How can I get the database in Management studio. I tried to use Attach db and it didn't worked, gave me following error Msg 1813, Level 16, State ...Show All

• James Smiley What's my login?

  Hello, I installed Visual Studio 2005 and SQL Server Express that comes with it. I have also downloaded Web Data Administrator for database management. What login do I enter to connect to SQL Express via Web Data Administrator SQL Express installed silently together with VS, and I was never asked to provide a default username/password. Any help PS. I am using Win XP Pro SP2 Thank you If you are using Win ...Show All

• Anonymous1673443 Adding Viewer Controls to WinForms or Web project

  With the release of the feature pack for SQL 2005 and the included Datamining Viewer Controls I was wondering three things. 1) How do you add these controls to your toolbox and 2) Are these controls installed with VS 2005 or SQL 2005 and these are just the redistributable versions for systems where VS 2005 and SQL 2005 are not installed 3) Is there a description of the controls and what each one does 1) How do you add these controls to y ...Show All

• dajrumman Scripting Options in Management Studio

  How do you change the scripting options in Management studio For example, I want to script the create statement and permissions for a sproc; however, it won't add the permissions - I have to manually add it. The lack of scripting options is a HUGE discrepancy with this tool. The old Enterprise Manager tool did a much better job at this. Am I going to have to use 2 tools Hi, I've only found one way to do th ...Show All

• katrien dynamic query

  hi, i'm using dynamic query in the dataset because i wanted the result to group by the particular parameter selected. however, another parameter requires the data to be taken from another table. is the following syntax acceptable =if (Parameters!rev_data = 'A') begin "select a,b,c.... from tableA" end else begin "select d,e,f.... from tableB" end i encounter this error : 'Expression expected'... is the ...Show All

• CodeForProject Applying SP to Log-shipping Standby server

  Scenario: SQL2000 server that is the Standby server in a log-shipping scenario The need: Apply SP4 to the standby server Issue: Service pack installation wants all databases to be "writable". The databases on the standby server are "IsInStandby" state and cannot be made "writable" (non-Read-Only) by the Alter Database command. Question: is there a way to alter the state so that I can apply the service pack ...Show All

• Danny Chan Foreach NodeList Enumerator

  Does anyone have any experience of using the NodeList enumerator in a Foreach loop BOL is a bit light on this. I want to enumerate over an XML Document that is passed into my package. The package is executed from a .net application. Has anyone done anything like this Any demo material Should I pass the XML Document into an SSIS object variable or a String variable Can the NodeList enumerator enumerate an XML document that is stored in a Str ...Show All

• AleksandrKostick Package Name in Custom LogProvider

  I'am working on a custom logprovider. And I want to log the packagename as well. How can I get the packagename in my log sub ...Show All

• wayneacton How do I pass multiple paramters to reporting services?

  I want to pass parameters from a web form to a reporting service report.  I have 3 report parameters defined.  Emplnbr, StartDate, EndDate.  The spelling is exactly the same in the report parameters asn in this statement. This is my statement Response.Write("<script language = ""Javascript"">var win=window.open(""http://becsql/ReportServer %2fHuman+Services/Training%2fTrainingReport&rs:Command=Render&rc:Paramete ...Show All