Answer Questions

• Will Merydith Database level lock

  Hi, How do I lock entire database I want an exclusive lock on the db by a user who is the dbo of that database only (not sa user). The scenario is we have a web application and each week we need to do data uploads (with etl). During this upload, the users accessing the website should not be able to read data. This is why I want database lock. Now the catch here is, the application access the data using user say abc. Abc is dbo for that database and the etl is also done by abc login. So will db locking help in this case as the website can also read the data being a abc user Thanks, Tanmaya You can use the ALTER DATABASE Name SET R ...Show All

• Zadoras Error: Subreport could not be shown.

  I work for a Microsoft Gold Partner and I am having a problem with subreports in SSRS 2005 SP1. Essentially, I have a report that contains subreports. The main report has a table that passes a parameter to a subreport in each row. The report renders properly when I preview it in Visual Studio, but once deployed to the server it only renders the first subreport for the first row, and every subreport thereafter displays the error, "Error: Subreport could not be shown." I tested each subreport individually on the SSRS sever and each executes and displays fine. I turned on traces in the web.config file and found some additional information: Robert Bruckner MSFT wrote: Ok, the reports are based on a report model - ...Show All

• cgkitab SSIS Error message

  I have an input text file on my local box and the SSIS package runs there. I am reading the first 24 characters of each row and populating a single-column table on a remote sql 2005 server. Her'es the werror message I get:   "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT              ' could not be opened. Operating system error code 2(The system cannot find the file specified.). Make sure you are accessing a local server via Windows security.". I certainly do have Windows access to the remove server as well as the local server. (and I test out all my SSIS connections before using them). Can anyone clarify the me ...Show All

• dseydel is_member behavior

  Hi All - I am running sql2005 on windows 2003 all with uptodate SPs Im sure this has been discussed somewhere, but I just dont understand why its behaving this way. my issue is that if a 'db_owner' is a member of another db role then the is_member('some_other_role') always returns 0 example: dbrole: testrole ntuser: joeuser ntgroup: testgroup ntgroup: grpsysadmins joeuser is a domain login. testgroup and grpsysadmins are both nt groups. joeuser is a member of both testgroup and grpsysadmins grpsysadmins is a member of administrators grp on the sql server machine testrole is a sql role testgroup is a login into sql testgroup is a member of testrole 1) when I do select is_member('db_owner') I get 1 2) when I do select i ...Show All

• Mario A RS.EXE parameters not working

  Hi Everyone, I am having a problem with the RS utility not recognizing my query parameters that I am passing to my timed subscription. I have set up my report with a "WorkOrder" parameter. I have created a trigger that causes my subscription to fire, and that trigger passes in the workorder number to the utility. The subscription fires successfully, but I am getting a blank report. I set the parameter value to "can be blank" so that I could create my subscription w/o an error. I know that my subscription id is correct when I use the fire method, because I DO get the appropriate report. I am also having the same problem when I actually log in to the report server and execute the utility from the command line. I ...Show All

• Blipwort Partition sizes

  We're looking at partitioning strategies for our cube set. The standard recommendation that I've seen in various places is to limit partitions to 20M rows or so. Can any one tell me (or point me to info about) where that number comes from For example, is that dictated primarily by the time to process the partition Query performance Disk storage efficiency Other factors I ask because we're looking at how to handle older partitions over time. Can we merge them into larger historical partitions if we know that reprocessing them would be rare (that is, if processing performance is the main concern) Would that kill query performance Or is SSAS just not designed to handle partitions that large, and it would just be a bad idea in general ...Show All

• Hemant Kumar How to manipulate string in query and create new field

  I'm very new to SQL server and can use some help. MyTable has ColumnA, which contains strings composed of 1 to 4 numeric characters (0 thru 9) followed by alphabetic characters. For example, "53ASDF". In my query, I need to create ColumnB, which takes the numeric prefix from ColumnA's string and prepends it with zeros, if necessary, to create a string of exactly 4 numeric characters. For example, I could get the following result: ColA ColB "6abc" "0006" "457def" "0457" "7232hij" "7232" I have implemented a temporary solution using a CASE statement: SELECT ColA, ColB = CASE WHEN ISNUMERIC(LEFT(ColA, 4)) = 1 THEN (LEFT(ColA, 4)) W ...Show All

