How do I administer SqlServer 2005

Hi;
I just installed SqlServer 2005 developer edition and I can't find any way
to administer it. There is a "Sql Server Configuration Manager" in the menu
but nothing like the Enterprise Manager in SqlServer 2000.
What am I missing?
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
You are missing SQL Server Management Studio.
You may need to put in the disk again, and select INSTALL Client Tools.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:CA288C02-B0C8-4F6E-A075-BB6AE535BCCF@.microsoft.com...
> Hi;
> I just installed SqlServer 2005 developer edition and I can't find any way
> to administer it. There is a "Sql Server Configuration Manager" in the
> menu
> but nothing like the Enterprise Manager in SqlServer 2000.
> What am I missing?
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
> Cubicle Wars - http://www.windwardreports.com/film.htm
>
|||that was it.
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
"Arnie Rowland" wrote:

> You are missing SQL Server Management Studio.
> You may need to put in the disk again, and select INSTALL Client Tools.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "David Thielen" <thielen@.nospam.nospam> wrote in message
> news:CA288C02-B0C8-4F6E-A075-BB6AE535BCCF@.microsoft.com...
>
>
|||Thanks Dave -and I enjoyed 'Cubicle Wars'. Nice.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"David Thielen" <thielen@.nospam.nospam> wrote in message
news:BD10F348-D97E-4B53-9D16-9EE9DEE054EE@.microsoft.com...[vbcol=seagreen]
> that was it.
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
> Cubicle Wars - http://www.windwardreports.com/film.htm
>
>
> "Arnie Rowland" wrote:
|||Hi David
You may install the client tools, then you'll get SQL Server Management
Studio.
If you need a web-based solution, then you can try myLittleAdmin for SQL
Server 2005
http://www.mylittleadmin.com
Best regards
David Thielen wrote:
> Hi;
> I just installed SqlServer 2005 developer edition and I can't find
> any way to administer it. There is a "Sql Server Configuration
> Manager" in the menu but nothing like the Enterprise Manager in
> SqlServer 2000.
> What am I missing?
I'm protected by SpamBrave
http://www.spambrave.com/

How do I add condition for a sum() value in the select statement?

Hi
I'm builing this string dynamically in C# program. I need to add one more
filtering condition of "Sum(Amount) >0" to the Select statement. I added it
but I got an error message. Can someone help on how to do this in one selec
t
statment?
Thanks, Alpha
select exttid,sum(amount) as FeeBalance from tblLedger
where exttid in
(select distinct(exttid) from tblBilling b
where datediff(day,cast('5/17/2005' as datetime),b.formdate) >= 0
and datediff(day,cast('8/17/2005' as datetime),b.formdate) <= 0)
and void = 0
group by exttidLook at the "Having" clause of the select statement. "Having" works on
"Group By" much like the 'Where" works on "From". In your case, you would
add something like:
HAVING Sum(Amount) > 0
after your Group By section.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:F6DA3969-24F9-4895-B7CB-93ECC06EB852@.microsoft.com...
> Hi
> I'm builing this string dynamically in C# program. I need to add one more
> filtering condition of "Sum(Amount) >0" to the Select statement. I added
> it
> but I got an error message. Can someone help on how to do this in one
> select
> statment?
> Thanks, Alpha
> select exttid,sum(amount) as FeeBalance from tblLedger
> where exttid in
> (select distinct(exttid) from tblBilling b
> where datediff(day,cast('5/17/2005' as datetime),b.formdate) >= 0
> and datediff(day,cast('8/17/2005' as datetime),b.formdate) <= 0)
> and void = 0
> group by exttidsql

How could I notify new subscribers with previous data?

Hi!

I have my NS running. Subscribers are reciving notifications right. How could I send past notifications to new users . Could it be possible?

I think we have all the previous data (the event data table as the notification table) what do you think is the best way or approach to do it?

i.e:

Insert an action item asigned to a user in my DB. If the user has a subscription to it, NS generate a notification and send an email to the user. In my case this user is not a subscriber yet, I add him 2 days after. How could I send the notification thas had been created for him before?

Regards ;)

If I ever have this problem, I will probably play with checking the <myNSApplicationName>Notifications table and look for the data matching the same criteria as those specified by this "late" client in his subscription(s).

...unless it's been already vacuumed, of course.

|||

Assuming this is a scheduled subscription, you can use a chronicles tables to keep track of the last time a subscription was processed. For new subscriptions, the datetime column should be set to something like '1900-01-01 00:00:00.000' so that it will match everything.

After the match, you then update the LastProcessedTime column of the chronicles table with the current datetime. That way, future quantums will only send the most recently added event data.

HTH...

Joe

How could I notify new subscribers with previous data?

Hi!

I have my NS running. Subscribers are reciving notifications right. How could I send past notifications to new users . Could it be possible?

I think we have all the previous data (the event data table as the notification table) what do you think is the best way or approach to do it?

i.e:

Insert an action item asigned to a user in my DB. If the user has a subscription to it, NS generate a notification and send an email to the user. In my case this user is not a subscriber yet, I add him 2 days after. How could I send the notification thas had been created for him before?

Regards ;)

If I ever have this problem, I will probably play with checking the <myNSApplicationName>Notifications table and look for the data matching the same criteria as those specified by this "late" client in his subscription(s).

...unless it's been already vacuumed, of course.

|||

Assuming this is a scheduled subscription, you can use a chronicles tables to keep track of the last time a subscription was processed. For new subscriptions, the datetime column should be set to something like '1900-01-01 00:00:00.000' so that it will match everything.

After the match, you then update the LastProcessedTime column of the chronicles table with the current datetime. That way, future quantums will only send the most recently added event data.

HTH...

Joe

How can Replicate Between Ms SQL 2005 to MYSQL

Hi;

I have sql 2005 server in my local area and mysql server on internet..

How can replicate Ms SQL 2005 to MYSQL ? is that possible ? or any possible version this server ?

I try sql 2000 server for replication; publishing starting but then ? take "invalid cursor state " message. ? delete tables msrep7 in mysql then replication starts but if replication stop for any reason , ? must delete table again again...

is this bug in sql 2000 ? how can fix that ?

Thanks...

MYSQL isn't a supported subscriber, so it may not work.