how to show and edit parameters in a windows form

Is there somebody who has used a windows form and a suitable control (Like
Datagrid) to extract parameters of an specific report and let user edit
them?
I 've done the exctracting the parameters ,,but I don't know how to extract
each parameter values(which are based on the different queries) and show it
to the user.
Thanks for your help.
ALISee the Report Wizard demo code in the AwReporterWin WinForm app that
accompanies my book source code.
http://www.manning-sandbox.com/thread.jspa?threadID=10393&tstart=45
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"ALI-R" <newbie@.microsoft.com> wrote in message
news:eqEm5q1yEHA.2624@.TK2MSFTNGP11.phx.gbl...
> Is there somebody who has used a windows form and a suitable control (Like
> Datagrid) to extract parameters of an specific report and let user edit
> them?
> I 've done the exctracting the parameters ,,but I don't know how to
extract
> each parameter values(which are based on the different queries) and show
it
> to the user.
> Thanks for your help.
> ALI
>|||Thank you very much indeed,,I was actually doing the same thing ,but it
helped a lot.
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:%23rF5hT4yEHA.2788@.TK2MSFTNGP15.phx.gbl...
> See the Report Wizard demo code in the AwReporterWin WinForm app that
> accompanies my book source code.
> http://www.manning-sandbox.com/thread.jspa?threadID=10393&tstart=45
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:eqEm5q1yEHA.2624@.TK2MSFTNGP11.phx.gbl...
> > Is there somebody who has used a windows form and a suitable control
(Like
> > Datagrid) to extract parameters of an specific report and let user edit
> > them?
> >
> > I 've done the exctracting the parameters ,,but I don't know how to
> extract
> > each parameter values(which are based on the different queries) and show
> it
> > to the user.
> >
> > Thanks for your help.
> > ALI
> >
> >
>

How to set-up sql server 2000 in win2k3 Server to store big-5 Chinese data

I am using Windows 2003 Server English Version. I wanna store the big-5
data so I install the sql server 2000 as if i install it in the Windows
2000 with Server Collation of the Chinese_Taiwan_Stroke_CL_AS.
However, the data are stored into the database server in unicode
instead of big-5 in that of windows 2000 OS.

I would like to ask how i can set so that the Sql Server 2000 can store
the big-5 data(micmic.chion@.gmail.com) writes:
> I am using Windows 2003 Server English Version. I wanna store the big-5
> data so I install the sql server 2000 as if i install it in the Windows
> 2000 with Server Collation of the Chinese_Taiwan_Stroke_CL_AS.
> However, the data are stored into the database server in unicode
> instead of big-5 in that of windows 2000 OS.
> I would like to ask how i can set so that the Sql Server 2000 can store
> the big-5 data

First of all, my knowledge and experience of Chinese and its character
sets is very limited, so bear with me.

I was under the impression that for non-Unicode characters sets, East
Asian languages are stored in varchar as double-byte character sets.
Unicode is stored in nvarchar. So you would probably use varchar for
your data. Could this be the answer?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I am using the varchar for the fields of table which i wanna save big-5
data.

When i entered the chinese data, the data can be saved. But when i read
the data from the web boswer (ie. IE ), i need to change the encoding
from unicode instead of big-5 in order to viewing it

Is it due to the language of the OS (ie. WIndows 2003)?|||(micmic.chion@.gmail.com) writes:
> I am using the varchar for the fields of table which i wanna save big-5
> data.
> When i entered the chinese data, the data can be saved. But when i read
> the data from the web boswer (ie. IE ), i need to change the encoding
> from unicode instead of big-5 in order to viewing it
> Is it due to the language of the OS (ie. WIndows 2003)?

Hm, if the columns in the database are varchar, then you just cannot
get Unicode into them. So my guess is that you do have Big-5 in the
database, and then something happens on the way to the web browser.

You could verify this by looking in Qurey Analyzer and doing a
SELECT on the table. If it looks OK, then I would guess it is
Big-5. Do run it even further you could do:

select convert(varbinary, big5col)

and the see whether the codes are Big-5 or Unicode. (This presumes that
you actually knows the codes for some characters.)

If my theory is correct that the data in the database is Big5, then
we need to find out why you get Unicode in the browser. Unfortunately,
I know almost as little about web servers as I know Chinese.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||(micmic.chion@.gmail.com) writes:
> I am using the varchar for the fields of table which i wanna save big-5
> data.
> When i entered the chinese data, the data can be saved. But when i read
> the data from the web boswer (ie. IE ), i need to change the encoding
> from unicode instead of big-5 in order to viewing it
> Is it due to the language of the OS (ie. WIndows 2003)?

Hm, if the columns in the database are varchar, then you just cannot
get Unicode into them. So my guess is that you do have Big-5 in the
database, and then something happens on the way to the web browser.

You could verify this by looking in Qurey Analyzer and doing a
SELECT on the table. If it looks OK, then I would guess it is
Big-5. Do run it even further you could do:

select convert(varbinary, big5col)

and the see whether the codes are Big-5 or Unicode. (This presumes that
you actually knows the codes for some characters.)

If my theory is correct that the data in the database is Big5, then
we need to find out why you get Unicode in the browser. Unfortunately,
I know almost as little about web servers as I know Chinese.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I try the method you mentioned in both MS SQL Server in Windows 2000
server and Windows 2K3.

select convert(varbinary, big5col)

It is found that the binary is the same.

I have found out that if you add the following in the heading of the
page,
this page can show the big-5 character.

<%@. codepage=950 %
As the string stored in database is in unicode format, if you set the
codepage as big-5 format, the data will be changed as big-5 and show in
the webpage.

Thank you for your great sugegstion

Ref: Chinese-simpified version:
http://www.evget.com/articles/evget_1092.html

