Is this the right tool?

I think Service Broker is the right tool for what I want to do but need confirmation. Here is what I want to do.

Our company sells small business consulting services. When a client signs up with us, we put a server at their site that runs our app (using SQL Server 2005). Once the server is setup at their site and operational we constantly send certain information from that server to our central corporate server. There could be thousands of records every day being sent from each of these servers to our corporate server. We're using webservices now to transfer this data from each server but I'm afraid we're reaching a point where webservices will no longer work because of the volume of data.

1) I assume that Service Broker was created, in part at least, to address these types of situations?

2) If #1 is correct, is there any step by step examples/instruction that shows me how to use Service Broker to communicate between two SQL Server databases on two different servers?

Thanks very much.

Amos.

Yes, Service Broker is explicitly designed with these scenarios in mind. It provides a reliable loosely coupled infrastructure for the communication:
- message delivery is guaranteed to be Exactly Once In Order (no message duplicates, no messages out of order)
- the infrastructure can gracefully handle availability problems (lack of connectivity to the corporate server will be transparent to the operations site, applications will never notice it)
- durable, transactional semantics for message delivery (messages cannot be lost between sender and recipient, delivery correctness is guaranteed even in the event of a connection interrupt, application crash etc)
- message queuing for handling load spikes, service interrupts, operational upgrades etc
- loosely coupled, designed with separate administrative control between the conversing parties (sender/receiver can upgrade separately the service application, can have separate administrative and security control etc)
- integration of data and messages in the database, benefiting from the existing recoverability of the database (backup/restore), availability (failover clustering, database mirroring), programmability (T-SQL, ADO.Net), monitoring (integration with SQL Profiler), relational semantics (e.g. ability to run a SELECT over a queue to see the messages pending to be received) etc etc.

For examples and samples, I recommend you visit the team site at www.sqlservicebroker.com, read the articles mentioned on http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=516904&SiteID=1 and other articles about it that you can find. If you can get hold of Roger's book 'The rational guide to SQL Service Broker', it's a great read on the subject. The easiest way to set up communication between two machines is using the tool mentioned at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=339850&SiteID=1

HTH,
~ Remus

Is this possible?

Hi guys,

Is there any mechanism or tool to convert T-SQL query to its corresponding MDX query?

Please let me know.

Sincerely,

Amde

That begs the question: is there necessarily a corresponding MDX query? So if you could explain the context, or what problem you're trying to solve, that would help.|||

Hi,

The thing is I have a T-SQL query which works perfectly in a relational database. And I want to implement the same functionality in my Cube. So I am curious to know if I could achieve this thing.

Sincerely,

Amde

|||

Hi Amde,

Can you give an idea of the cube and how it is built from relational data? Also, what values does the T-SQL query return, or what does the query look like?

|||

hi,

Basically, I am working on repoting service, and I don't know how the cube is built. All I know is that I have the dimesions, measures, levels, members and so on to generat the report. But, I can tell you about the T-sql query and you can give whether I can achieve the same functionality using MDX query?

The t-sql query do some calculation on the date information and keep on storing the values in the temporary table. Finally, these value will be used in the report.

Sincerely,

Amde

