mine is a small organisation and we have deployed an ERP on windows 2003 server. their are total 60 ERP users and we have 25 concurrent licences for ERP.
at the backend we are running MS SQL 2000 standard edition. we have created one user in Database and ERP accesses data through this user only.
now i need to understand how many CAL for database i need to purchase. either 60 or 25 or 1.
thanks
Hi friends,
How r u?..i have one clarification..Curently, i am doing one search engine stuff...for that, i have to populate data from sql server database to flat file..i got java script search engine code from one web-site,in that code,data's are fetching from flat-file only..so i have populate the data from sql server to flat-file, and then get the key-word value from that flat-file according to the user input..Is it possible?..send mail..
Bye from
Jan Reddy
I just finished getting a local database mirrored to an offsite "DR" server. Interesting experience getting that working, but that's another story! It's set up as "High Safety without automatic failover (synchronous) (without a witness). I was hoping I could get a sanity check in this flow....
Local database gets updated each morning with a few meg of data, so it's pretty low use. It's mirrored through a T1 (soon to be dual). My remove copy was restored from yesterday€™s backup, and the mirror was sync'd in less than 10 minutes, so I don't expect bandwidth to be an issue...
In the event that my local server or network is down, I'd be able to log into my remote server, and run my application remotely. From what I've seen, the "Failover" option is only available on the "Primary" server? Will this become an option if the remote no longer sees the primary, or do I need to do this through the command: ALTER DATABASE <dbname> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS?
Since the updates are so limited, I'm not too concerned with data loss, but will need to make sure I can get this running quickly if needed...
As I understand it, this will put the mirrored database as the primary, and when the old primary comes back only, it'll become the new mirror? I can then let them sync, and force a failover from the remote system to put the primary back to the local network.
I just want to make sure I understand this correctly before I start testing. Thanks for any assistance!
Steve
I want to create a DataList that shows products, which will be on
multiple pages. I have my stored proc to show paged results, which
contains a return value for more records.
I have found examples of coding the DataReader, defining all the
parameters etc, but what about the drag and drop SqlDataSource?? You
can select the DataSource Mode to be "DataReader". I can put select
parameters in, with input and my return value. I don't know how to then
access the return value, or output value if needed, from this? My
DataList references the SqlDataSource, but I don't know how to get the
return/output value out??? This is very frustrating, cause I can't find
any info about it anywhere. Always input parameters, but no output.
This is my current SqlDataSource...
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
DataSourceMode="DataReader" ConnectionString="<%$
ConnectionStrings:Personal %>" SelectCommand="sp_PagedItems"
SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:QueryStringParameter Name="Page" QueryStringField="page" />
<asp:Parameter Name="RecsPerPage" DefaultValue="10" />
<asp:QueryStringParameter Name="CategoryID" QueryStringField="cat"
/>
<asp:Parameter Name="RETURN_VALUE" Direction="ReturnValue" Size="1"
/>
</SelectParameters>
</asp:SqlDataSource>
If I take out the RETURN_VALUE Parameter, my results display in my data
list, but that's useless if I can't access the return value to
determine the remaining number of pages etc. Is my RETURN_VALUE
parameter wrong? How do I access that? My stored proc is shown below...
CREATE PROCEDURE sp_PagedItems
(
@Page int,
@RecsPerPage int,
@CategoryID int
)
AS
-- We don't want to return the # of rows inserted
-- into our temporary table, so turn NOCOUNT ON
SET NOCOUNT ON
--Create a temporary table
CREATE TABLE #TempItems
(
ID int IDENTITY,
No varchar(100),
Name varchar(100),
SDescription varchar(500),
Size varchar(10),
ImageURL varchar(100)
)
-- Insert the rows from tblItems into the temp. table
INSERT INTO #TempItems (No, Name, SDescription, Size, ImageURL)
SELECT No, Name, SDescription, Size, ImageURL FROM Products WHERE CategoryID=@CategoryID
-- Find out the first and last record we want
DECLARE @FirstRec int, @LastRec int
SELECT @FirstRec = (@Page - 1) * @RecsPerPage
SELECT @LastRec = (@Page * @RecsPerPage + 1)
-- Now, return the set of paged records, plus, an indiciation of we
-- have more records or not!
SELECT *,
MoreRecords =
(
SELECT COUNT(*)
FROM #TempItems TI
WHERE TI.ID >= @LastRec
)
FROM #TempItems
WHERE ID > @FirstRec AND ID < @LastRec
-- Turn NOCOUNT back OFF
SET NOCOUNT OFF
I hope someone can help here. I found that I was having replication failing due to the fact that there is a foreign key being referrenced, here is the error:
Could not drop object 'dbo.tblName' because it is referenced by a FOREIGN KEY constraint.
(Source: Database Name (Data source); Error number: 3726)
In searching for some sort of answer - I came across this:
Join Filters
Foreign key relationships are central to most database designs. For example, in a database that tracks product orders, you often see a CUSTOMER table with a CustID primary key and an ORDER table with a CustID foreign key that references the CUSTOMER table. In merge replication, if you filter the CUSTOMER table with a subset filter clause, you must also filter the ORDER table, so that only the rows that reference the filtered subset of rows from the CUSTOMER table are replicated. Filtering requirements that are based on a foreign key relationship must be explicitly represented in the merge replication configuration through a join filter (which lists the two related table articles and a logical expression that identifies the relationship), as shown in the following example:CUSTOMER.CustID = ORDER.CustIDThe effect of this join filter between the CUSTOMER table and the ORDER table, together with the subset filter
clause on the CUSTOMER table, is that Subscribers to the publication receive only those rows from the CUSTOMER
table where State = 'WA' and only those rows from the ORDER table that correspond to the CustID
values in the filtered CUSTOMER table.
________________________________________________________________________
Am I reading this right? If I have only one table that I need to replicate, I would need to included the other tables connected by
the foreign key for the replication to work, and in doing so - the table I designate for updating in this replication will be the only
one affected and the others that have go with this - won't update their corresponding dupe tables? Sorry - I hope this makes sense.
I have a question , because I€™m not very experienced with VB.
The function declares
Public myString
Public myKey
When something is declared this way, what happens if two or more users happen to execute the report at the same time? Is myString and myKey public to all of those reports at the same time, or does the Report Server manage those variables separately for each of the reports running concurrently?
Any clarification on this......................?
thanks
My goal is to populate a dropdownlist with only with users that are "Techs". I am using the membership database that you ccan set up through VWD. I added this column to the aspnet_Users table: IsTech as bit datatype. I thought I had the right SQL statement but apparently not, because I get an Invalid column name 'True'.Here is my statement: <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:HRIServiceConnectionString1 %>" SelectCommand="SELECT [UserID], [FirstName]+ ' ' + [LastName] AS techid FROM [aspnet_Users] WHERE [isTech] = True ORDER BY [LastName], [FirstName]"> </asp:SqlDataSource>
View 9 Replies View RelatedThe distinction between Entity and Relationship is obvious to me. But I am confused by Table. Table describes Entity, Relationship, or both?
Thanks for any input.
http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx
The above link says the pros and cons of two SQL Server 2005 editions.
Document says Compact Edition is not good for €˜When you need a multi-user database server
€™.
What is the meaning of multi-user database?
Does this means the database strictly will not support two database connections at a time?
-Thank you,
Gish
Can come one help me how to disable an index using select query.
Hi,
I am working on a SQL Server database that will be accessed (mainly) via a web interface that will have users from various countries. As I understand it, the best way to store data is to use 'n' (nvarchar etc) datatypes for columns, which allow users to enter data and it will be stored in the raw Unicode format. For other reasons the collation of the db has been changed (to Slovenian) but I understand that this will only affect how data is sorted. However, whenever I try to put certain data into the nvarchar field (Such as the £ symbol) the data get transferred to a letter L. Is that how it would be expected to work and if so am I missing something here - note I Know ent manager sometimes shows data incorrectly, but this happens when I add/view data from anywhere (i.e. end manager/ the website/ query analyser).
Any clarification would be much appreciated.
Kenny
Hi,
I'm seeing confusing results coming back from a query and I want to make sure my joins are working as expected.
I have 3 tables, tbl_family, tbl_familyPhone, and tbl_phone. tbl_FamilyPhone is a linking table between families and phones that specifies if it's the primary number.
tbl_Family tbl_FamilyPhone tbl_Phone
--------------- ------------------------- ----------------
pk_FamilyID pk_FamilyPhoneID pk_phoneID
fName fk_FamilyID fk_TypeID
lName fk_PhoneID ...
... ...
So a family has many familyPhones and a phone has many family phones. I'm trying to get all the families and their home phone only, if they have one. I don't want families to duplicate and I don't want any left out. Here's what I've got
Code Snippet
select [whatever]
from tbl_family
LEFT OUTER JOIN tbl_familyphone on tbl_family.pk_familyid = tbl_Familyphone.fk_familyid
inner JOIN tbl_phone on tbl_familyphone.fk_phoneID = tbl_phone.pk_phoneid and tbl_phone.fk_phonetypeid = 'E6F1688E-015B-481D-8C41-DCC1FEA5D5AB'
My thinking is the inner join between tbl_Phone and tbl_FamilyPhone will cause any FamilyPhone record without a phone record to be left out (fk_phonetypeid is the id of a home phone). Though some FamilyPhone records may be left out, I will not lose any families because it is left outer joined to familyphone. Is this right? Because if I just do select count(*) from families I get 4517 records, but when running the query above with the joins, I get 4383 records.
Does the Table Lock option in the OLE DB Destination task in a data flow refer to a lock on the destination table or on the source table from which the table is loading from?
The reason I ask is because I have a package run twice simultaneously pulling from the same server and table onto two different tables on two different servers. When I kick off my job to run the two data pulls, one of the jobs terminates with a
"TCP Provider: An existing connection was forcibly closed by the remote host." message. I believe this is due to a table lock on the server, but can't figure this out.
Thanks in advance for your help.
My environment looks like:
- Windows 2008R2 SP2 VM (VMware 6)
- SQL 2012 SP2 Std.
- NetApp iSCSI LUNs, Snapmanager for SQL
So I have created a test database and configured the logs to grow to max. 120MB in size.
To check the allocated and free space I right-clicked the database -> tasks -> shrink file
I see currently allocated: 5,00MB and 2,50MB free space for the MDF Database
I see currently allocated: 1,00MB and 0,63MB free space for the LDF Logfile
Next I use a data generator to fill the database with random data.
After adding around 500k rows I check the size again:
I see currently allocated: 17,00MB and 0,44MB free space for the MDF Database
I see currently allocated: 61,94MB and 0,27MB free space for the LDF Logfile
Next I take a full backup incl. truncating log files. After that I check the size again:
I see currently allocated:Â 17,00MB and 0,44MB free space for the MDF Database
I see currently allocated: 61,94MB and 57,24MB free space for the LDF Logfile
So now my question is where are those 56,97MB? I imagined they should now be added to the MDF file but they seem to be just gone. I did this procedure 2x more time and the MDF stays the same size while the LDF is almost empty after backups. Then I thought maybe its in the memory of the server so I rebooted it. But still the MDF has the same size... Is this normal? How it should work?
From BOL, I see these remarks with respect to the MODIFY FILE subcommand (my underline added):
Initializing Files
By default, data and log files are initialized by filling the files with zeros when you perform one of the following operations:
Create a database
Add files to an existing database
Increase the size of an existing file
Restore a database or filegroup
Which leads me to believe that expanding the size of a datafile will also wipe out (my definition of 'initialize') any existing data within that file.
I may be misunderstanding 'initialize', because when I tested it out, I found this wasn't the case - my table data written to the file was still there after a resize.
Need to clarify to what degree I'd be taking a risk by increasing the file size on a datafile which already has data in it.
We're upgrading our SQL Server database from 2005 to 2012.I ran the Upgrade Advisory report and got this issue "Non-integer constants are not allowed in the ORDER BY clause in 90" because of the script below
SELECT
gp.BRAND+' <> '+gp.CATEGORY AS 'full name',
gp.PRODCODE,
gp.CATEGORY
FROM dbo.GFK_PRODUCT gp
ORDER BY
'full name'
I tried running the same query in our test SQL Server 2012 and it ran successfully. Now I'm confuse if i still need to change it.I google the issue a bit and came across this link and mentioned this.
1.) Non-integer constants are ... constants that are not integer number.
Example:Â 'string1'Â represents
a string constant
0x01Â represents
a varbinary constant
{ts
'2015-02-26 06:00:00'}Â represents a datetime constant
1.23Â represents
a numeric constants
2) So single quotes are used to define a string constants / character string constants but SQL Server allows also to use single quotation marks use also as column identifier
delimiter:
SELECT ... expression AS 'Column1'
FROM ...
In this context is clear that 'Column1' is a column identifier but when used in ORDER BY : ORDER BY 'Column1' it generates confusion because SQL Server doesn't knows if it represents a string literal (character string constant) or it represents a column identifier / column name."Do I still need to change the existing code even though it's working fine in 2012? If yes, it is because of best practice reason or it will total get deprecated/not working in the future version?
Is there a way to get Licensing information(product key) off an installed version of SQL Server 2005? Most Microsoft Software has the product key in the about dialog box, but SQL Server doesn't have this anywhere.
Thanks,
Help me please!!!
I'm going crazy trying to find out the license deal for SQL Server 2000 Developer Edition. It seems that here (in the UK) the Developer edition exists and you can buy it but, Micrisoft (UK) and various resellers etc don't know the licensing deal!!!
Now, i've read a snippet somewhere about the developer edition that for a fixed price of around $499 you get a server license limited to 8 connections and you don't have to buy any CALs! However my reseller thinks that you still have to buy CALs up to maximum of 8? Well, i don't think so!!
Has anyone got this edition and know the deal?
Many thanks...
We are about to deploy an application that uses SQL Server 7.0. Enterprise edition running on a dual processor machine. We expect a maximum concurrent usage of about 500 users, normally about 150/200. Could anyone advise me what the cheapest license arrangement would be, I've had conflicting views from Microsoft and two third party software suppliers? We intend to use the machine in future for other applications but as yet have very little idea of usage.
Joe
Can any one please clear my confusion. when we install 2000 it always give option ofr licence (processor or per seat) but i installed 2005 couple of times but can' see any option in whole installation about type of licenscing. any one have any idea where and how to choose type of licence for SQL Server 2005.
Thanks
greetings,
I have several servers running sql enterprise. how do I tell version, licensing model, and client licensing(cal) installed on the server.
Thanks in advance.
Hi SQL TEAM
I'm in a bit of a situation.
Please bare with me as i explain.
We would like to host a web server
Web Server = Windows 2003 Server Standard Edition running IIS
All the website hosted on this server will be available to the public.
Question 1.How do i licenses Windows 2003 Server Standard Edition?
Question 2.Do i need a CAL for every single person browsing to any of the websites hosted on the above server.
As far as i know you can not get a PER CPU license for Windows 2003 Server, is this true.
Question 3. Where would a CAL be required.
Question 4. How about remote desktop to the above server? that requires a CAL.
Thanks in advance for any replies
I know that I can have up to 2 GB RAM for the Standard Edition of SQLServer, but if I had two instances, can I have 2 GB per instance, say for 2instances which would equal 4 GB, or is it 2 GB for that installation of SQLServer and all of it's instances?Thanks.
View 2 Replies View Related
Hello
We have a sql server 2005 Enterprise Edition installed on one of our servers where we gor processor license.
The question is can i install a second instance of Sql Server 2000 with out buying any extra licenses or should we buy licenses for this second instance seperately.
Thanks in Advance...
Obviously I'm missing something here (Like a brain??), but from the documentation I'm somewhat confused as to the licensing aspect of the everywhere edition.
Scenario: I have a client (small business for example) and I'm updeating their MS Access application, currently having the front and back ends seperate. May I substitute SQL Everywhere edition in place of the data back-end without further licensing, or will a CAL be required?
Thanks,
The company I work for has the latest MSDN subscription which has the SQL 2005 Standard edtion, as well as others, and I am trying to figure out what the license is for the SQL. I.E. Processor or what. Any help would be greatly appreciated.
Thanks,
LPATTERSON
I have a multiple processor server. Can I intall a single processor sql server 2005 on that machine and limit it to one processor only?
View 6 Replies View RelatedHi,
I need to know if I have to buy an extra license for my subscriber server in the following two scenarios. I have checked similar threads in the forum but could not find an exact answer.
Scenario 1 :
Server A : Publisher - SQL Server 2005 Standard Edition.
Server B : Subscriber - SQL Server 2005 Standard Edition
Server B has ONLY the replica of one or more DBs of Server A
I have already purchased SQL Server processor license for Server A
Replication Type : Transaction Replication
Scenario 2 :
Server A : Publisher - SQL Server 2005 Standard Edition.
Server B : Subscriber - SQL Server 2005 Standard Edition
Server B has the replica of one or more DBs of Server A plus one or more operational (mostly reporting) DBs
I have already purchased SQL Server processor license for Server A
Replication Type : Transaction Replication
Thanks
Hamed
Hi...First, I am not sure whether I put this post correctly or not. My issue is I developed one simple web application with using ASP.Net 2.0, VB 2005 and SQL express. I wonder that if i install it to my customer's pc, do they need to pay for SQL express's licensing since it is free now.. Thanks in advance.Regards, Anson
View 1 Replies View RelatedThe MSDE licence says that it can be used for up to 5 concurrent users. My app is an ASP.NET app, so won't I just be using one user - the ASP.NET account? I'm wondering whether we can get away with just buying a new server and sticking MSDE on it rather than shelling out for another £5000 SQL server licence...
View 2 Replies View RelatedI expected to find loads of posts regarding licensing but surprising not.
I have SQL Server Developer Edition, which I believe gives me the right to build and distribute applications which use MSDE (http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp).
Is there any requirement for the end user to purchase any microsoft product or license?
Quick licensing question...If I am developing an asp.net application using sql server 2005...what is the licensing situation? Do I need just the one CAL for the server with IIS that is hosting the application? or is it one CAL per database connection? One CAL for every person using my application? I'm not sure and I want to make sure that I comply with the licensing for my application. Thanks in advance!Phil
View 11 Replies View RelatedHello all,
I did explore the archives on this one, but could'nt find anything that closely matched my issue. I'm running SQL 7.0 Server (Desktop version) on my
laptop and when I try to use DTS to transfer data from a SQL Server 7.0 running on NT Server 4.0 in the SAME NT domain. The error I get says that the
licensing arrangement I have does not permit me to use DTS.
Please help!
Regards
Uday