Erland Sommarskog 寫道：
> (micmic.chion@.gmail.com) writes:
> > I am using the varchar for the fields of table which i wanna save big-5
> > data.
> > When i entered the chinese data, the data can be saved. But when i read
> > the data from the web boswer (ie. IE ), i need to change the encoding
> > from unicode instead of big-5 in order to viewing it
> > Is it due to the language of the OS (ie. WIndows 2003)?
> Hm, if the columns in the database are varchar, then you just cannot
> get Unicode into them. So my guess is that you do have Big-5 in the
> database, and then something happens on the way to the web browser.
> You could verify this by looking in Qurey Analyzer and doing a
> SELECT on the table. If it looks OK, then I would guess it is
> Big-5. Do run it even further you could do:
> select convert(varbinary, big5col)
> and the see whether the codes are Big-5 or Unicode. (This presumes that
> you actually knows the codes for some characters.)
> If my theory is correct that the data in the database is Big5, then
> we need to find out why you get Unicode in the browser. Unfortunately,
> I know almost as little about web servers as I know Chinese.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||(micmic.chion@.gmail.com) writes:
> I try the method you mentioned in both MS SQL Server in Windows 2000
> server and Windows 2K3.
> select convert(varbinary, big5col)
> It is found that the binary is the same.
> I have found out that if you add the following in the heading of the
> page,
> this page can show the big-5 character.
><%@. codepage=950 %>
>
> As the string stored in database is in unicode format, if you set the
> codepage as big-5 format, the data will be changed as big-5 and show in
> the webpage.
>
> Thank you for your great sugegstion

I'm glad to have been to help about something I hardly know at all!

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

How to setup Sharepoint Portal Server 2003 with SQL Sever 2005

Hello, everyone

I try to set up Sharepoint Portal Server 2003 in SQL Server 2005 database (on Windows 2003 Server R2). But It cannot create new portal site... the Error message told about "cannot access instance..." (in fact that I input the correct instance, user, and password)...? I wanna know that How to setup it...

Setapong

? Hi, Read the topic Deploying Reporting Services and Windows SharePoint Services Side-by-Side in Books Online. Andrew Watt [MVP] <Setapong@.discussions.microsoft.com> wrote in message news:7f684d78-a79f-4004-8611-cc687d9cff43@.discussions.microsoft.com... Hello, everyone I try to set up Sharepoint Portal Server 2003 in SQL Server 2005 database (on Windows 2003 Server R2). But It cannot create new portal site... the Error message told about "cannot access instance..." (in fact that I input the correct instance, user, and password)...? I wanna know that How to setup it... Setapong

How to Setup Merge replication with sql express

I have a Windows Mobile aplication that uses merge replication to synchronize between sql compact and full sql Enterprise edition and It works great. Instantiating the SqlCeReplication object setting it's properties and calling Synchronize on it is pretty simple assuming everything is setup properly at the publisher.

For the life of me I can't figure out how to do this on the desktop (Programatically setup a subscription and create a database using objects in the System.Replication Namespace and hopefully call Synchronize on it).

Someone please point me in the right direction.

Thanks,

Patrick

See topic "Programming with Replication Management Objects", http://msdn2.microsoft.com/en-us/library/ms146869(SQL.90).aspx.

|||

Look at the MergeSynchronizationAgent class.

Here is some sample code in C#:

Code Snippet

_mergeAgent = newMergeSynchronizationAgent();

_mergeAgent.Publication = _publication;

_mergeAgent.Publisher = _publisher;

_mergeAgent.PublisherDatabase = _publisherDB;

_mergeAgent.PublisherSecurityMode = SecurityMode.Integrated;

_mergeAgent.Distributor = _distributor;

_mergeAgent.DistributorLogin = _distributorLogin;

_mergeAgent.DistributorPassword = _distributorPassword;

_mergeAgent.DistributorSecurityMode = SecurityMode.Standard;

_mergeAgent.Subscriber = _subscriber;

_mergeAgent.SubscriberDatabase = _subscriberDB;

_mergeAgent.SubscriberLogin = _subscriberLogin;

_mergeAgent.SubscriberPassword = _subscriberPassword;

_mergeAgent.SubscriberSecurityMode = SecurityMode.Standard;

_mergeAgent.SubscriptionType = SubscriptionOption.Pull;

_mergeAgent.LoginTimeout = _LoginTimeOut;

_mergeAgent.QueryTimeout = _QueryTimeOut;

_mergeAgent.Synchronize();

Hope this helps!

How to setup default value using GETDATE?

Hi, All
On Northwind database in SQL Server 2000, I try to setup default value at
table design windows for "OrderDate" using GETDATE(), but it does not work.
How do I use setup GETDATE default value for date type? Thanks

KaiOn Sun, 09 May 2004 03:39:07 GMT, kai wrote:

>Hi, All
> On Northwind database in SQL Server 2000, I try to setup default value at
>table design windows for "OrderDate" using GETDATE(), but it does not work.
>How do I use setup GETDATE default value for date type? Thanks
>Kai

Hi Kai,

ALTER TABLE MyTable
ADD DEFAULT GETDATE() FOR MyColumn
go

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)|||What do you mean exactly by 'it does not work'? Note that the default value
is used only when the column is omitted from the INSERT column list.

To add to Hugo's response, it's a good idea to name constraints explicitly
so that subsequent schema maintenance is easier:

ALTER TABLE MyTable
ADD CONSTRAINT DF_MyTable_MyColumn
DEFAULT GETDATE() FOR MyColumn

--
Hope this helps.

Dan Guzman
SQL Server MVP

"kai" <kailiang@.earthlink.net> wrote in message
news:vJhnc.3578$KE6.2982@.newsread3.news.atl.earthl ink.net...
> Hi, All
> On Northwind database in SQL Server 2000, I try to setup default value
at
> table design windows for "OrderDate" using GETDATE(), but it does not
work.
> How do I use setup GETDATE default value for date type? Thanks
> Kaisql

How to set up security to SQL 2005 Reporting Service?

