do process

how can I do
perform a stored procedure with paramert from my client application but my q
uestion is sent call but transfer process to sqlserver a for example i can c
lose my application but process continue running in a sqlserver until finiss
hed, similar a job but with
out job.
Thank You
AlfSome environments and providers (e.g. .NET) will allow you to make a stored
procedure call asynchronous, meaning it does not have to wait for the
result.
So, it is hard to say if your client application can do that, because you
forgot to tell us anything about your client application.
A
<ag> wrote in message news:%23iXkfN6QGHA.4740@.TK2MSFTNGP14.phx.gbl...
> how can I do
>
> perform a stored procedure with paramert from my client application but my
> question is sent call but transfer process to sqlserver a for example i
> can close my application but process continue running in a sqlserver until
> finisshed, similar a job but without job.
> Thank You
> Alf
>

Do I need to reinstall analysis services after we upgraded sqlserv

Do I need to reinstall/upgrade analysis services after we upgraded sqlserver
from stanadard edition to enterprise edition? The developer tried to use
partition on analysis service and message from analysis manager showed that
it is not aware that our sqlserver has been upgraded to enterprise edition
already. "user-defined partitions are available only if you installed
analysis services on enterprise edition".May be the problem is caused by the meta data repository? If we migrate the
repository to SQL server, the problem will be resolved?
"sabby" wrote:
> Do I need to reinstall/upgrade analysis services after we upgraded sqlserver
> from stanadard edition to enterprise edition? The developer tried to use
> partition on analysis service and message from analysis manager showed that
> it is not aware that our sqlserver has been upgraded to enterprise edition
> already. "user-defined partitions are available only if you installed
> analysis services on enterprise edition".

DNS required ?

Hi All!
I facing the following problem:
Sometimes i get error while connecting to my SQLServer instance from client
machine "Timeout expired". I found it occurs when my DNS server is not reach
eable from client machine. But i connecting through alias, created by Client
network utility, where i s
pecify directly IP-address, NOT DNS-name ! I tried to connect through QA, os
ql - resuls the same.
Why it requires DNS ? What parameter i missing ?
Telnet on IP-address port works normally.
Server - NT 4.0 SP6 PDC, SQLServer 2000 Std Ed
Client - Windows 98 or NT 4.0IF you try to connect to a server named London, the name London needs to be
resolved to the IP address. This is the function that DNS provides...
However if you use theIP address yourself, DNS does not have to do anything.
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Slava Melnikov" <vasya000@.yandex.ru> wrote in message
news:F6CBFA12-2F13-452B-B848-5BA82228D0A1@.microsoft.com...
> Hi All!
> I facing the following problem:
> Sometimes i get error while connecting to my SQLServer instance from
client machine "Timeout expired". I found it occurs when my DNS server is
not reacheable from client machine. But i connecting through alias, created
by Client network utility, where i specify directly IP-address, NOT DNS-name
! I tried to connect through QA, osql - resuls the same.
> Why it requires DNS ? What parameter i missing ?
> Telnet on IP-address port works normally.
> Server - NT 4.0 SP6 PDC, SQLServer 2000 Std Ed
> Client - Windows 98 or NT 4.0|||What version of the SQL Server ODBC driver (sqlsrv32.dll) is installed on
the client. There is a issue with wsome of the earlier MDAC 2.6 SQL Server
ODBC drivers. If your driver version is 2000.8.0.194 you may be running
into this problem. It also occurs on some later versions as well. If you
install one of the more recent versions of MDAC, such as MDAC 2.7 then the
problem I am describing will not occur. Of course this assumes that you are
using the version of MDAC that has the problem.
When you ping the ip address does the response come back quickly or dies it
take some time?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||O-oh!
sqlsrv32.dll version is really 2000.8.0.194.
Thanks for help, Rand !
I should install latest service pack or new MDAC it's
enough ?
ping works normally

>--Original Message--
>What version of the SQL Server ODBC driver
(sqlsrv32.dll) is installed on
>the client. There is a issue with wsome of the earlier
MDAC 2.6 SQL Server
>ODBC drivers. If your driver version is 2000.8.0.194 you
may be running
>into this problem. It also occurs on some later versions
as well. If you
>install one of the more recent versions of MDAC, such as
MDAC 2.7 then the
>problem I am describing will not occur. Of course this
assumes that you are
>using the version of MDAC that has the problem.
>When you ping the ip address does the response come back
quickly or dies it
>take some time?
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>

Distribution of SQLServer Database

