Downsize from SQL Server to MSDE?

We recommend that our clients install SQL Server at each of their satellite
offices. Every night we DTS the central database out to the satellite
offices. That way, if the link goes down, or if the main server were to go
down, we'd have one or more backup databases to switch over to.
One client is looking to save on SQL Server licensing costs. They understand
that the main server will need to be SQL Server, but they're reluctant to
pay extra for additional servers which won't normally be used. They're
asking if they could have MSDE installed at the satellite offices, rather
than SQL Server, and is there any way the main SQL Server database can be
pumped down to the satellite MSDE databases nightly. Is this possible with
DTS or any other way?
If you have any suggestions or reference links, that would be very much
appreciated!
Thanks,
- Joe Geretz -
As long as the MSDE installation does not violate Microsoft's EULA for MSDE
or the database is not greater than 2GB in size or the usage of the MSDE
instances will not be hampered by the built in processing governor in MSDE,
then I would see no problem.
Jim
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:ulI7Pp3FEHA.712@.tk2msftngp13.phx.gbl...
> We recommend that our clients install SQL Server at each of their
satellite
> offices. Every night we DTS the central database out to the satellite
> offices. That way, if the link goes down, or if the main server were to go
> down, we'd have one or more backup databases to switch over to.
> One client is looking to save on SQL Server licensing costs. They
understand
> that the main server will need to be SQL Server, but they're reluctant to
> pay extra for additional servers which won't normally be used. They're
> asking if they could have MSDE installed at the satellite offices, rather
> than SQL Server, and is there any way the main SQL Server database can be
> pumped down to the satellite MSDE databases nightly. Is this possible with
> DTS or any other way?
> If you have any suggestions or reference links, that would be very much
> appreciated!
> Thanks,
> - Joe Geretz -
>

Downsize from SQL Server to MSDE?

We recommend that our clients install SQL Server at each of their satellite
offices. Every night we DTS the central database out to the satellite
offices. That way, if the link goes down, or if the main server were to go
down, we'd have one or more backup databases to switch over to.
One client is looking to save on SQL Server licensing costs. They understand
that the main server will need to be SQL Server, but they're reluctant to
pay extra for additional servers which won't normally be used. They're
asking if they could have MSDE installed at the satellite offices, rather
than SQL Server, and is there any way the main SQL Server database can be
pumped down to the satellite MSDE databases nightly. Is this possible with
DTS or any other way?
If you have any suggestions or reference links, that would be very much
appreciated!
Thanks,
- Joe Geretz -
As long as the MSDE installation does not violate Microsoft's EULA for MSDE
or the database is not greater than 2GB in size or the usage of the MSDE
instances will not be hampered by the built in processing governor in MSDE,
then I would see no problem.
Jim
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:ulI7Pp3FEHA.712@.tk2msftngp13.phx.gbl...
> We recommend that our clients install SQL Server at each of their
satellite
> offices. Every night we DTS the central database out to the satellite
> offices. That way, if the link goes down, or if the main server were to go
> down, we'd have one or more backup databases to switch over to.
> One client is looking to save on SQL Server licensing costs. They
understand
> that the main server will need to be SQL Server, but they're reluctant to
> pay extra for additional servers which won't normally be used. They're
> asking if they could have MSDE installed at the satellite offices, rather
> than SQL Server, and is there any way the main SQL Server database can be
> pumped down to the satellite MSDE databases nightly. Is this possible with
> DTS or any other way?
> If you have any suggestions or reference links, that would be very much
> appreciated!
> Thanks,
> - Joe Geretz -
>
sql

Downsize from SQL Server to MSDE?

