Network share/Multi user deployment

SQL Server Compact Edition

Index ‹ SQL Server

- Previous
  - 1
    - SP_Change_Users_Login It's hard to say without knowing what the purpose of these users is. It also looks like you've had this situation before the upgrade. If you just want to make all users map to the same login, you can create the login, like Raul indicated, and then you can map the users that have a different SID to this same login by using the ALTER USER ... WITH LOGIN statement that I discussed at http://blogs.msdn.com/lcris/archive/2007/02/19/sql-server-2005-some-new-security-features-in-sp2.aspx . This should make all users have that login's sid. But you should understand how you got in this situation in the first place - were these users supposed to really map to the same login From some background on how logins map to users, it may also help to take a look at this: http://blogs.msdn.com/lcris/archive/2007/03/23/basic-sql-server-security-concepts-logins-users-and-principals.aspx . Thanks Laurentiu Tag: Network share/Multi user deployment
  - 2
    - Partitioned View Problem Hi all, I am designing 3 p:artitioned views for 3 tables. Those tables grow up in 1.5 millions of rows per month (each one), so I decided to partition those tables monthly. The issue is that if I want to create the views with more than 256 months (256 tables) SQL Server says: 'Server: Msg 106, Level 15, State 1, Procedure Jugadas, Line 258 Too many table names in the query. The maximum allowable is 256.' Is there any workaround for this Another solution maybe PD1: I've tested with less than 256 tables and it works fine, I can update and query the tables (except for a couple of querys where I've got to join 2 or more of the involucred views in which case I got a similar error saying about a 260 table limit). Tag: Network share/Multi user deployment
  - 3
    - how to get all data from database on sql server 2005 how to get all data from database on sql server 2005 in to a file. File is include scripts can build another database as the same old database. include data in all table Tag: Network share/Multi user deployment
  - 4
    - Linked server memory consumption Hi all, I have two database server, named it DB_A and DB_B. I want to establish a linked server of DB_A in my DB_B. There's a script in DB_B that queries data from DB_A but only execute periodically. Does linked server consume large memory or CPU when it didn't use Thanks in advance, Hery Tag: Network share/Multi user deployment
  - 5
    - Querying 1 member from 2 hierarchies in same dimension? I've tried to do this: select ({[Date].[Fiscal].[Fiscal Year].&[2004], [Date].[Calendar].[Calendar Year].&[2004]}) on 0 from [Adventure Works] but it errors with Members belong to different hierarchies in the function. Then I tried: select ({[Date].[Fiscal].[Fiscal Year].&[2004], [Date].[Calendar].[Calendar Year].[All Periods]}, { [Date].[Fiscal].[Fiscal Year].[All Periods], [Date].[Calendar].[Calendar Year].&[2004]}) on 0 from [Adventure Works] Two sets specified in the function have different dimensionality. Tag: Network share/Multi user deployment
  - 6
    - Visual Studio closes when data source has changed Phil Brammer wrote: Just know that using SSIS in a source control environment *can* cause problems. The XML is not easily "diff-able" and as such sometimes versions get corrupt. Just something to consider. I know people use it regularly without problems though, too. I had one client using a 3rd party source control system (sorry - cannot remember the name, but it was not Subversion) that regularly corrupted the DTSX files because it wasn't handling them as Unicode correctly. FWIW, I have had hundreds of packages in TFS for months and have never had issues with corruption. Tag: Network share/Multi user deployment
  - 7
    - OLTP Database Design help for bank's customer table Hello,friends 1) CustomerID 2) FirstName 3) MiddleName 4) SurName 5) Title 6) Marital Status 7) Education 8) Occupation 9) Annual Income 10) Line of Business 11) DOB 12) Father Name 13) Mother Name 14) SpouseName 15) Gender 16) Email 17) MainTel 18) Home Tel 19) Passport Number 20)---------------------- 21)- - - - - - - - - - - 100)------------------- Above mentioned list is a snapshot of our customer master table ,which contain approximately 100 attributes related to a customer. We are designing an application for banking sector (but NOT Core banking solution),for which we may need to capture variable number of addresses for bank's customer,i.e more then three types of addresses Fixed,Temporary and Communication addresses(which is generally the case with all banks). A single address includes address1/address2/city/country/state/pincode fields. In context of OLTP database, We have option to put multiple addresses in child table but that involves various joins at the time of data retrival and slow down the query. As another option we can can create redundent addresses columns(address1/address2/city/country/state/pincode) in master table that will accumulate addresses if demand for more then three type addresses arises(although there is reasonable numer of extra addresses is expected, i.e 10) Database is expected to serve the records of 25 million(approx) bank's customer,so does someone can suggest me how to maintan the balance between two approches. Tag: Network share/Multi user deployment
  - 8
    - Need drillthrough for just one month--but cube goes back two years BIGuy--we never found a solution. Tag: Network share/Multi user deployment
  - 9
    - Data Mining Client for Excel Is it at all possible to use this tool without any connection to SQL Server (mine data in Excel Worksheets only) Or is it required to connect to SQL Server From reading the documentation, one minute I get the feeling this is possible, then the next section I get a feeling it's not. Can anyone help Thanks. Tag: Network share/Multi user deployment
  - 10
    - microsoft decision tree algorithm Thank you for your answer, Jamie. but my question is how to split the continous INPUT attribute (The target variable is assumed automatically to be continuous in the case of regression tree). Tag: Network share/Multi user deployment
  - 11
    - DBCC SQLPERF WaitStates / OLEDB OK ... how many of you run dbcc SQLPERF(waitstats) to display analyze SQL Server 2000 resource utilization How about sp_waitstats This is a very useful stored procedure that takes the sqlperf output and aggregates it over common wait types. If you've had to work on a sick SQL Server box, I've found this pretty useful to help pinpoint bottlenecks. While there's plenty written about the various wait types, there seems to a shortage of stuff written about acceptable or expected values! I am experiencing some performance problems with some procedures running on the EE of SQL 2000 w/SP3 on a server with 12 GB of RAM & 8 CPUs. Since no major locking issues stood out, I ventured to see what types of waits were occurring. Using both dbcc SQLPERF(waitstats) and sp_waitstats I found 98% of the waits where the OLEDB type. First I've never seen a single wait type be responsible for such a large %. For this type of wait, SQL Server is waiting for a OLE DB provider to service its request. High transactions or slow connection speeds in a distributed env are a big cause of these. This can be caused by slow authentication, outdate MDAC or incorrect DB Providers. (OK, I have to admit I haven't seen this type of wait before) Has anyone else encountered this type of wait I've seen various I/O Latch waits in the past but this is the first time I've seen OLEDB. If you've seen this, what were the steps taken to remedy this situation Thanks, JoeT Tag: Network share/Multi user deployment
  - 12
    - Sql 2005 Management Studio I have the same requirement. If you found a solution, can you please post it Thanks, Tony Tag: Network share/Multi user deployment
  - 13
    - DTS Package problem? I have set up a couple of DTS local packages to run ActiveX scripts creating XML files and copying them to our webserver (on the same domain). I can run them OK manually via the 'Execute' package command in the drop down list when I right click on them and also get the 'Package successfully run' message back on running them, but when I schedule them to run overnight I find the SQL Server Agent reports them as 'failed' . What am I doing wrong Tag: Network share/Multi user deployment
  - 14
    - SQL mail using external mail server Hello We are using SQL Server 2000 SP4 Standard Edition and would like to use the e-mail function to monitor certain alerts. However, an e-mail server (SMTP server) is not installed on that box, but on a different IP address within the network. I have set up the e-mail operator, enabled e-mail in SQL Agent and set the Mail Configuration in Support Services. However, on testing I get the following error : Error 18030: xp_test_mapi_profile : Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client. As I cannot install Outlook on this server, I am now stuck. Has anyone a suggestion how I can overcome this issue Thanks, Marcel Tag: Network share/Multi user deployment
  - 15
    - Synchronization fails I think Support code 80070008 has something to do with memory on the device. Go to Start => Settings => Memory and kill any un-needed processes. Then try to Sync again. SC Tag: Network share/Multi user deployment
  - 16
    - Help on global variable for insert statement If I am understanding you correctly, it appears that you wish to load textbox values into the table depending upon the status of other textbox values. Your use of the IF...ELSEIF structure may work just fine for your intentions. Something like this might work. IF Textbox1.Text = '' Then IF Textbox2.Text = '' Then oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('" + Textbox3.Text + "', '" + Textbox6.Text + "', '" + Textbox9.Text + "')" ELSE oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('" Textbox2.Text + "', '" + Textbox5.Text + "', '" + Textbox8.Text + "')" END IF ELSE oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('" + Textbox1.Text + "', '" + Textbox4.Text + "', '" + Textbox7.Text + "')" END IF Tag: Network share/Multi user deployment
- Next
  - 1
    - Cannot connect to SQL Server DB Engine...Instance Contains SQL Express in Name Ekrem Thank you for that information. I have more details to help pinpoint the problem. I have the enterprise version which I installed. (I installed the developer's version on a different machine and had access to all services locally). I uninstalled and reinstalled. When IK view services, I see SQL EXPRESS service running, not SQLSERVER. SO I can connect locally to a SQL Express instance, however, I cannot connect to the DB server, to which I have full permissions. The first message I receive had a reference to the pipes, so I enabled pipes on the DB server. I went to connect to it again, and cannot see it in my list of browsed servers. UGH ! Tag: Network share/Multi user deployment
  - 2
    - continuous attribute & Complexity_Penalty I am having one question about discretization of continous attributes values. How does it work I need this information for my thesis. I have a continous attribut, namely SKS, with range 0-20. When I use Microsoft Decision Tree algorithm, this attribut split in SKS <= 18 and SKS > 18. I want to know how does it find 18 as a number to split not the other. One question again about Microsoft Decision Tree algorithm, about Complexity_Penalty parameter. How does it affect the algorithm For example, if I set this value=0.1 what does it mean and how does it correspond with growth tree Thanks a lot before for your kindness to answer my questions.. :-) Tag: Network share/Multi user deployment
  - 3
    - Deploying subscriptions on different server Hi, I have three environments which are exactly the same. A dev, prod and backup server. Everyone has its own installation of SQL. What is the best practice to re-use the subscriptions for the other environments I know I could restore the test database but I would prefer not. Thanks in advance for any input. Best regards, Jam Tag: Network share/Multi user deployment
  - 4
    - MDX Query performance issue Yes - what I tried to say in the previous message, that there doesn't seem to be a solution to your performance problem. NON_EMPTY_BEHAVIOR improves performance of queries similar to yours, but unfortunatelly, it cannot be applied in your case. Tag: Network share/Multi user deployment
  - 5
    - DFT - Howto last execute a storedprocedure donRiccardo wrote: Well I'm only collecting, Taskname, InsertedRows, UpdatedRows and DeletedRows, and not actually the execution time, then it would be more correct to have it after the DFT. But the main reason was to NOT needing an EST after every DFT, keeping a more cleaner ControlFlow /Richard I don't get it, but to each his own. The control flow is still the proper place, in my opinion, for what it's worth. The PostExecute() method seems a bit silly to me because it's hidden from view and perhaps easy to overlook when maintaining the package. Tag: Network share/Multi user deployment
  - 6
    - Jump To Report Without Running It Automatically Hi I need to be able to click a hyperlink in one report to open a linked report, but without automatically running the linked report. Scenario . I have a report showing customer details and on this page there is a link to a price enquiry report. This price enquiry report has two parameters: customer code and product code. When I click the price enquiry hyperlink in the customer details report I can only attach a value to the customer code parameter. The product code parameter is not known at this stage and would have to be provided by the user after the price enquiry report is opened (but not run). The customer code parameter should already be filled (carried in the link). When I click the link at the moment I get the error "The 'product' parameter is missing a value". Any advice much appreciated. Thanks, SQLServant Tag: Network share/Multi user deployment
  - 7
    - Can I Upload a URL or Shortcut to the SSRS Home Page? I have a simple WSS 2.0 SharePoint site for my SSRS deployment which I would like to link my users to from the SSRS home page. Is it possible to add a link or shortcut to my SSRS home page without embedding it inside of a document or report Tag: Network share/Multi user deployment
  - 8
    - Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later. As mentioned above in the posts, change the log on account from local system account to a specified account, even if its the same account that you are signed on to the server. Worked like a charm for me.. thanks guys... Tag: Network share/Multi user deployment
  - 9
    - Capture date and timestamp of a file? The script would be your FTP session. It would replace your FTP task. Tag: Network share/Multi user deployment
  - 10
    - SCOPE_IDENTITY() hi what is difference between thos two's SCOPE_IDENTITY() and @@IDENTITY thanx Tag: Network share/Multi user deployment
  - 11
    - How to dynamically process a Model in a Web App mr jamie... this link seems to be dead please send in the link again Tag: Network share/Multi user deployment
  - 12
    - SUM and Iif statements Jarrett, (iBB) is just an alias I use here. What you provided does get me past intellisense, but what I need to accomplish is not reflected in that statement. See my reply to Shyam for details. Thanks! Tag: Network share/Multi user deployment
  - 13
    - Windows CE 6.0 and SQL Server Compact I do not know, I don't work for Microsoft. But version 3.5 is currently in beta, and will be released when Visual Studio 2008 is released, beginning of next year Tag: Network share/Multi user deployment
  - 14
    - Logging Differences: Dtexec vs (Dtexecui or Visual Studio) Having a problem where I can't get "OnPostExecute" or "OnPostValidate" logging lines to appear in outputted log file when using dtexec. These lines do appear however when running through the gui interfaces (Visual Studio or Dtexecui) with the same package being run. Is this because there is a difference in logging between the two or what else could be causing this. I read that Dtexecui just runs/calls Dtexec but this does not seem to be the case as I have tested this scenario with the same package and get the different looging outputs. Even used the command line text from Dtexecui and ran with Dtexec but still different results. Thanks in advance Paul Tag: Network share/Multi user deployment
  - 15
    - connecting through C# When I look at the connection string it's: Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\ProcBuilder.mdf;Integrated Security=True;User Instance=True This works fine on my machine, but when I try to run it on another computer it tells me: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections." It should not be trying to connect remotely, it's a local DB. Do I have to install SQL Express on the machine I'm installing this on for it to work Tag: Network share/Multi user deployment
  - 16
    - Remote Access to SQLServer 2005 It seems like you have not configured for remote connection though u said u did. Refer : http://support.microsoft.com/kb/914277 http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx Madhu Tag: Network share/Multi user deployment

arothberg

Can a SQL Server 2005 Compact Edition database file be deployed on a file share and be accessed by multiple (5-10) concurrent users This is a current scenario being implemented at several sites using MS Access databases.

Each client would have the SQLce engine installed on it and would only access the database via a managed C# application.

Top

Re: Network share/Multi user deployment

William Vaughn

Ah, no. While you can place a .SDF on a file share, the first process that opens the file locks it for all other users. This is discussed in my new EBook. See www.hitchhikerguides.net.

Top