Hi,
We're in the process of developing a .NET application which will use a
SQLServer database. When installed/deployed the application will query this
database. I assume each time the application is installed the SQL Server
database will need to be installed. Is this the case - sorry I know it's a
dumb question but I am a complete SQL Server novice. If this is the case then
which licensing option should we go for?
Any help would be greatly appreciated.
-Kim
Hi Kim
There is a version of SQL Server which is designed to be deployed with user
programs. It's called MSDE & you can read more about it here:
http://msdn.microsoft.com/library/de...ar_ts_67ax.asp
There are limits on it's growth (2Gb per db, max 2 CPUs etc) & if you exceed
these, you'd probably be looking at SQL Server Standard Edition.
Regards,
Greg Linwood
SQL Server MVP
"kim d" <kimd@.discussions.microsoft.com> wrote in message
news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> Hi,
> We're in the process of developing a .NET application which will use a
> SQLServer database. When installed/deployed the application will query
> this
> database. I assume each time the application is installed the SQL Server
> database will need to be installed. Is this the case - sorry I know it's a
> dumb question but I am a complete SQL Server novice. If this is the case
> then
> which licensing option should we go for?
> Any help would be greatly appreciated.
> -Kim
|||It also depends on what you mean about deplying SQL... YOu might wish all of
the clients to share data from a single database, or you might wish to
install the MSDE version on each client, so there is no data sharing...
In either case, at least you will have to the the SQL Connectivity piece on
the client.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"kim d" <kimd@.discussions.microsoft.com> wrote in message
news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> Hi,
> We're in the process of developing a .NET application which will use a
> SQLServer database. When installed/deployed the application will query
this
> database. I assume each time the application is installed the SQL Server
> database will need to be installed. Is this the case - sorry I know it's a
> dumb question but I am a complete SQL Server novice. If this is the case
then
> which licensing option should we go for?
> Any help would be greatly appreciated.
> -Kim
|||Ideally clients would share data from a single database but there would be
the capability to work 'off-line' - in other words users could access the
database even while not explicitly connected to the server. I presume in this
case it would require a separate MSDE installation on each client as well as
on the server database. Does MSDE support this type of behaviour?
"Wayne Snyder" wrote:

> It also depends on what you mean about deplying SQL... YOu might wish all of
> the clients to share data from a single database, or you might wish to
> install the MSDE version on each client, so there is no data sharing...
> In either case, at least you will have to the the SQL Connectivity piece on
> the client.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "kim d" <kimd@.discussions.microsoft.com> wrote in message
> news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> this
> then
>
>
|||Great, so does this mean that we would only need to purchase a SQLServer
developers license?
"Greg Linwood" wrote:

> Hi Kim
> There is a version of SQL Server which is designed to be deployed with user
> programs. It's called MSDE & you can read more about it here:
> http://msdn.microsoft.com/library/de...ar_ts_67ax.asp
> There are limits on it's growth (2Gb per db, max 2 CPUs etc) & if you exceed
> these, you'd probably be looking at SQL Server Standard Edition.
> Regards,
> Greg Linwood
> SQL Server MVP
> "kim d" <kimd@.discussions.microsoft.com> wrote in message
> news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
>
>
|||In this case, you'd be looking at Personal Edition, which is on the SS
media. Then you replicate the Central Database to your clients, which can
then go "offline."
That's what this edition was created for. It has restrictions, but
different than those of MSDE, which is more an Access database replacement.
SS Personal Edition is more for business, semi-connected users, like sales
staff.
Sincerely,
Anthony Thomas

"kim d" <kimd@.discussions.microsoft.com> wrote in message
news:7E0720DF-6224-4B91-A92E-5D4C542D7FC3@.microsoft.com...
Ideally clients would share data from a single database but there would be
the capability to work 'off-line' - in other words users could access the
database even while not explicitly connected to the server. I presume in
this
case it would require a separate MSDE installation on each client as well as
on the server database. Does MSDE support this type of behaviour?
"Wayne Snyder" wrote:

> It also depends on what you mean about deplying SQL... YOu might wish all
of
> the clients to share data from a single database, or you might wish to
> install the MSDE version on each client, so there is no data sharing...
> In either case, at least you will have to the the SQL Connectivity piece
on[vbcol=seagreen]
> the client.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "kim d" <kimd@.discussions.microsoft.com> wrote in message
> news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> this
a
> then
>
>

Distribution of SQLServer Database