We recommend that our clients install SQL Server at each of their satellite
offices. Every night we DTS the central database out to the satellite
offices. That way, if the link goes down, or if the main server were to go
down, we'd have one or more backup databases to switch over to.
One client is looking to save on SQL Server licensing costs. They understand
that the main server will need to be SQL Server, but they're reluctant to
pay extra for additional servers which won't normally be used. They're
asking if they could have MSDE installed at the satellite offices, rather
than SQL Server, and is there any way the main SQL Server database can be
pumped down to the satellite MSDE databases nightly. Is this possible with
DTS or any other way?
If you have any suggestions or reference links, that would be very much
appreciated!
Thanks,
- Joe Geretz -As long as the MSDE installation does not violate Microsoft's EULA for MSDE
or the database is not greater than 2GB in size or the usage of the MSDE
instances will not be hampered by the built in processing governor in MSDE,
then I would see no problem.
Jim
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:ulI7Pp3FEHA.712@.tk2msftngp13.phx.gbl...
> We recommend that our clients install SQL Server at each of their
satellite
> offices. Every night we DTS the central database out to the satellite
> offices. That way, if the link goes down, or if the main server were to go
> down, we'd have one or more backup databases to switch over to.
> One client is looking to save on SQL Server licensing costs. They
understand
> that the main server will need to be SQL Server, but they're reluctant to
> pay extra for additional servers which won't normally be used. They're
> asking if they could have MSDE installed at the satellite offices, rather
> than SQL Server, and is there any way the main SQL Server database can be
> pumped down to the satellite MSDE databases nightly. Is this possible with
> DTS or any other way?
> If you have any suggestions or reference links, that would be very much
> appreciated!
> Thanks,
> - Joe Geretz -
>

'downgrade' sql server 2005

I developed my application using SQL2005 Developer edition. but my clients
wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
Edition to Express?As long as your DB is less than 4gb .Backup and restore.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Patrick Yong" <patrickyong@.newsgroups.nospam> wrote in message
news:eTmqj1gQGHA.4900@.TK2MSFTNGP09.phx.gbl...
> I developed my application using SQL2005 Developer edition. but my clients
> wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
> Edition to Express?
>

Don't send report if it has no data

Hi All,
I have the standard version of SQL Server installed.
I have setup a few reports that will be automatically sent to some out
clients on a daily basis via a normal email-based subscription in reporting
services.
On some days, these reports are blank i.e. no rows returned in the dataset.
I am wondering if it is possible for the report to not be sent if a
situation exists where the report is blank
Thanks
SanjeevIf you have access to the sql server agent and can write a quick query that
will let you know if the data is going to be available it is possible. Each
subscription creates a sql server job in the sql server agent. The job
basically fires a stored procedure that executes the event (get params->run
report->render->mail or save...). The sql server jobs are saved with GUID
names that link back to the report like below. So look in the catalog and
find the report link to the scheduleID or Subscription ID. That ID will
link with the sql server job. Edit the job and have it do some if logic.
IF (there are results in this quick query) THEN trigger the event ELSE
(return 0, dbsendmail an error or however you want to handle it). This is
the basic idea of it. Let me know if you need any more help/detail.
FROM dbo.Catalog INNER JOIN
dbo.ReportSchedule ON dbo.Catalog.ItemID = dbo.ReportSchedule.ReportID INNER
JOIN
dbo.Schedule ON dbo.ReportSchedule.ScheduleID = dbo.Schedule.ScheduleID
Michael Abair
Programmer / Analyst
Chicos FAS Inc.
"Sanjeev Rampersad" <sanjeev@.sqr.com> wrote in message
news:O7miaQq9GHA.3960@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I have the standard version of SQL Server installed.
> I have setup a few reports that will be automatically sent to some out
> clients on a daily basis via a normal email-based subscription in
> reporting services.
> On some days, these reports are blank i.e. no rows returned in the
> dataset.
> I am wondering if it is possible for the report to not be sent if a
> situation exists where the report is blank
> Thanks
> Sanjeev
>|||Hi Michael,
Works like a charm.
Thanks a million
Sanjeev
"Michael Abair" <michael.abair@.chicos.com> wrote in message
news:%23Xgxept9GHA.4708@.TK2MSFTNGP05.phx.gbl...
> If you have access to the sql server agent and can write a quick query
> that will let you know if the data is going to be available it is
> possible. Each subscription creates a sql server job in the sql server
> agent. The job basically fires a stored procedure that executes the event
> (get params->run report->render->mail or save...). The sql server jobs
> are saved with GUID names that link back to the report like below. So
> look in the catalog and find the report link to the scheduleID or
> Subscription ID. That ID will link with the sql server job. Edit the job
> and have it do some if logic. IF (there are results in this quick query)
> THEN trigger the event ELSE (return 0, dbsendmail an error or however you
> want to handle it). This is the basic idea of it. Let me know if you
> need any more help/detail.
>
> FROM dbo.Catalog INNER JOIN
> dbo.ReportSchedule ON dbo.Catalog.ItemID = dbo.ReportSchedule.ReportID
> INNER JOIN
> dbo.Schedule ON dbo.ReportSchedule.ScheduleID = dbo.Schedule.ScheduleID
>
> --
> Michael Abair
> Programmer / Analyst
> Chicos FAS Inc.
> "Sanjeev Rampersad" <sanjeev@.sqr.com> wrote in message
> news:O7miaQq9GHA.3960@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> I have the standard version of SQL Server installed.
>> I have setup a few reports that will be automatically sent to some out
>> clients on a daily basis via a normal email-based subscription in
>> reporting services.
>> On some days, these reports are blank i.e. no rows returned in the
>> dataset.
>> I am wondering if it is possible for the report to not be sent if a
>> situation exists where the report is blank
>> Thanks
>> Sanjeev
>

