Background water mark

It would be really cool to sort of ghost our company logo as a background
beneath report content.
Any ideas on how to do this are welcome?
All the Best,
GHello Joe,
Reporting Services doesn't have a specific way to produce watermarks, but
you can create them manually.
Watermark at the printer level
Look at the capacities of the printer driver you use to create a paper copy
of the report. Many printers, even low-end ones, have the ability to add
watermarks as part of the print process. This is usually defined in the
printer driver's settings. It can be configured by creating a separate
instance of an existing printer driver and then configuring that instance
to add a watermark to all output. Adding another instance of a printer
driver does not take much system overhead, so this is economical and
convenient. To produce the watermarked edition of a document, just print to
the right instance of the printer driver.
Watermark at the report level
If you want to add the watermark on the report level, there are a few ways
to do this. You may simply create a bitmap with the appropriate watermark
on it and set that as a background image for the header, body or footer of
the report. Another approach would be to create a textbox behind the report
grid and place the needed watermarking there. In both cases, you would
probably need to set the background for all cells on the grid to
"Transparent" so that the background items would show through; any colored
items (even if they use white) would overprint the image.
Another possibility is to create a textbox for the watermark, make the
background of that textbox transparent, and bring it to the top of the
Z-order for the report, so it remains on top of everything else.
Here is the article I reference:
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1163757,00.html
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei Lu,
Thank you for the definitive reply, I have noticed that Report Services
does not like to place other objects on top of Image components.
Setting up additional printer definitions would be easy, however it would
certainly confuse and aggravate the average user.
I will try your other suggestions and post the results.
All the best,
Greg Rowland|||My Pleasure, Greg.
If you have any question, please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Greg,
Have you tested the suggestion? Anything I can help, please feel free to
let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Back up database

Hi everyone,

I am working in a company where data is changed daily (IT department of a shopping center) where item prices change everyday, the quantity available in stock vary daily,...
What is the scenarios available for the back up on SQL Server 2000 (I am a developer not a database administrator, but I have a task to do which is to make a back up for the critical data) .

could u help me with some links or idea.
I was thinking of doing a full back up one time everyweek and daily I will do a differential backup?
is that the best solution?
Thanks.

The Backup and Restore Wizard is one of the best things in the product, create job schedules for your backups and it will run. I have covered most of your questions in this thread below. If you have more questions post again. Hope this helps.
http://forums.asp.net/1050678/showpost.aspx

AX (Loading) - Standby Database

I have SQL Server 2000 database server that I inherit from another company.
There is a AX database on this database server that was set up for Standby.
Everytime the database transaction log is created the message listed below
is inserted into the SQL Server errorlog file.
The AX database status is constantly loading is this normal?
Is it possible to set up SQL Server standby database with the SQL Server
2000 standard edition?
Errorlog Message
Bypassing recovery for database 'AX' because it is marked IN LOAD.
Thank You,Hi Joe
This is normal for standby databases. They are kept in "loading" mode
(otherwise known as "norecovery") because transaction logs are continually
being restored to them. If a standby database is brought online (by
recovering it) it will no longer be able to receive log updates from the
source db.
Regards,
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
http://www.SQLBenchmarkPro.com
Join the tuning revolution..
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:82161ABF-EF1E-426A-A127-AF10CF4EB32D@.microsoft.com...
> I have SQL Server 2000 database server that I inherit from another
> company.
> There is a AX database on this database server that was set up for
> Standby.
> Everytime the database transaction log is created the message listed below
> is inserted into the SQL Server errorlog file.
> The AX database status is constantly loading is this normal?
> Is it possible to set up SQL Server standby database with the SQL Server
> 2000 standard edition?
> Errorlog Message
> Bypassing recovery for database 'AX' because it is marked IN LOAD.
> Thank You,

AX (Loading) - Standby Database

I have SQL Server 2000 database server that I inherit from another company.
There is a AX database on this database server that was set up for Standby.
Everytime the database transaction log is created the message listed below
is inserted into the SQL Server errorlog file.
The AX database status is constantly loading is this normal?
Is it possible to set up SQL Server standby database with the SQL Server
2000 standard edition?
Errorlog Message
Bypassing recovery for database 'AX' because it is marked IN LOAD.
Thank You,Hi Joe
This is normal for standby databases. They are kept in "loading" mode
(otherwise known as "norecovery") because transaction logs are continually
being restored to them. If a standby database is brought online (by
recovering it) it will no longer be able to receive log updates from the
source db.
Regards,
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
http://www.SQLBenchmarkPro.com
Join the tuning revolution..
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:82161ABF-EF1E-426A-A127-AF10CF4EB32D@.microsoft.com...
> I have SQL Server 2000 database server that I inherit from another
> company.
> There is a AX database on this database server that was set up for
> Standby.
> Everytime the database transaction log is created the message listed below
> is inserted into the SQL Server errorlog file.
> The AX database status is constantly loading is this normal?
> Is it possible to set up SQL Server standby database with the SQL Server
> 2000 standard edition?
> Errorlog Message
> Bypassing recovery for database 'AX' because it is marked IN LOAD.
> Thank You,