I have Sql 2005 server (SSAS, SSRS, Database)installed on my workstation running on Windows XP Pro. SP2 for development only. However I need to migrate the reports to a "Production" enviroment next month which is set up with two servers running on Windows 2003 Server, one will serve as Data Server with Sql 2005 server and SSAS installed on it and the other will serve as Report Server with Sql 2005 Reporting Service. My question is how to set up the IIS on the Report Server to allow users from the domain to access the Report Manager (the reporting Service is intend to set up as an "Intranet" tool for the users ie No Internet access to the reports). A "dumpy" user will be set up at the Report Server for the data connection to the remote Sql 2005 Server. Also how to implement the security on the individual folder in the Report Manager. Currently I have folders set up for the department and I want to set up security only allow people from those depts to access their folder/subfolders. How to set up security on folder and subfolders in Report Manager? Can I set the security on my Windows XP machine to test it before I roll it out to the Production servers? Thanks.

here is a microsoft link that talks about role based security in reporting services...

http://msdn2.microsoft.com/en-us/library/ms156014.aspx

hope this helps...good luck!

How to set up Private Network on SQL 2000 EE on Windows 2003

To All Gurus:
I have a question on SQL Server 2000 Network routing Where any help is
appreciated. I would like to know if it is possible for a SQL Server to talk
to another SQL Server using a private network. What I am trying to do is I
have
transactional replcation enabled where I want to use private network
for data transfer between publisher\subscriber\distributor. I have 3
NICs on Each. One is reserved for public routing, second is for backup
routing and the third one can be on private network. How do I
architect this kind of design in my SQL Server shop.
Thanks in advance,
Mark wrote:
> To All Gurus:
> I have a question on SQL Server 2000 Network routing Where any help is
> appreciated. I would like to know if it is possible for a SQL Server to talk
> to another SQL Server using a private network. What I am trying to do is I
> have
> transactional replcation enabled where I want to use private network
> for data transfer between publisher\subscriber\distributor. I have 3
> NICs on Each. One is reserved for public routing, second is for backup
> routing and the third one can be on private network. How do I
> architect this kind of design in my SQL Server shop.
> Thanks in advance,
>
Hi Mark
I'm not sure that I understand what you mean about Private Network, but
nevertheless it shouldn't be a problem to do what you want. You can
access the server either via the IP address or the name, but you just
have to make sure that you have a route to the server. If they are not
on the same subnet, you'll have to have route between the networks in
your DNS.
The easiest place to start, might be to register the server(s) in EM.
When you have that in place, you can also setup the replication.
HTH
Regards
Steen
|||Hi Steve:
Thanks for your response.
I am sorry if I wasn't clear on my explanation. I had few questions in my
mind:
1. If I have 3 Separate NIC Cards on my SQL Server and all of them are
publicly routed with in the LAN, would SQL Server listen to all NICs? Or do I
have to do something special for SQL to listen to all NICs.
2. Do all these NICs have to be on different subnet or can they be on same
subnet?
3. If they are on separate subnet, what do I need to do extra?
4. I dont know how to route between the network in DNS? Can you provide some
more explanation or some white paper link for that.
Thanks in advance.
"Steen Persson (DK)" wrote:

> Mark wrote:
> Hi Mark
> I'm not sure that I understand what you mean about Private Network, but
> nevertheless it shouldn't be a problem to do what you want. You can
> access the server either via the IP address or the name, but you just
> have to make sure that you have a route to the server. If they are not
> on the same subnet, you'll have to have route between the networks in
> your DNS.
> The easiest place to start, might be to register the server(s) in EM.
> When you have that in place, you can also setup the replication.
> HTH
> Regards
> Steen
>
|||Mark wrote:
> Hi Steve:
> Thanks for your response.
> I am sorry if I wasn't clear on my explanation. I had few questions in my
> mind:
> 1. If I have 3 Separate NIC Cards on my SQL Server and all of them are
> publicly routed with in the LAN, would SQL Server listen to all NICs? Or do I
> have to do something special for SQL to listen to all NICs.
> 2. Do all these NICs have to be on different subnet or can they be on same
> subnet?
> 3. If they are on separate subnet, what do I need to do extra?
> 4. I dont know how to route between the network in DNS? Can you provide some
> more explanation or some white paper link for that.
>
1. You should be able to contact the server from all 3 nic's (Have never
tried it myself though...)
2. From a SQL server point of view, they haven't got to be on the same
subnet. They'll just each of them listen to what comes to their IP
address on the specified port. It's then their IP address and subnet
together with your routing schema that determines which clients that can
"talk" to the server.
4. Here you have to talk to your network people or read up on IP
addresses/Subnetmasks and Routing. I haven't got any specific links to
that but I'm sure that a search on google will give you a lot if hits.
This isn't specific to SQL server, so for that it might be the wrong
group. A quick search on google found this one -
http://www.nwc.com/unixworld/tutorial/001.html . It might not be the
best, but it's maybe a start.
Regards
Steen
Regards

How to set up Private Network on SQL 2000 EE on Windows 2003

To All Gurus:
I have a question on SQL Server 2000 Network routing Where any help is
appreciated. I would like to know if it is possible for a SQL Server to talk
to another SQL Server using a private network. What I am trying to do is I
have
transactional replcation enabled where I want to use private network
for data transfer between publisher\subscriber\distributor. I have 3
NICs on Each. One is reserved for public routing, second is for backup
routing and the third one can be on private network. How do I
architect this kind of design in my SQL Server shop.
Thanks in advance,Mark wrote:
> To All Gurus:
> I have a question on SQL Server 2000 Network routing Where any help is
> appreciated. I would like to know if it is possible for a SQL Server to ta
lk
> to another SQL Server using a private network. What I am trying to do is I
> have
> transactional replcation enabled where I want to use private network
> for data transfer between publisher\subscriber\distributor. I have 3
> NICs on Each. One is reserved for public routing, second is for backup
> routing and the third one can be on private network. How do I
> architect this kind of design in my SQL Server shop.
> Thanks in advance,
>
Hi Mark
I'm not sure that I understand what you mean about Private Network, but
nevertheless it shouldn't be a problem to do what you want. You can
access the server either via the IP address or the name, but you just
have to make sure that you have a route to the server. If they are not
on the same subnet, you'll have to have route between the networks in
your DNS.
The easiest place to start, might be to register the server(s) in EM.
When you have that in place, you can also setup the replication.
HTH
Regards
Steen|||Hi Steve:
Thanks for your response.
I am sorry if I wasn't clear on my explanation. I had few questions in my
mind:
1. If I have 3 Separate NIC Cards on my SQL Server and all of them are
publicly routed with in the LAN, would SQL Server listen to all NICs? Or do
I
have to do something special for SQL to listen to all NICs.
2. Do all these NICs have to be on different subnet or can they be on same
subnet?
3. If they are on separate subnet, what do I need to do extra?
4. I dont know how to route between the network in DNS? Can you provide some
more explanation or some white paper link for that.
Thanks in advance.
"Steen Persson (DK)" wrote:

