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...
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...
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...
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...
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
Hi, I have a query regarding this, I would like to know if i added both /PAE and /3GB with AWE what is the impact. Also if i enable only /3GB in...
Hi, how to make a sql job run on first and 15 th of every month? Pl. let me know asap. --Rajendar ok
Hi all, Happy Nee Year 2006. I have problem when iam doing a back on share drive. The sql agent job is failing. Can someone help me out in this...
Hi, I've a query like this: "select col1 from table1 for xml auto" Want to store this data into a variable called @v1 varchar(1000). when I write...
Hi all, I'm encountering this error, when trying to created fulltext search. "Error 7635: The Microsoft Search service cannot be administered under...
Hi all, I made linkded server from SQL Server to SQLBase database server as LS. When I try to click on tables under LS following error is...
Hi all, After pushing the data to subscribers we want to see the data is matching in publisher and subscriber For matching we are running the...
Hi all, I want to restore database on existing replicated database. Any Ideas, how to proceed? Thanks in advance Rajendar ok
Separate names with a comma.
