Answer Questions

• Jon Stroh User variable doesn't appear on variables collection???

  I've created a user variable but when I'm going through its variable collections for that TaskHost appears all the system users but not mine. Why th.variables.count 26 When I have 27 including the mine. I'm so sorry, I was wrong. It appear but not in order. ...Show All

• Gianluca Hotz Help - Creating reports in pdf format

  Hi all, Greetings I m using Sql Server 2000 for creating Reports. I like to display the ad-hoc generated report in pdf format. Do i have any pdf writter to display the report or i can able to do it in programmatically. If we can then plz give me the source code to write a pdf report. Advance Thanks & Regards Guna. PDF creating is an outofthebox feature of Reporting Service. It is available as a rendering format in the report manager (Web interface) of each report, unless inactivated. HTH, Jens K. Suessmeyer. --- http//www.sqlserver2005.de --- ...Show All

• New-Bee DSN issue/question..

  I have 2 instances of SQL on the same box. I am running Great Plains on both. When I change the properties of one system DSN, it automatically updates the other entry also. Have any of you seen this before Any insights would help. Thanks Sundar You are in the wrong forum. Try this for starters: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=93&SiteID=1 following Phil's suggestion, thread moved to DB Engine forum ...Show All

• Nikolay Georgiev How to use parameters in the MDX?

  Hi all, I'm working on a project that builds a report in RS 2005 agains the data cube created in AS 2005. I created a report in RS 2005 against database table, and the parameters were easy to be added in the T-SQl query. There are about 15 parameters needs to add in the query, and I can use "IN, =, Betweent.. and ," in the "where" clause, e.g., select * FROM Mytable1 WHERE EmployeeID IN (@EmployeeID) and EmployeeName] IN (@EmployeeName) ... and Salary between @SalaryFrom and @SalaryTo ... and Date between @DateStart and @DateEnd most of the restriction fields are column fileds in the report. Right now, I need to switch the datasource to the data cube, and then I have to u ...Show All

• George Waters SQL2005 database mailer problem

  Hi there, Got a 2005 SP1 SQL box, with database mailer giving problems. In the sysmail_event_log is has 1) Exception Information =================== Exception Type: System.NullReferenceException Message: Object reference not set to an instance of an object. Data: System.Collections.ListDictionaryInternal TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32) HelpLink: NULL Source: DatabaseMailEngine StackTrace Information =================== at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID) at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.SessionManager.GetAccount(Int32 accountID) at Microsoft.SqlServer.Management.SqlIMai ...Show All

• jsedlak Stored Procedu Is this possible?/How To?

  Hi, I'm building a yahoo type messenger. Is it possible within a stored procedure to do the following on the rows found below from a user simon   ID(primary key) Username        Message          New             Unread -------                  -------                  -------                  ------          &nbs ...Show All

• Ragavendra dbcc sqlperf in SQL Server 2005

  In SQL Server 2005, the dbcc sqlperf requires View Server State permission. If this permission cannot be granted, how can I find out the nlogpcntused (Percentage of the log file currently occupied with transaction log information) By the way, is there any place that I can find out this kind of difference (required permission) between SQL Server 2000 and SQL Server 2005 Thanks for any help, Peter You could use the query below to get the same information. Note that the information obtained from the catalog view could be inaccurate but it should suffice for most purposes. select (total_size*8)/1024. as LogSize_MB, (used_size*8)/1024. as LogSpaceUsed_MB, (used_size*100)/(total_size*1.) as [Log ...Show All

• y2k4life Viewing stored procedures via Crystal Report wizard in VB .NET 2003

  Hi, I have a very problem which is frustrating me endlessly! I have MSSQL2000 stored procedures created which I want to use as the datasource of my generated Crystal Reports, but when using the Internal Visual Studio Crystal Report Generating Wizard connecting to my MSSQL2000 database I cannot select see or select any of my stored procedures I want to use as the base of my reports... Unfortunately I can ONLY view tables to my dismay! I am using the Crystal Report designing tools that come with Visual Studio 2003... Please, is there anyone out there that knows how I can see my stored procedures I used to be able to do it in a previous installation also of Visual Studio2003 using MSSQL2000, so I know it IS possible! ... But at t ...Show All

• Jacco Mintjes creating and scheduling job for SSIS

  Hi All I want to create and schedule job for my SSIS packages. But I have no idea how to do that. I am able to execute my SSIS packages under Stored Packages->MSDB->SSIS packages But I have to manually run them. I want them to schedule them as job. Do SSIS packages also execute as DTS packages used to execute, I mean under SQL Server Agent. Phil Brammer wrote: bachocha wrote: It's the same as if you were executing the package from the command prompt. The Agent calls DTExec so set the password using the /SET option. Go to the properties of the Job then go to Steps then edit the step and go to the Set Values t ...Show All

• danadanny SRS Report Usage Statstics - SQL Server 2000

  Hello, everyone. I'm aware that there is a way to monitor the Report Execution log in Reporting Services for SQL Server 2005. (See http://msdn2.microsoft.com/en-us/library/ms155836.aspx ) However, is there an equivelant in 2000 We're attempting to find something that basically allows us to monitor who is using what reports, and how often. We have approximately 100 reports or more, but we don't know how often/frequently they're being used, and we need to clean house. If anyone knows of some custom made solutions that perform the same functions, I'm open to suggestions. Thanks in advance! Yes, the execution log provides the same information for SQL Server Reporting Services 2000. There is a DTS package and execution log reports that ...Show All

• steve1_rm row level security and Integration services bulk inserts don't work

  Hi i followed Microsofts "Implementing Row-and-Cell-Level Security in Classified Databases Using SQL Server 2005" this works fine when i insert delete data on a normal script (mangement studio) my project runs in a SSIS package, different users. i cannot do a bulk insert using OLEDB data Destination i get the following error An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Conflicting locking hints are specified for table "dbo.tblUniqueLabelMarking". This may be caused by a conflicting hint specified for a view.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Conflict ...Show All

• M Rice New table on server not replicating to device

  Hi, I have a SQL 2005 Mobile db merge synching to SQL Server 2005. I've been using this for a few months now and generally it works well (except when adding not null columns with default values, but that's another story...). I just added a new table to the server, went into the publication articles and checked the new table. It told me I would need to generate a new snapshot for the table, so I then generated a new snapshot. Then I synched the mobile db and it worked with no errors, but the new table I added on the server is not on the mobile db (I checked using the Query Analyzer). I have also tried reinitializing subscriptions, but this didn't work either. Any ideas why this table would not be synched to my mobile db (and no error mes ...Show All

• Raoul_BennetH Why can't I use data-driven subscriptions?

  I am using Reporting Services 2005 locally for testing purposes and also on a production server. Locally, I can create data-driven subscriptions, but not on the server. The only difference I can think of between my local test environment and the production server is the versions of SQL server database. Locally, I am using SQL server 2005 but on the server I am using SQL server 2000 (but with Reporting Services 2005). Can the version difference be the reason for not being able to use data-driven subscriptions Note: I have followed various guidelines and walkthroughs that describe how a data-driven subscription is created, i.e. stored credentials on the report server and such should not be the problem. Operating systems: locally; Windo ...Show All

• spin_n Execution Log Sample Reports - Job Failed

  I am trying to install the samle execution log reports provided with SSRS. http://msdn2.microsoft.com/en-us/library/ms161561.aspx When I try to install them on our development server everything goes fine until I try to start the job (step #13 in link above) "Execution of job 'RSExecutionLog_Update' failed. See the history log for details. When I view the history I get: "Executed as user: WILWHAPP\SYSTEM. The package execution failed. The step failed" From the error provided I'm guessing this is a security issue. I just don't know what and where I should change something. Any suggestions thats sometimes the issue, part of admin group or not, sometimes you just need t ...Show All

• Yitzhak Steinmetz Problem with Command exec job step in SQL2000 sp3

  Hi, I have a command exec SQL Agent job step in sql 2000 sp3 that is like this C: cd \Program Files\Microsoft Analysis Services\Bin call "msmdarch" /r HKSH1-FILE2 "\Program Files\Microsoft Analysis Services\Data\" "\cubes\Warlock.cab" "\cubes\MyRestoreLog.log" "C:\Temp" The problem I have with this code is that it runs fine in a cmd window but fail with error when I try to run it from the job. Executed as user: ONSEMI\smteam. The process could not be created for step 10 of job 0x4A0900B6BF0B6644AF720DFA384A2425 (reason: Access is denied). The step failed. The user that owns the job is admin on the box. Any idea This was working a few months ago. Thanks, Philippe ...Show All