> Mark wrote:
> Hi Mark
> I'm not sure that I understand what you mean about Private Network, but
> nevertheless it shouldn't be a problem to do what you want. You can
> access the server either via the IP address or the name, but you just
> have to make sure that you have a route to the server. If they are not
> on the same subnet, you'll have to have route between the networks in
> your DNS.
> The easiest place to start, might be to register the server(s) in EM.
> When you have that in place, you can also setup the replication.
> HTH
> Regards
> Steen
>|||Mark wrote:
> Hi Steve:
> Thanks for your response.
> I am sorry if I wasn't clear on my explanation. I had few questions in my
> mind:
> 1. If I have 3 Separate NIC Cards on my SQL Server and all of them are
> publicly routed with in the LAN, would SQL Server listen to all NICs? Or d
o I
> have to do something special for SQL to listen to all NICs.
> 2. Do all these NICs have to be on different subnet or can they be on same
> subnet?
> 3. If they are on separate subnet, what do I need to do extra?
> 4. I dont know how to route between the network in DNS? Can you provide so
me
> more explanation or some white paper link for that.
>
1. You should be able to contact the server from all 3 nic's (Have never
tried it myself though...)
2. From a SQL server point of view, they haven't got to be on the same
subnet. They'll just each of them listen to what comes to their IP
address on the specified port. It's then their IP address and subnet
together with your routing schema that determines which clients that can
"talk" to the server.
4. Here you have to talk to your network people or read up on IP
addresses/Subnetmasks and Routing. I haven't got any specific links to
that but I'm sure that a search on google will give you a lot if hits.
This isn't specific to SQL server, so for that it might be the wrong
group. A quick search on google found this one -
http://www.nwc.com/unixworld/tutorial/001.html . It might not be the
best, but it's maybe a start.
Regards
Steen
Regards

How to set up Private Network on SQL 2000 EE on Windows 2003

To All Gurus:
I have a question on SQL Server 2000 Network routing Where any help is
appreciated. I would like to know if it is possible for a SQL Server to talk
to another SQL Server using a private network. What I am trying to do is I
have
transactional replcation enabled where I want to use private network
for data transfer between publisher\subscriber\distributor. I have 3
NICs on Each. One is reserved for public routing, second is for backup
routing and the third one can be on private network. How do I
architect this kind of design in my SQL Server shop.
Thanks in advance,Mark wrote:
> To All Gurus:
> I have a question on SQL Server 2000 Network routing Where any help is
> appreciated. I would like to know if it is possible for a SQL Server to talk
> to another SQL Server using a private network. What I am trying to do is I
> have
> transactional replcation enabled where I want to use private network
> for data transfer between publisher\subscriber\distributor. I have 3
> NICs on Each. One is reserved for public routing, second is for backup
> routing and the third one can be on private network. How do I
> architect this kind of design in my SQL Server shop.
> Thanks in advance,
>
Hi Mark
I'm not sure that I understand what you mean about Private Network, but
nevertheless it shouldn't be a problem to do what you want. You can
access the server either via the IP address or the name, but you just
have to make sure that you have a route to the server. If they are not
on the same subnet, you'll have to have route between the networks in
your DNS.
The easiest place to start, might be to register the server(s) in EM.
When you have that in place, you can also setup the replication.
HTH
Regards
Steen|||Hi Steve:
Thanks for your response.
I am sorry if I wasn't clear on my explanation. I had few questions in my
mind:
1. If I have 3 Separate NIC Cards on my SQL Server and all of them are
publicly routed with in the LAN, would SQL Server listen to all NICs? Or do I
have to do something special for SQL to listen to all NICs.
2. Do all these NICs have to be on different subnet or can they be on same
subnet?
3. If they are on separate subnet, what do I need to do extra?
4. I dont know how to route between the network in DNS? Can you provide some
more explanation or some white paper link for that.
Thanks in advance.
"Steen Persson (DK)" wrote:
> Mark wrote:
> > To All Gurus:
> >
> > I have a question on SQL Server 2000 Network routing Where any help is
> > appreciated. I would like to know if it is possible for a SQL Server to talk
> > to another SQL Server using a private network. What I am trying to do is I
> > have
> > transactional replcation enabled where I want to use private network
> > for data transfer between publisher\subscriber\distributor. I have 3
> > NICs on Each. One is reserved for public routing, second is for backup
> > routing and the third one can be on private network. How do I
> > architect this kind of design in my SQL Server shop.
> >
> > Thanks in advance,
> >
> Hi Mark
> I'm not sure that I understand what you mean about Private Network, but
> nevertheless it shouldn't be a problem to do what you want. You can
> access the server either via the IP address or the name, but you just
> have to make sure that you have a route to the server. If they are not
> on the same subnet, you'll have to have route between the networks in
> your DNS.
> The easiest place to start, might be to register the server(s) in EM.
> When you have that in place, you can also setup the replication.
> HTH
> Regards
> Steen
>|||Mark wrote:
> Hi Steve:
> Thanks for your response.
> I am sorry if I wasn't clear on my explanation. I had few questions in my
> mind:
> 1. If I have 3 Separate NIC Cards on my SQL Server and all of them are
> publicly routed with in the LAN, would SQL Server listen to all NICs? Or do I
> have to do something special for SQL to listen to all NICs.
> 2. Do all these NICs have to be on different subnet or can they be on same
> subnet?
> 3. If they are on separate subnet, what do I need to do extra?
> 4. I dont know how to route between the network in DNS? Can you provide some
> more explanation or some white paper link for that.
>
1. You should be able to contact the server from all 3 nic's (Have never
tried it myself though...)
2. From a SQL server point of view, they haven't got to be on the same
subnet. They'll just each of them listen to what comes to their IP
address on the specified port. It's then their IP address and subnet
together with your routing schema that determines which clients that can
"talk" to the server.
4. Here you have to talk to your network people or read up on IP
addresses/Subnetmasks and Routing. I haven't got any specific links to
that but I'm sure that a search on google will give you a lot if hits.
This isn't specific to SQL server, so for that it might be the wrong
group. A quick search on google found this one -
http://www.nwc.com/unixworld/tutorial/001.html . It might not be the
best, but it's maybe a start.
Regards
Steen
Regards