|||Well, knowing the T-SQL would help (sounds like it's more than just queries, if temp tables are inolved). But it would be hard to figure out the MDX without knowing something about the cube design - how do the dimensions and measures relate to the report you're trying to generate, for example?|||

By the way, is it possible to create a temporary table in cubes?

|||Not exactly, but depends on what overall problem you're trying to solve - I think it's useful to understand the capabilities of Analysis Services OLAP in its own right, versus just drawing detailed comparisons to relational concepts.|||

Okay, assume the following scenario:

I have a date dimension, which stores date info. Assume I want to select the members of the dimension , for example, based on this condition: [Dates].[Date].&[2006-02-25T00:00:00]:[Dates].[Date].&[2006-06-24T00:00:00]. And I want the output in the following format;i.e. on a monthly basis.

From 2006-02-25 to 2006-03-24

From 2006-03-25 to 2006-04-24

From 2006-04-25 to 2006-05-24

From 2006-05-25 to 2006-06-24

How can I achieve this scenario?

Sincerely,

Amde

|||

A couple of questions:

Is 24th the end of the fiscal or reporting month - in which case create a separate "fiscal month"?|||

Hi,

Here is some answer inline:

-"Fiscal month" is not necessary for my report, because of the fact that the report is not financial related.

-Yes there will be a measure which counts some values on each date range.

Sincerely,

Amde

sql

Is there such a tool?

> Is there a tool, which could register all changes in a database? For
> example, a program connects to the database and makes some changes. The
tool
> would give as the results: what tables were affected and even what rows
were
> inserted, modified or deleted.
Have a look on our MSSQL LogManager.
http://www.upscene.com/products/audit/mssqllm_main.htm
Best Regards,
Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com
Vycka wrote:
> Is there a tool, which could register all changes in a database? For
> example, a program connects to the database and makes some changes.
> The tool would give as the results: what tables were affected and
> even what rows were inserted, modified or deleted.
OmniAudit does exactly that. http://www.krell-software.com
Steve Troxell
Krell Software
|||This tool is pretty handy, but...
I installed it to my computer, then I did "prepare database for logging".
After that my program that uses the database got out of order. It started to
behave unpredictably so I decided not to use the tool and I did "unprepare
database from logging". In my opinion after doing this the database should
become clean of this program. But unfortunately now my database program
stopped working at all throwing error messages saying that "could not find
stored procedure dbo.P_INSERTINTOLOGTABLE". What is this? As far as I can
see it is related with triggers that were not deleted by that tool (MS SQL
LogManager).
Please Explain me, how to make my program (and database) work smoothly
exactly as it was?
Thank you for your help
"Thomas Steinmaurer" <t.steinmaurer@._no_upscene_spam_.com> wrote in message
news:#$Vsc2THEHA.1944@.TK2MSFTNGP11.phx.gbl...
> tool
> were
> Have a look on our MSSQL LogManager.
> http://www.upscene.com/products/audit/mssqllm_main.htm
>
> Best Regards,
> Thomas Steinmaurer
> LogManager Serie - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database and MS SQL Server
> Upscene Productions
> http://www.upscene.com
>
|||Hi,

> This tool is pretty handy, but...
> I installed it to my computer, then I did "prepare database for logging".
> After that my program that uses the database got out of order. It started
to
> behave unpredictably so I decided not to use the tool and I did "unprepare
> database from logging".
Can you elaborate what you mean with "got out of order", please?

> In my opinion after doing this the database should
> become clean of this program.
Right.

> But unfortunately now my database program
> stopped working at all throwing error messages saying that "could not find
> stored procedure dbo.P_INSERTINTOLOGTABLE". What is this? As far as I can
> see it is related with triggers that were not deleted by that tool (MS SQL
> LogManager).
The Unprepare-Wizard should take care of that. And so far, it did.
Do you see any tables/views starting with MSSQLLM$... at all?
If the logging trigger weren't remove, then you might find them via
the following name template (btw, that depends, what trigger naming
conventions you've used during the Prepare).
For example:
TRI_<table_name>_L_<event_type>
A concrete example would be:
TRI_ADDRESS_L_D or
TRI_ADDRESS_L_I or
TRI_ADDRESS_L_U
What Microsoft SQL Server are you using?
Best Regards,
Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com
|||"Thomas Steinmaurer" <t.steinmaurer@._no_upscene_spam_.com> wrote in message
news:OQOcEEZHEHA.3564@.TK2MSFTNGP09.phx.gbl...
> Hi,
logging".
started
> to
"unprepare
> Can you elaborate what you mean with "got out of order", please?
My program is a very complex document and contact managemet program. So when
I tried to add a new document, or add a new contact to the database in stead
of getting common notification window I got another program window
absolutely out of point. It is difficult to explain everything when you
don't know my program. I didn't made this program, it is a big commercial
program developed by a company. It was made on Visual Studio ASP.NET.
>
> Right.
find
can
SQL
> The Unprepare-Wizard should take care of that. And so far, it did.
> Do you see any tables/views starting with MSSQLLM$... at all?
Now three tables and one view was dropped after "unprepare" procedure.
But in SysObjects table I found six triggers related with two tables from my
DB. I Dropped them by writing seperate querries. Now everything works fine -
no error messages, no unaccountable program behaviour.
I appreciate your help, thank you.

> If the logging trigger weren't remove, then you might find them via
> the following name template (btw, that depends, what trigger naming
> conventions you've used during the Prepare).
> For example:
> TRI_<table_name>_L_<event_type>
> A concrete example would be:
> TRI_ADDRESS_L_D or
> TRI_ADDRESS_L_I or
> TRI_ADDRESS_L_U
> What Microsoft SQL Server are you using?
I'm Using MS SQL Server 2000 08.00.0760

>
> Best Regards,
> Thomas Steinmaurer
> LogManager Serie - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database and MS SQL Server
> Upscene Productions
> http://www.upscene.com
>
|||> > > This tool is pretty handy, but...
> logging".
> started
> "unprepare
> My program is a very complex document and contact managemet program. So
when
> I tried to add a new document, or add a new contact to the database in
stead
> of getting common notification window I got another program window
> absolutely out of point.
I guess, you don't have an error message or a screenshoot of that
window, do you? I'm just trying to fix a possible issue, if there is
anything to fix at all.

> Now three tables and one view was dropped after "unprepare" procedure.
I did some extensive testing, and I couldn't break the Unprepare
process in any way. Existing log trigger get removed automatically,
before the Unprepare wizard removes logging metadata. It works
here, as expected.

> But in SysObjects table I found six triggers related with two tables from
my
> DB. I Dropped them by writing seperate querries. Now everything works
fine -
> no error messages, no unaccountable program behaviour.
> I appreciate your help, thank you.
You are welcome!
Best Regards,
Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com

Is there any way to deploy an SSIS Package (File Mode) to an App Server without SQL Instance?

We would like to deploy SSIS packages as an ETL Tool to an appserver that does not have SQL Server 2005 installed. Is this possible, or does it HAVE to be executed on the server with SQL 2005 installed?

Kevin
SQL Server (the database engine) doesn't have to be installed. However, you will need to install the SSIS full client (from the SQL Server installation media) and have a valid SQL Server license for that machine.|||

What Phil said is true that you can do this, however, there are other considerations on why you may not want to.

One main reason is if you are moving large amount of data through SSIS. If you have it on a seperate machine:

[Source Machine] - - - large amount of data - - > [SSIS machine] - - - large amoutn of data - - > [destination machine]

VS

[Source Machine] - - - large amount of data - - > [SSIS/Desitination machine]

As you can see, you will be moving large sets of data accross your network twice.

Is there any tool which support design and modeling for SQL 2005?

ERwin¡¢PowerDesigner¡¢Visio ...?
I want it could created a document according to the DB's schemal.Hi
I would expect most of the larger players will have versions to release when
SQL2005 is launched.
John
"microsoft.public.sqlserver.server" wrote:
> ERwin¡¢PowerDesigner¡¢Visio ...?
> I want it could created a document according to the DB's schemal.
>
>

Is there any tool which support design and modeling for SQL 2005?

ERwinPowerDesignerVisio ...?
I want it could created a document according to the DB's schemal.
Hi
I would expect most of the larger players will have versions to release when
SQL2005 is launched.
John
"microsoft.public.sqlserver.server" wrote:

> ERwin?￠PowerDesigner?￠Visio ...?
> I want it could created a document according to the DB's schemal.
>
>

Is there any tool which support design and modeling for SQL 2005?

ERwinPowerDesignerVisio ...?
I want it could created a document according to the DB's schemal.Hi
I would expect most of the larger players will have versions to release when
SQL2005 is launched.
John
"microsoft.public.sqlserver.server" wrote:

> ERwin?￠PowerDesigner?￠Visio ...?
> I want it could created a document according to the DB's schemal.
>
>

Is there any tool for printing all table structure of a database

Dear all,
I am wondering if there is any tool which allows us to print out the table
structure of all tables in a database. Anyone knows?
Thanks a lot.Hi,
Query the below system view.
INFORMATION_SCHEMA.COLUMNS
Thanks
Hari
SQL Server MVP
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.|||Right-Click your database, select All Tasks and then select Generate SQL
Scripts
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.|||On Fri, 26 Aug 2005 19:56:01 -0700, "Ivan"
<Ivan@.discussions.microsoft.com> wrote:
>I am wondering if there is any tool which allows us to print out the table
>structure of all tables in a database. Anyone knows?
>Thanks a lot.
Besides the previous two answers, also look at the diagram feature in
Enterprise Manager!
J.|||> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.
If "print" really means "paper", check out the Schema Printing features
in our tool called Database Workbench - www.upscene.com
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Is there any tool for printing all table structure of a database

Dear all,
I am wondering if there is any tool which allows us to print out the table
structure of all tables in a database. Anyone knows?
Thanks a lot.
Hi,
Query the below system view.
INFORMATION_SCHEMA.COLUMNS
Thanks
Hari
SQL Server MVP
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.
|||Right-Click your database, select All Tasks and then select Generate SQL
Scripts
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.
|||On Fri, 26 Aug 2005 19:56:01 -0700, "Ivan"
<Ivan@.discussions.microsoft.com> wrote:
>I am wondering if there is any tool which allows us to print out the table
>structure of all tables in a database. Anyone knows?
>Thanks a lot.
Besides the previous two answers, also look at the diagram feature in
Enterprise Manager!
J.
|||
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.
If "print" really means "paper", check out the Schema Printing features
in our tool called Database Workbench - www.upscene.com
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Is there any tool for printing all table structure of a database

Dear all,
I am wondering if there is any tool which allows us to print out the table
structure of all tables in a database. Anyone knows?
Thanks a lot.Hi,
Query the below system view.
INFORMATION_SCHEMA.COLUMNS
Thanks
Hari
SQL Server MVP
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.|||Right-Click your database, select All Tasks and then select Generate SQL
Scripts
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.|||On Fri, 26 Aug 2005 19:56:01 -0700, "Ivan"
<Ivan@.discussions.microsoft.com> wrote:
>I am wondering if there is any tool which allows us to print out the table
>structure of all tables in a database. Anyone knows?
>Thanks a lot.
Besides the previous two answers, also look at the diagram feature in
Enterprise Manager!
J.|||
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.
If "print" really means "paper", check out the Schema Printing features
in our tool called Database Workbench - www.upscene.com
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

IS THERE ANY TOOL

Is there any tool like Enterprise Manager to help me create databases , tables ... with MSDE?
If there isn't how can i create these objects?
Perhaps using OSQL Command?
Thank you
George
> Is there any tool like Enterprise Manager to help me create databases
> , tables ... with MSDE? If there isn't how can i create these objects?
> Perhaps using OSQL Command?
A good list here:
http://www.microsoft.com/sql/msde/partners/default.asp
I strongly recommend our tool : myLittleAdmin
(http://www.mylittletools.net/mla_sql)
Sincerely
el.c.
// myLittleTools.net : leading provider of web-based applications.
// myLittleAdmin : online MS SQL manager
// http://www.mylittletools.net
// webmaster@.mylittletools.net
|||I use SQL Server Web Data Administrator (free stuff), and
it is really cool!
To help you, I will show were to find the software in the
correct order of installation:
..Microsoft .NET Framework Version 1.1
Redistributable Package
http://www.microsoft.com/downloads/details.aspx?
FamilyID=262d25e3-f589-4842-8157-
034d1e7cf3a3&displaylang=en
..Microsoft .NET Framework SDK Version 1.1
http://www.microsoft.com/downloads/details.aspx?
FamilyID=9b3a2ca6-3647-4070-9f41-
a333c6b9181d&displaylang=en
..ASP.NET Cassini Sample Web Server
http://asp.net/Projects/Cassini/Download/Default.aspx?
tabindex=0&tabid=1
..Microsoft SQL Web Data Administrator
http://www.microsoft.com/downloads/details.aspx?
FamilyId=C039A798-C57A-419E-ACBC-
2A332CB7F959&displaylang=en
Good luck!
Aldrin
PS INSTALL SOFTWARE PACKAGES IN THIS ORDER!
[color=darkblue]
>--Original Message--
create databases[color=darkblue]
create these objects?
>A good list here:
>http://www.microsoft.com/sql/msde/partners/default.asp
>I strongly recommend our tool : myLittleAdmin
>(http://www.mylittletools.net/mla_sql)
>Sincerely
>el.c.
>--
>// myLittleTools.net : leading provider of web-based
applications.
>// myLittleAdmin : online MS SQL manager
>// http://www.mylittletools.net
>// webmaster@.mylittletools.net
>
>.
>
|||The Developer edition of SQL Server is available for $49 from
Microsoft, which has all of the client tools (SEM, QA, Profiler,
etc.), which you can install independently of the server.
--mary
On Tue, 13 Apr 2004 02:51:03 -0700, GEORGE
<anonymous@.discussions.microsoft.com> wrote:

>Is there any tool like Enterprise Manager to help me create databases , tables ... with MSDE?
>If there isn't how can i create these objects?
>Perhaps using OSQL Command?
>Thank you
>George

Is there any book (books?) to help us creating a Sync tool (Bidirectional)

Hi guys,

We have been looking for books which cover the DB synchronisation subject. We have started creating a plugin to our socket server but we quickly realised how much of a challenge it would be (We are creating it "from scratch"). The conflict problems, the order to tables (rows) be synchronised (Child - Parent) and how to delete rows were some of the problems we found. The main goal is to synchronise devices in the field (Compact framework) to the server using less bandwich as possible.
We are trying to be "agnostic" about the DB in both Server and Client side.

We are pretty sure there are books out there which cover this subject, we just couldn't find them!

We know this will be a challenge but we also know it will be a great feature to add to the server.

Does anyone could point me out to any book?

Cheers

Jean Baro
Dynamic Devices Ltd

Instead of reinventing the wheel, maybe you should have a look at ADO.NET Synchronization Services. http://blogs.msdn.com/Synchronizer/

|||Thanks Erik!

Is there any book (books?) to help us creating a Sync tool (Bidirectional)

Hi guys,

We have been looking for books which cover the DB synchronisation subject. We have started creating a plugin to our socket server but we quickly realised how much of a challenge it would be (We are creating it "from scratch"). The conflict problems, the order to tables (rows) be synchronised (Child - Parent) and how to delete rows were some of the problems we found. The main goal is to synchronise devices in the field (Compact framework) to the server using less bandwich as possible.
We are trying to be "agnostic" about the DB in both Server and Client side.

We are pretty sure there are books out there which cover this subject, we just couldn't find them!

We know this will be a challenge but we also know it will be a great feature to add to the server.

Does anyone could point me out to any book?

Cheers

Jean Baro
Dynamic Devices Ltd

Instead of reinventing the wheel, maybe you should have a look at ADO.NET Synchronization Services. http://blogs.msdn.com/Synchronizer/

|||Thanks Erik!