SQL Server Replication License Requirments

SQL Server Replication

Index ‹ SQL Server

- Previous
  - 1
    - Upload a Sql website to a host server Yes, they will. Tag: SQL Server Replication License Requirments
  - 2
    - SQL 2005 Transact-SQL Full Outer Self Join "This will perform much faster than the FULL JOIN especially for larger data sets." If there is an unique index on Product + Vendor (in that order, combination key), do you still think the second option will be more efficient than the first one This table is expected to have about 10,000 products and about 20 vendors for each product (about 200,000 at the maximum). Please clarify. Thanks Tag: SQL Server Replication License Requirments
  - 3
    - Data entry in a datetime field. I don't understand how it could get corrupted everytime. I have installed SQL Express non-service pack version, I have at one point used both SP1 and SP2 (each instance was preceeded by a full system/OS reinstall), yet I faced the same issue everytime. Tag: SQL Server Replication License Requirments
  - 4
    - Upgrade Hey guys - I need your help. We are using SQL Server 2000- do you think, we should upgrade to some later release of Microsoft SQL Servier or Migrate to Oracle, IBM or Sybase. I am also wondering, what do you think of Open Source MySQL and PostgreSQL. Have anyone of you using these databases. Thanks guys for your help - Mark Smith Tag: SQL Server Replication License Requirments
  - 5
    - Matrix Report Not Showing All Columns I have a matrix report that I am using with MonthName(Fields!Month.Value) across the top of the report. However, when there is no data under the column, the month is skipped. So, for example, I get this: January March Actual Goal Actual Goal 25 25 30 35 I have tried adding iif(Sum(Fields!Total.Value, "DatasetName" )> 0, Sum(Fields!Total.Value, "DatasetName" ), "N/A" ) But it still is not showing up. Any ideas Thanks, SHP Tag: SQL Server Replication License Requirments
  - 6
    - Access denied starting SQL Server agent When you read these sources, you will find that SQL Agent needs a high level of local access and permissions. Definintely should have a domain account (if in a domain), and be limited as to network resources. Not a domain admin. Probably not a local admin -however, that is often chosen for ease of use. It is best to 'hand craft' an account with just the right type of permissions for Agent to do its job. If a job needs access to resources, then either Agent will need those permissions, or you will set up an Agent Proxy account. Hope these help. Configuration - Service Accounts, SQL Server or SQL Server Agent service account http://support.microsoft.com/kb/283811/en-us http://msdn2.microsoft.com/en-us/library/ms143691.aspx Configuration - Service Accounts,Selecting an Account for the SQL Server Agent Service http://msdn2.microsoft.com/en-us/library/ms191543.aspx http://support.microsoft.com/kb/907557 Tag: SQL Server Replication License Requirments
  - 7
    - Can I/Should I turn off logging on some tempdb transactions? if I cant turn it off entirely, is there anyway of ensuring it is truncated between sections of code (I could then break up huge operations into smaler operations and truncate between them) Tag: SQL Server Replication License Requirments
  - 8
    - Released CozyRoc SSIS+ 1.1 Beta 3 Released a new beta of SSIS+ 1.1 library. It includes a new SSIS Zip Control Flow Task for compression and decompression of Zip, GZip, BZip2, Unix, Tar archives. Tag: SQL Server Replication License Requirments
  - 9
    - OLAP, DTS and SQL Thanks Gswan! But I don't really get it... So your SSIS package populates the cube (or dimension, i guess is not important), and calls the stored procedure. This stored procedure starts a job, that process the cubes Ok, then, the sentence to call the stored procedure from a SSIS package is that one: EXEC msdb.dbo.sp_start_job @job_name=N'SSAS : Process Cube - Full' and then, when configuring the job, I need to add this piece of code (adapted for my cube) <Process xmlns:xsd=" http://www.w3.org/2001/XMLSchema " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlnsdl2=" http://schemas.microsoft.com/analysisservices/2003/engine/2 " xmlnsdl2_2=" http://schemas.microsoft.com/analysisservices/2003/engine/2/2 "> <Object> <DatabaseID>ASCube</DatabaseID> <DimensionID>Date</DimensionID> </Object> <Type>ProcessData</Type> <WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> Is it like this How can I populate the cub from a SSIS package Thanks a lot! I think I'm starting to see the light! Tag: SQL Server Replication License Requirments
  - 10
    - sp_ListFiles works differently based on the O/S level. Be sure to test "sp_ListFiles" carefully if you use it. It will fail on some versions of Windows because "DIR" returns different time formats. For example, Windows NT 5.2 (3790) does not return the required time format. "usp_Clean_Backup_Files" uses "sp_ListFiles" and that is how I came across this. Tag: SQL Server Replication License Requirments
  - 11
    - rda dropping primary key index You may be hitting a limitation in SQL CE, like max table size = 512 MB For limits, see SQL CE BOL: Database Objects Tag: SQL Server Replication License Requirments
  - 12
    - report i need example of report, for some busines solution, do you know where i can to find it. Tag: SQL Server Replication License Requirments
  - 13
    - counting all records in a database Is there an easy way to count all records in a database Tag: SQL Server Replication License Requirments
  - 14
    - copy index statistics from production to development. I have a very large database that I need to be able to copy the statistics only from the production database server to my develoment environment. I need to be able to reproduce the execution plans on development without moving all the data. MS does this when they need to review the exeecution plan for large complex databases. Need help. Tag: SQL Server Replication License Requirments
  - 15
    - An attempt to attach an auto-named database ....\aspnetdb.mdf failed Did you create this using Visual Web Developer Express or Full Visual Studio 2005 I tried this in Express and it couldn't connect to my DB Tag: SQL Server Replication License Requirments
  - 16
    - Database in recovery I have a database currently showing to be in recovery. I have not been able to find a GUI method to monitor the progress (to determine when it might complete) so is there a command line T-SQL method to monitor the recovery process Tag: SQL Server Replication License Requirments