How to set up a report when a specific user makes changes to a database

Hi,
We just recently upgraded from SQL 2000 to SQL 2005 running on a Windows
2003 R2 SP2 server.
I successfully created a mailbox for SQL to use and associated the SQL Agent
to use this e-mail when sending out alerts.
I am however not able to find a way for an e-mail to be sent if a specific
user makes a change to a database.
Can somebody please point me in the right direction.
Thank you,
WarrenCan you explain exactly what you mean by "makes a change to the database"? ALTER TABLE? UPDATE?
Something else? Triggers and possibly event notifications seems to be what you want to look into.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
news:O2KVocZ4GHA.508@.TK2MSFTNGP06.phx.gbl...
> Hi,
> We just recently upgraded from SQL 2000 to SQL 2005 running on a Windows 2003 R2 SP2 server.
> I successfully created a mailbox for SQL to use and associated the SQL Agent to use this e-mail
> when sending out alerts.
> I am however not able to find a way for an e-mail to be sent if a specific user makes a change to
> a database.
> Can somebody please point me in the right direction.
> Thank you,
> Warren
>|||Basically anything that would be considered a change to the database for
auditing purposes.
Can you lead me in the right direction on setting up triggers or event
notifications? I am new to SQL 2005.
Thank you,
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ujWBChZ4GHA.1496@.TK2MSFTNGP05.phx.gbl...
> Can you explain exactly what you mean by "makes a change to the database"?
> ALTER TABLE? UPDATE? Something else? Triggers and possibly event
> notifications seems to be what you want to look into.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
> news:O2KVocZ4GHA.508@.TK2MSFTNGP06.phx.gbl...
>> Hi,
>> We just recently upgraded from SQL 2000 to SQL 2005 running on a Windows
>> 2003 R2 SP2 server.
>> I successfully created a mailbox for SQL to use and associated the SQL
>> Agent to use this e-mail when sending out alerts.
>> I am however not able to find a way for an e-mail to be sent if a
>> specific user makes a change to a database.
>> Can somebody please point me in the right direction.
>> Thank you,
>> Warren
>>
>|||> Basically anything that would be considered a change to the database for auditing purposes.
Wow. Are you willing to pay the performance penalty for this?
Your best bet is probably to use some of the products out there. They use a combination of
server-side Profiler traces along with reading the transaction log (something which we cannot do
ourselves) so performance impact would be less than if doing it ourselves. Not to mention the dev
time of doing it yourself.
Here's one: http://www.lumigent.com/products/auditdb.html
Some of the other log reader tools vendors might also have such products, I've listed the ones I
know of on my links page: http://www.karaszi.com/SQLServer/links.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
news:Ox6dFSj4GHA.3736@.TK2MSFTNGP02.phx.gbl...
> Basically anything that would be considered a change to the database for auditing purposes.
> Can you lead me in the right direction on setting up triggers or event notifications? I am new to
> SQL 2005.
> Thank you,
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:ujWBChZ4GHA.1496@.TK2MSFTNGP05.phx.gbl...
>> Can you explain exactly what you mean by "makes a change to the database"? ALTER TABLE? UPDATE?
>> Something else? Triggers and possibly event notifications seems to be what you want to look into.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
>> news:O2KVocZ4GHA.508@.TK2MSFTNGP06.phx.gbl...
>> Hi,
>> We just recently upgraded from SQL 2000 to SQL 2005 running on a Windows 2003 R2 SP2 server.
>> I successfully created a mailbox for SQL to use and associated the SQL Agent to use this e-mail
>> when sending out alerts.
>> I am however not able to find a way for an e-mail to be sent if a specific user makes a change
>> to a database.
>> Can somebody please point me in the right direction.
>> Thank you,
>> Warren
>>
>|||Maybe I should refrase that a little bit.
Basically I need to have some type of checks and balances setup where an
alert is sent when the dba does something to a database or makes changes.
In the configuration we are using the dba may connect to the SQL server once
a quarter if that.
Warren
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtG$wOt4GHA.3376@.TK2MSFTNGP05.phx.gbl...
>> Basically anything that would be considered a change to the database for
>> auditing purposes.
> Wow. Are you willing to pay the performance penalty for this?
> Your best bet is probably to use some of the products out there. They use
> a combination of server-side Profiler traces along with reading the
> transaction log (something which we cannot do ourselves) so performance
> impact would be less than if doing it ourselves. Not to mention the dev
> time of doing it yourself.
> Here's one: http://www.lumigent.com/products/auditdb.html
> Some of the other log reader tools vendors might also have such products,
> I've listed the ones I know of on my links page:
> http://www.karaszi.com/SQLServer/links.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
> news:Ox6dFSj4GHA.3736@.TK2MSFTNGP02.phx.gbl...
>> Basically anything that would be considered a change to the database for
>> auditing purposes.
>> Can you lead me in the right direction on setting up triggers or event
>> notifications? I am new to SQL 2005.
>> Thank you,
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:ujWBChZ4GHA.1496@.TK2MSFTNGP05.phx.gbl...
>> Can you explain exactly what you mean by "makes a change to the
>> database"? ALTER TABLE? UPDATE? Something else? Triggers and possibly
>> event notifications seems to be what you want to look into.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
>> news:O2KVocZ4GHA.508@.TK2MSFTNGP06.phx.gbl...
>> Hi,
>> We just recently upgraded from SQL 2000 to SQL 2005 running on a
>> Windows 2003 R2 SP2 server.
>> I successfully created a mailbox for SQL to use and associated the SQL
>> Agent to use this e-mail when sending out alerts.
>> I am however not able to find a way for an e-mail to be sent if a
>> specific user makes a change to a database.
>> Can somebody please point me in the right direction.
>> Thank you,
>> Warren
>>
>>
>|||Did you look at the product?
There's no pre-packaged solution for this. You need to determine exactly what type of changes you
want to be alerted for. Based on that decide whether you find a product that suit your need or if
you want to do it yourself. Depending on what type of changes you want to be alerted for, event
notification can be an option. See Books Online, CREATE EVENT NOTIFICATION.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
news:ONw1e1w4GHA.4352@.TK2MSFTNGP03.phx.gbl...
> Maybe I should refrase that a little bit.
> Basically I need to have some type of checks and balances setup where an alert is sent when the
> dba does something to a database or makes changes.
> In the configuration we are using the dba may connect to the SQL server once a quarter if that.
> Warren
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:OtG$wOt4GHA.3376@.TK2MSFTNGP05.phx.gbl...
>> Basically anything that would be considered a change to the database for auditing purposes.
>> Wow. Are you willing to pay the performance penalty for this?
>> Your best bet is probably to use some of the products out there. They use a combination of
>> server-side Profiler traces along with reading the transaction log (something which we cannot do
>> ourselves) so performance impact would be less than if doing it ourselves. Not to mention the dev
>> time of doing it yourself.
>> Here's one: http://www.lumigent.com/products/auditdb.html
>> Some of the other log reader tools vendors might also have such products, I've listed the ones I
>> know of on my links page: http://www.karaszi.com/SQLServer/links.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
>> news:Ox6dFSj4GHA.3736@.TK2MSFTNGP02.phx.gbl...
>> Basically anything that would be considered a change to the database for auditing purposes.
>> Can you lead me in the right direction on setting up triggers or event notifications? I am new
>> to SQL 2005.
>> Thank you,
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
>> news:ujWBChZ4GHA.1496@.TK2MSFTNGP05.phx.gbl...
>> Can you explain exactly what you mean by "makes a change to the database"? ALTER TABLE? UPDATE?
>> Something else? Triggers and possibly event notifications seems to be what you want to look
>> into.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
>> news:O2KVocZ4GHA.508@.TK2MSFTNGP06.phx.gbl...
>> Hi,
>> We just recently upgraded from SQL 2000 to SQL 2005 running on a Windows 2003 R2 SP2 server.
>> I successfully created a mailbox for SQL to use and associated the SQL Agent to use this
>> e-mail when sending out alerts.
>> I am however not able to find a way for an e-mail to be sent if a specific user makes a change
>> to a database.
>> Can somebody please point me in the right direction.
>> Thank you,
>> Warren
>>
>>
>>
>|||Okay,
Maybe I really just need the basic and I can't figure out how to make it
work. Books on line wasn't very helpful.
Is there a white paper on setting up user auditing for just logging on?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eoaft5w4GHA.2596@.TK2MSFTNGP06.phx.gbl...
> Did you look at the product?
> There's no pre-packaged solution for this. You need to determine exactly
> what type of changes you want to be alerted for. Based on that decide
> whether you find a product that suit your need or if you want to do it
> yourself. Depending on what type of changes you want to be alerted for,
> event notification can be an option. See Books Online, CREATE EVENT
> NOTIFICATION.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
> news:ONw1e1w4GHA.4352@.TK2MSFTNGP03.phx.gbl...
>> Maybe I should refrase that a little bit.
>> Basically I need to have some type of checks and balances setup where an
>> alert is sent when the dba does something to a database or makes changes.
>> In the configuration we are using the dba may connect to the SQL server
>> once a quarter if that.
>> Warren
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:OtG$wOt4GHA.3376@.TK2MSFTNGP05.phx.gbl...
>> Basically anything that would be considered a change to the database
>> for auditing purposes.
>> Wow. Are you willing to pay the performance penalty for this?
>> Your best bet is probably to use some of the products out there. They
>> use a combination of server-side Profiler traces along with reading the
>> transaction log (something which we cannot do ourselves) so performance
>> impact would be less than if doing it ourselves. Not to mention the dev
>> time of doing it yourself.
>> Here's one: http://www.lumigent.com/products/auditdb.html
>> Some of the other log reader tools vendors might also have such
>> products, I've listed the ones I know of on my links page:
>> http://www.karaszi.com/SQLServer/links.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
>> news:Ox6dFSj4GHA.3736@.TK2MSFTNGP02.phx.gbl...
>> Basically anything that would be considered a change to the database
>> for auditing purposes.
>> Can you lead me in the right direction on setting up triggers or event
>> notifications? I am new to SQL 2005.
>> Thank you,
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
>> wrote in message news:ujWBChZ4GHA.1496@.TK2MSFTNGP05.phx.gbl...
>> Can you explain exactly what you mean by "makes a change to the
>> database"? ALTER TABLE? UPDATE? Something else? Triggers and possibly
>> event notifications seems to be what you want to look into.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
>> news:O2KVocZ4GHA.508@.TK2MSFTNGP06.phx.gbl...
>> Hi,
>> We just recently upgraded from SQL 2000 to SQL 2005 running on a
>> Windows 2003 R2 SP2 server.
>> I successfully created a mailbox for SQL to use and associated the
>> SQL Agent to use this e-mail when sending out alerts.
>> I am however not able to find a way for an e-mail to be sent if a
>> specific user makes a change to a database.
>> Can somebody please point me in the right direction.
>> Thank you,
>> Warren
>>
>>
>>
>>
>|||> Is there a white paper on setting up user auditing for just logging on?
Only login events. That makes it a very special case, and you can do that with a few clicks. SSMS,
Right-click the server in Object Explorer, Properties, the security window.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
news:%23OOnP485GHA.512@.TK2MSFTNGP06.phx.gbl...
> Okay,
> Maybe I really just need the basic and I can't figure out how to make it work. Books on line
> wasn't very helpful.
> Is there a white paper on setting up user auditing for just logging on?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:eoaft5w4GHA.2596@.TK2MSFTNGP06.phx.gbl...
>> Did you look at the product?
>> There's no pre-packaged solution for this. You need to determine exactly what type of changes you
>> want to be alerted for. Based on that decide whether you find a product that suit your need or if
>> you want to do it yourself. Depending on what type of changes you want to be alerted for, event
>> notification can be an option. See Books Online, CREATE EVENT NOTIFICATION.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
>> news:ONw1e1w4GHA.4352@.TK2MSFTNGP03.phx.gbl...
>> Maybe I should refrase that a little bit.
>> Basically I need to have some type of checks and balances setup where an alert is sent when the
>> dba does something to a database or makes changes.
>> In the configuration we are using the dba may connect to the SQL server once a quarter if that.
>> Warren
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
>> news:OtG$wOt4GHA.3376@.TK2MSFTNGP05.phx.gbl...
>> Basically anything that would be considered a change to the database for auditing purposes.
>> Wow. Are you willing to pay the performance penalty for this?
>> Your best bet is probably to use some of the products out there. They use a combination of
>> server-side Profiler traces along with reading the transaction log (something which we cannot
>> do ourselves) so performance impact would be less than if doing it ourselves. Not to mention
>> the dev time of doing it yourself.
>> Here's one: http://www.lumigent.com/products/auditdb.html
>> Some of the other log reader tools vendors might also have such products, I've listed the ones
>> I know of on my links page: http://www.karaszi.com/SQLServer/links.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
>> news:Ox6dFSj4GHA.3736@.TK2MSFTNGP02.phx.gbl...
>> Basically anything that would be considered a change to the database for auditing purposes.
>> Can you lead me in the right direction on setting up triggers or event notifications? I am
>> new to SQL 2005.
>> Thank you,
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
>> news:ujWBChZ4GHA.1496@.TK2MSFTNGP05.phx.gbl...
>> Can you explain exactly what you mean by "makes a change to the database"? ALTER TABLE?
>> UPDATE? Something else? Triggers and possibly event notifications seems to be what you want
>> to look into.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Warren Hollinshead" <whollinshead@.insmed.com> wrote in message
>> news:O2KVocZ4GHA.508@.TK2MSFTNGP06.phx.gbl...
>>> Hi,
>>> We just recently upgraded from SQL 2000 to SQL 2005 running on a Windows 2003 R2 SP2 server.
>>> I successfully created a mailbox for SQL to use and associated the SQL Agent to use this
>>> e-mail when sending out alerts.
>>> I am however not able to find a way for an e-mail to be sent if a specific user makes a
>>> change to a database.
>>> Can somebody please point me in the right direction.
>>>
>>> Thank you,
>>> Warren
>>>
>>>
>>
>>
>>
>