• mortkar SSIS package very slow in design

  Hello, I have designed a quite small SSIS package and everything worked just fine . Untill I moved the SSIS project folder to another solution folder and added whole solution to Visual source safe. Since then opening the package for design has become unbelievably slow, debugging it even worse. I think the cause is in moving the SSIS project folder. But I have no idea how to fix this. Any suggestions Janez Yes , I left the database in state where all temporay objects are still present. When I opened the package I got zero validation errors, but it was exactly as slow as before... Hi, turning on delay package validati ...Show All

• Stephen Turner HOW DO I ACCESS SQL SERVER TO USE NORTHWIND DB

  I am attempting to access the SQL server in order to use the Northwind database. Typing in via the command prompt the following: osql –E -1 “EXEC sp_attach_db N’Northwind’,N’c:\SQL Server 2000 Sample Databases\northwind.mdf’” The command prompt response: [SQL Native Client] "An error has occurred while establishing a connection to the server when connecting to the SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connects." Also, I loaded SQL Server Management Studio Express and not sure if I even need this. I click on the Icon but I’m not sure what I need to do to establish a logon and connect. Any help will b ...Show All

• John Zolezzi View Data from a Compact Database with the Management Studio Express ?

  Hi there, after some hours of installing and experiments i can now open and sql server compact database (sdf) iam also able to create a new database and add tables and columns. (everything with the ms sql server management studio express) i can also open the northwind database. but iam not able to view the data . if i rightclick on a normal database table i can choose ->open table and see its content. but on a compact table i have at rightclick only edit table properties delete refresh how can i see the data in the table or add new content thanks hi tamil, it was very complicated and i search long for a solution. first i take a blank computer . i install new visual stu ...Show All

• Alan Jr Null values when extracting data from an excel file

  Hello, I'm trying to import some data from a spreadsheet to a database table from a package in integration services. The problem is that I see the data when I open the excel file but when I try to run my package , it doesn't insert any rows in the table and it finishes with a success status. My excel file has some formulas to get the data from other worksheets. I added a Data Viewer and all I see is null values in every cell. I need help...does anyone know what's wrong As soon as I close the Excel workbook containing links, I start getting NULLS through the dataflow. When the workbook is open, the linked data works fine. This may seem to be obviuos; but meake sure you are pointing to the ...Show All

• François Paradis Connect to Database in SQL 2005 Express

  I am trying to connect to the sample databases in SQL Express. I am getting this error. 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. (provider: Name Pipes Provider, error: 40 - could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) I have downloaded and installed AdventureWorks, Northwind, and Pubs. If I have to allow remote connections how do I do that I am a studen and I am brand new at this. first ensure the sample database you wish to use is registered (some of the samples must first be attached ...Show All

• Aelx Book

  Hi, Can you recommend a book on SSIS. I am particularly interested in books which demonstrate a particular project from start to finish while going through chapters. Thanks My favourite is MS SQL Server 2005 Integration Services by Kirk Haselden. Professional SQL Server 2005 Integration Services (Wrox) Is that book based on a case study from start to finish please Thanks Neither book is based on a case study. If you want a case to study, Project Real is a good start, and includes good documentation. The books stand on their own as good learning and references guides. I also prefer Kirk Haseldens book "Integration Services". It cove ...Show All

• MDesigner named set questions

  As I understand it, a named set is not processed until it is needed. Once these are processed are they cached for use by other client requests If there are Aggregations set up in the cube will this trigger the named sets be processed right away with the cube I assume that if a named set is too big there could be loss in performance, is there a way to hold down the size of a named set here are some examples of named sets i've created using some calculated members. perhaps there is a better way of doing this *************** Calculated Members*************************** CREATE MEMBER CURRENTCUBE .[MEASURES].[HP Plus Addl Billing] AS aggregate ([PREP CONTROL HDR].[Bill Formats].&[19],[Measures].[Billed Sales ...Show All

• Venkata Prasad K Error trying to deploy Report

  I have a report which works perfectly well within Visual Studio in design. However as soon as I try to deploy this to the Report Server it throws the following error: w3wp!library!6!02/12/2007-16:29:17:: i INFO: Call to CreateReport( 'Defects by Application (Inactive and Active by Severity) Chart', '/AET Deployment', def) w3wp!library!6!02/12/2007-16:29:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlExc ...Show All