New to SQL Server

I am new to sql server, mostly work with an other product build by a company
in california. We can call it "company O"
We had a application written for our company. The version of SQL Server is
2000. They created all the objects owned by dbo. When I asked why, I was
told this is what Microsoft recommends. My question is why should the
objects be owned by dbo and not use the a model like
schema/username.objectname
Can some one explain why use the dbo as the owner of the objects in a
database vrs have a schema and then grant permissions on the objects in the
schema?In SQL Server 2000, schemas don't work that way. Having everything owned by
dbo makes it much easier to manage. SQL Server 2005 properly implements
schemas such that what you're talking about does make sense.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"jbwest77" <jbwest77@.discussions.microsoft.com> wrote in message
news:1C71EE4D-A6F0-42BE-A48E-693830152596@.microsoft.com...
>I am new to sql server, mostly work with an other product build by a
>company
> in california. We can call it "company O"
> We had a application written for our company. The version of SQL Server
> is
> 2000. They created all the objects owned by dbo. When I asked why, I was
> told this is what Microsoft recommends. My question is why should the
> objects be owned by dbo and not use the a model like
> schema/username.objectname
> Can some one explain why use the dbo as the owner of the objects in a
> database vrs have a schema and then grant permissions on the objects in
> the
> schema?|||On Mon, 21 Nov 2005 15:48:01 -0800, "jbwest77"
<jbwest77@.discussions.microsoft.com> wrote:
>I am new to sql server, mostly work with an other product build by a company
>in california. We can call it "company O"
>We had a application written for our company. The version of SQL Server is
>2000. They created all the objects owned by dbo. When I asked why, I was
>told this is what Microsoft recommends. My question is why should the
>objects be owned by dbo and not use the a model like
>schema/username.objectname
>Can some one explain why use the dbo as the owner of the objects in a
>database vrs have a schema and then grant permissions on the objects in the
>schema?
It's just always been that way, and various tools and defaults are
very awkward if you try to use ownership other than dbo.
If things are finally better in Yukon, then we'll just have to break
old habits!
So, I'd say that at least on this issue, so far I wouldn't hold it
against your developers.
J.|||In SQL Server 2000 you can implement the schema/username.objectname that you
mentioned, more exactly the username. You can create a user, like finance,
and give ownership of the objects to that user. We have several applications
like that and we do not have any problem.
If you want to implement schemas Oracle-style then we have SQL Server 2005.
Ben Nevarez
"jbwest77" <jbwest77@.discussions.microsoft.com> wrote in message
news:1C71EE4D-A6F0-42BE-A48E-693830152596@.microsoft.com...
>I am new to sql server, mostly work with an other product build by a
>company
> in california. We can call it "company O"
> We had a application written for our company. The version of SQL Server
> is
> 2000. They created all the objects owned by dbo. When I asked why, I was
> told this is what Microsoft recommends. My question is why should the
> objects be owned by dbo and not use the a model like
> schema/username.objectname
> Can some one explain why use the dbo as the owner of the objects in a
> database vrs have a schema and then grant permissions on the objects in
> the
> schema?|||Thanks for the input.
"Ben Nevarez" wrote:
> In SQL Server 2000 you can implement the schema/username.objectname that you
> mentioned, more exactly the username. You can create a user, like finance,
> and give ownership of the objects to that user. We have several applications
> like that and we do not have any problem.
> If you want to implement schemas Oracle-style then we have SQL Server 2005.
> Ben Nevarez
>
> "jbwest77" <jbwest77@.discussions.microsoft.com> wrote in message
> news:1C71EE4D-A6F0-42BE-A48E-693830152596@.microsoft.com...
> >I am new to sql server, mostly work with an other product build by a
> >company
> > in california. We can call it "company O"
> >
> > We had a application written for our company. The version of SQL Server
> > is
> > 2000. They created all the objects owned by dbo. When I asked why, I was
> > told this is what Microsoft recommends. My question is why should the
> > objects be owned by dbo and not use the a model like
> > schema/username.objectname
> > Can some one explain why use the dbo as the owner of the objects in a
> > database vrs have a schema and then grant permissions on the objects in
> > the
> > schema?
>
>