How to set Report manager PDF export timeout?

In the report manager you have the option to export to PDF which pops up a
windows that has a timeout encoded into the URL that generates the PDF. The
URL generated looks like:
http://localhost/Reports/Reserved.ReportViewerWebControl.axd?Server=http%3a%2f%2flocalhost%2fReportServer&Timeout=100000&ReportSession=ayxrhe45b5gzjh55mcra5o45&ControlID=18a6c1bb-379f-4332-9b44-16aa3eb2468b&OpType=Export&Format=PDF
I'm pretty sure it's this hardcoded value in the URL because when I increase
it; it works. Is there any way to configure this? I searched the web but I
haven't seen this addressed anywhere.
Windows 2003 server -
SQL Server April 2005 CTPAny ideas on this...
Is there no way to increase this timeout? Can Microsoft maybe add a
configuration setting into the 2005 version so this can be set in the config
file? It seems like an easy request since someone hardcoded the default to
100000.
Thanks,
Jeff
"Jeff Glenn" wrote:
> In the report manager you have the option to export to PDF which pops up a
> windows that has a timeout encoded into the URL that generates the PDF. The
> URL generated looks like:
> http://localhost/Reports/Reserved.ReportViewerWebControl.axd?Server=http%3a%2f%2flocalhost%2fReportServer&Timeout=100000&ReportSession=ayxrhe45b5gzjh55mcra5o45&ControlID=18a6c1bb-379f-4332-9b44-16aa3eb2468b&OpType=Export&Format=PDF
> I'm pretty sure it's this hardcoded value in the URL because when I increase
> it; it works. Is there any way to configure this? I searched the web but I
> haven't seen this addressed anywhere.
> Windows 2003 server -
> SQL Server April 2005 CTP

