Answer Questions

• Kuntal Loya - MSFT Query

  I have attached the Adventureworks database to SQL Server 2005. Whenerver I try to run a new query to this database Ex: select * from sales . customer I get this error message Msg 208, Level 16, State 1, Line 1 Invalid object name 'sales.customer' . I don't know why this is happining Hi, make sure you are deling with the right database (Select db_name()). Didi you change the default collation Seems that yo ...Show All

• Kirk Pinneo SQL Server 2005 Express limits

  I see that Express has a 4 GB database limit -- is this RAW data, or the size of the files, is it the size of objects like indexes and indexed views What happens when you pass 4 GB Thanks Oh - I like that -- so it somewhat helps. But what is the 4 GB limit. File size for the datbaase. Does MS have some sort of regulator. What happens if an insert exceeds the 4 GB. Does 4 GB just raw data, or does it include in ...Show All

• Toomy Ling SQL Servers Communicating Across a DMZ

  In a proposed architecture, a production SQL Server will live in the DMZ, and an additional internal Production server will reside on the internal network. If Port 1433 is opened on the firewall and access to the DMZ SQL is restricted to only the internal SQL server, is this secure I've been told two stories: 1) That if port 1433 is opened, that a hacker can enter the DMZ and then browse ANY SQL Server on the internal network, not just the inte ...Show All

• btb73 Memory allocation to SQL Server - AWE under 32 GB

  I am setting up a server under Windows Server 2003 Enterprise Edition (SP1) and SQL Server 2000 Enterprise Edition (SP4). The new server is a AMD opteron with 32 GB of memory. I noticed that PAE is enabled automatically by Windows 2003. Should I enable AWE for SQL Server 2000 and specify Max and Min amount of memory for SQL Server Is there a limit on how much I could specify in MAX memory for SQL This is the first time I have a server wit ...Show All

• galbox20 Comparing differences in database structure between databases

  I am trying to find a way to easily compare the difference in table/column structure between two SQL server databases. I am doing this since I need to document the foreign key relationships between a database schema that is currently under development. The foreign keys are not defined as constraints in the database, but are controlled through the application. The current naming conventions make it easy to see what the relationships are ( ...Show All

• Steve Collins Restore Database from file

  Hello, I had backed up a database from SQL 2000, just before I format my computer. Now I have installed SQL 2005 and trying to restore that database to it, it doesn't work and I get the following error when doing that =================================== Restore failed for Server 'localhost\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) ------------------------------ For help, click: http://go.microsoft.com/fwlink ProdName=Micros ...Show All

• Sorin Varzaru Finding the Analysis Services Project Template

  I am having trouble with a very simple step. I can't seem to find the Analysis Services Project Template. I am using SQL 2005 with the Business Intelligence Design Studio, and I tried to follow the tutorial for "Creating an Analysis Services Project," I open the new project dialog box, and the template is not there. Anyone have any idea what I should do Thanks very much! Thanks for your help! I ...Show All

• MartinClayton Oracle 9i -> SQL Server 2005: Snapshot agent aborts suddenly uninterrupted

  Hi - I hope some of you can help me with this problem. I'm trying to run the snapshot agent for 77 published tables, but the agent stops suddenly uninterrupted. It stops in the middle of taking a snapshot of a table containing 81,719,531 rows. The error message is pasted below. Message 2006-06-14 05:33:33.53 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57200000 total rows copied) 2006-06-14 0 ...Show All

• joop SSIS error message when trying to open MSDB in management studio

  Hi all, I get this error when trying to open folder MSDB in management studio. I'm running Win 2003, SQL server 2005 64 bit on AMD with two instances of SQL. Any one that have a solution I havent found any thing that works. If I enable VIA in SQL Server I can't start SQL Service TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For ...Show All

• Zoidberg Invalid Data Type error with Subreports

  I have a report with two subreports.  The parameter connecting the report with the subreports is based on a field with a datatype of UniqueIdentifier. If I run each of the subreports by themselves, entering in value for the parameter, they run fine. When I try to run the master report, it runs, but the subreport sections contain the following text instead of the correct output: "Error: Subreport could not be shown."  The Output window ...Show All

• aprivate Calculate Median Value

  I am converting a report created using Crystal Reports 10 to Reporting Services.  The report contains a list of items with dollar values.  The original report displays both the Average and Median value.  I can easily ( using avg(Field1.Value!) ) determine the average but cannot find a function to determine the median. How can I add the Median to the report   Thanks in advance, Greg ...Show All

• dragonsteve Strange reporting services permission error

  In a Team project, my account has a role of "Content Manager", but I go to the reporting Services home page for the project, click the "Contents" tab (this is address I see: http://devgrpun1/Reports/Pages/Folder.aspx ItemPath=%2fProject1&ViewMode=Detail ) and try to click to edit a report (e.g. Quality Indicators), I got an error message: The permissions granted to user 'UPSTREAMACCTS\nyc' are insufficient for performi ...Show All

• WedgeSoft Sql Server 2005 setup error message

  Hi I am trying to learn VB 2005 and I am reaching a step in my studies which requires downloading Sql Server 2005. However every time I attempt to download, I receive this error message. "SQL Server Setup cannot install files to the compressed or encrypted folder: c:\Program Files\Microsoft SQL Server\. To continue, make sure that your installation directories are not compressed or encrypted, or specify a different directory, and then ru ...Show All

• Leo TLee yyyymmdd text data into a datetime field in SQL Server?

  Hello, I have an Excel spreadsheet that contains 100,000 + rows of data. Two of the columns in the spreadsheet are date fields that are sent over in the yyyymmdd format (no separators such as "-" or "/"). I tried converting these fields into dates using the Data Conversion task in SSIS. This doesn't work as it appears that SSIS cannot map a string in the format of yyyymmdd to a valid date. In lieu of this, I have added a S ...Show All

• NZSnowman Answer: Report Model/Builder

  In a database there are 2 tables, one is student and the other is activities.  A student can have multiple activities.  There is a one to many relationship between student and activities based upon student_id.  Not every student has an activity. In report builder I would like all of the students to appear regardless of whether they have an activity or not.  By default, only those students who have activities appear. This appe ...Show All