New Template, open exsisting, any way to call reporting wizard now?

Any way to load my new template, and then call wizard? seems wizard is
not accessable if after I start with open existing item.
Can anybody recommend and easy to follow book on on reporting services
2005?
dumb question, say I have a grouping report like this
group
detail detail datetime
detail detail datetime
detail detail datetime
and I want to change the background color any datetime fields that
elapsed more than 4 hours since last entry to red. How? where? what?
Thanks.In the background color - have an expression :
I hardcoded the date/time below as an example, but this would actually be
your Fields!dtDateField.Value and getdate() would be Now()
If it is greater than 4 hours, it is displayed in red, otherwise blue - but
=iif(datediff(hh, '10/27/06 8:00:00AM', Now()) > 4, "Red", "White")
=-Chris
"Jason" <jason@.cyberpine.com> wrote in message
news:1161914681.963331.129650@.i3g2000cwc.googlegroups.com...
> Any way to load my new template, and then call wizard? seems wizard is
> not accessable if after I start with open existing item.
> Can anybody recommend and easy to follow book on on reporting services
> 2005?
>
> dumb question, say I have a grouping report like this
>
> group
> detail detail datetime
> detail detail datetime
> detail detail datetime
>
> and I want to change the background color any datetime fields that
> elapsed more than 4 hours since last entry to red. How? where? what?
> Thanks.
>|||sorry, 4 hours greater than than the date/time on the subsiquent row
the row.
But, the thing I really stuck on is the report design, if I'm limited
to one dataset the group. Can I have two datasets in a groupset, or
will I have create a view with duplicating data?
I have two tables
filelog:
id
filename
datelog:
id
date
type
I'm trying to do this
Id
filename, filename, filename (line wraping if neccessary)
date type
date type
id
filename, filename, filename (line wraping if neccessary)
date type
date type
==there might be some 5 to 20 filelog rows for every id, there can number
of datelog entries with the same id, but other than Id there is no
other corrilationbe between filelog and datelog
Chris Conner wrote:
> In the background color - have an expression :
> I hardcoded the date/time below as an example, but this would actually be
> your Fields!dtDateField.Value and getdate() would be Now()
> If it is greater than 4 hours, it is displayed in red, otherwise blue - but
> =iif(datediff(hh, '10/27/06 8:00:00AM', Now()) > 4, "Red", "White")
> =-Chris
> "Jason" <jason@.cyberpine.com> wrote in message
> news:1161914681.963331.129650@.i3g2000cwc.googlegroups.com...
> > Any way to load my new template, and then call wizard? seems wizard is
> > not accessable if after I start with open existing item.
> >
> > Can anybody recommend and easy to follow book on on reporting services
> > 2005?
> >
> >
> > dumb question, say I have a grouping report like this
> >
> >
> > group
> > detail detail datetime
> > detail detail datetime
> > detail detail datetime
> >
> >
> > and I want to change the background color any datetime fields that
> > elapsed more than 4 hours since last entry to red. How? where? what?
> >
> > Thanks.
> >

New stored procedure call

Hi,
Actually the stored procedure ' Update ' is being called when ever I
click new button or edit button . But when i click the save button in the
grid the record is commited. But it is taken care by framework.Now when i
click the save button i must get the message as the record saved.
Thanks,
Jyothsna.Hi Jyothsna
Probably u are using a stored procedure to update the records. Introduce a
return parameter to the stored procedure and return a certain number when th
e
record is sucess and some number when record fails ex. 1 and -1 respectively
try to catch the return value when the button is clicked. Based on the
result display the message.
best Regards,
Chandra
http://chanduas.blogspot.com/
---
"Jyothsna" wrote:

>
> Hi,
> Actually the stored procedure ' Update ' is being called when ever
I
> click new button or edit button . But when i click the save button in the
> grid the record is commited. But it is taken care by framework.Now when i
> click the save button i must get the message as the record saved.
> Thanks,
> Jyothsna.
>
>

New Intel PIV 2.8E 1M cache US$169 only

Place your order now, call: +86 13708077010 Chau Li Mawrote:

> Place your order now, call: +86 13708077010 Chau Li Ma
>