Domain change has affected SQL need help

Hey,
One of my clients has migrated from an old NT domain to an AD domain with
Win2K servers. When the migration was performed, SQL 7.0 came across as well
,
but now displays some strange characteristics. NT authentication no longer
works, only SQL authentication.
The MS Search service does not start but I have an article to fix this.
Do I need to do anything else to SQL besides the MS Search service to get
SQL seeing the new domain correctly?
I was never involved in the move of SQL, and now this damn server runs a
mission-critical CRM package on SQL that can in no way be interupted or go
down during the day, and rebuilding is out of the question
Any help would be appreciated.
SQL7 running latest SP. Unfortunately cannot move to SQL 2000.
JoeJoe
SQL Server is a member of domain or stand alone?
Try to delete an old NT/Logins and create a new ones.
"Joe from NZ" <Joe from NZ@.discussions.microsoft.com> wrote in message
news:C79F6DCD-6C16-40B2-9189-1773ECAD335B@.microsoft.com...
> Hey,
> One of my clients has migrated from an old NT domain to an AD domain with
> Win2K servers. When the migration was performed, SQL 7.0 came across as
> well,
> but now displays some strange characteristics. NT authentication no longer
> works, only SQL authentication.
> The MS Search service does not start but I have an article to fix this.
> Do I need to do anything else to SQL besides the MS Search service to get
> SQL seeing the new domain correctly?
> I was never involved in the move of SQL, and now this damn server runs a
> mission-critical CRM package on SQL that can in no way be interupted or go
> down during the day, and rebuilding is out of the question
> Any help would be appreciated.
> SQL7 running latest SP. Unfortunately cannot move to SQL 2000.
> Joe|||Hi Uri,
The server is a member server of an AD domain.
The domain has 2 AD controllers, and 6 member servers.
Joe
"Uri Dimant" wrote:

> Joe
> SQL Server is a member of domain or stand alone?
> Try to delete an old NT/Logins and create a new ones.
>
> "Joe from NZ" <Joe from NZ@.discussions.microsoft.com> wrote in message
> news:C79F6DCD-6C16-40B2-9189-1773ECAD335B@.microsoft.com...
>
>

Domain change has affected SQL need help

