Help! No Clue On My Requirement And Where To Start

Jun 28, 2004

Hi,
I am not even sure where and what to do on this requirements

"If the system crashes before all the information during transaction fails, none of those changes will be saved to the database."


what kind of info you need from my DB?
no clue.

thanks

View 1 Replies


ADVERTISEMENT

No Clue About This Error

Jul 13, 2006

 No clue whats causing this error,please help
Server Error in '/learn' Application.


Unable to open the physical file "g:inetpubwwwrootlearnApp_DataPersonal.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".An attempt to attach an auto-named database for file g:inetpubwwwrootlearnApp_DataPersonal.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

View 2 Replies View Related

Need To Backup W/o A Clue How To

Dec 10, 2002

I have no idea what I'm doing in SQL Server 2000... honestly no DBMS. I have a book at home but am required to do a backup of about 20 databases today (updating software tonight). Can anyone help me out? I found this (http://www.databasejournal.com/img/backupdatabase.sql) script but do not know how to run it (query analyzer?).

Thanks!

View 1 Replies View Related

Query Would Run For Ever - No Clue

Oct 25, 2005

Hello fellow DBAs

I have a strange situation here. I am executing a SQL query which runs for ever till it fills up all the available temp space.

The same query runs within 1 minute in another database on another server. That database is a development database but with same records (and data).

I tried the following:

UPDATE STATISTICS
DBREINDEX
FIXED FRAGMENTATION BY RUNNING DBINDEXDEFRAG

Nothing helps... what should I do next?

View 1 Replies View Related

Buy A Clue As To How To Iterate Sideways

Sep 14, 2007



hi
i am having a hard time with two kinds of text files that have kind of 'repeating groups' in them...i want to loop it, but dont know how.
one is a text file with a record length of 1200 bytes, but all 95601records are all on one row with no lf, cr or anything else between them, so i cannot feature how to get the forEach container to chop of a Right of claimchunk of 1200 bytes at a time, then go get the next 1200 bytes, because the items aren't stacked, they are adjacent to each other, if you see what i mean.
the other text file has a record lenght of 52 bytes with 28 bytes filler, but this file also goes 'down and across', meaning that here, there are fourteen 'rows' in the file, and they have thousands of lines too, so this one also has to consume all the columns on the row before it moves to the next row.
am i making this harder than it needs to be?
thanks for any light

View 7 Replies View Related

Matrix Report - Need A Clue

May 11, 2007

My data is like this:



QualifiedDate Total DateTimeQualified



2007-05-11 30 5/11/2007 3:12

2007-05-11 29 5/11/2007 6:28

2007-05-10 22 5/10/2007 1:54

2007-05-10 10 5/10/2007 5:55





Report needs to be like this:



2007-05-11 59

2007-05-10 32



with a drill down option to get it broken down my the datetimequalified



I've seen some examples but they are so overblown I can't figure it out



Can someone give me something simple to start with?

View 1 Replies View Related

Substring (Need Help) , Clue, Hint , Solution....?

Apr 10, 2002

Hi there,

I need to get back the actual characters (without trailing blanks) contained in a char(43) field.
So i tried:
- substring(fieldname,1,len(fieldname)) which yields a 43 char column
- using a variable that contains the actual length in
substring(fieldname,1,@nchar)) the same.
- tricking by concatenating the resulting string with a dummy like "" didn't
work either.
So apparently I am at a dead end.
Anybody a clue, hint or solution????
Thanks to all contributors

View 4 Replies View Related

Any Clue To Make This Query Run Faster

Oct 3, 2006

Any help would be really appreciated....
My stored procedure...




CREATE PROCEDURE business3rd7
@Fromdate DATETIME,
@ToDate DATETIME
AS