Hi,
We're in the process of developing a .NET application which will use a
SQLServer database. When installed/deployed the application will query this
database. I assume each time the application is installed the SQL Server
database will need to be installed. Is this the case - sorry I know it's a
dumb question but I am a complete SQL Server novice. If this is the case then
which licensing option should we go for?
Any help would be greatly appreciated.
-KimHi Kim
There is a version of SQL Server which is designed to be deployed with user
programs. It's called MSDE & you can read more about it here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_67ax.asp
There are limits on it's growth (2Gb per db, max 2 CPUs etc) & if you exceed
these, you'd probably be looking at SQL Server Standard Edition.
Regards,
Greg Linwood
SQL Server MVP
"kim d" <kimd@.discussions.microsoft.com> wrote in message
news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> Hi,
> We're in the process of developing a .NET application which will use a
> SQLServer database. When installed/deployed the application will query
> this
> database. I assume each time the application is installed the SQL Server
> database will need to be installed. Is this the case - sorry I know it's a
> dumb question but I am a complete SQL Server novice. If this is the case
> then
> which licensing option should we go for?
> Any help would be greatly appreciated.
> -Kim|||It also depends on what you mean about deplying SQL... YOu might wish all of
the clients to share data from a single database, or you might wish to
install the MSDE version on each client, so there is no data sharing...
In either case, at least you will have to the the SQL Connectivity piece on
the client.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"kim d" <kimd@.discussions.microsoft.com> wrote in message
news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> Hi,
> We're in the process of developing a .NET application which will use a
> SQLServer database. When installed/deployed the application will query
this
> database. I assume each time the application is installed the SQL Server
> database will need to be installed. Is this the case - sorry I know it's a
> dumb question but I am a complete SQL Server novice. If this is the case
then
> which licensing option should we go for?
> Any help would be greatly appreciated.
> -Kim|||Ideally clients would share data from a single database but there would be
the capability to work 'off-line' - in other words users could access the
database even while not explicitly connected to the server. I presume in this
case it would require a separate MSDE installation on each client as well as
on the server database. Does MSDE support this type of behaviour?
"Wayne Snyder" wrote:
> It also depends on what you mean about deplying SQL... YOu might wish all of
> the clients to share data from a single database, or you might wish to
> install the MSDE version on each client, so there is no data sharing...
> In either case, at least you will have to the the SQL Connectivity piece on
> the client.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "kim d" <kimd@.discussions.microsoft.com> wrote in message
> news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> > Hi,
> > We're in the process of developing a .NET application which will use a
> > SQLServer database. When installed/deployed the application will query
> this
> > database. I assume each time the application is installed the SQL Server
> > database will need to be installed. Is this the case - sorry I know it's a
> > dumb question but I am a complete SQL Server novice. If this is the case
> then
> > which licensing option should we go for?
> > Any help would be greatly appreciated.
> > -Kim
>
>|||Great, so does this mean that we would only need to purchase a SQLServer
developers license?
"Greg Linwood" wrote:
> Hi Kim
> There is a version of SQL Server which is designed to be deployed with user
> programs. It's called MSDE & you can read more about it here:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_67ax.asp
> There are limits on it's growth (2Gb per db, max 2 CPUs etc) & if you exceed
> these, you'd probably be looking at SQL Server Standard Edition.
> Regards,
> Greg Linwood
> SQL Server MVP
> "kim d" <kimd@.discussions.microsoft.com> wrote in message
> news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> > Hi,
> > We're in the process of developing a .NET application which will use a
> > SQLServer database. When installed/deployed the application will query
> > this
> > database. I assume each time the application is installed the SQL Server
> > database will need to be installed. Is this the case - sorry I know it's a
> > dumb question but I am a complete SQL Server novice. If this is the case
> > then
> > which licensing option should we go for?
> > Any help would be greatly appreciated.
> > -Kim
>
>|||In this case, you'd be looking at Personal Edition, which is on the SS
media. Then you replicate the Central Database to your clients, which can
then go "offline."
That's what this edition was created for. It has restrictions, but
different than those of MSDE, which is more an Access database replacement.
SS Personal Edition is more for business, semi-connected users, like sales
staff.
Sincerely,
Anthony Thomas
"kim d" <kimd@.discussions.microsoft.com> wrote in message
news:7E0720DF-6224-4B91-A92E-5D4C542D7FC3@.microsoft.com...
Ideally clients would share data from a single database but there would be
the capability to work 'off-line' - in other words users could access the
database even while not explicitly connected to the server. I presume in
this
case it would require a separate MSDE installation on each client as well as
on the server database. Does MSDE support this type of behaviour?
"Wayne Snyder" wrote:
> It also depends on what you mean about deplying SQL... YOu might wish all
of
> the clients to share data from a single database, or you might wish to
> install the MSDE version on each client, so there is no data sharing...
> In either case, at least you will have to the the SQL Connectivity piece
on
> the client.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "kim d" <kimd@.discussions.microsoft.com> wrote in message
> news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> > Hi,
> > We're in the process of developing a .NET application which will use a
> > SQLServer database. When installed/deployed the application will query
> this
> > database. I assume each time the application is installed the SQL Server
> > database will need to be installed. Is this the case - sorry I know it's
a
> > dumb question but I am a complete SQL Server novice. If this is the case
> then
> > which licensing option should we go for?
> > Any help would be greatly appreciated.
> > -Kim
>
>

Distributing SQLServer Database

Good Day!

I want to know how to distribute a database in SQL Server from one computer to another?

Thnx!

Kapalic

you can use Backup/restore method or dettach /attach method. Backup/restore is an online metod and dettach/attach is an offline method.

Madhu