Hey,
One of my clients has migrated from an old NT domain to an AD domain with
Win2K servers. When the migration was performed, SQL 7.0 came across as well,
but now displays some strange characteristics. NT authentication no longer
works, only SQL authentication.
The MS Search service does not start but I have an article to fix this.
Do I need to do anything else to SQL besides the MS Search service to get
SQL seeing the new domain correctly?
I was never involved in the move of SQL, and now this damn server runs a
mission-critical CRM package on SQL that can in no way be interupted or go
down during the day, and rebuilding is out of the question
Any help would be appreciated.
SQL7 running latest SP. Unfortunately cannot move to SQL 2000.
Joe
Joe
SQL Server is a member of domain or stand alone?
Try to delete an old NT/Logins and create a new ones.
"Joe from NZ" <Joe from NZ@.discussions.microsoft.com> wrote in message
news:C79F6DCD-6C16-40B2-9189-1773ECAD335B@.microsoft.com...
> Hey,
> One of my clients has migrated from an old NT domain to an AD domain with
> Win2K servers. When the migration was performed, SQL 7.0 came across as
> well,
> but now displays some strange characteristics. NT authentication no longer
> works, only SQL authentication.
> The MS Search service does not start but I have an article to fix this.
> Do I need to do anything else to SQL besides the MS Search service to get
> SQL seeing the new domain correctly?
> I was never involved in the move of SQL, and now this damn server runs a
> mission-critical CRM package on SQL that can in no way be interupted or go
> down during the day, and rebuilding is out of the question
> Any help would be appreciated.
> SQL7 running latest SP. Unfortunately cannot move to SQL 2000.
> Joe
|||Hi Uri,
The server is a member server of an AD domain.
The domain has 2 AD controllers, and 6 member servers.
Joe
"Uri Dimant" wrote:

> Joe
> SQL Server is a member of domain or stand alone?
> Try to delete an old NT/Logins and create a new ones.
>
> "Joe from NZ" <Joe from NZ@.discussions.microsoft.com> wrote in message
> news:C79F6DCD-6C16-40B2-9189-1773ECAD335B@.microsoft.com...
>
>

Domain change has affected SQL need help

