Answer Questions

• lung123 Using Xcopy to get the .mdf file of pubs database to the App_Data folder of a website of VWD Express project

  Hi all, I have a stand-alone Windows XP Pro PC that has SQL Server Express (SSE) and Visual Web Developer Express (VWDE) programs. The Microsoft "pubs" Database is installed in the SQL Server Management Studio Express (SSMSE). I created a website in my VWDE program. I need the .mdf file of the pubs Database in the App_Data folder of website of my VWDE project. I think that User Instance in my SSE is established. I have studied Xcopy Deployment (SQL Server Express) and User Instance for a quite a while and I still do not know where and how to use Xcopy to get the mdf file of the pubs database into the App_Data folder of the website of my VWDE project. Please help and give me the detailed key steps/instructions about where and h ...Show All

• Woody_In_Sheffield SQL 2005 express edition

  hi, i try to import acess data to SQL 2005 express but i couldn't find the possibility and it is possible to just copy the database (SQL 2005 express) Thank you Amelie hi Amelie, yes, this can be done... just detach the database, as this will properly shut it down and prepare it fo file system operations like copy and/or move... then you have to re-attach it.. (just a side note, the above system stored procedure has been deprecated in SQL Server 2005 in favour of the expanded CREATE DATABASE xxxx (......) FOR ATTACH ; sintax)... just remember to reattach it on the original machine as well if you like to continue to use.. BTW, ADO.Net offers a simple solution via a property ...Show All

• dizzyjay Tutorial cube error:

  Hi I am using SQL 2000 Analysis Services and going through the tutorial. Got to last stage of the 'Quick start' section where I want to browse my cube data I just get the error "Unable to browse the cube 'Sales'" Unspecified error. If I close AM and go back in and try then a seond error 'Unable to locate cube 'Sales' is also displayed. Everything in tutorial before that point went fine. Just can't get past this issue now. I only have one instance of SQL installed. Any help much appreciated. Rich Sorry got confused a bit with versions. It is little surpising to find anyone trying to learn AS2000 these days. Most of the people spending time trying to get around using AS2005. To ...Show All

• Chris.James.Boyd SQL server version needed for an internet site

  Hi All, I am a new comer to the internet e-commerce and ebusiness service. I would like to know whether the SQL Server 2005 standard x32 edition (5 client), could be good enough to support an ebusiness internet site. When an internet browser access to my site, would that access be counted as one client Also, I would like to know whether anyone there have experience of using SQL express edition to support an internet site, that has robust data transaction. And how is the performance. Thanks a lot. SPA SQL Express is used to support Web sites. However, due to the single CPU and memory limitations, it most likely would not be a good match for a successful high traffic eCommerce site. Performance is related ...Show All

• Arthropleura The return of Problem Assigning Value to Package Variable From Data Flow Script Component

  I have a Data Flow Script Component(Destination Type) and in the properties I have a read/write variable called User::giRowCount User::giRowCount is populated by a Row Count Component previously in the Data Flow. After reading http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=97494&SiteID=1 it is very clear that you can actually only use  variables in the PostExecute of a Data Flow Script Component or you will get an error "Microsoft.SqlServer.Dts.Pipeline.ReadWriteVariablesNotAvailableException: The collection of variables locked for read and write access is not available outside of PostExecute." What I need to do is actually create a file in the PreExecute and write the number of records = User::giRowCount as&nbs ...Show All

• eddy05 accessing data base from remote computer

  we have sql 2005 standard edition. i was trying ( unsuccessfully ) to configure RAS on server 2003 to allow the server to authentificate vpn requests. i don't know how but the next day people started complaining about their mapped network drives being disconnected, and now no one can connect to the database via the network, eventhough they still have access to the server, and the network drives were remapped. actually now that you mention it, there is a message that keeps showing up since about the time i started playing around with RAS. it is from NfsSvr. it says mapping information could not be obtained from user mapping. another attempt will be made in 30 minutes. this message first appeared about noon on fri. however we started h ...Show All