- Next
  - 1
    - how to enable a user account I found the the status of guest account in model database is abnormal,but i don't know how to make it active. any suggestions thanks Tag: SQL Server Replication License Requirments
  - 2
    - Why can't I use columns based on case down in my where clause I am writing a fairly simple sql, and I would like to write something like Code Snippet select firstname as firstname, case when firstname = 'Peter' then 'yes' else 'no' end as whatever from MyTable where whatever = 'yes' And this should then select out the rows where column number 2 is 'yes'. It doesn't work, and I have to copy the firstname = 'Peter' into the where clause. But why Tag: SQL Server Replication License Requirments
  - 3
    - The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. (System.Data) Following article talks about the Jet database engine installation: http://support.microsoft.com/kb/239114 Basically, if your system is XP SP2, you should have MSJET40.DLL and msjetoledb40.dll on your system. If you could not find those files on your system, you could install WindowsXP-KB829558-x86-ENU.exe Tag: SQL Server Replication License Requirments
  - 4
    - Service accounts, local admin, and sysadmin question! Yes, there is a BUILTIN\Administrators login on the server, with sysadmin privs. There is also a separate login for the SQL Server agent local administrator account. Perhaps this is the problem, the fact that the administrator account has its own login AND is part of the BUILTIN\Administrators group Because the separate login does not have sysadmin privs checked off. I think this separate login got added by accident when I scripted all the logins from a 2000 box to the 2005 server, and even though it in 2000 it is clear it is a login via group membership, the script added it like a separate login. Q. I suppose it would be safe to remove this login, yes Thanks Tag: SQL Server Replication License Requirments
  - 5
    - Incorrect Totals This seems like a good scenario for "measure expressions" - if you inspect the Adventure Works cube, various Sales Amount measures are multiplied by currency rates. For example, you could create a new "sum" measure like [Value] on the MG1 "Units" field. Then, for this new measure, configure the "Measure Expression" property as: [Measures].[Value] * [Measures].[Price] This entry in Chris Webb's blog discusses measure expressions: ... But here's a cool cube design feature that doesn't cause any conflict of interest for me - measure expessions. The easiest way to explain what they are is to explain one scenario where they're useful. In AS2K, if you've tried to model currency conversion, you're probably aware that you need to multiply the measure values in your main fact table by the currency rate before any aggregation of the resulting values takes place. You then have two choices for your cube: either precalculate the values in the fact table itself or in a view, which leads to much faster queries but also much bigger cubes, and which means the rates can't then be altered without reprocessing; or do the currency conversion at runtime using MDX, which generally leads to slower queries but which allows users to change the currency rates dynamically (for example using writeback). Neither of these options are exactly ideal so in AS2005 measure expressions offer a kind of halfway house - they are calculated at query time and yet are much faster than the equivalent MDX, but the price you pay is that they are nowhere near as flexible as calculated members in terms of the calculations you can define. ... Tag: SQL Server Replication License Requirments
  - 6
    - Error: Subreport could not be shown. Hey, I just tried that with my nwifes non-MS-priviledged Account and I can’t find it either. Seems thats you will have to be invited to put feedback on the portal. There is a link where you can post your questions (also this for your invitation) mailto:sqlconne@microsoft.(here_c0/\/\es_a_D0t_c0m ) HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Tag: SQL Server Replication License Requirments
  - 7
    - Converting XML Datetime to SQL Datetime Hi Galex I tried: SELECT Assessmentxml . value ( 'xs:dateTime(/Abc/AbcDate)[1]' , 'datetime' ) AS [AssessmentExpectedStartDate] FROM dbo . Assessment I got: Msg 2365, Level 16, State 1, Line 10 XQuery [dbo.Assessment.AssessmentXML.value()]: Cannot explicitly convert from 'xdt:untypedAtomic *' to 'xs:dateTime' Then I tried: SELECT Assessmentxml . value ( '(/Abc/AbcDate)[1] CAST AS xs:dateTime' , 'datetime' ) AS [AssessmentExpectedStartDate] FROM dbo . Assessment and got Msg 2370, Level 16, State 1, Line 2 XQuery [dbo.Assessment.AssessmentXML.value()]: No more tokens expected at the end of the XQuery expression. Found 'CAST'. What is the correct syntax to make it work Thanks Tag: SQL Server Replication License Requirments
  - 8
    - how to get YYYYMMDD formate I see that you have broken the date into at least four columns (century, year, month, day) -that is a major design error and will 'haunt' you and continually cause problems in accessing, using, and presenting the data. It would be so much simpler if you stored the date as a single datetime datatype column. However, assuming that you can't correct this very bad design mistake, you can 're-create' the dates in a fashion such as this. (I recommend creating the dates in the format of 'yyyymmdd -that is a ISO standard format that will be properly accepted by SQL Server regardless of the local/regional date settings. SELECT convert( datetime, ( PYBTHC + right(( '00' + PYBTHY ), 2 ) + right(( '00' + PYBTHM ), 2 ) + right(( '00' + PYBTHD ), 2 )), 112 ) This assumes that PBYTHC is always two digits... (By with this incredibly bad design, that may be a falicious assumption...) Tag: SQL Server Replication License Requirments
  - 9
    - Comparison of SQL Server Reporting Services to Access Reports, Crystal Reports, Cognos or other options Hello SQL Server Experts, Data Analysts, and Report Writers et al: re: Reporting Options with SQL Server I wanted to propose an offshoot to the pryor thread: Would anyone take a stab at comparing Access Reports, Crystal Reports, Cognos or other options to all the Reporting Services and its components offered as part of SQL Server , especially as to extracting data from SQL Server into a report format I guess this is a far as capabilites, ease of use, limitations, and especially formatting or presentation of the end report product Thank you to all, and I hope this is a beneficial discussion to others. Hal1490 Hal9000 Tag: SQL Server Replication License Requirments
  - 10
    - Changing the default database files path fails dear MVPs, I tried to loop through the inner exception of the failedOperationException and it turned out that the problem is that Database.Create(), Database.Drop() and connection.ExecuteNonQuery(databaseName + ".dbo.sp_fulltext_database @action = 'disable'" ); cannot be contained in a transaction this answers my question about transactions thank you very much Tag: SQL Server Replication License Requirments
  - 11
    - SSRS in Sharepoint, WrapperReportRenderingException/JobCanceledException for large Matrix (OLAP) reports Hi Prash That's spot on - thank you so much, really appreciated! Regards Alex Tag: SQL Server Replication License Requirments
  - 12
    - AMO:Can any one knows hoe to rename a role and permissions to that role Hi All, I am working on AMO and vb.net.Here with this I am managing Analysis Server 2005 with AMO. My problem is , am able to create a role with role members . but when i try to rename a existing role i couldnt see any direct methods available with AMO.So what i did is first i created a role with normal procedure and then after , i am planning to drop the existing one. here when i did this i am getting some errors while dropping the role like meta data permissions are not able to drop. so could any one come across this kind of situation please help me. your help is valuable to the go further. Regards, vishweshwar.P Tag: SQL Server Replication License Requirments
  - 13
    - RDA - multi table error for tracking Thanks Erik! I appreciate all your help. Tag: SQL Server Replication License Requirments
  - 14
    - What is the easy way to do this?. Alter the table to add the new column Code Block CREATE TABLE #Test ( [TestID] INT IDENTITY(1, 1), [enddt] DATETIME, ) GO INSERT INTO #Test(enddt) SELECT '20071210' UNION SELECT '20071028' SELECT * FROM #Test GO ALTER TABLE #Test ADD [status] AS CAST((CASE WHEN enddt <= GETDATE() THEN 'live' ELSE 'expired' END) AS VARCHAR(20)) GO SELECT * FROM #Test GO Tag: SQL Server Replication License Requirments
  - 15
    - Add SQL database - "login failed for user" error Hi I've installed 'SQL Server Express 2005 SP2'. When I select 'SQL database' from 'Add new item ' (either in Visual C# or Visual Web Developer express) I get the following errror: "Login failed for user'. My OS is Vista. I've tried reinstalling SQL Server express, but I still get the same error. Any ideas on how to fix this Thanks Jon Tag: SQL Server Replication License Requirments
  - 16
    - MULTIPLE COLUMNS using and GROUP BY I hope there's someone that is able to help me. I'm new to SQL Server 2005 and have come across a pretty tough problem. I need to return City Names from the City Table ordered by province and postal code. However, SELECT statement returns multiple occurrences of a City_Name from the Cities table. I only want the City Name to appear once though. Here's the SQL statement: "SELECT City_Name, Province_ID, City_PostCode FROM Cities WHERE City_PostCode >= " + startcode + " AND City_PostCode <= " + endcode AND City_Name != '" + exclude ORDER BY Province_ID ASC, City_PostCode ASC "; I've tried to use distinct on the City Name but that didn't work. It seems the distinct keyword has to use all the column names to return a distinct record. An alternative would be to GROUP the records by City_Name however you have to use all the columns that were selected leaving me with the same distinct keyword problem. Can anyone help me Tag: SQL Server Replication License Requirments

Matt552989

I'm setting up SQL Server 2005 Replication. I have purchase a processor license for SQL Server 2005. Do I need a Windows CAL for each device that will be accessing the replication via IIS

Thanks!

Matt

Top

Re: SQL Server Replication License Requirments

Tarek Ghazali

Hi Matt,

Replication via IIS is based on https protocol so it 's similar to Web-based applications.

And you have purchased a processor license.

Processor license. Optimized for customers building business-to-business (B2B), business-to-consumer (B2C), and business-to-employee Web-based applications. A single license is required for each CPU in the operating system instance running SQL Server. This license does not require any device or user client access licenses (CALs).

for more informations :

http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

Regards,

Tarek Ghazali

SQL Server MVP

Web Site: http://www.sqlmvp.com

Top