Hey,
One of my clients has migrated from an old NT domain to an AD domain with
Win2K servers. When the migration was performed, SQL 7.0 came across as well,
but now displays some strange characteristics. NT authentication no longer
works, only SQL authentication.
The MS Search service does not start but I have an article to fix this.
Do I need to do anything else to SQL besides the MS Search service to get
SQL seeing the new domain correctly?
I was never involved in the move of SQL, and now this damn server runs a
mission-critical CRM package on SQL that can in no way be interupted or go
down during the day, and rebuilding is out of the question :(
Any help would be appreciated.
SQL7 running latest SP. Unfortunately cannot move to SQL 2000. :(
JoeJoe
SQL Server is a member of domain or stand alone?
Try to delete an old NT/Logins and create a new ones.
"Joe from NZ" <Joe from NZ@.discussions.microsoft.com> wrote in message
news:C79F6DCD-6C16-40B2-9189-1773ECAD335B@.microsoft.com...
> Hey,
> One of my clients has migrated from an old NT domain to an AD domain with
> Win2K servers. When the migration was performed, SQL 7.0 came across as
> well,
> but now displays some strange characteristics. NT authentication no longer
> works, only SQL authentication.
> The MS Search service does not start but I have an article to fix this.
> Do I need to do anything else to SQL besides the MS Search service to get
> SQL seeing the new domain correctly?
> I was never involved in the move of SQL, and now this damn server runs a
> mission-critical CRM package on SQL that can in no way be interupted or go
> down during the day, and rebuilding is out of the question :(
> Any help would be appreciated.
> SQL7 running latest SP. Unfortunately cannot move to SQL 2000. :(
> Joe|||Hi Uri,
The server is a member server of an AD domain.
The domain has 2 AD controllers, and 6 member servers.
Joe
"Uri Dimant" wrote:
> Joe
> SQL Server is a member of domain or stand alone?
> Try to delete an old NT/Logins and create a new ones.
>
> "Joe from NZ" <Joe from NZ@.discussions.microsoft.com> wrote in message
> news:C79F6DCD-6C16-40B2-9189-1773ECAD335B@.microsoft.com...
> > Hey,
> >
> > One of my clients has migrated from an old NT domain to an AD domain with
> > Win2K servers. When the migration was performed, SQL 7.0 came across as
> > well,
> > but now displays some strange characteristics. NT authentication no longer
> > works, only SQL authentication.
> > The MS Search service does not start but I have an article to fix this.
> >
> > Do I need to do anything else to SQL besides the MS Search service to get
> > SQL seeing the new domain correctly?
> >
> > I was never involved in the move of SQL, and now this damn server runs a
> > mission-critical CRM package on SQL that can in no way be interupted or go
> > down during the day, and rebuilding is out of the question :(
> >
> > Any help would be appreciated.
> > SQL7 running latest SP. Unfortunately cannot move to SQL 2000. :(
> >
> > Joe
>
>

dollar signs at the end of tables

Anyone know what's with dollar signs at the end of tables? One of my
clients has been "messing around" with his database, and I know he hasn't
got a clue. So now all the tables have been duplicated with the duplicates
having dollar signs at the end of the tables.
ex.
tblMytable
tblMytable$
Thanks,
JonIt's not actually my database, it's one of my clients, and I have absolutly
no idea what he did.
Thanks for the post though :-)
"Chinna Kondaveeti" <ckondaveeti@.hotmail.com> wrote in message
news:0d7201c36699$eaf99340$a001280a@.phx.gbl...
> I am not sure how they got in your database. But, usually
> when we export the excel workbooks using DTS, and if you
> choose the option create table and load the data, it will
> create a table with the worksheet name followed by $ (e.g.
> sheet1$ etc.)
> Thanks
> Chinna.
> >--Original Message--
> >Anyone know what's with dollar signs at the end of
> tables? One of my
> >clients has been "messing around" with his database, and
> I know he hasn't
> >got a clue. So now all the tables have been duplicated
> with the duplicates
> >having dollar signs at the end of the tables.
> >
> >ex.
> >
> >tblMytable
> >tblMytable$
> >
> >Thanks,
> >
> >Jon
> >
> >
> >.
> >|||May be MS access also puts duplicates, if you try to
connect to SQL Server database and try to save the tables.
Thanks
Chinna.
>--Original Message--
>Anyone know what's with dollar signs at the end of
tables? One of my
>clients has been "messing around" with his database, and
I know he hasn't
>got a clue. So now all the tables have been duplicated
with the duplicates
>having dollar signs at the end of the tables.
>ex.
>tblMytable
>tblMytable$
>Thanks,
>Jon
>
>.
>|||On Tue, 19 Aug 2003 17:39:03 -0400, "Jonathan Williams"
<anon@.covad.net> wrote:
>It's not actually my database, it's one of my clients, and I have absolutly
>no idea what he did.
>Thanks for the post though :-)
Hmm the further thought here would be... " have you actually asked him
what the f** he did?"
Al
>
>"Chinna Kondaveeti" <ckondaveeti@.hotmail.com> wrote in message
>news:0d7201c36699$eaf99340$a001280a@.phx.gbl...
>> I am not sure how they got in your database. But, usually
>> when we export the excel workbooks using DTS, and if you
>> choose the option create table and load the data, it will
>> create a table with the worksheet name followed by $ (e.g.
>> sheet1$ etc.)
>> Thanks
>> Chinna.
>> >--Original Message--
>> >Anyone know what's with dollar signs at the end of
>> tables? One of my
>> >clients has been "messing around" with his database, and
>> I know he hasn't
>> >got a clue. So now all the tables have been duplicated
>> with the duplicates
>> >having dollar signs at the end of the tables.
>> >
>> >ex.
>> >
>> >tblMytable
>> >tblMytable$
>> >
>> >Thanks,
>> >
>> >Jon
>> >
>> >
>> >.
>> >
>