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


ADVERTISEMENT

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

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 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

What Is Requirement To Make Remote Access To Other Machine ?

Jun 14, 2007

What is requirement to make remote access to other machine ?

View 5 Replies View Related

Minimum MDAC Version Requirement (Error)

Aug 8, 2006

Hi everyone;

I'm just getting started. I'm on Window 2000 pro with service pack 4 etc...
I installed "C#" and "Microsoft Visual Web Developer 2005 Express Edition" -thats fine.

I then installed "Microsoft SQL Server" (SQLEXPR.EXE) it was good until it did a check:

Everything checked and passed fine except for the 2nd to last one:
- Minimum MDAC Version Requirement (Error)
Messages
* Minimum MDAC Version Requirement

* The system does not have the required version of Microsoft Data Access Components (MDAC) for this SQL Server release. For details, see Hardware and Software Requirements for Installing SQL Server 2005 in Microsoft SQL Server Books Online.


- Edition Change Check (Success)
Messages
* Edition Change Check

* Check Passed
-----------------------------------------------------------------

So I was wondering where did I go wrong. I have lots of hard drive space too.

CPU is 1.80GHz - with 523,056 KB RAM

I did some research but there seems to be 100's of pages.

View 4 Replies View Related

Min Requirement To Run Report Builder Without SQL Server Installed

Feb 13, 2008

Do i have to install ms sql server on ever machine to work Report Builder?

View 5 Replies View Related

Interesting Requirement! How To Query Port Numbers From 120 Servers!

Dec 7, 2004

I need to document the port numbers from nearly 120 sql servers in the network. Is there any query that I can use to get this info??

Thanks,

View 13 Replies View Related

Default Installation Path Permission Requirement (Warning)

Apr 18, 2008

I am trying to install SQL Server 2005 Standard Edition in parallel with SQL Server 2000. The server is a Dell 2650 with 1 GB RAM running Windows 2000 Server.

The initial part of the setup runs the System Configuration Checker (SCC), which is generating this warning:


Default Installation Path Permission Requirement (Warning)

The server is a member of a domain, but I am logged in as the local administrator. The drive is not compressed. There are no file system problems. I am at a loss as to why this warning is occuring, and do not want to proceed until I figure this out.

(I got this warning on another server as well. That was a test server, so I proceeded. The engine seems to run ok, but SSIS will not load, says a component is missing. Not sure if the two issues are related or not).

Any ideas?

Thanks,
Mike



View 3 Replies View Related

SQL Tools :: Disk Space Requirement For Rebuild Indexes

Jul 9, 2015

I am using SQL Server 2008 (RTM) Standard Edition.

In my environment, one of my Database size is 75 gb and I have to create a plan for index rebuild using maintenance plan.But when we rebuild indexes, it requires some space on data and log files of database.how can we calculate disk space requirement for index rebuild process ?

View 4 Replies View Related

T-SQL (SS2K8) :: Design Table Which Can Store Education Requirement For Job Vacancy

Aug 13, 2014

This is my table named - CV

*CVID is a primary key

This is my table named - CVEducation

*CV to CVEducation is 1 to Many. CVEducation(CVID) is a foreign key

This is my table named - Level

*LevelID is stored in CVEducation. So, we can know - This education is Diploma or Degree or Masters or so on

This is my table named - StudyField

*StudyFieldID is stored in CVEducation. Som we can know - What kind of Education they have.

This is the example of Job Vacancy 1

1- Need Diploma in Chemistry OR Degree in Chemistry.

2- CGPA at least - 2.5

*May be need to store 2 rows with each CGPA

This is the example of Job Vacancy 2

1- Need Diploma in Commerce OR Diploma in Economics OR Degree in Biology

2- CGPA at least - 2.8

*May be need to store 3 rows with each CGPA

How to design my table to store Job Vacancy Minimal Requirement? I know, there's some cases we cannot computerized. But, at least some of Job Vacancy Requirement we can computerized.

View 5 Replies View Related

What Is The System Requirement Installing Ms Sql Server 2003 Client Version?

Sep 6, 2006

compare to ms sql 2000, the newer version seems to be slow when i tryto open or modify a table. is this a demerit of the newer vesion or mymachine problem?

View 4 Replies View Related

COM Plus Catalog Requirement (Warning) Com+ Failure SQL 2005 Express Bootstrap

Jan 24, 2007

- COM Plus Catalog Requirement (Warning)



Messages

COM Plus Catalog Requirement


If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.


Workaround says remove the .manifest files. Where are they?

SETUP CONTINUES TO FAIL









View 11 Replies View Related

Setup Question: ASP.Net Version Registration Requirement Warning Message

Jul 9, 2006

 

Hi there,

I have only this warning message during the System Configuration Check:

ASP.Net Version Registration Requirement (Warning)



Messages

ASP.Net Version Registration Requirement


64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).


Does this mean that I can't install Reporting Services or should I pay no attention to it and continue to install?

I'm running on Windows 64-bit Pro. edition.

Thanks,

Eric

View 24 Replies View Related







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