I have a maintenance plan failure. Here are the output file. Where can I
> trouble shoot or why has it failed. But on next schedule, next day it works ?
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
> Server 'HACSSDB004' as 'IHESS\srvsql002' (trusted)
> Starting...
I have a date field (<Terminated On (Date))which is a Dimension). I have tried to create a FLAG so that all dates greater than 31/12/2004 give the Boolean value of 1.
I have tried create a object (both as a dimension and measure)using the following
=<Terminated On (Date)>>31/12/2004
but...
I have a date field (<Terminated On (Date))which is a Dimension). I have tried to create a FLAG so that all dates greater than 31/12/2004 give the Boolean value of 1.
I have tried create a object (both as a dimension and measure)using the following
=<Terminated On (Date)>>31/12/2004
but...
I have created a report that will compare whether a authorised date is greater or equal to today's date. I have got the user to enter today's date. How can I automate this without user having to enter the date.
e.g Authorsied_date >=Currentdate(), this has to entered in tne conditions part of...
I have created a report that will compare whether a authorised date is greater or equal to today's date. I have got the user to enter today's date. How can I automate this without user having to enter the date.
e.g Authorsied_date >=Currentdate(), this has to entered in tne conditions part of...
I have just restrieved a database from our TAPEDRIVE to a directory and tried to restoring it a a database SQL 2000. I keep getting the following error.
Any help will be appreciated.
Error 3242: The file on device ‘E:\MSSQL\Data\TetnetReports_Data3.MDF’ is not a calid Microsoft Tape Format...
My database grows quite quickly and I have just have had to shrink it using the SHRINK utilty. Can I poss automate this so it is always shrunk auto to its optimum size.
Many thanks
I tried to backing up using the Backup utility on SQL Server 2000. I had backed up the database a week ago. Tried backing up again and received the following error.
"The Volume on device 'd:\MSSQL\BACKUP\CFNLIVE_db.bak' is not part of a multiple family media set. BACKUP WITH FORMAT can be used...
How can I create 2 prompts in a Business report so the user needs to enter into only one prompt to retrieve results. eg.they can enter the Customer Code OR Customer Name.
The following message appears 'DEMO:Full msdb log', do I need to do anything with the log file eg. shrink it. If so can anyone tell me how to do this.
Many thanks
On running a Business Objects document retrieved from the REPOSITORY the user gets the following message :
"You are not authorised to use this document (FRM0008)"
Can anyone help in resolving this as it is happening more and more...
Many thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.