select distinct CONVERT(VARCHAR(10),Receipts.Companynumber1)+CONVE RT(VARCHAR(10),Receipts.Companynumber2) as co ,
Receipts.Premium1+Receipts.Premium2 as Premium,
"CAN"=case when Receipts.transactiontype='CAN'
then (receipts.premium1+receipts.premium2)
else 0
end,
"NET"=Receipts.Premium1+Receipts.Premium2-case when Receipts.transactiontype='CAN'
then (receipts.premium1+receipts.premium2)
else 0
end,

"#NEW"=case when Receipts.transactiontype='NEW' then count(Receipts.policynumber) else
0 end,

-------
"$NEW"=
case when Receipts.transactiontype='NEW' then (Receipts.Premium1+Receipts.premium2)
else 0 end,
"#REN"=case when Receipts.transactiontype='REN' then count(Receipts.policynumber) else
0 end,
"$RENEW"=
case when Receipts.transactiontype='REN' then (Receipts.Premium1+Receipts.premium2)
else 0 end,
"#AP"=case when Receipts.transactiontype='AP' then count(Receipts.policynumber) else 0
end,
"$AP"=
case when Receipts.transactiontype='AP' then (Receipts.Premium1+Receipts.premium2) else
0 end,
"#SENT"=case when policy.Renewalofferdate between @Fromdate AND @ToDate then
count(policy.policynumber) end,

"%"=case when case when Receipts.transactiontype='REN' then count(Receipts.policynumber)else 0
end =0 then 0
when case when policy.Renewalofferdate between @Fromdate AND @ToDate then
count(policy.policynumber) else 0 end=0 then 0
else
case when Receipts.transactiontype='REN' then count(Receipts.policynumber)else 0
end /case when policy.Renewalofferdate between @Fromdate AND @ToDate then
count(policy.policynumber) else 0 end end,


"Current Year"= case when policy.Renewalofferdate between @Fromdate AND @ToDate then
count(clubamount) end,
"Previous Year"=case when policy.Renewalofferdate between DateAdd(year, -1, @Fromdate)
AND DateAdd(year, -1, @ToDate) then count(clubamount) end,
"#AA"=count(receipts.clubamount),
"$AA"=sum(receipts.clubamount)

FROM Receipts,Policy
where Receipts.Agencyid=Policy.Agentid
group by
Receipts.CompanyNumber1,Receipts.CompanyNumber2,
Receipts.Premium1,Receipts.Premium2,
Receipts.TransactionType,policy.Renewalofferdate,
Receipts.Agencyid



GO


Query plan...

----------------------Query Plan

