Page Blank

I have chart and table in my report.Depending upon groups i decide whether to show chart or not. when there is condition that chart should be invisible then my first page comes blank and data is shown from 2nd page.Thanks in advance
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.Try out generating the reports after removing all page
breaks if any.
>--Original Message--
>I have chart and table in my report.Depending upon groups
i decide whether to show chart or not. when there is
condition that chart should be invisible then my first
page comes blank and data is shown from 2nd page.Thanks in
advance
>--
>Posted using Wimdows.net NntpNews Component -
>Post Made from http://www.SqlJunkies.com/newsgroups Our
newsgroup engine supports Post Alerts, Ratings, and
Searching.
>.
>sql

Owner

I have several SQL databases and the owner is different on each of those
depending on who created it over time.
1. Can I change the owner? How?
2. What should I change it to?
3. If I change it to sa would that affect the dbs if I change the sa password?
4. Any issues if the owner account has been removed from windows/active
directory
Thanks1. Use sp_changedbowner to change the owner of the database
2. Usually I set it to either sa or a Windows account belongs to local
admistrators group. Otherwise, you may run into some unexpected problems. (I
just can't recall what it is. I think it's something related to bulk insert.
I am not sure)
3. No.
4. If you set the owner to sa, then you don't need to worry about this issue.
"Niles" wrote:
> I have several SQL databases and the owner is different on each of those
> depending on who created it over time.
> 1. Can I change the owner? How?
> 2. What should I change it to?
> 3. If I change it to sa would that affect the dbs if I change the sa password?
> 4. Any issues if the owner account has been removed from windows/active
> directory
> Thanks|||Comments Inline
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:94EDE74E-7E15-4738-9C17-9657272C5E29@.microsoft.com...
>I have several SQL databases and the owner is different on each of those
> depending on who created it over time.
> 1. Can I change the owner? How?
Yes.
USE MyDatabase
go
EXEC sp_changedbowner ('sa')
> 2. What should I change it to?
SA
> 3. If I change it to sa would that affect the dbs if I change the sa
> password?
No. Passwords affect the login not the database.
> 4. Any issues if the owner account has been removed from windows/active
> directory
There may be some problems, but changing the owner to SA should fix any
lingering issues.
Geoff N. Hiten
Microsoft SQL Server MVP
> Thanks|||Thanks
"Jack" wrote:
> 1. Use sp_changedbowner to change the owner of the database
> 2. Usually I set it to either sa or a Windows account belongs to local
> admistrators group. Otherwise, you may run into some unexpected problems. (I
> just can't recall what it is. I think it's something related to bulk insert.
> I am not sure)
> 3. No.
> 4. If you set the owner to sa, then you don't need to worry about this issue.
> "Niles" wrote:
> > I have several SQL databases and the owner is different on each of those
> > depending on who created it over time.
> > 1. Can I change the owner? How?
> > 2. What should I change it to?
> > 3. If I change it to sa would that affect the dbs if I change the sa password?
> > 4. Any issues if the owner account has been removed from windows/active
> > directory
> >
> > Thanks