How to Set Max Memory?

I don't have much (if any) experiance running an SQL server. I
currently have Windows SBS2k installed with 2gb of memory for the
system. I would like to install more, but my budget doesn't allow for
it at the moment.
I know there is a way to set the max memory an SQL instance can use,
but I can't find a real step by step instruction.
The server is running SBS 2k3 standard, so its only the SQL desktop
edition.
First thing I need to know is how I know what instance is associated
w/ what PID.
Next, I need some hand holding on what I need to do to set the max
memory.
Any help would be appreciated.
Thanks!You could execute the following statements in Query
Analyzer, osql or whatever you get with that version of SBS:
select serverproperty('ProcessID')
will give you the PID for the instance you are logged into.
sp_configure 'max server memory', 1024
will set the max server memory to 1024 MB (1 GB)
-Sue
On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:

>I don't have much (if any) experiance running an SQL server. I
>currently have Windows SBS2k installed with 2gb of memory for the
>system. I would like to install more, but my budget doesn't allow for
>it at the moment.
>I know there is a way to set the max memory an SQL instance can use,
>but I can't find a real step by step instruction.
>The server is running SBS 2k3 standard, so its only the SQL desktop
>edition.
>First thing I need to know is how I know what instance is associated
>w/ what PID.
>Next, I need some hand holding on what I need to do to set the max
>memory.
>
>Any help would be appreciated.
>Thanks!|||Adding to Sue we can use SP_WHO to find out in detail which user with with
pid and to which database and server instance there is an activity.
"Sue Hoegemeier" wrote:

> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>
>|||On Feb 13, 12:20 am, Sue Hoegemeier <S...@.nomail.please> wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26...@.gmail.com wrote:
>
>
>
>
>
>
>
> - Show quoted text -
well that sounds nice and simple. I"ve gotta make my way to work now
so I"ll try it out in about two hours and keep my fingers crossed.
Thanks for the help.

How to Set Max Memory?

I don't have much (if any) experiance running an SQL server. I
currently have Windows SBS2k installed with 2gb of memory for the
system. I would like to install more, but my budget doesn't allow for
it at the moment.
I know there is a way to set the max memory an SQL instance can use,
but I can't find a real step by step instruction.
The server is running SBS 2k3 standard, so its only the SQL desktop
edition.
First thing I need to know is how I know what instance is associated
w/ what PID.
Next, I need some hand holding on what I need to do to set the max
memory.
Any help would be appreciated.
Thanks!
You could execute the following statements in Query
Analyzer, osql or whatever you get with that version of SBS:
select serverproperty('ProcessID')
will give you the PID for the instance you are logged into.
sp_configure 'max server memory', 1024
will set the max server memory to 1024 MB (1 GB)
-Sue
On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:

>I don't have much (if any) experiance running an SQL server. I
>currently have Windows SBS2k installed with 2gb of memory for the
>system. I would like to install more, but my budget doesn't allow for
>it at the moment.
>I know there is a way to set the max memory an SQL instance can use,
>but I can't find a real step by step instruction.
>The server is running SBS 2k3 standard, so its only the SQL desktop
>edition.
>First thing I need to know is how I know what instance is associated
>w/ what PID.
>Next, I need some hand holding on what I need to do to set the max
>memory.
>
>Any help would be appreciated.
>Thanks!
|||Adding to Sue we can use SP_WHO to find out in detail which user with with
pid and to which database and server instance there is an activity.
"Sue Hoegemeier" wrote:

> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>
>
|||On Feb 13, 12:20 am, Sue Hoegemeier <S...@.nomail.please> wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26...@.gmail.com wrote:
>
>
>
>
> - Show quoted text -
well that sounds nice and simple. I"ve gotta make my way to work now
so I"ll try it out in about two hours and keep my fingers crossed.
Thanks for the help.

How to Set Max Memory?

I don't have much (if any) experiance running an SQL server. I
currently have Windows SBS2k installed with 2gb of memory for the
system. I would like to install more, but my budget doesn't allow for
it at the moment.
I know there is a way to set the max memory an SQL instance can use,
but I can't find a real step by step instruction.
The server is running SBS 2k3 standard, so its only the SQL desktop
edition.
First thing I need to know is how I know what instance is associated
w/ what PID.
Next, I need some hand holding on what I need to do to set the max
memory.
Any help would be appreciated.
Thanks!You could execute the following statements in Query
Analyzer, osql or whatever you get with that version of SBS:
select serverproperty('ProcessID')
will give you the PID for the instance you are logged into.
sp_configure 'max server memory', 1024
will set the max server memory to 1024 MB (1 GB)
-Sue
On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
>I don't have much (if any) experiance running an SQL server. I
>currently have Windows SBS2k installed with 2gb of memory for the
>system. I would like to install more, but my budget doesn't allow for
>it at the moment.
>I know there is a way to set the max memory an SQL instance can use,
>but I can't find a real step by step instruction.
>The server is running SBS 2k3 standard, so its only the SQL desktop
>edition.
>First thing I need to know is how I know what instance is associated
>w/ what PID.
>Next, I need some hand holding on what I need to do to set the max
>memory.
>
>Any help would be appreciated.
>Thanks!|||Adding to Sue we can use SP_WHO to find out in detail which user with with
pid and to which database and server instance there is an activity.
"Sue Hoegemeier" wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26901@.gmail.com wrote:
> >I don't have much (if any) experiance running an SQL server. I
> >currently have Windows SBS2k installed with 2gb of memory for the
> >system. I would like to install more, but my budget doesn't allow for
> >it at the moment.
> >
> >I know there is a way to set the max memory an SQL instance can use,
> >but I can't find a real step by step instruction.
> >
> >The server is running SBS 2k3 standard, so its only the SQL desktop
> >edition.
> >
> >First thing I need to know is how I know what instance is associated
> >w/ what PID.
> >
> >Next, I need some hand holding on what I need to do to set the max
> >memory.
> >
> >
> >Any help would be appreciated.
> >Thanks!
>|||On Feb 13, 12:20 am, Sue Hoegemeier <S...@.nomail.please> wrote:
> You could execute the following statements in Query
> Analyzer, osql or whatever you get with that version of SBS:
> select serverproperty('ProcessID')
> will give you the PID for the instance you are logged into.
> sp_configure 'max server memory', 1024
> will set the max server memory to 1024 MB (1 GB)
> -Sue
> On 12 Feb 2007 20:40:26 -0800, trump26...@.gmail.com wrote:
>
> >I don't have much (if any) experiance running an SQL server. I
> >currently have Windows SBS2k installed with 2gb of memory for the
> >system. I would like to install more, but my budget doesn't allow for
> >it at the moment.
> >I know there is a way to set the max memory an SQL instance can use,
> >but I can't find a real step by step instruction.
> >The server is running SBS 2k3 standard, so its only the SQL desktop
> >edition.
> >First thing I need to know is how I know what instance is associated
> >w/ what PID.
> >Next, I need some hand holding on what I need to do to set the max
> >memory.
> >Any help would be appreciated.
> >Thanks!- Hide quoted text -
> - Show quoted text -
well that sounds nice and simple. I"ve gotta make my way to work now
so I"ll try it out in about two hours and keep my fingers crossed.
Thanks for the help.