• Ash Dude newsequentialid

  HI Does anyone know if the sentence below from BOL means newsequentialid does not generate unique id on computer with network card we have a sql database that uses newid for several tables, I want to switch to newsequentialid to reduce page splits The GUIDs generated by NEWSEQUENTIALID() are unique within a particular computer only if the computer does not have a network card thanks Pauli Hi, see this article for more information: http://sqljunkies.com/Article/4067A1B1-C31C-4EAF-86C3-80513451FC03.scuk HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Barts007 start from expression

  Hi, Maybe somebody experienced the same thing: It happens more and more that I have to split up my packages into two flows and then execute one flow dependent on a variable's value. Like for example if a boolean variable is true -> do one side of the package otherwise follow the other flow Untill now I started from an empty script task and then achieved my goal via constraints but as I want to cut out all the quick and dirty parts of my packages... So, should I create a custom component greets, Tom Hello Darren, Thanks, you're right, in order to keep the visibility acceptable (I'm working on a project that will be passed through to the client), I've chosen for the expressions. Greets, Tom ...Show All

• Majones Basic convert question

  Hi, How can I convert one number to string with option ot choose decimal I mean function ( 1234.45, varchar , 2 ) or function ( 1234.45, varchar , 3 ) function ( 1234.45, varchar , 1 ) function ( 1234.45, varchar , 0) Is there any function cheers Here's one way:   CONVERT(VARCHAR, CONVERT(DECIMAL(9,3), 1234.45))   Change the DECIMAL(9,3) appropriately for whatever scale you need...   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     <Alessandro Camargo@discussions.microsoft.com > wrote in message news:ba20cb3c-e990-4276-a07e-a22e8e1ed9a7@discussions.mi ...Show All

• Jonathan Cran Difference between the SQL Server Express Bundled with C#/VB VS the downloadable SQL Server Express SP1 with advanced Services

  What is the Difference between the SQL Server Express Bundled with C#/VB VS the downloadable SQL Server Express SP1 with advanced Services I installed C# with SQL Server Express, however I wanted to add the Full Text Searching and the SQL Server Management Studio Express, so I downloaded and installed the SQL Server 2005 Express Edition with Advanced Services SP1. When I installed it over top of my current installation, it complained of version mismatching, and then C# failed to recognize that I had SQL 2005 Express installed at all. What I'd like to know is, which version is more current (they have to be different, they had different version numbers, one was 9.xx.xxxx the other was 2005.9.xx.xxxx) The one bundled with C#, or th ...Show All

• Don McDonald DatabaseLog table

  AdventureWorks database has tables: DatabaseLog, ErrorLog. I figured there should be a system stored procedure that creates such tables for your database. So far I could not find what it is. I would appreciate a pointer. Thanks. Andrea Montanari wrote: hi, Jens is right about the "general logging" purpose... if you like you can script those objects out... try having a look at my amScript free project, that can script out even the database trigger so that you can inspect the relative DDL code.. regards Thank you, Andrea and Jens. Andrea's websites are very helpful. I have already downloaded some code. As far as I can remember those tables, these are just tables for a generic error sol ...Show All

• Idanle Moving reports backward from RS2005 to RS2000

  Is there a nice way to get reports from an RS2005 project into an RS2000 project I know this sounds like an odd request but I have built reports in RS2005 that need to be deployed to a server with only 2000 on it. I don't really want to have to go in and re-draw all those reports. Any ideas would be most appreciated! Thanks, Eva I just followed the instructions to the letter. I didn't need anything else. ok... I have read your comment in Charlie's article - you entered your sql-statements right in the reports without using stored procedure. Best way for the downsizing-option... If you think about a scenario with stored procedures I think it would be worth thi ...Show All

• Hatzi74 Avg based on column values

  Greetings, I need to avg column data based on grid textboxes. I cannot use AVG because the column values come from a comma delimited string. I have tried using !Parameters to store a count and total for each column but they are always read only. What is the best approach. The columns come from a field which is in the format of (99,75,60,100,-1,20,-1,80,75) for each record -1 means the values are not counted in the average. I have a function for each textbox that parses the value from the list based on the column index. There can be 1 to many columns. Everytime I to set the value of a field or parameter at runtime I get a read-only error.   Maybee the only way is to use calculated fields.   Any id ...Show All

• MaliGogi Association model prediction not using itemsets

  I have a market basket model using associations. It generated several dozen itemsets. However when I attempt to run a singleton prediction like this: select ( Predict (Orderproduct3q, INCLUDE_STATISTICS ,10)) as [Recommendation] From [Case All] NATURAL PREDICTION JOIN ( SELECT ( SELECT '16407' AS [Pname])) AS t1 the resulting predictions don't take the itemsets into account. Instead, the predictions consist of the ranked products in the training set, ordered by frequency. This appears to happen regardless of the precise query specified within the "natural prediction join". What's going on here and how do I generate a singleton prediction which makes use of the itemsets ...Show All

• jasmine pham SQL Client Redirect - Database Mirroring

  Hi All, My apologies if this question seems abit basic, but I'm a DBA by trade and programming .Net isn't my strong point ;) I've enabled database mirroring on 3 SQL 2005 servers, a principal, a mirror and a witness. Principal - SQL 2005 Enterprise Edition, SP1 Mirror - SQL 2005 Enterprise Edition, SP1 Witness - SQL 2005 Express, SP1 I've written some test code to test the mirroring but as soon as the connection is pulled from the principal, the client re-direct doesn't work and the program bombs. I'd be grateful fi someone could have a look at my code below and tell me if there's any schoolboy errors (NB, the user running the code is a sys admin on all 3 servers) Thanks in advance. Im ...Show All