|--Sort(DISTINCT ORDER BY:([Expr1008] ASC, [Expr1009] ASC, [Expr1010] ASC, [Expr1011] ASC, [Expr1012] ASC, [Expr1013] ASC, [Expr1014] ASC, [Expr1015] ASC, [Expr1016] ASC, [Expr1017] ASC, [Expr1018] ASC, [Expr1019] ASC, [Expr1020] ASC, [Expr1021] ASC, [Ex
|--Compute Scalar(DEFINE:([Expr1008]=Convert([Receipts].[CompanyNumber1])+Convert([Receipts].[CompanyNumber2]), [Expr1009]=[Receipts].[Premium1]+[Receipts].[Premium2], [Expr1010]=If ([Receipts].[TransactionType]='CAN') then ([Receipts].[Premium1]+[R
|--Compute Scalar(DEFINE:([Expr1004]=Convert([Expr1076]), [Expr1005]=Convert([Expr1077]), [Expr1006]=Convert([Expr1078]), [Expr1007]=If ([Expr1078]=0) then NULL else [Expr1079]))
|--Stream Aggregate(GROUP BY:([Receipts].[CompanyNumber1], [Receipts].[CompanyNumber2], [Receipts].[Premium1], [Receipts].[Premium2], [Receipts].[TransactionType], [Policy].[RenewalOfferDate], [Receipts].[AgencyID]) DEFINE:([Expr1076]=COUN
|--Sort(ORDER BY:([Receipts].[CompanyNumber1] ASC, [Receipts].[CompanyNumber2] ASC, [Receipts].[Premium1] ASC, [Receipts].[Premium2] ASC, [Receipts].[TransactionType] ASC, [Policy].[RenewalOfferDate] ASC, [Receipts].[AgencyID] ASC))
|--Hash Match(Inner Join, HASH:([Policy].[AgentID])=([Receipts].[AgencyID]), RESIDUAL:([Policy].[AgentID]=[Receipts].[AgencyID]))
|--Table Scan(OBJECT:([gasInquiry].[dbo].[Policy]))
|--Table Scan(OBJECT:([gasInquiry].[dbo].[Receipts]))



The two tables has number of records as 13349 and 97032.It taking more than 30 mins...
Any way to make it faster...

View 14 Replies View Related

Clue - Who Dun It? The Data Adapter, DataSet, SqlSelect Etc...

Feb 23, 2007

Ok, I know my connection string and config file are good. Once the rest of the code is added I receive this error:
"SQL Server does not exist or access denied. "
 I'm using the 1.1 framework and my hosting company provides MSSql 2005.
Thanks for your time,
Charlie
Here's the code in my cond behind file.
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
 
 
namespace blog
{
            /// <summary>
            /// Summary description for WebForm1.
            /// </summary>
            public class WebForm1 : System.Web.UI.Page
            {
                        protected System.Data.SqlClient.SqlConnection sqlConnect;
                        protected System.Web.UI.WebControls.DataList dList;
                        protected System.Data.SqlClient.SqlDataAdapter DA;
                        protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;
                        protected System.Web.UI.WebControls.LinkButton linkAdmin;
                        protected System.Web.UI.WebControls.Image header;
                        protected blog.DS ds1;
           
                        private void Page_Load(object sender, System.EventArgs e)
                        {
                                    DA.Fill(ds1, "blogEntry");
                                    dList.DataBind();
                        }
 
                        #region Web Form Designer generated code
                        override protected void OnInit(EventArgs e)
                        {
                                    //
                                    // CODEGEN: This call is required by the ASP.NET Web Form Designer.
                                    //
                                    InitializeComponent();
                                    base.OnInit(e);
                        }
                       
                        /// <summary>
                        /// Required method for Designer support - do not modify
                        /// the contents of this method with the code editor.
                        /// </summary>
                        private void InitializeComponent()
                        {   
                                    this.sqlConnect = new System.Data.SqlClient.SqlConnection();
                                    this.DA = new System.Data.SqlClient.SqlDataAdapter();
                                    this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
                                    this.ds1 = new blog.DS();
                                    ((System.ComponentModel.ISupportInitialize)(this.ds1)).BeginInit();
                                    this.linkAdmin.Click += new System.EventHandler(this.linkAdmin_Click);
                                    //
                                    // sqlConnection String
                                    //////////////////webserver////////////////
                                    this.sqlConnection1.ConnectionString = "Server=xxx.xxx.xxx.x;Database=myDataBase;User ID=myID;Password=myPass";
 
                                    //////////////////local///////////////////
                                    //this.sqlConnect.ConnectionString = "workstation id=HAL;packet size=4096;integrated security=SSPI;data source=HAL;pers" +
                                                //"ist security info=False;initial catalog=blog";
                                    //
                                    // DA
                                    //
                                    this.DA.SelectCommand = this.sqlSelectCommand1;
                                    this.DA.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                                                                                                                                                                                                                                                                         new System.Data.Common.DataTableMapping("Table", "blogEntry", new System.Data.Common.DataColumnMapping[] {
                                                           
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        new System.Data.Common.DataColumnMapping("bodyID", "bodyID"),
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              new System.Data.Common.DataColumnMapping("linkID", "linkID")})});
                                    //
                                    // sqlSelectCommand1
                                    //
                                    this.sqlSelectCommand1.CommandText = "SELECT id, wxID, dateID, titleID, bodyID, linkID FROM blogEntry ORDER BY id DESC";
                                    this.sqlSelectCommand1.Connection = this.sqlConnect;
                                    //
                                    // ds1
                                    //
                                    this.ds1.DataSetName = "DS";
                                    this.ds1.Locale = new System.Globalization.CultureInfo("en-US");
                                    this.Load += new System.EventHandler(this.Page_Load);
                                    ((System.ComponentModel.ISupportInitialize)(this.ds1)).EndInit();
 
                        }
                        #endregion
 
                        private void linkAdmin_Click(object sender, System.EventArgs e)
                        {
                                    Server.Transfer("logOn.aspx",true);
                        }
            }
}
 

View 5 Replies View Related

I’m Getting This Error When Checking Out A Report From Visual Source Safe…any Clue As To What It Means?

Mar 22, 2007

Originally got this error as the reason some of my .rptproj files could not be converted from SRS 2000 to 2005.  Now I€™m getting this error when checking out a report from Visual Source Safe 6.0€¦any clue as to what it means?

Project item '4294967294' does not represent a file.

This is for a solution created and stored in VSS using VS2003 and SRS 2000.  Now trying to open with VS 2005.

View 2 Replies View Related

Maintenance Plan - Back Up Database Task Fails Without Giving A Real Clue On How To Fix It.

Apr 18, 2008

Created a maintenance plan to backup my sharepoint databases.
When I execute it the following error occurs:
Execution failed. See the maintenance plan and SQL Server Agent job history logs for details:
Additional Information:
Job 'SharePointBackUp.Backup_SharePoint faild. (SqlManagerUI)
- Execute maintenance plan. SharePointBackUP (Error)
Messages
* Execution failed. See the maintenance plan and SQL Server Agent job history logs for details.

------------------------------
ADDITIONAL INFORMATION:

Job 'SharePointBackUP.Backup_SharePoint' failed. (SqlManagerUI)


When checking the Maintenance PlansharePointBackUP log it is empty!
Under Job History I thinks this:
Date 4/18/2008 12:55:35 PM
Log Job History (SharePointBackUP.Backup_SharePoint)
Step ID 1
Server DESD7
Job Name SharePointBackUP.Backup_SharePoint
Step Name Backup_SharePoint
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed.
line 1? Is that line one of the T-SQL statement? Because if that's the case then it's not because I copied and pasted the line in to a query and it executed without error.
Under SQL Agent there are no entries!
So what bloody log am I suppose to be checking?! This is very frustrating.
I then copied and pasted every sql statement in to a query and THEY all ran just fine.

What's going wrong here, and how can I correct it?

View 5 Replies View Related

SQL Requirement

May 17, 2008

Hi
I am looking to buy an SQL server2005 with 5 CAL's for my company in UK to fulfill our database management requirements. There seems to be a big difference between the US and UK prices. The US prices are somewhere around half the price of what i could get in UK. Are there any tax implications if i order one from US. Would there be any problems of registration if i buy from US. Any answers would be greatly appreciated.
I need to order them asap.
Thanks

View 1 Replies View Related

HAVE One Requirement In A Table.

Jan 22, 2008

i HAVE  one requirement in a table. that is   column1 for first record value 100next record                  101next record                  102next record                  103for next                         104I want to update that table daily with this requirement.not with identity columnnext day 100 may be 220,339, some thing random numberlike this how can i update a table column1

View 2 Replies View Related

License Requirement

Jan 24, 2005

Hello,

Anyone aware of any license requirment for selling any application developed in ASP.NET (C#) using MSDE as backend?

Any response will be highly appreciated.

Thanks

View 5 Replies View Related

SQL 2003 Requirement

Apr 24, 2003

Windows 2003 came in the market already.
Yukon is going to release soon.

Will SQL Server 2003 run better on Windows 2000 Server, or it will run better on Windows Server 2003?

Anybody know?

View 1 Replies View Related

Urgent Requirement

Jun 10, 2008

Hi Experts ,
I want to insert datas randomly to all columns of a table.The columns have different datatypes like int,varchar,datetime. What to do??? It is urgent so please help.


TIA

RKNAIR

View 6 Replies View Related

Hardware Requirement

Dec 26, 2007



Is there any recommendation of how to calculate what would be a suitable hardware requirement for running a huge database on Production. I have a database with over 150GB of data. The server has 1.5GB memory. The database is indexed. The size of the database will most probably exceed over 400GB of data. Is there any recommendation on how much memory / hardware to put on the box.

Also on a side topic, how do large sites (example - microsoft forum) keep storing information in a database and still allow fast searching? Do they move old info to another database... But I am able to search across old information as well.

View 5 Replies View Related

Com Plus Catalog Requirement?

Sep 27, 2007


Hello, this is Subhani .

I am installing Sql 2005 standard version.

The problem is that while I am installing Sql 2005 the two warning messages are given that €œcom plus catalog requirement€? & €œminimum hardware requirement€? So please suggest me, what I have to do to install successfully

View 2 Replies View Related

VLDB RAM Requirement

Jul 17, 2007

Hi experts,

We have SQL Server 2005 installed in MS Windows server 2003 with 8 GB RAM. This server has 4 processors.

Ours is a VLDB and a single table has 400 million records occupying nearly 40 GB of space.

We find it vert difficult to meet the response time set by the clients in many occasions.

Should the RAM be atleast as big as the biggest table in the database ? Is this mandatory ?

Even any other suggestions for improving the performance are welcome.

Thanks & Regards,

Hariarul

View 4 Replies View Related

IIS Feature Requirement (Warning

Sep 18, 2007

Hello there

I installed sql server 2005 developer edition

and the only error message i got was.

- IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

how do i get hold of Internet Information Services
I installed it on vista premium.

Please help

Regards
ROB

View 3 Replies View Related

HW Requirement For SQL Server 2005

May 20, 2006

We are running four servers at different sites say A,B,C and D and wantit to connect main Server at head office what would be theconfiguration of main server for running SQL Server 2005.There are twodatabase say X and Y at each server at sites A,B,C and D. X requires37.4 MB memory while Y requires 154 MB memory. 500 records arepopulated in X database at each site While 30000 records are populatedin Y database at each site. What would be HW requirement for SQLServer?With regardsAli Raza Rajput

View 2 Replies View Related

SQL Server Express Requirement

Jun 21, 2007

Hi, I read throught the requirements of installing SQL Express and found that one of the requirement stated Microsoft .NET Framework. As I'm now developing my application in VC++(MFC), it's not build on .NET Framework. I wish to know in my case, can I use SQL Express in my application? Thank in advance.

View 4 Replies View Related

Operationg System Requirement

Apr 24, 2006

I am in the process of learning SQL from scratch and figure it would be helpful if I can run a local server and experiment with it as I move along some book reading. I have a few questions regarding the operating system requirement for running a localhost server and hope some of you can answer to my novice questions. Can I setup a server under Windows XP? when I looked thru the documentation it indicated only windows 2000 and other Microsoft server OS will support a SQL server setup. Why then it also indicate XP as compatible? Is it because it's compatible as a client? If I do have to run a server under a different operationg system, what is the best approach for setting up another server on my only PC system along with my XP. Thanks for any answers and comments in advance.

View 7 Replies View Related

Server/Network Requirement

Jun 8, 2007

I have developed a client server application using SQL Server 2005 Express and VB.Net. I will be distributing it to my customers. I am putting together a System Requirement document. I am wondering what kind of Server (o/s) and network configuration customers need to have. I know they cannot use a pier to pier network setting. What kind of network setting do they need to have? Does the server machine need to have a server o/s (such as Win 2003 Server) or is Windows XP fine? Any help will be appreciated.

View 3 Replies View Related

Pending Reboot Requirement

Feb 20, 2007

I just installed SP2. I wanted to install the AdventureWorksDW database as part of the Database Engine Tuning Advisor tutorial. It said my install was not finished and I had a "pending reboot requirement." I shut down, and 8 different updates ran. When I tried to install the AdventureWorksDW database again, I got the same message. I'll see if there are still more updates to run.

View 10 Replies View Related

How To Write Query For This Requirement

Oct 26, 2007

Hi friends
this is the Orders to rise the publisheres (Titles or magzines).
I have two tables
1) orders Tables the columns are like orderno int , titleId int ,ItContaincomb bit, combinationID int.


Values(1,2,null,null)
values(1,3,null,null)
values(2,4,null,null)
Values(2,3,null,null)
values(2,2,null,null)
values(3,4,null,null)




2) CombinationTable containg columns like CombId int , Titleid int.
values(101,2)
values(101,3)
values(102,4)
values(102,5)
valus(103,2)
values(103,4)


my requirement is in orders table the last twocolumns should be filled by checking the combination table
1)
take 101 combination containg 2,3 titles check these all titles are containg or not . if Compulsory all titles containg means in orders table we put
ItContaincomb true, combinationID 101 for all containg titles.

if not containg single title in orders table for combination 101 means
we put that titleid rows should containg column of ItContaincomb is false and combid is 0.



i want below out put for above two tables how to write a query or how to use all function.
the output is (in orders table)
Values(1,2,true,101)
values(1,3,true,101)
values(2,4,false,0)
Values(2,3,false,0)
values(2,2,true,103)
values(3,4,true,103


please help me .
thanks regards
venkat

View 3 Replies View Related

Installation (min Hardware Requirement) W2k3

Nov 14, 2007

Hi.
I've been having a problem with SQL Server 2005 installation.

I get these errors:

- SQL Server Edition Operating System Compatibility (Warning)
Messages
* SQL Server Edition Operating System Compatibility

* Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.


- Minimum Hardware Requirement (Warning)
Messages
* Minimum Hardware Requirement

* The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.


I can't install server services --> see here http://img221.imageshack.us/my.php?image=sqlinstalacjase9.jpg


-I'm trying to install SQL Server 2005 Standard edition on Virtual PC (host Windows XP Pro SP2, virtual system: Windows 2003 Server)

-I've been trying assigning from 512 to 750 Mb of RAM to virtual system

-I can install it on host (xp pro) without any problem

-I'm installing it from iso files - so it's not possible something is wrong with cd

-I'm using laptop Lenovo - Core 2 Duo 1,5 Ghz | 1 Gb ram

-I have plenty of space and checked option that says the disk is "dynamically expanding"


Any pointers? [Don't give me those http://fun.noshit.pl/DIR-2007.11.08/pointerstb1.png]

View 2 Replies View Related

IIS Feature Requirement And Reporting Services

Jan 4, 2008

Hi
I was trying to install the SQL server 2005 trial version and the only warning I got was for IIS feature requirement.
I am using MS Windows XP home edition SP2 with 1GB RAM and 2.80 GHz pentium processor.
How can I get this IIS feature on my machine with these specifications? am I forced to have a different operationg system to support the IIS? Is this problem caused by the operating system I am using or what else could have caused this?

After installing SQL server 2005 by ignoring the IIS warning I realised I could not get Reporting service feature installed.
How can I get this Reporting service ? Will I be able to get the reporting services installed if I do not change the Operating system? What should I do if I want to have reporting services components installed on my machine?



Thanks

Below is the warning message I got , I tried to follow the instruction but I could not see the IIS anywhere on my machine
"- IIS Feature Requirement (Warning)
Messages
·IIS Feature Requirement
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online."

View 7 Replies View Related

Regd - License Requirement For Replication

Jan 26, 2007

Hello,

I am trying to figure out if we want to implement replication in SQL Server 2005 does it require licensing.

I have got information on BOL for license information on cluster and log shipping , but

didnot get any exact information for license regardign Replication and Database Mirroring.


Can anybody please direct me to where I can checkout .

Thanks

View 4 Replies View Related

IIS Feature Requirement - All Components Are Installed!

Apr 10, 2008

I'm trying to install SQL Server 2005 Express with Advanced Features (SP2), ideally with Reporting Services. However, every time I try to install it, setup fails the IIS Feature Requirement.

This is starting to get annoying, as every single component for IIS 7.0 is installed.

Strangely, if I go into the Programs and Features thing (I'm on Vista HP), select SQL Server 2005, and click Change, the setup here passes the IIS test.

Could it be that because SQL Server is already installed (just the database engine), it is affecting an 'upgrade' to the Advanced Features pack? Will I have to uninstall SQL Server completely, then reinstall it (no biggy) ?

View 6 Replies View Related

Redistributable SQL Express Registration Requirement?

Oct 30, 2006

I noticed that Microsoft gives license to redistribute SQL Server Express as part of an application (though we have to register for this - http://www.microsoft.com/sql/editions/express/howtobuy.mspx).

So we would like to take advantage of this, and redistribute SQL Server Express 2005 as part of our WinForms application (using the method described http://blogs.msdn.com/sqlexpress/archive/2006/09/20/763956.aspx or http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/emsqlexcustapp.asp)

My Question is: If we perform a silent install on the client machine (included with the installation of our application), are our end-users required to register Sql Server Express in order to use it? From this page (http://msdn.microsoft.com/vstudio/express/register/) it appears that in order to use an Express version for longer than 30 days, one is required to register it. However, requiring our clients to register their version of Express kind of defeats the purpose of our using Express as our database format. We need a database that we can distribute with our application, that the end-users can use without having to register.

So is the redistribution license enough (in order that the end-users do not have to register their individual copies)? Or will the end-users also have to register their copies (in which case we probably cannot use SQL Express)?

View 3 Replies View Related

Interesting SQL Query Requirement For &<SELECT&> Menu

Nov 7, 2005

Hi AllWondered if you could help me with the below query.I have 1 simple table called STOCKCATS that consists of 2 fields.These fields are called CATID and LEVEL.The contents of this table are as follows:CATID LEVELcat01 <nothing>cat02 <nothing>cat03 cat01cat04 <nothing>cat05 cat01cat06 cat02cat07 cat04etc.. etc...The way this table works is that I have an ASP page that allows the user tocreate a stock category at 2 levels, category level and sub-category level.When I file the entered data into the table, if the user has chosen tocreate a category level stock category then the LEVEL field is left blankand if they chose to create a sub-category level category then I post therelevant category level stock category code in the LEVEL field. Forexample, in the above list cat01 is a category level stock category andcat05 is a sub-category as it is a sub-category of cat01.My query is that I want to populate a simple HTML <SELECT> menu (using ASP),but instead of it being a straightforward 'select catid from stockcats orderby catid', I want to group this list into some kind of order, eg:instead of:cat01 <nothing> << I need to bring back this 2nd column so that I cando a simple IF THEN in asp to indent sub-catscat02 <nothing>cat03 cat01cat04 <nothing>cat05 cat01cat06 cat02cat07 cat04I would likecat01 <nothing> << dittocat03 cat01cat05 cat01cat02 <nothing>cat06 cat02cat04 <nothing>cat07 cat04Do you know if this is possible in pure SQL (I must confess that I'm usingMySQL, but I would have thought the SQL syntax would be the same if it ispossible) or a combo of ASP & SQL?ThanksRobbie

View 3 Replies View Related

Urgent Requirement For Project Leader/apm Required

Feb 1, 2007

hi, we are having urgent requirement for one of client cmmi level5company in hyd and chennaiif u r intrested send me u r updated resumeJoin Bytes!

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved