Hi - I would like to email subscribe my SSRS report and when i am trying to create new subscription getting the below error;"subscription cannot be...
Hi friends - I've created a basic report that renders to 8.5in in width when I export to web archive format in Report Server. However, when I...
I want to know day wise history as mentioned below since my job runs everyday Startdatetime Enddatetime Duration
Thanks for reply.I want these details thru query where I can refere tables of MSDB
HI - we have a job 'Job1' which runs every day at 3:00PM. Now, I want to know the startdate,enddate, total duration of the job for the last one...
We are facing some issue in restoring the backup in SQL 2k5. We found the below error message in Error Log: BackupIoRequest::WaitForIoCompletion:...
Hi - Is there any way to save the results of a query to a text file.. SELECT * FROM Table1. I wanna save the results of the above query to a text...
Forgot to include one important info. I am actually connecting the cube from EXCEL Pivot. I traced the query and ran the SSMS. In either cases am...
when I ran the below query i am getting the error: SELECT NON EMPTY Hierarchize({DrilldownLevel({[Geography].[Area].[All]})}) DIMENSION PROPERTIES...
I’m looking for a T-SQL command to find system databases. I am aware of the Database.IsSystemObject() method available through SQL 2005 SDK, but I...
Test connection is successful. And more over CUBE is getting processed for dimensions and the issue is coming when it processing the measures thanks
I ran the below command and processed the cube. exec sp_configure 'affinity mask', 0x00000003 GO reconfigure GO Now, new problem begins :) OLE DB...
The following message is logged in SQL log: "The time stamp counter of CPU on scheduler id 3 is not synchronized with other CPUs." Apart from above...
Hi – I made some changes to CUBE and started the processing. Ideally it should not take more than 2 hrs to process. But, it is under processing...
Thanks Hemanth, for pointers. However, my problem didn't get solved. Any other thoughts..? --Rajendar ok
Hi,<br /><br />We have IIS/Report server in one box and database is in another box. SQLReports. Some times we are getting a weird error (The remote...
Hi, I've a table with huge data. I wanted to find out the time difference in creating the index on it using SORT_IN_TEMP_DB Option and with using...
We have a problem relating to the sql server jobs. We have a .net application which sends mails using smtp mail object. This application is called...
Hi, How much space require to Install SQL 2005 default instance and named instance respectively --Rajendar ok
Separate names with a comma.
