Is there any way to write reports for WAP, or other clients'
KKjell,
With RS reports can be generated in HTML. HTML 4.0 is used for uplevel
browsers and HTML3.2 for downlevel browsers. So, for browser-equiped
clients, such smart phones, reports should render just fine. Other formats,
such as cHTML will require writing a custom rendering extension.
Another option is to export the report in XML and apply XSL transformation
using the Data Output tab.
--
Hope this helps.
----
Teo Lachev, 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/
----
"Kjell Brandes" <kjell@.brandes.tv> wrote in message
news:uOjow%23lmEHA.3432@.TK2MSFTNGP14.phx.gbl...
> Is there any way to write reports for WAP, or other clients'
> K
>|||Hi Teo, Thanx for your reply!!
About writing rendering extensions.
Is this something you write about in your book, or do you have some tips on
good sites handeling this matter'
reg.
Kjell
"Teo Lachev" <teo.lachev@.nospam.prologika.com> wrote in message
news:e9SW9PsmEHA.3712@.TK2MSFTNGP15.phx.gbl...
> Kjell,
> With RS reports can be generated in HTML. HTML 4.0 is used for uplevel
> browsers and HTML3.2 for downlevel browsers. So, for browser-equiped
> clients, such smart phones, reports should render just fine. Other
formats,
> such as cHTML will require writing a custom rendering extension.
> Another option is to export the report in XML and apply XSL transformation
> using the Data Output tab.
> --
> Hope this helps.
> ----
> Teo Lachev, 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/
> ----
> "Kjell Brandes" <kjell@.brandes.tv> wrote in message
> news:uOjow%23lmEHA.3432@.TK2MSFTNGP14.phx.gbl...
> > Is there any way to write reports for WAP, or other clients'
> >
> > K
> >
> >
>|||Kjell,
I don't think that the rendering extension interfaces are documented as of
this time. The functionality is there but there is no documentation or
samples to the best of my knowledge. My book doesn't include an example of a
rendering extension.
For more information about this please see the following thread:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=OgC7Pr8eEHA.1604%40TK2MSFTNGP11.phx.gbl&rnum=7&prev=/groups%3Fq%3Drendering%2Bextension%2Bsample%2Bgroup:*.reportingsvcs%26hl%3Den%26lr%3D%26ie%3DUTF-8%26scoring%3Dd%26selm%3DOgC7Pr8eEHA.1604%2540TK2MSFTNGP11.phx.gbl%26rnum%3D7
--
Hope this helps.
----
Teo Lachev, 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/
----
"Kjell Brandes" <kjell@.brandes.tv> wrote in message
news:ePnZPxymEHA.2140@.TK2MSFTNGP11.phx.gbl...
> Hi Teo, Thanx for your reply!!
> About writing rendering extensions.
> Is this something you write about in your book, or do you have some tips
on
> good sites handeling this matter'
> reg.
> Kjell
>
> "Teo Lachev" <teo.lachev@.nospam.prologika.com> wrote in message
> news:e9SW9PsmEHA.3712@.TK2MSFTNGP15.phx.gbl...
> > Kjell,
> >
> > With RS reports can be generated in HTML. HTML 4.0 is used for uplevel
> > browsers and HTML3.2 for downlevel browsers. So, for browser-equiped
> > clients, such smart phones, reports should render just fine. Other
> formats,
> > such as cHTML will require writing a custom rendering extension.
> >
> > Another option is to export the report in XML and apply XSL
transformation
> > using the Data Output tab.
> >
> > --
> > Hope this helps.
> >
> > ----
> > Teo Lachev, 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/
> > ----
> >
> > "Kjell Brandes" <kjell@.brandes.tv> wrote in message
> > news:uOjow%23lmEHA.3432@.TK2MSFTNGP14.phx.gbl...
> > > Is there any way to write reports for WAP, or other clients'
> > >
> > > K
> > >
> > >
> >
> >
>
Showing posts with label clients. Show all posts
Showing posts with label clients. Show all posts
Friday, February 24, 2012
clients sometimes get locked and can't write
I have an SQL 2000 back end. We have a couple of databases with about 12-20
tables a piece. About once or twice a month there are times for up to an
hour or so where no one can write from any of the front end applications to
the SQL 2000 back end. Each application gives their own error which all are
basically a time out waiting to write. Often times the system will just
start working again on its own.
When this happens the first thing we check in the Enterprise Manager is for
any locks and there are none. We then check to see if one of the other
applications like Access 2003, Labview or others can write to the database
and we see they cannot. Next we see if we can open the table on the SQL
server and edit or append and we CAN from the Enterprise Manager?
Thinking that there might be someone locking a record or a page we kick
everyone out and just let one person (sometimes myself as an admin) try to
work and they cannot. We then restart the SQL server and the workstations
and have someone try again and they still fail.
The only thing that I have seen help get it out of this state is when I go
to my daily maintenance jobs and run both my integrity check and my
optimization plan. The Integrety Check plan was done with the wizard and
it:
1. Checks the integrity of all user database
2. Includes indexes
3. Attempts to repair minor problems.
4. Run every day at 12:00 AM
The Optimization plan is set to:
1. Reorganize Data and Index Pages
2. Change free space to 10%
3. Run every day at 1:30 AM
Finally, when I look in the Event Viewer logs for anything strange I really
do not see anything in the app, security, or system logs anywhere near the
time of the start of the errors.
Sounds like the SQL Server Agents for the SQL Server instances aren't
running sometimes. Goto start->administrative tools->services and
look for the SQL Server Agent (your server instance name) entries and
see their status. Should be in "Started" state. If not started,
click on the entry and click start in top left corner of pane.
SQL Server Agents are the programs that act as proxies to enable
remote access to a SQL server instance. If they are not running,
nobody will be able to gain access to the server, and will receive
time out errors instead.
Some programs, such as backups, may stop the agents so they can take a
snapshot of the database. These programs should start the agents as
soon as they are done. If you find the agents in a stopped state in
the next outage, you should try to trace down what program was
executing at the time they were stopped, and check if that program is
configured properly.
|||I don't think it is the agent because the users are able to read the data
remotely. Also, the only maintenance that is done is done at 1-3 AM. This
problem happens randomly mid day.
"Andy" <anedza@.infotek-consulting.com> wrote in message
news:e1159a72-4a2a-449d-a8d7-d22be76d6595@.q78g2000hsh.googlegroups.com...
> Sounds like the SQL Server Agents for the SQL Server instances aren't
> running sometimes. Goto start->administrative tools->services and
> look for the SQL Server Agent (your server instance name) entries and
> see their status. Should be in "Started" state. If not started,
> click on the entry and click start in top left corner of pane.
> SQL Server Agents are the programs that act as proxies to enable
> remote access to a SQL server instance. If they are not running,
> nobody will be able to gain access to the server, and will receive
> time out errors instead.
> Some programs, such as backups, may stop the agents so they can take a
> snapshot of the database. These programs should start the agents as
> soon as they are done. If you find the agents in a stopped state in
> the next outage, you should try to trace down what program was
> executing at the time they were stopped, and check if that program is
> configured properly.
>
>
>
tables a piece. About once or twice a month there are times for up to an
hour or so where no one can write from any of the front end applications to
the SQL 2000 back end. Each application gives their own error which all are
basically a time out waiting to write. Often times the system will just
start working again on its own.
When this happens the first thing we check in the Enterprise Manager is for
any locks and there are none. We then check to see if one of the other
applications like Access 2003, Labview or others can write to the database
and we see they cannot. Next we see if we can open the table on the SQL
server and edit or append and we CAN from the Enterprise Manager?
Thinking that there might be someone locking a record or a page we kick
everyone out and just let one person (sometimes myself as an admin) try to
work and they cannot. We then restart the SQL server and the workstations
and have someone try again and they still fail.
The only thing that I have seen help get it out of this state is when I go
to my daily maintenance jobs and run both my integrity check and my
optimization plan. The Integrety Check plan was done with the wizard and
it:
1. Checks the integrity of all user database
2. Includes indexes
3. Attempts to repair minor problems.
4. Run every day at 12:00 AM
The Optimization plan is set to:
1. Reorganize Data and Index Pages
2. Change free space to 10%
3. Run every day at 1:30 AM
Finally, when I look in the Event Viewer logs for anything strange I really
do not see anything in the app, security, or system logs anywhere near the
time of the start of the errors.
Sounds like the SQL Server Agents for the SQL Server instances aren't
running sometimes. Goto start->administrative tools->services and
look for the SQL Server Agent (your server instance name) entries and
see their status. Should be in "Started" state. If not started,
click on the entry and click start in top left corner of pane.
SQL Server Agents are the programs that act as proxies to enable
remote access to a SQL server instance. If they are not running,
nobody will be able to gain access to the server, and will receive
time out errors instead.
Some programs, such as backups, may stop the agents so they can take a
snapshot of the database. These programs should start the agents as
soon as they are done. If you find the agents in a stopped state in
the next outage, you should try to trace down what program was
executing at the time they were stopped, and check if that program is
configured properly.
|||I don't think it is the agent because the users are able to read the data
remotely. Also, the only maintenance that is done is done at 1-3 AM. This
problem happens randomly mid day.
"Andy" <anedza@.infotek-consulting.com> wrote in message
news:e1159a72-4a2a-449d-a8d7-d22be76d6595@.q78g2000hsh.googlegroups.com...
> Sounds like the SQL Server Agents for the SQL Server instances aren't
> running sometimes. Goto start->administrative tools->services and
> look for the SQL Server Agent (your server instance name) entries and
> see their status. Should be in "Started" state. If not started,
> click on the entry and click start in top left corner of pane.
> SQL Server Agents are the programs that act as proxies to enable
> remote access to a SQL server instance. If they are not running,
> nobody will be able to gain access to the server, and will receive
> time out errors instead.
> Some programs, such as backups, may stop the agents so they can take a
> snapshot of the database. These programs should start the agents as
> soon as they are done. If you find the agents in a stopped state in
> the next outage, you should try to trace down what program was
> executing at the time they were stopped, and check if that program is
> configured properly.
>
>
>
clients sometimes get locked and can't write
I have an SQL 2000 back end. We have a couple of databases with about 12-20
tables a piece. About once or twice a month there are times for up to an
hour or so where no one can write from any of the front end applications to
the SQL 2000 back end. Each application gives their own error which all are
basically a time out waiting to write. Often times the system will just
start working again on its own.
When this happens the first thing we check in the Enterprise Manager is for
any locks and there are none. We then check to see if one of the other
applications like Access 2003, Labview or others can write to the database
and we see they cannot. Next we see if we can open the table on the SQL
server and edit or append and we CAN from the Enterprise Manager'
Thinking that there might be someone locking a record or a page we kick
everyone out and just let one person (sometimes myself as an admin) try to
work and they cannot. We then restart the SQL server and the workstations
and have someone try again and they still fail.
The only thing that I have seen help get it out of this state is when I go
to my daily maintenance jobs and run both my integrity check and my
optimization plan. The Integrety Check plan was done with the wizard and
it:
1. Checks the integrity of all user database
2. Includes indexes
3. Attempts to repair minor problems.
4. Run every day at 12:00 AM
The Optimization plan is set to:
1. Reorganize Data and Index Pages
2. Change free space to 10%
3. Run every day at 1:30 AM
Finally, when I look in the Event Viewer logs for anything strange I really
do not see anything in the app, security, or system logs anywhere near the
time of the start of the errors.Sounds like the SQL Server Agents for the SQL Server instances aren't
running sometimes. Goto start->administrative tools->services and
look for the SQL Server Agent (your server instance name) entries and
see their status. Should be in "Started" state. If not started,
click on the entry and click start in top left corner of pane.
SQL Server Agents are the programs that act as proxies to enable
remote access to a SQL server instance. If they are not running,
nobody will be able to gain access to the server, and will receive
time out errors instead.
Some programs, such as backups, may stop the agents so they can take a
snapshot of the database. These programs should start the agents as
soon as they are done. If you find the agents in a stopped state in
the next outage, you should try to trace down what program was
executing at the time they were stopped, and check if that program is
configured properly.|||I don't think it is the agent because the users are able to read the data
remotely. Also, the only maintenance that is done is done at 1-3 AM. This
problem happens randomly mid day.
"Andy" <anedza@.infotek-consulting.com> wrote in message
news:e1159a72-4a2a-449d-a8d7-d22be76d6595@.q78g2000hsh.googlegroups.com...
> Sounds like the SQL Server Agents for the SQL Server instances aren't
> running sometimes. Goto start->administrative tools->services and
> look for the SQL Server Agent (your server instance name) entries and
> see their status. Should be in "Started" state. If not started,
> click on the entry and click start in top left corner of pane.
> SQL Server Agents are the programs that act as proxies to enable
> remote access to a SQL server instance. If they are not running,
> nobody will be able to gain access to the server, and will receive
> time out errors instead.
> Some programs, such as backups, may stop the agents so they can take a
> snapshot of the database. These programs should start the agents as
> soon as they are done. If you find the agents in a stopped state in
> the next outage, you should try to trace down what program was
> executing at the time they were stopped, and check if that program is
> configured properly.
>
>
>
tables a piece. About once or twice a month there are times for up to an
hour or so where no one can write from any of the front end applications to
the SQL 2000 back end. Each application gives their own error which all are
basically a time out waiting to write. Often times the system will just
start working again on its own.
When this happens the first thing we check in the Enterprise Manager is for
any locks and there are none. We then check to see if one of the other
applications like Access 2003, Labview or others can write to the database
and we see they cannot. Next we see if we can open the table on the SQL
server and edit or append and we CAN from the Enterprise Manager'
Thinking that there might be someone locking a record or a page we kick
everyone out and just let one person (sometimes myself as an admin) try to
work and they cannot. We then restart the SQL server and the workstations
and have someone try again and they still fail.
The only thing that I have seen help get it out of this state is when I go
to my daily maintenance jobs and run both my integrity check and my
optimization plan. The Integrety Check plan was done with the wizard and
it:
1. Checks the integrity of all user database
2. Includes indexes
3. Attempts to repair minor problems.
4. Run every day at 12:00 AM
The Optimization plan is set to:
1. Reorganize Data and Index Pages
2. Change free space to 10%
3. Run every day at 1:30 AM
Finally, when I look in the Event Viewer logs for anything strange I really
do not see anything in the app, security, or system logs anywhere near the
time of the start of the errors.Sounds like the SQL Server Agents for the SQL Server instances aren't
running sometimes. Goto start->administrative tools->services and
look for the SQL Server Agent (your server instance name) entries and
see their status. Should be in "Started" state. If not started,
click on the entry and click start in top left corner of pane.
SQL Server Agents are the programs that act as proxies to enable
remote access to a SQL server instance. If they are not running,
nobody will be able to gain access to the server, and will receive
time out errors instead.
Some programs, such as backups, may stop the agents so they can take a
snapshot of the database. These programs should start the agents as
soon as they are done. If you find the agents in a stopped state in
the next outage, you should try to trace down what program was
executing at the time they were stopped, and check if that program is
configured properly.|||I don't think it is the agent because the users are able to read the data
remotely. Also, the only maintenance that is done is done at 1-3 AM. This
problem happens randomly mid day.
"Andy" <anedza@.infotek-consulting.com> wrote in message
news:e1159a72-4a2a-449d-a8d7-d22be76d6595@.q78g2000hsh.googlegroups.com...
> Sounds like the SQL Server Agents for the SQL Server instances aren't
> running sometimes. Goto start->administrative tools->services and
> look for the SQL Server Agent (your server instance name) entries and
> see their status. Should be in "Started" state. If not started,
> click on the entry and click start in top left corner of pane.
> SQL Server Agents are the programs that act as proxies to enable
> remote access to a SQL server instance. If they are not running,
> nobody will be able to gain access to the server, and will receive
> time out errors instead.
> Some programs, such as backups, may stop the agents so they can take a
> snapshot of the database. These programs should start the agents as
> soon as they are done. If you find the agents in a stopped state in
> the next outage, you should try to trace down what program was
> executing at the time they were stopped, and check if that program is
> configured properly.
>
>
>
Clients not installing
Getting this error...
SMS Client Configuration Manager cannot connect to the machine
"ComputerName". The operating system reported error 1314: A required
privilege is not held by the client.
Possible cause: The client is not accessible.
Solution: Verify that the client is connected to the network and that the
SMS Service account or (if specified) the SMS Client Remote Installation
account have the required privileges, as specified in the SMS documentation.
Does the account I specified in Connection Accounts need to have local admin
perms? How can I double check?
Jason
Crap wrong group...sorry.
"JasonMeyer" <jason.meyer@.nospam.isd623.org> wrote in message
news:euwoiFFPFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Getting this error...
> SMS Client Configuration Manager cannot connect to the machine
> "ComputerName". The operating system reported error 1314: A required
> privilege is not held by the client.
> Possible cause: The client is not accessible.
> Solution: Verify that the client is connected to the network and that the
> SMS Service account or (if specified) the SMS Client Remote Installation
> account have the required privileges, as specified in the SMS
> documentation.
> Does the account I specified in Connection Accounts need to have local
> admin perms? How can I double check?
> Jason
>
SMS Client Configuration Manager cannot connect to the machine
"ComputerName". The operating system reported error 1314: A required
privilege is not held by the client.
Possible cause: The client is not accessible.
Solution: Verify that the client is connected to the network and that the
SMS Service account or (if specified) the SMS Client Remote Installation
account have the required privileges, as specified in the SMS documentation.
Does the account I specified in Connection Accounts need to have local admin
perms? How can I double check?
Jason
Crap wrong group...sorry.
"JasonMeyer" <jason.meyer@.nospam.isd623.org> wrote in message
news:euwoiFFPFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Getting this error...
> SMS Client Configuration Manager cannot connect to the machine
> "ComputerName". The operating system reported error 1314: A required
> privilege is not held by the client.
> Possible cause: The client is not accessible.
> Solution: Verify that the client is connected to the network and that the
> SMS Service account or (if specified) the SMS Client Remote Installation
> account have the required privileges, as specified in the SMS
> documentation.
> Does the account I specified in Connection Accounts need to have local
> admin perms? How can I double check?
> Jason
>
Clients in different domains
I have situation like this:
Company with one head office and one remote office. In the two offices I have two domains with two PDCs. The two networks are connected with eachother through leased line and the routers are configured properly. The SQL Server is on the PDC in head office and "local" clients connect fine. I cannot connect from the remote office. I think that I have folowing solutions:
1. make trust relationships between two domains - it will be hard a little bit because second PDC is samba on linux
2. make all clients in remote office to be members of the head office domain - potential problems if the leased line drops
3. make all clients to log in with same account as SQL Server logs locally - stupid
4. something else - what?
Thanks in advance!
DanielSql authentication is designed for such cases as this.
http://msdn.microsoft.com/library/en-us/architec/8_ar_cs_79kj.asp|||I am with SQL Server authentication and despite of this I cannot connect from some computers...|||Take a look at the following kb and make sure the firewall is setup correctly.
http://support.microsoft.com/default.aspx?scid=kb;en-us;287932
Company with one head office and one remote office. In the two offices I have two domains with two PDCs. The two networks are connected with eachother through leased line and the routers are configured properly. The SQL Server is on the PDC in head office and "local" clients connect fine. I cannot connect from the remote office. I think that I have folowing solutions:
1. make trust relationships between two domains - it will be hard a little bit because second PDC is samba on linux
2. make all clients in remote office to be members of the head office domain - potential problems if the leased line drops
3. make all clients to log in with same account as SQL Server logs locally - stupid
4. something else - what?
Thanks in advance!
DanielSql authentication is designed for such cases as this.
http://msdn.microsoft.com/library/en-us/architec/8_ar_cs_79kj.asp|||I am with SQL Server authentication and despite of this I cannot connect from some computers...|||Take a look at the following kb and make sure the firewall is setup correctly.
http://support.microsoft.com/default.aspx?scid=kb;en-us;287932
Clients connect via Named Pipes even though its disabled
We've got SQL 2000 clients (standard install, no sp) who are connecting
to our SQL 2000 Servers with Named Pipes even though we've disabled
named pipes in the client network utility. They should be connecting
via tcp/ip. Any ideas on what could be causing this?
Hi Gary,
How are you determining that the client is connecting using named pipes? Is
there a chance that your connection string is prefixed with "np:"? If so,
this will override any client network settings. Otherwise, this is probably
the result of the last connection being cached. One way around this would
be to force the connection to use tcp/ip and this will overwrite the cache.
Il-Sung
Il-Sung Lee
Program Manager -- SQL Server Protocols
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gary" <gary.noon@.tradeweb.com> wrote in message
news:1118352084.179815.156620@.g14g2000cwa.googlegr oups.com...
> We've got SQL 2000 clients (standard install, no sp) who are connecting
> to our SQL 2000 Servers with Named Pipes even though we've disabled
> named pipes in the client network utility. They should be connecting
> via tcp/ip. Any ideas on what could be causing this?
>
to our SQL 2000 Servers with Named Pipes even though we've disabled
named pipes in the client network utility. They should be connecting
via tcp/ip. Any ideas on what could be causing this?
Hi Gary,
How are you determining that the client is connecting using named pipes? Is
there a chance that your connection string is prefixed with "np:"? If so,
this will override any client network settings. Otherwise, this is probably
the result of the last connection being cached. One way around this would
be to force the connection to use tcp/ip and this will overwrite the cache.
Il-Sung
Il-Sung Lee
Program Manager -- SQL Server Protocols
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gary" <gary.noon@.tradeweb.com> wrote in message
news:1118352084.179815.156620@.g14g2000cwa.googlegr oups.com...
> We've got SQL 2000 clients (standard install, no sp) who are connecting
> to our SQL 2000 Servers with Named Pipes even though we've disabled
> named pipes in the client network utility. They should be connecting
> via tcp/ip. Any ideas on what could be causing this?
>
Clients connect via Named Pipes even though its disabled
We've got SQL 2000 clients (standard install, no sp) who are connecting
to our SQL 2000 Servers with Named Pipes even though we've disabled
named pipes in the client network utility. They should be connecting
via tcp/ip. Any ideas on what could be causing this?Hi Gary,
How are you determining that the client is connecting using named pipes? Is
there a chance that your connection string is prefixed with "np:"? If so,
this will override any client network settings. Otherwise, this is probably
the result of the last connection being cached. One way around this would
be to force the connection to use tcp/ip and this will overwrite the cache.
Il-Sung
Il-Sung Lee
Program Manager -- SQL Server Protocols
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gary" <gary.noon@.tradeweb.com> wrote in message
news:1118352084.179815.156620@.g14g2000cwa.googlegroups.com...
> We've got SQL 2000 clients (standard install, no sp) who are connecting
> to our SQL 2000 Servers with Named Pipes even though we've disabled
> named pipes in the client network utility. They should be connecting
> via tcp/ip. Any ideas on what could be causing this?
>
to our SQL 2000 Servers with Named Pipes even though we've disabled
named pipes in the client network utility. They should be connecting
via tcp/ip. Any ideas on what could be causing this?Hi Gary,
How are you determining that the client is connecting using named pipes? Is
there a chance that your connection string is prefixed with "np:"? If so,
this will override any client network settings. Otherwise, this is probably
the result of the last connection being cached. One way around this would
be to force the connection to use tcp/ip and this will overwrite the cache.
Il-Sung
Il-Sung Lee
Program Manager -- SQL Server Protocols
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gary" <gary.noon@.tradeweb.com> wrote in message
news:1118352084.179815.156620@.g14g2000cwa.googlegroups.com...
> We've got SQL 2000 clients (standard install, no sp) who are connecting
> to our SQL 2000 Servers with Named Pipes even though we've disabled
> named pipes in the client network utility. They should be connecting
> via tcp/ip. Any ideas on what could be causing this?
>
Clients being disconnected periodically over WAN
Some background information. I have a Windows 2003 Server that is also
running SQL 2000 on network "172.16.30.0". I have a remote facility,
"172.16.20.0", that is connected by WAN with a full T1 line. When the remote
users login to our SQL application the server creates a routing statement for
each user's machine. If I do a "route print" statement I see the static
routes for the facility, "172.16.20.0 255.255.255.0 172.16.30.11" under both
Active and Persistent routes. I also see the IP addresses of the remote
computers under Active Routes. For some reason the remote users are being
disconnected from the SQL application but their IP addresses still remain
under Active Routes. They cannot log back into the SQL application until I
manually delete their routes from the SQL Server. Once this is done they can
successful log back into the SQL application. Is the server suppose to keep
track of remote machine routing connections? We migrated from Frame Relay to
VPN connectivity and I do not recall seing each remote user's IP address
within the "Route Print" statement previously.
Not my usual turf, but since no one else responded, I'll put my foot in my
mouth.
I think you have a network issue, not a database issue. It sounds like
youhave a timeout in TCP/IP (or whatever) that is doing the disconnect. I
have not seen SS drop a user or prevent one from logging in (assuming valid
userid, etc), even multiple connections from the same place.
I know there are several places that timeout could be, so someone with more
of a networks background will have to help you point your shotgun.
Joseph R.P. Maloney, CSP,CCP,CDP
"Bill Freeze" wrote:
> Some background information. I have a Windows 2003 Server that is also
> running SQL 2000 on network "172.16.30.0". I have a remote facility,
> "172.16.20.0", that is connected by WAN with a full T1 line. When the remote
> users login to our SQL application the server creates a routing statement for
> each user's machine. If I do a "route print" statement I see the static
> routes for the facility, "172.16.20.0 255.255.255.0 172.16.30.11" under both
> Active and Persistent routes. I also see the IP addresses of the remote
> computers under Active Routes. For some reason the remote users are being
> disconnected from the SQL application but their IP addresses still remain
> under Active Routes. They cannot log back into the SQL application until I
> manually delete their routes from the SQL Server. Once this is done they can
> successful log back into the SQL application. Is the server suppose to keep
> track of remote machine routing connections? We migrated from Frame Relay to
> VPN connectivity and I do not recall seing each remote user's IP address
> within the "Route Print" statement previously.
>
running SQL 2000 on network "172.16.30.0". I have a remote facility,
"172.16.20.0", that is connected by WAN with a full T1 line. When the remote
users login to our SQL application the server creates a routing statement for
each user's machine. If I do a "route print" statement I see the static
routes for the facility, "172.16.20.0 255.255.255.0 172.16.30.11" under both
Active and Persistent routes. I also see the IP addresses of the remote
computers under Active Routes. For some reason the remote users are being
disconnected from the SQL application but their IP addresses still remain
under Active Routes. They cannot log back into the SQL application until I
manually delete their routes from the SQL Server. Once this is done they can
successful log back into the SQL application. Is the server suppose to keep
track of remote machine routing connections? We migrated from Frame Relay to
VPN connectivity and I do not recall seing each remote user's IP address
within the "Route Print" statement previously.
Not my usual turf, but since no one else responded, I'll put my foot in my
mouth.
I think you have a network issue, not a database issue. It sounds like
youhave a timeout in TCP/IP (or whatever) that is doing the disconnect. I
have not seen SS drop a user or prevent one from logging in (assuming valid
userid, etc), even multiple connections from the same place.
I know there are several places that timeout could be, so someone with more
of a networks background will have to help you point your shotgun.
Joseph R.P. Maloney, CSP,CCP,CDP
"Bill Freeze" wrote:
> Some background information. I have a Windows 2003 Server that is also
> running SQL 2000 on network "172.16.30.0". I have a remote facility,
> "172.16.20.0", that is connected by WAN with a full T1 line. When the remote
> users login to our SQL application the server creates a routing statement for
> each user's machine. If I do a "route print" statement I see the static
> routes for the facility, "172.16.20.0 255.255.255.0 172.16.30.11" under both
> Active and Persistent routes. I also see the IP addresses of the remote
> computers under Active Routes. For some reason the remote users are being
> disconnected from the SQL application but their IP addresses still remain
> under Active Routes. They cannot log back into the SQL application until I
> manually delete their routes from the SQL Server. Once this is done they can
> successful log back into the SQL application. Is the server suppose to keep
> track of remote machine routing connections? We migrated from Frame Relay to
> VPN connectivity and I do not recall seing each remote user's IP address
> within the "Route Print" statement previously.
>
Clients being disconnected periodically over WAN
Some background information. I have a Windows 2003 Server that is also
running SQL 2000 on network "172.16.30.0". I have a remote facility,
"172.16.20.0", that is connected by WAN with a full T1 line. When the remote
users login to our SQL application the server creates a routing statement for
each user's machine. If I do a "route print" statement I see the static
routes for the facility, "172.16.20.0 255.255.255.0 172.16.30.11" under both
Active and Persistent routes. I also see the IP addresses of the remote
computers under Active Routes. For some reason the remote users are being
disconnected from the SQL application but their IP addresses still remain
under Active Routes. They cannot log back into the SQL application until I
manually delete their routes from the SQL Server. Once this is done they can
successful log back into the SQL application. Is the server suppose to keep
track of remote machine routing connections? We migrated from Frame Relay to
VPN connectivity and I do not recall seing each remote user's IP address
within the "Route Print" statement previously.Not my usual turf, but since no one else responded, I'll put my foot in my
mouth.
I think you have a network issue, not a database issue. It sounds like
youhave a timeout in TCP/IP (or whatever) that is doing the disconnect. I
have not seen SS drop a user or prevent one from logging in (assuming valid
userid, etc), even multiple connections from the same place.
I know there are several places that timeout could be, so someone with more
of a networks background will have to help you point your shotgun.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Bill Freeze" wrote:
> Some background information. I have a Windows 2003 Server that is also
> running SQL 2000 on network "172.16.30.0". I have a remote facility,
> "172.16.20.0", that is connected by WAN with a full T1 line. When the remote
> users login to our SQL application the server creates a routing statement for
> each user's machine. If I do a "route print" statement I see the static
> routes for the facility, "172.16.20.0 255.255.255.0 172.16.30.11" under both
> Active and Persistent routes. I also see the IP addresses of the remote
> computers under Active Routes. For some reason the remote users are being
> disconnected from the SQL application but their IP addresses still remain
> under Active Routes. They cannot log back into the SQL application until I
> manually delete their routes from the SQL Server. Once this is done they can
> successful log back into the SQL application. Is the server suppose to keep
> track of remote machine routing connections? We migrated from Frame Relay to
> VPN connectivity and I do not recall seing each remote user's IP address
> within the "Route Print" statement previously.
>
running SQL 2000 on network "172.16.30.0". I have a remote facility,
"172.16.20.0", that is connected by WAN with a full T1 line. When the remote
users login to our SQL application the server creates a routing statement for
each user's machine. If I do a "route print" statement I see the static
routes for the facility, "172.16.20.0 255.255.255.0 172.16.30.11" under both
Active and Persistent routes. I also see the IP addresses of the remote
computers under Active Routes. For some reason the remote users are being
disconnected from the SQL application but their IP addresses still remain
under Active Routes. They cannot log back into the SQL application until I
manually delete their routes from the SQL Server. Once this is done they can
successful log back into the SQL application. Is the server suppose to keep
track of remote machine routing connections? We migrated from Frame Relay to
VPN connectivity and I do not recall seing each remote user's IP address
within the "Route Print" statement previously.Not my usual turf, but since no one else responded, I'll put my foot in my
mouth.
I think you have a network issue, not a database issue. It sounds like
youhave a timeout in TCP/IP (or whatever) that is doing the disconnect. I
have not seen SS drop a user or prevent one from logging in (assuming valid
userid, etc), even multiple connections from the same place.
I know there are several places that timeout could be, so someone with more
of a networks background will have to help you point your shotgun.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Bill Freeze" wrote:
> Some background information. I have a Windows 2003 Server that is also
> running SQL 2000 on network "172.16.30.0". I have a remote facility,
> "172.16.20.0", that is connected by WAN with a full T1 line. When the remote
> users login to our SQL application the server creates a routing statement for
> each user's machine. If I do a "route print" statement I see the static
> routes for the facility, "172.16.20.0 255.255.255.0 172.16.30.11" under both
> Active and Persistent routes. I also see the IP addresses of the remote
> computers under Active Routes. For some reason the remote users are being
> disconnected from the SQL application but their IP addresses still remain
> under Active Routes. They cannot log back into the SQL application until I
> manually delete their routes from the SQL Server. Once this is done they can
> successful log back into the SQL application. Is the server suppose to keep
> track of remote machine routing connections? We migrated from Frame Relay to
> VPN connectivity and I do not recall seing each remote user's IP address
> within the "Route Print" statement previously.
>
Clients being disconnected periodically over WAN
Some background information. I have a Windows 2003 Server that is also
running SQL 2000 on network "172.16.30.0". I have a remote facility,
"172.16.20.0", that is connected by WAN with a full T1 line. When the remot
e
users login to our SQL application the server creates a routing statement fo
r
each user's machine. If I do a "route print" statement I see the static
routes for the facility, "172.16.20.0 255.255.255.0 172.16.30.11" under both
Active and Persistent routes. I also see the IP addresses of the remote
computers under Active Routes. For some reason the remote users are being
disconnected from the SQL application but their IP addresses still remain
under Active Routes. They cannot log back into the SQL application until I
manually delete their routes from the SQL Server. Once this is done they ca
n
successful log back into the SQL application. Is the server suppose to keep
track of remote machine routing connections? We migrated from Frame Relay t
o
VPN connectivity and I do not recall seing each remote user's IP address
within the "Route Print" statement previously.Not my usual turf, but since no one else responded, I'll put my foot in my
mouth.
I think you have a network issue, not a database issue. It sounds like
youhave a timeout in TCP/IP (or whatever) that is doing the disconnect. I
have not seen SS drop a user or prevent one from logging in (assuming valid
userid, etc), even multiple connections from the same place.
I know there are several places that timeout could be, so someone with more
of a networks background will have to help you point your shotgun.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Bill Freeze" wrote:
> Some background information. I have a Windows 2003 Server that is also
> running SQL 2000 on network "172.16.30.0". I have a remote facility,
> "172.16.20.0", that is connected by WAN with a full T1 line. When the rem
ote
> users login to our SQL application the server creates a routing statement
for
> each user's machine. If I do a "route print" statement I see the static
> routes for the facility, "172.16.20.0 255.255.255.0 172.16.30.11" under bo
th
> Active and Persistent routes. I also see the IP addresses of the remote
> computers under Active Routes. For some reason the remote users are being
> disconnected from the SQL application but their IP addresses still remain
> under Active Routes. They cannot log back into the SQL application until
I
> manually delete their routes from the SQL Server. Once this is done they
can
> successful log back into the SQL application. Is the server suppose to ke
ep
> track of remote machine routing connections? We migrated from Frame Relay
to
> VPN connectivity and I do not recall seing each remote user's IP address
> within the "Route Print" statement previously.
>
running SQL 2000 on network "172.16.30.0". I have a remote facility,
"172.16.20.0", that is connected by WAN with a full T1 line. When the remot
e
users login to our SQL application the server creates a routing statement fo
r
each user's machine. If I do a "route print" statement I see the static
routes for the facility, "172.16.20.0 255.255.255.0 172.16.30.11" under both
Active and Persistent routes. I also see the IP addresses of the remote
computers under Active Routes. For some reason the remote users are being
disconnected from the SQL application but their IP addresses still remain
under Active Routes. They cannot log back into the SQL application until I
manually delete their routes from the SQL Server. Once this is done they ca
n
successful log back into the SQL application. Is the server suppose to keep
track of remote machine routing connections? We migrated from Frame Relay t
o
VPN connectivity and I do not recall seing each remote user's IP address
within the "Route Print" statement previously.Not my usual turf, but since no one else responded, I'll put my foot in my
mouth.
I think you have a network issue, not a database issue. It sounds like
youhave a timeout in TCP/IP (or whatever) that is doing the disconnect. I
have not seen SS drop a user or prevent one from logging in (assuming valid
userid, etc), even multiple connections from the same place.
I know there are several places that timeout could be, so someone with more
of a networks background will have to help you point your shotgun.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Bill Freeze" wrote:
> Some background information. I have a Windows 2003 Server that is also
> running SQL 2000 on network "172.16.30.0". I have a remote facility,
> "172.16.20.0", that is connected by WAN with a full T1 line. When the rem
ote
> users login to our SQL application the server creates a routing statement
for
> each user's machine. If I do a "route print" statement I see the static
> routes for the facility, "172.16.20.0 255.255.255.0 172.16.30.11" under bo
th
> Active and Persistent routes. I also see the IP addresses of the remote
> computers under Active Routes. For some reason the remote users are being
> disconnected from the SQL application but their IP addresses still remain
> under Active Routes. They cannot log back into the SQL application until
I
> manually delete their routes from the SQL Server. Once this is done they
can
> successful log back into the SQL application. Is the server suppose to ke
ep
> track of remote machine routing connections? We migrated from Frame Relay
to
> VPN connectivity and I do not recall seing each remote user's IP address
> within the "Route Print" statement previously.
>
Client tools to view cubes
Hello!
I'm a new in DW world and I'm searching for tools to my clients view the
cubes generated using SQL 2005.
I already found some good products like "Business Objects" toolset but
the price is inacessible... :-(
The problem to use Excel to visualize the data, for example, is because
We host all the data of our clients using a ASP model (so the Excel can't
access the SQL Server directly).
Any idea?
Thanks!
RMeloWe use BIDS (Business Intelligece Studio) Basically Visual Studios. Create
a new Analysis Project, create Data Source to your Cube, then Add Report -
using Query Builder you can navigate your cubes and dimensions and create
reports to save and re-use.
Using SSMS (new Enterprise Manager) - you can do same but you lose all your
research when you exit. Creating it as a report you can save your work.
All above is FREE! M$ just bought out Proclarity - which is a proper full
blown Cube tool - but it will be a bit more than free.
"RMelo" <rmelo@.community.nospam> wrote in message
news:%23J1uZVjsGHA.3368@.TK2MSFTNGP02.phx.gbl...
> Hello!
> I'm a new in DW world and I'm searching for tools to my clients view
> the cubes generated using SQL 2005.
> I already found some good products like "Business Objects" toolset but
> the price is inacessible... :-(
> The problem to use Excel to visualize the data, for example, is because
> We host all the data of our clients using a ASP model (so the Excel can't
> access the SQL Server directly).
> Any idea?
> Thanks!
> RMelo
>|||Joe,
Good! But I think that BIDS is not a tool to a end user... Does
Microsoft have any web based app to manipulate the cubes?
Remember that to mey end users I don't have a direct connect to SQL
Server (I'm running my app on a datacenter, using the internet).
Thanks!
RMelo
Joe escreveu:
> We use BIDS (Business Intelligece Studio) Basically Visual Studios. Creat
e
> a new Analysis Project, create Data Source to your Cube, then Add Report -
> using Query Builder you can navigate your cubes and dimensions and create
> reports to save and re-use.
> Using SSMS (new Enterprise Manager) - you can do same but you lose all you
r
> research when you exit. Creating it as a report you can save your work.
> All above is FREE! M$ just bought out Proclarity - which is a proper full
> blown Cube tool - but it will be a bit more than free.
> "RMelo" <rmelo@.community.nospam> wrote in message
> news:%23J1uZVjsGHA.3368@.TK2MSFTNGP02.phx.gbl...
>|||Joe,
Good! But I think that BIDS is not a tool to a end user... Does
Microsoft have any web based app to manipulate the cubes?
Remember that to mey end users I don't have a direct connect to SQL
Server (I'm running my app on a datacenter, using the internet).
Thanks!
RMelo
Joe escreveu:
> We use BIDS (Business Intelligece Studio) Basically Visual Studios. Creat
e
> a new Analysis Project, create Data Source to your Cube, then Add Report -
> using Query Builder you can navigate your cubes and dimensions and create
> reports to save and re-use.
> Using SSMS (new Enterprise Manager) - you can do same but you lose all you
r
> research when you exit. Creating it as a report you can save your work.
> All above is FREE! M$ just bought out Proclarity - which is a proper full
> blown Cube tool - but it will be a bit more than free.
> "RMelo" <rmelo@.community.nospam> wrote in message
> news:%23J1uZVjsGHA.3368@.TK2MSFTNGP02.phx.gbl...
>|||Joe,
Good! But I think that BIDS is not a tool to a end user... Does Microsoft
have any web based app to manipulate the cubes?
Remember that to mey end users I don't have a direct connect to SQL
Server (I'm running my app on a datacenter, using the internet).
Thanks!
RMelo
"Joe" <hortoristic@.gmail dot com> wrote in message
news:%231bjcNmsGHA.3684@.TK2MSFTNGP05.phx.gbl...
> We use BIDS (Business Intelligece Studio) Basically Visual Studios.
> Create a new Analysis Project, create Data Source to your Cube, then Add
> Report - using Query Builder you can navigate your cubes and dimensions
> and create reports to save and re-use.
> Using SSMS (new Enterprise Manager) - you can do same but you lose all
> your research when you exit. Creating it as a report you can save your
> work.
> All above is FREE! M$ just bought out Proclarity - which is a proper full
> blown Cube tool - but it will be a bit more than free.
> "RMelo" <rmelo@.community.nospam> wrote in message
> news:%23J1uZVjsGHA.3368@.TK2MSFTNGP02.phx.gbl...
>|||Hello RMelo,
I understand that you'd like to use some Web based application to connct
and manipulate the cubes, and you does not have direct access to AS 2005.
If I'm off-base, please let me know.
You'd like to consider Pivottable in Office Web Component (OWC). You may
want to refer to following article for more details about OWC and pivottable
Using Web Technologies with Office XP
http://msdn.microsoft.com/library/d...-us/modcore/htm
l/deovrusingwebtechnologies.asp
Office Web Components section from the article,
http://msdn.microsoft.com/library/d...-us/dnoxpta/htm
l/vsofficedev.asp
Also, you may consider using HTTP Access to Analysis Services 2005 so that
clients does not need to access server directly from clients:
Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft
Windows Server 2003
http://www.microsoft.com/technet/pr...5/httpasws.mspx
If you want to manage AS 2005, you may want to consider using AMO and
develop your own Web application.
Analysis Management Objects (AMO)
http://msdn2.microsoft.com/en-us/library/ms124924.aspx
If you have any further questions on this, please feel free to let's know.
Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||I know it's not as easy as it could be - but we have been training ppl who
have never even seen SQL 2005 on BIDS and within 4 to 6 hours they are able
to work on their own using BIDS.
As mentioned, the ProClarity product from M$ is what you want - but you have
to pay extra for that - BIDS is free.
"msnews.microsoft.com" <rmelo@.community.nospam> wrote in message
news:uLdIFtmsGHA.5044@.TK2MSFTNGP05.phx.gbl...[vbcol=seagreen]
> Joe,
> Good! But I think that BIDS is not a tool to a end user... Does
> Microsoft have any web based app to manipulate the cubes?
> Remember that to mey end users I don't have a direct connect to SQL
> Server (I'm running my app on a datacenter, using the internet).
> Thanks!
> RMelo
> Joe escreveu:
I'm a new in DW world and I'm searching for tools to my clients view the
cubes generated using SQL 2005.
I already found some good products like "Business Objects" toolset but
the price is inacessible... :-(
The problem to use Excel to visualize the data, for example, is because
We host all the data of our clients using a ASP model (so the Excel can't
access the SQL Server directly).
Any idea?
Thanks!
RMeloWe use BIDS (Business Intelligece Studio) Basically Visual Studios. Create
a new Analysis Project, create Data Source to your Cube, then Add Report -
using Query Builder you can navigate your cubes and dimensions and create
reports to save and re-use.
Using SSMS (new Enterprise Manager) - you can do same but you lose all your
research when you exit. Creating it as a report you can save your work.
All above is FREE! M$ just bought out Proclarity - which is a proper full
blown Cube tool - but it will be a bit more than free.
"RMelo" <rmelo@.community.nospam> wrote in message
news:%23J1uZVjsGHA.3368@.TK2MSFTNGP02.phx.gbl...
> Hello!
> I'm a new in DW world and I'm searching for tools to my clients view
> the cubes generated using SQL 2005.
> I already found some good products like "Business Objects" toolset but
> the price is inacessible... :-(
> The problem to use Excel to visualize the data, for example, is because
> We host all the data of our clients using a ASP model (so the Excel can't
> access the SQL Server directly).
> Any idea?
> Thanks!
> RMelo
>|||Joe,
Good! But I think that BIDS is not a tool to a end user... Does
Microsoft have any web based app to manipulate the cubes?
Remember that to mey end users I don't have a direct connect to SQL
Server (I'm running my app on a datacenter, using the internet).
Thanks!
RMelo
Joe escreveu:
> We use BIDS (Business Intelligece Studio) Basically Visual Studios. Creat
e
> a new Analysis Project, create Data Source to your Cube, then Add Report -
> using Query Builder you can navigate your cubes and dimensions and create
> reports to save and re-use.
> Using SSMS (new Enterprise Manager) - you can do same but you lose all you
r
> research when you exit. Creating it as a report you can save your work.
> All above is FREE! M$ just bought out Proclarity - which is a proper full
> blown Cube tool - but it will be a bit more than free.
> "RMelo" <rmelo@.community.nospam> wrote in message
> news:%23J1uZVjsGHA.3368@.TK2MSFTNGP02.phx.gbl...
>|||Joe,
Good! But I think that BIDS is not a tool to a end user... Does
Microsoft have any web based app to manipulate the cubes?
Remember that to mey end users I don't have a direct connect to SQL
Server (I'm running my app on a datacenter, using the internet).
Thanks!
RMelo
Joe escreveu:
> We use BIDS (Business Intelligece Studio) Basically Visual Studios. Creat
e
> a new Analysis Project, create Data Source to your Cube, then Add Report -
> using Query Builder you can navigate your cubes and dimensions and create
> reports to save and re-use.
> Using SSMS (new Enterprise Manager) - you can do same but you lose all you
r
> research when you exit. Creating it as a report you can save your work.
> All above is FREE! M$ just bought out Proclarity - which is a proper full
> blown Cube tool - but it will be a bit more than free.
> "RMelo" <rmelo@.community.nospam> wrote in message
> news:%23J1uZVjsGHA.3368@.TK2MSFTNGP02.phx.gbl...
>|||Joe,
Good! But I think that BIDS is not a tool to a end user... Does Microsoft
have any web based app to manipulate the cubes?
Remember that to mey end users I don't have a direct connect to SQL
Server (I'm running my app on a datacenter, using the internet).
Thanks!
RMelo
"Joe" <hortoristic@.gmail dot com> wrote in message
news:%231bjcNmsGHA.3684@.TK2MSFTNGP05.phx.gbl...
> We use BIDS (Business Intelligece Studio) Basically Visual Studios.
> Create a new Analysis Project, create Data Source to your Cube, then Add
> Report - using Query Builder you can navigate your cubes and dimensions
> and create reports to save and re-use.
> Using SSMS (new Enterprise Manager) - you can do same but you lose all
> your research when you exit. Creating it as a report you can save your
> work.
> All above is FREE! M$ just bought out Proclarity - which is a proper full
> blown Cube tool - but it will be a bit more than free.
> "RMelo" <rmelo@.community.nospam> wrote in message
> news:%23J1uZVjsGHA.3368@.TK2MSFTNGP02.phx.gbl...
>|||Hello RMelo,
I understand that you'd like to use some Web based application to connct
and manipulate the cubes, and you does not have direct access to AS 2005.
If I'm off-base, please let me know.
You'd like to consider Pivottable in Office Web Component (OWC). You may
want to refer to following article for more details about OWC and pivottable
Using Web Technologies with Office XP
http://msdn.microsoft.com/library/d...-us/modcore/htm
l/deovrusingwebtechnologies.asp
Office Web Components section from the article,
http://msdn.microsoft.com/library/d...-us/dnoxpta/htm
l/vsofficedev.asp
Also, you may consider using HTTP Access to Analysis Services 2005 so that
clients does not need to access server directly from clients:
Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft
Windows Server 2003
http://www.microsoft.com/technet/pr...5/httpasws.mspx
If you want to manage AS 2005, you may want to consider using AMO and
develop your own Web application.
Analysis Management Objects (AMO)
http://msdn2.microsoft.com/en-us/library/ms124924.aspx
If you have any further questions on this, please feel free to let's know.
Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||I know it's not as easy as it could be - but we have been training ppl who
have never even seen SQL 2005 on BIDS and within 4 to 6 hours they are able
to work on their own using BIDS.
As mentioned, the ProClarity product from M$ is what you want - but you have
to pay extra for that - BIDS is free.
"msnews.microsoft.com" <rmelo@.community.nospam> wrote in message
news:uLdIFtmsGHA.5044@.TK2MSFTNGP05.phx.gbl...[vbcol=seagreen]
> Joe,
> Good! But I think that BIDS is not a tool to a end user... Does
> Microsoft have any web based app to manipulate the cubes?
> Remember that to mey end users I don't have a direct connect to SQL
> Server (I'm running my app on a datacenter, using the internet).
> Thanks!
> RMelo
> Joe escreveu:
Sunday, February 19, 2012
client to client connection
hi we have a sql 2k installed on one server and 2 clients installed with sql server 2005 express..
clients pc are winxp..is it possible to connect from one client to one client pc using the sql express?
thanksBy default, SQL Server Express is not configured to accept remote connections, which helps reduce the risk of attack via the SQL Server service. If you do need to access your Express server from other machines, you can enable remote connections using the Surface Area Configuration tool.
You will probably need to open the TCP port your Express servers are listening to in your firewall as well. The default port number is 1433.
Client to Client communication
Hello,
I have a SQL Server 2005 Database. On some clients (I will call that input
clients) users will enter data and on some other clients these Data will be
used.
Well, I want to avoid, that the other clients have to poll the database all
the time for changes. I thought of somethig like an event which will be rised
at the input client and catched at the other clients.
Is there any possibility to do something like that direct with the SQL
Server (Express) where all the clients are connected to?
Or do I have to write my own server application where the clients have to
connect too and make my own network communication through sockets ect.
Note: The application is ought to work with the SQL Server 2005 Express by
default (for smaller databases), but will be abel to use the SQL Server 2005
also.
thanks, Robert
You could use Global ##Temp tables.
But then again, you will still be using a table on the server, and the
clients will have to poll that table for changes.
But if you were using Notification Services, the clients could be notified
that the changed data is available. (Of course, Notification Services is NOT
included with SQL Express.)
Basically, you are 'butting heads' with the design paradigm of SQL Server.
It is a data STORAGE and RETREIVAL service, NOT a COMMUNICATION service. You
may need to create your own communication service.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"rfw68" <rfw68@.nospam.nospam> wrote in message
news:6AE389B2-A7B3-45E7-974A-4E98AC97A7A8@.microsoft.com...
> Hello,
> I have a SQL Server 2005 Database. On some clients (I will call that input
> clients) users will enter data and on some other clients these Data will
> be
> used.
> Well, I want to avoid, that the other clients have to poll the database
> all
> the time for changes. I thought of somethig like an event which will be
> rised
> at the input client and catched at the other clients.
> Is there any possibility to do something like that direct with the SQL
> Server (Express) where all the clients are connected to?
> Or do I have to write my own server application where the clients have to
> connect too and make my own network communication through sockets ect.
> Note: The application is ought to work with the SQL Server 2005 Express by
> default (for smaller databases), but will be abel to use the SQL Server
> 2005
> also.
> thanks, Robert
>
|||Hello Robert,,
I agree with Arnie that SQL Server is not meant to do this job since it's
mainly for data storage and retrivial.
As Arnie mentioned, Notification service can be used to do this type of
jobs but it is not included in Express edition.
Notification Services
http://www.microsoft.com/sql/technologies/notification/default.mspx
An Introduction to SQL Server Notification Services
http://www.codeproject.com/dotnet/sqlns.asp
Usually you could add subscription to your application so that it could be
notified when data is changed on the server side, and client application
can retrival the newest data at this time.
If you don't want to use Notification Services, you may need to develop
your own service on server side to monitor the data change in SQL Server
and notfiy the clients. Since many users may change data concurrently, I
think it is usually not realistic for it to notifiy other clients by using
client-client communication. A central point might be a better option for
this situation.
If you have any comments or feedback, please feel free to let's know. Thank
you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi,
I think that our SocketPro can help you out easily at www.udaparts.com
See the article "
Notify your coworkers any messages anywhere
" at http://www.udaparts.com/document/articles/chatservice.htm
Also, see the tutorial 2 inside the package SocketPro for our chat
service.
Regards,
"rfw68" <rfw68@.nospam.nospam> wrote in message
news:6AE389B2-A7B3-45E7-974A-4E98AC97A7A8@.microsoft.com...
> Hello,
> I have a SQL Server 2005 Database. On some clients (I will call that input
> clients) users will enter data and on some other clients these Data will
> be
> used.
> Well, I want to avoid, that the other clients have to poll the database
> all
> the time for changes. I thought of somethig like an event which will be
> rised
> at the input client and catched at the other clients.
> Is there any possibility to do something like that direct with the SQL
> Server (Express) where all the clients are connected to?
> Or do I have to write my own server application where the clients have to
> connect too and make my own network communication through sockets ect.
> Note: The application is ought to work with the SQL Server 2005 Express by
> default (for smaller databases), but will be abel to use the SQL Server
> 2005
> also.
> thanks, Robert
>
I have a SQL Server 2005 Database. On some clients (I will call that input
clients) users will enter data and on some other clients these Data will be
used.
Well, I want to avoid, that the other clients have to poll the database all
the time for changes. I thought of somethig like an event which will be rised
at the input client and catched at the other clients.
Is there any possibility to do something like that direct with the SQL
Server (Express) where all the clients are connected to?
Or do I have to write my own server application where the clients have to
connect too and make my own network communication through sockets ect.
Note: The application is ought to work with the SQL Server 2005 Express by
default (for smaller databases), but will be abel to use the SQL Server 2005
also.
thanks, Robert
You could use Global ##Temp tables.
But then again, you will still be using a table on the server, and the
clients will have to poll that table for changes.
But if you were using Notification Services, the clients could be notified
that the changed data is available. (Of course, Notification Services is NOT
included with SQL Express.)
Basically, you are 'butting heads' with the design paradigm of SQL Server.
It is a data STORAGE and RETREIVAL service, NOT a COMMUNICATION service. You
may need to create your own communication service.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"rfw68" <rfw68@.nospam.nospam> wrote in message
news:6AE389B2-A7B3-45E7-974A-4E98AC97A7A8@.microsoft.com...
> Hello,
> I have a SQL Server 2005 Database. On some clients (I will call that input
> clients) users will enter data and on some other clients these Data will
> be
> used.
> Well, I want to avoid, that the other clients have to poll the database
> all
> the time for changes. I thought of somethig like an event which will be
> rised
> at the input client and catched at the other clients.
> Is there any possibility to do something like that direct with the SQL
> Server (Express) where all the clients are connected to?
> Or do I have to write my own server application where the clients have to
> connect too and make my own network communication through sockets ect.
> Note: The application is ought to work with the SQL Server 2005 Express by
> default (for smaller databases), but will be abel to use the SQL Server
> 2005
> also.
> thanks, Robert
>
|||Hello Robert,,
I agree with Arnie that SQL Server is not meant to do this job since it's
mainly for data storage and retrivial.
As Arnie mentioned, Notification service can be used to do this type of
jobs but it is not included in Express edition.
Notification Services
http://www.microsoft.com/sql/technologies/notification/default.mspx
An Introduction to SQL Server Notification Services
http://www.codeproject.com/dotnet/sqlns.asp
Usually you could add subscription to your application so that it could be
notified when data is changed on the server side, and client application
can retrival the newest data at this time.
If you don't want to use Notification Services, you may need to develop
your own service on server side to monitor the data change in SQL Server
and notfiy the clients. Since many users may change data concurrently, I
think it is usually not realistic for it to notifiy other clients by using
client-client communication. A central point might be a better option for
this situation.
If you have any comments or feedback, please feel free to let's know. Thank
you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi,
I think that our SocketPro can help you out easily at www.udaparts.com
See the article "
Notify your coworkers any messages anywhere
" at http://www.udaparts.com/document/articles/chatservice.htm
Also, see the tutorial 2 inside the package SocketPro for our chat
service.
Regards,
"rfw68" <rfw68@.nospam.nospam> wrote in message
news:6AE389B2-A7B3-45E7-974A-4E98AC97A7A8@.microsoft.com...
> Hello,
> I have a SQL Server 2005 Database. On some clients (I will call that input
> clients) users will enter data and on some other clients these Data will
> be
> used.
> Well, I want to avoid, that the other clients have to poll the database
> all
> the time for changes. I thought of somethig like an event which will be
> rised
> at the input client and catched at the other clients.
> Is there any possibility to do something like that direct with the SQL
> Server (Express) where all the clients are connected to?
> Or do I have to write my own server application where the clients have to
> connect too and make my own network communication through sockets ect.
> Note: The application is ought to work with the SQL Server 2005 Express by
> default (for smaller databases), but will be abel to use the SQL Server
> 2005
> also.
> thanks, Robert
>
Thursday, February 16, 2012
Client Network Utility Service Pack
2 Questions:
1) I am getting back into SQL more than before, in my new job. I need to find the service pack installed on the clients who have the Client Network Utility installed. I do not remember how to do this.
2) Running 'Select @.@.VERSION' on the server returns 7.00.1063 but does not indicate the service pack. Does this still mean sp4 has been installed?
I'm trying to ensure we'll all up to date since our dual 700 procs are acting eratic...jumps between 10 - 95% or so.
Server info:
NT Server SP6
SQL 7.0
2GB Ram
2 procs @. 700Mhz
Roughly 80 network connections.
No other programs running on server except Antivirus.
Thank you!Yes - sp4 is installed. Also, antivirus can cause several issues with any application. When you say jumping from 10% to 95%, are you isolating the application that is causing this ?|||Originally posted by rnealejr
Yes - sp4 is installed. Also, antivirus can cause several issues with any application. When you say jumping from 10% to 95%, are you isolating the application that is causing this ?
Thanks for the reply! Based on the Perf Monitor, sqlservr.exe uses up most of the CPU. VNC is what I am using to connect to it to monitor it remotely, which does take up some of the CPU. There are only a couple other programs that will take up 1 or 2 of the CPU, but that doesn't even seem worthy of mentioning.
There is only one database that is about 4.5 GB large. It is essentially an out of the box CRM system database, not custom built.
I have read an online resource for using Performance Monitor which was very helpful, but I haven't been able to determine what exactly SQL is doing to cause it to spike.
There are no jobs running while I am monitoring the performance. Memory doesn't seem to be a problem at all, and my indexes appear to be fine.
Thanks again!|||I would trash vnc and install terminal services (the administrative mode /not application) to remotely connect to your sql server machine. vnc causes cpu spikes. rtvscan is an antivirus application that causes spikes as well. When it hits 95% what applications are consuming the resource (is it only sql) ?
1) I am getting back into SQL more than before, in my new job. I need to find the service pack installed on the clients who have the Client Network Utility installed. I do not remember how to do this.
2) Running 'Select @.@.VERSION' on the server returns 7.00.1063 but does not indicate the service pack. Does this still mean sp4 has been installed?
I'm trying to ensure we'll all up to date since our dual 700 procs are acting eratic...jumps between 10 - 95% or so.
Server info:
NT Server SP6
SQL 7.0
2GB Ram
2 procs @. 700Mhz
Roughly 80 network connections.
No other programs running on server except Antivirus.
Thank you!Yes - sp4 is installed. Also, antivirus can cause several issues with any application. When you say jumping from 10% to 95%, are you isolating the application that is causing this ?|||Originally posted by rnealejr
Yes - sp4 is installed. Also, antivirus can cause several issues with any application. When you say jumping from 10% to 95%, are you isolating the application that is causing this ?
Thanks for the reply! Based on the Perf Monitor, sqlservr.exe uses up most of the CPU. VNC is what I am using to connect to it to monitor it remotely, which does take up some of the CPU. There are only a couple other programs that will take up 1 or 2 of the CPU, but that doesn't even seem worthy of mentioning.
There is only one database that is about 4.5 GB large. It is essentially an out of the box CRM system database, not custom built.
I have read an online resource for using Performance Monitor which was very helpful, but I haven't been able to determine what exactly SQL is doing to cause it to spike.
There are no jobs running while I am monitoring the performance. Memory doesn't seem to be a problem at all, and my indexes appear to be fine.
Thanks again!|||I would trash vnc and install terminal services (the administrative mode /not application) to remotely connect to your sql server machine. vnc causes cpu spikes. rtvscan is an antivirus application that causes spikes as well. When it hits 95% what applications are consuming the resource (is it only sql) ?
Client Network Utility
A third-party application we have to use requires the installation of the
Client Network Utility on clients workstation. Is there any way to install
this piece of the Client Tools without running through the standard SQL
Server setup routing that prompts for the CD-Key?
Thanks, in advance, for any assistance.
Brian Lorenz
You may already have it installed without knowing it...
Start | Run | cliconfg
<Enter>
Keith Kratochvil
"Lorenz, Brian" <LorenzBrian@.discussions.microsoft.com> wrote in message
news:F7D8D1F9-E914-409E-AA68-0A3DEED36457@.microsoft.com...
>A third-party application we have to use requires the installation of the
> Client Network Utility on clients workstation. Is there any way to install
> this piece of the Client Tools without running through the standard SQL
> Server setup routing that prompts for the CD-Key?
> Thanks, in advance, for any assistance.
> --
> Brian Lorenz
|||cliconfig not found.
I'm looking to install just the Client Network Utility on a bunch of clients
that have never had any of the SQL Client Tools installed...so, there's never
been any installation...I'm guessing that's why cliconfig is not present.
Brian Lorenz
"Keith Kratochvil" wrote:
> You may already have it installed without knowing it...
> Start | Run | cliconfg
> <Enter>
> --
> Keith Kratochvil
>
> "Lorenz, Brian" <LorenzBrian@.discussions.microsoft.com> wrote in message
> news:F7D8D1F9-E914-409E-AA68-0A3DEED36457@.microsoft.com...
>
>
|||Re-read my post. I typed cliconfg NOT cliconf_i_g
Keith Kratochvil
"Lorenz, Brian" <LorenzBrian@.discussions.microsoft.com> wrote in message
news:9BFB47F0-1155-4331-9F99-C3CF7FFA0B7F@.microsoft.com...[vbcol=seagreen]
> cliconfig not found.
> I'm looking to install just the Client Network Utility on a bunch of
> clients
> that have never had any of the SQL Client Tools installed...so, there's
> never
> been any installation...I'm guessing that's why cliconfig is not present.
> --
> Brian Lorenz
>
> "Keith Kratochvil" wrote:
Client Network Utility on clients workstation. Is there any way to install
this piece of the Client Tools without running through the standard SQL
Server setup routing that prompts for the CD-Key?
Thanks, in advance, for any assistance.
Brian Lorenz
You may already have it installed without knowing it...
Start | Run | cliconfg
<Enter>
Keith Kratochvil
"Lorenz, Brian" <LorenzBrian@.discussions.microsoft.com> wrote in message
news:F7D8D1F9-E914-409E-AA68-0A3DEED36457@.microsoft.com...
>A third-party application we have to use requires the installation of the
> Client Network Utility on clients workstation. Is there any way to install
> this piece of the Client Tools without running through the standard SQL
> Server setup routing that prompts for the CD-Key?
> Thanks, in advance, for any assistance.
> --
> Brian Lorenz
|||cliconfig not found.
I'm looking to install just the Client Network Utility on a bunch of clients
that have never had any of the SQL Client Tools installed...so, there's never
been any installation...I'm guessing that's why cliconfig is not present.
Brian Lorenz
"Keith Kratochvil" wrote:
> You may already have it installed without knowing it...
> Start | Run | cliconfg
> <Enter>
> --
> Keith Kratochvil
>
> "Lorenz, Brian" <LorenzBrian@.discussions.microsoft.com> wrote in message
> news:F7D8D1F9-E914-409E-AA68-0A3DEED36457@.microsoft.com...
>
>
|||Re-read my post. I typed cliconfg NOT cliconf_i_g
Keith Kratochvil
"Lorenz, Brian" <LorenzBrian@.discussions.microsoft.com> wrote in message
news:9BFB47F0-1155-4331-9F99-C3CF7FFA0B7F@.microsoft.com...[vbcol=seagreen]
> cliconfig not found.
> I'm looking to install just the Client Network Utility on a bunch of
> clients
> that have never had any of the SQL Client Tools installed...so, there's
> never
> been any installation...I'm guessing that's why cliconfig is not present.
> --
> Brian Lorenz
>
> "Keith Kratochvil" wrote:
Tuesday, February 14, 2012
Client IP Address Search
Does anyone have a method of tracing a clients IP address
from the SPID available inside SQL Server to the sp_who2
command?Here's one I prepared earlier :-)
create proc get_hostip (@.spid int = NULL)
as
set nocount on
declare @.host varchar(100)
declare @.ip varchar(15)
declare @.cmd varchar(200)
declare @.temp varchar(255)
create table #ip(iptext varchar(255))
If @.spid is null select @.host = host_name()
else
select @.host = max(hostname)
from master.dbo.sysprocesses
where spid = @.spid
if @.host is not null
begin
set @.cmd = 'ping -n 1 ' + @.host
insert #ip exec master..xp_cmdshell @.cmd
select @.ip = ISNULL(substring(iptext,(charindex('[',iptext)+1),
(charindex(']',iptext)-(charindex('[',iptext)+1))),'')
from #ip
where charindex('[',iptext)>0
end
drop table #ip
select NULLIF(rtrim(@.host),'') as 'Hostname',
rtrim(@.ip) as 'IP_Address'
return
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"David B" <david.brough@.nygard.com> wrote in message
news:02e401c39ffb$8a4c74e0$a401280a@.phx.gbl...
Does anyone have a method of tracing a clients IP address
from the SPID available inside SQL Server to the sp_who2
command?|||I am sure you know this will not work for remote hostname. There is no way
for you to resolve my current hostname (client2) for example. This is
because my hostname is not registered with your DNS or WINS and I'm not on
your local subnets so broadcast will not reach me.
As far as name resolutions on windows is concerned, there are 2 kinds:
1. Netbios name resolution - there is no dot in the name. The order for
resolution is as follow:
NetBIOS name cache
WINS
Broadcasts
LMHOSTS
Hosts
DNS
2. Hostname resolution - the order is as follow:
Hosts
DNS
NetBIOS name cache
WINS
Broadcasts
LMHOSTS
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eCdcf9$nDHA.3320@.tk2msftngp13.phx.gbl...
> Here's one I prepared earlier :-)
> create proc get_hostip (@.spid int = NULL)
> as
> set nocount on
> declare @.host varchar(100)
> declare @.ip varchar(15)
> declare @.cmd varchar(200)
> declare @.temp varchar(255)
> create table #ip(iptext varchar(255))
> If @.spid is null select @.host = host_name()
> else
> select @.host = max(hostname)
> from master.dbo.sysprocesses
> where spid = @.spid
> if @.host is not null
> begin
> set @.cmd = 'ping -n 1 ' + @.host
> insert #ip exec master..xp_cmdshell @.cmd
> select @.ip = ISNULL(substring(iptext,(charindex('[',iptext)+1),
> (charindex(']',iptext)-(charindex('[',iptext)+1))),'')
> from #ip
> where charindex('[',iptext)>0
> end
> drop table #ip
> select NULLIF(rtrim(@.host),'') as 'Hostname',
> rtrim(@.ip) as 'IP_Address'
> return
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "David B" <david.brough@.nygard.com> wrote in message
> news:02e401c39ffb$8a4c74e0$a401280a@.phx.gbl...
> Does anyone have a method of tracing a clients IP address
> from the SPID available inside SQL Server to the sp_who2
> command?
>
>|||Yeah, I should have stressed its limitations, it is of course dependent on
resolving the hostname.
My PC resolves a local ping as [::1] , not sure why :-)
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"oj" <nospam_ojngo@.home.com> wrote in message
news:e8jj7QAoDHA.1764@.tk2msftngp13.phx.gbl...
I am sure you know this will not work for remote hostname. There is no way
for you to resolve my current hostname (client2) for example. This is
because my hostname is not registered with your DNS or WINS and I'm not on
your local subnets so broadcast will not reach me.
As far as name resolutions on windows is concerned, there are 2 kinds:
1. Netbios name resolution - there is no dot in the name. The order for
resolution is as follow:
NetBIOS name cache
WINS
Broadcasts
LMHOSTS
Hosts
DNS
2. Hostname resolution - the order is as follow:
Hosts
DNS
NetBIOS name cache
WINS
Broadcasts
LMHOSTS
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eCdcf9$nDHA.3320@.tk2msftngp13.phx.gbl...
> Here's one I prepared earlier :-)
> create proc get_hostip (@.spid int = NULL)
> as
> set nocount on
> declare @.host varchar(100)
> declare @.ip varchar(15)
> declare @.cmd varchar(200)
> declare @.temp varchar(255)
> create table #ip(iptext varchar(255))
> If @.spid is null select @.host = host_name()
> else
> select @.host = max(hostname)
> from master.dbo.sysprocesses
> where spid = @.spid
> if @.host is not null
> begin
> set @.cmd = 'ping -n 1 ' + @.host
> insert #ip exec master..xp_cmdshell @.cmd
> select @.ip = ISNULL(substring(iptext,(charindex('[',iptext)+1),
> (charindex(']',iptext)-(charindex('[',iptext)+1))),'')
> from #ip
> where charindex('[',iptext)>0
> end
> drop table #ip
> select NULLIF(rtrim(@.host),'') as 'Hostname',
> rtrim(@.ip) as 'IP_Address'
> return
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "David B" <david.brough@.nygard.com> wrote in message
> news:02e401c39ffb$8a4c74e0$a401280a@.phx.gbl...
> Does anyone have a method of tracing a clients IP address
> from the SPID available inside SQL Server to the sp_who2
> command?
>
>
from the SPID available inside SQL Server to the sp_who2
command?Here's one I prepared earlier :-)
create proc get_hostip (@.spid int = NULL)
as
set nocount on
declare @.host varchar(100)
declare @.ip varchar(15)
declare @.cmd varchar(200)
declare @.temp varchar(255)
create table #ip(iptext varchar(255))
If @.spid is null select @.host = host_name()
else
select @.host = max(hostname)
from master.dbo.sysprocesses
where spid = @.spid
if @.host is not null
begin
set @.cmd = 'ping -n 1 ' + @.host
insert #ip exec master..xp_cmdshell @.cmd
select @.ip = ISNULL(substring(iptext,(charindex('[',iptext)+1),
(charindex(']',iptext)-(charindex('[',iptext)+1))),'')
from #ip
where charindex('[',iptext)>0
end
drop table #ip
select NULLIF(rtrim(@.host),'') as 'Hostname',
rtrim(@.ip) as 'IP_Address'
return
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"David B" <david.brough@.nygard.com> wrote in message
news:02e401c39ffb$8a4c74e0$a401280a@.phx.gbl...
Does anyone have a method of tracing a clients IP address
from the SPID available inside SQL Server to the sp_who2
command?|||I am sure you know this will not work for remote hostname. There is no way
for you to resolve my current hostname (client2) for example. This is
because my hostname is not registered with your DNS or WINS and I'm not on
your local subnets so broadcast will not reach me.
As far as name resolutions on windows is concerned, there are 2 kinds:
1. Netbios name resolution - there is no dot in the name. The order for
resolution is as follow:
NetBIOS name cache
WINS
Broadcasts
LMHOSTS
Hosts
DNS
2. Hostname resolution - the order is as follow:
Hosts
DNS
NetBIOS name cache
WINS
Broadcasts
LMHOSTS
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eCdcf9$nDHA.3320@.tk2msftngp13.phx.gbl...
> Here's one I prepared earlier :-)
> create proc get_hostip (@.spid int = NULL)
> as
> set nocount on
> declare @.host varchar(100)
> declare @.ip varchar(15)
> declare @.cmd varchar(200)
> declare @.temp varchar(255)
> create table #ip(iptext varchar(255))
> If @.spid is null select @.host = host_name()
> else
> select @.host = max(hostname)
> from master.dbo.sysprocesses
> where spid = @.spid
> if @.host is not null
> begin
> set @.cmd = 'ping -n 1 ' + @.host
> insert #ip exec master..xp_cmdshell @.cmd
> select @.ip = ISNULL(substring(iptext,(charindex('[',iptext)+1),
> (charindex(']',iptext)-(charindex('[',iptext)+1))),'')
> from #ip
> where charindex('[',iptext)>0
> end
> drop table #ip
> select NULLIF(rtrim(@.host),'') as 'Hostname',
> rtrim(@.ip) as 'IP_Address'
> return
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "David B" <david.brough@.nygard.com> wrote in message
> news:02e401c39ffb$8a4c74e0$a401280a@.phx.gbl...
> Does anyone have a method of tracing a clients IP address
> from the SPID available inside SQL Server to the sp_who2
> command?
>
>|||Yeah, I should have stressed its limitations, it is of course dependent on
resolving the hostname.
My PC resolves a local ping as [::1] , not sure why :-)
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"oj" <nospam_ojngo@.home.com> wrote in message
news:e8jj7QAoDHA.1764@.tk2msftngp13.phx.gbl...
I am sure you know this will not work for remote hostname. There is no way
for you to resolve my current hostname (client2) for example. This is
because my hostname is not registered with your DNS or WINS and I'm not on
your local subnets so broadcast will not reach me.
As far as name resolutions on windows is concerned, there are 2 kinds:
1. Netbios name resolution - there is no dot in the name. The order for
resolution is as follow:
NetBIOS name cache
WINS
Broadcasts
LMHOSTS
Hosts
DNS
2. Hostname resolution - the order is as follow:
Hosts
DNS
NetBIOS name cache
WINS
Broadcasts
LMHOSTS
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eCdcf9$nDHA.3320@.tk2msftngp13.phx.gbl...
> Here's one I prepared earlier :-)
> create proc get_hostip (@.spid int = NULL)
> as
> set nocount on
> declare @.host varchar(100)
> declare @.ip varchar(15)
> declare @.cmd varchar(200)
> declare @.temp varchar(255)
> create table #ip(iptext varchar(255))
> If @.spid is null select @.host = host_name()
> else
> select @.host = max(hostname)
> from master.dbo.sysprocesses
> where spid = @.spid
> if @.host is not null
> begin
> set @.cmd = 'ping -n 1 ' + @.host
> insert #ip exec master..xp_cmdshell @.cmd
> select @.ip = ISNULL(substring(iptext,(charindex('[',iptext)+1),
> (charindex(']',iptext)-(charindex('[',iptext)+1))),'')
> from #ip
> where charindex('[',iptext)>0
> end
> drop table #ip
> select NULLIF(rtrim(@.host),'') as 'Hostname',
> rtrim(@.ip) as 'IP_Address'
> return
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "David B" <david.brough@.nygard.com> wrote in message
> news:02e401c39ffb$8a4c74e0$a401280a@.phx.gbl...
> Does anyone have a method of tracing a clients IP address
> from the SPID available inside SQL Server to the sp_who2
> command?
>
>
Client Hang
Hello,
We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3) that hangs our SQLServer Clients after starting a DTC transaction.
SQL Server service starts automatically at startup and it starts DTC.
?Does anybody know how to solve the problem and what is happening?
> Hello,
> We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3)
> that hangs our SQLServer Clients after starting a DTC transaction.
> SQL Server service starts automatically at startup and it starts DTC.
> ?Does anybody know how to solve the problem and what is happening?
>
It could be an MS DTC problem. You can use a tool named DTCPing to
troubleshoot MS DTC operation:
HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3) that hangs our SQLServer Clients after starting a DTC transaction.
SQL Server service starts automatically at startup and it starts DTC.
?Does anybody know how to solve the problem and what is happening?
> Hello,
> We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3)
> that hangs our SQLServer Clients after starting a DTC transaction.
> SQL Server service starts automatically at startup and it starts DTC.
> ?Does anybody know how to solve the problem and what is happening?
>
It could be an MS DTC problem. You can use a tool named DTCPing to
troubleshoot MS DTC operation:
HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Client Hang
Hello
We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3) that hangs our SQLServer Clients after starting a DTC transaction
SQL Server service starts automatically at startup and it starts DTC
¿Does anybody know how to solve the problem and what is happening?> Hello,
> We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3)
> that hangs our SQLServer Clients after starting a DTC transaction.
> SQL Server service starts automatically at startup and it starts DTC.
> ¿Does anybody know how to solve the problem and what is happening?
>
--
It could be an MS DTC problem. You can use a tool named DTCPing to
troubleshoot MS DTC operation:
HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3) that hangs our SQLServer Clients after starting a DTC transaction
SQL Server service starts automatically at startup and it starts DTC
¿Does anybody know how to solve the problem and what is happening?> Hello,
> We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3)
> that hangs our SQLServer Clients after starting a DTC transaction.
> SQL Server service starts automatically at startup and it starts DTC.
> ¿Does anybody know how to solve the problem and what is happening?
>
--
It could be an MS DTC problem. You can use a tool named DTCPing to
troubleshoot MS DTC operation:
HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Client Hang
Hello,
We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3) that h
angs our SQLServer Clients after starting a DTC transaction.
SQL Server service starts automatically at startup and it starts DTC.
?Does anybody know how to solve the problem and what is happening?
> Hello,
> We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3)
> that hangs our SQLServer Clients after starting a DTC transaction.
> SQL Server service starts automatically at startup and it starts DTC.
> ?Does anybody know how to solve the problem and what is happening?
>
--
It could be an MS DTC problem. You can use a tool named DTCPing to
troubleshoot MS DTC operation:
HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3) that h
angs our SQLServer Clients after starting a DTC transaction.
SQL Server service starts automatically at startup and it starts DTC.
?Does anybody know how to solve the problem and what is happening?
> Hello,
> We han a SQL Server Developer Edition (64-Bit) versión 8.00.760(SP3)
> that hangs our SQLServer Clients after starting a DTC transaction.
> SQL Server service starts automatically at startup and it starts DTC.
> ?Does anybody know how to solve the problem and what is happening?
>
--
It could be an MS DTC problem. You can use a tool named DTCPing to
troubleshoot MS DTC operation:
HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Client for SQL Server 7.0
Are either of the programs below full featured clients for SQL Server
7.0? I am having difficulty reindexing my database for the first time--
i.e. I get no feedback from the server from a dbcc dbreindex command.
It appears that my syntax is correct:
DBCC DBREINDEX(tablename,'',85)
The statement above returns "OK" (no error), but it executes in 0
seconds and appears to do nothing. I have gotten the same result using
both of the following as a client:
MS Access 2003 (through a project)
Database Fishing Tool (http://daft.sourceforge.net/)
Is it that I don't have the right client or am I missing something
else?
How many indexes do you have on this table?
SQL Query Analyzer (comes with SQL 7) is sufficient to run this command.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"aschrage16" <art.schrage@.gmail.com> wrote in message
news:1141139745.303817.76810@.i40g2000cwc.googlegro ups.com...
> Are either of the programs below full featured clients for SQL Server
> 7.0? I am having difficulty reindexing my database for the first time--
> i.e. I get no feedback from the server from a dbcc dbreindex command.
> It appears that my syntax is correct:
> DBCC DBREINDEX(tablename,'',85)
> The statement above returns "OK" (no error), but it executes in 0
> seconds and appears to do nothing. I have gotten the same result using
> both of the following as a client:
> MS Access 2003 (through a project)
> Database Fishing Tool (http://daft.sourceforge.net/)
> Is it that I don't have the right client or am I missing something
> else?
>
|||What does the output of DBCC SHOWCONTIG(tablename) show?
Andrew J. Kelly SQL MVP
"aschrage16" <art.schrage@.gmail.com> wrote in message
news:1141139745.303817.76810@.i40g2000cwc.googlegro ups.com...
> Are either of the programs below full featured clients for SQL Server
> 7.0? I am having difficulty reindexing my database for the first time--
> i.e. I get no feedback from the server from a dbcc dbreindex command.
> It appears that my syntax is correct:
> DBCC DBREINDEX(tablename,'',85)
> The statement above returns "OK" (no error), but it executes in 0
> seconds and appears to do nothing. I have gotten the same result using
> both of the following as a client:
> MS Access 2003 (through a project)
> Database Fishing Tool (http://daft.sourceforge.net/)
> Is it that I don't have the right client or am I missing something
> else?
>
|||That's what's led me through this search for a client. I have
repeatedly tried to run DBCC commands of several types (including DBCC
SHOWCONTIG, DBCC DBREINDEX, etc.) and I get no output back unless there
is an error in the syntax. Is there perhaps a setting somewhere in SQL
Server 7 that's hiding the output or something?
Andrew J. Kelly wrote:[vbcol=seagreen]
> What does the output of DBCC SHOWCONTIG(tablename) show?
> --
> Andrew J. Kelly SQL MVP
>
> "aschrage16" <art.schrage@.gmail.com> wrote in message
> news:1141139745.303817.76810@.i40g2000cwc.googlegro ups.com...
|||Have you tried using Query Analyzer or oSql? You may want to try and add
SET NOCOUNT ON before the DBCC command and send them as a batch.
Andrew J. Kelly SQL MVP
<aschrage16@.yahoo.com> wrote in message
news:1142264035.895114.18780@.u72g2000cwu.googlegro ups.com...
> That's what's led me through this search for a client. I have
> repeatedly tried to run DBCC commands of several types (including DBCC
> SHOWCONTIG, DBCC DBREINDEX, etc.) and I get no output back unless there
> is an error in the syntax. Is there perhaps a setting somewhere in SQL
> Server 7 that's hiding the output or something?
>
> Andrew J. Kelly wrote:
>
|||I tried SET NOCOUNT ON and sent it as a batch with the DBCC command...
no luck. I do not own SQL SERVER myself, but I asked my ISP to run the
following DBCC statement in Query Analyzer:
dbcc dbreindex('tablename','',85)
Here's the response he got from SQL Server:
28-Feb-2006 05:25:23
RUN took 0.0 seconds.
<c1>: OK.
This is the same response I got through my client and its the same
response I get from all DBCC commands. Takes 0.0 seconds and no output.
Andrew J. Kelly wrote:[vbcol=seagreen]
> Have you tried using Query Analyzer or oSql? You may want to try and add
> SET NOCOUNT ON before the DBCC command and send them as a batch.
> --
> Andrew J. Kelly SQL MVP
>
> <aschrage16@.yahoo.com> wrote in message
> news:1142264035.895114.18780@.u72g2000cwu.googlegro ups.com...
|||Ok, I tried oSql (actually sqlcmd) and I got output from dbcc
showcontig. I wonder what the deal is with the client programs I have
been using? Do you know where to get one that actually works? sqlcmd
seems to work, but its kind of cumbersome. Unfortunately, I don't own a
copy of SQL Server... I just want to remotely manage the SQL database
that is hosted by my ISP.
|||That output does not look like it is from QA. But one thing to note. If
you do not have a Clustered index on the table a reindex will not have
anything to do since it can not defragment a HEAP. Do you have a clustered
index?
Andrew J. Kelly SQL MVP
<aschrage16@.yahoo.com> wrote in message
news:1142360307.440893.80110@.i40g2000cwc.googlegro ups.com...
>I tried SET NOCOUNT ON and sent it as a batch with the DBCC command...
> no luck. I do not own SQL SERVER myself, but I asked my ISP to run the
> following DBCC statement in Query Analyzer:
> dbcc dbreindex('tablename','',85)
> Here's the response he got from SQL Server:
> --
> 28-Feb-2006 05:25:23
> RUN took 0.0 seconds.
> <c1>: OK.
> --
> This is the same response I got through my client and its the same
> response I get from all DBCC commands. Takes 0.0 seconds and no output.
>
> Andrew J. Kelly wrote:
>
|||The output was actually from the client I was using, but my ISP said
they got "the same thing", which I guess meant no output, or "OK" or
something.
I don't have a clustered index (I don't think). So that would make
sense then. Is DBCC INDEXDEFRAG meaningless then too?
|||Yes it is. If you have nonclustered indexes then you can run either on them
but you need to specify the index name. It will do nothing for the data
itself though. For that you need a clustered index. It is highly recommended
that every table have a clustered index and a Primary Key but any one of the
indexes or constraints can be clustered..
Andrew J. Kelly SQL MVP
<aschrage16@.yahoo.com> wrote in message
news:1142442108.215232.323050@.u72g2000cwu.googlegr oups.com...
> The output was actually from the client I was using, but my ISP said
> they got "the same thing", which I guess meant no output, or "OK" or
> something.
> I don't have a clustered index (I don't think). So that would make
> sense then. Is DBCC INDEXDEFRAG meaningless then too?
>
7.0? I am having difficulty reindexing my database for the first time--
i.e. I get no feedback from the server from a dbcc dbreindex command.
It appears that my syntax is correct:
DBCC DBREINDEX(tablename,'',85)
The statement above returns "OK" (no error), but it executes in 0
seconds and appears to do nothing. I have gotten the same result using
both of the following as a client:
MS Access 2003 (through a project)
Database Fishing Tool (http://daft.sourceforge.net/)
Is it that I don't have the right client or am I missing something
else?
How many indexes do you have on this table?
SQL Query Analyzer (comes with SQL 7) is sufficient to run this command.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"aschrage16" <art.schrage@.gmail.com> wrote in message
news:1141139745.303817.76810@.i40g2000cwc.googlegro ups.com...
> Are either of the programs below full featured clients for SQL Server
> 7.0? I am having difficulty reindexing my database for the first time--
> i.e. I get no feedback from the server from a dbcc dbreindex command.
> It appears that my syntax is correct:
> DBCC DBREINDEX(tablename,'',85)
> The statement above returns "OK" (no error), but it executes in 0
> seconds and appears to do nothing. I have gotten the same result using
> both of the following as a client:
> MS Access 2003 (through a project)
> Database Fishing Tool (http://daft.sourceforge.net/)
> Is it that I don't have the right client or am I missing something
> else?
>
|||What does the output of DBCC SHOWCONTIG(tablename) show?
Andrew J. Kelly SQL MVP
"aschrage16" <art.schrage@.gmail.com> wrote in message
news:1141139745.303817.76810@.i40g2000cwc.googlegro ups.com...
> Are either of the programs below full featured clients for SQL Server
> 7.0? I am having difficulty reindexing my database for the first time--
> i.e. I get no feedback from the server from a dbcc dbreindex command.
> It appears that my syntax is correct:
> DBCC DBREINDEX(tablename,'',85)
> The statement above returns "OK" (no error), but it executes in 0
> seconds and appears to do nothing. I have gotten the same result using
> both of the following as a client:
> MS Access 2003 (through a project)
> Database Fishing Tool (http://daft.sourceforge.net/)
> Is it that I don't have the right client or am I missing something
> else?
>
|||That's what's led me through this search for a client. I have
repeatedly tried to run DBCC commands of several types (including DBCC
SHOWCONTIG, DBCC DBREINDEX, etc.) and I get no output back unless there
is an error in the syntax. Is there perhaps a setting somewhere in SQL
Server 7 that's hiding the output or something?
Andrew J. Kelly wrote:[vbcol=seagreen]
> What does the output of DBCC SHOWCONTIG(tablename) show?
> --
> Andrew J. Kelly SQL MVP
>
> "aschrage16" <art.schrage@.gmail.com> wrote in message
> news:1141139745.303817.76810@.i40g2000cwc.googlegro ups.com...
|||Have you tried using Query Analyzer or oSql? You may want to try and add
SET NOCOUNT ON before the DBCC command and send them as a batch.
Andrew J. Kelly SQL MVP
<aschrage16@.yahoo.com> wrote in message
news:1142264035.895114.18780@.u72g2000cwu.googlegro ups.com...
> That's what's led me through this search for a client. I have
> repeatedly tried to run DBCC commands of several types (including DBCC
> SHOWCONTIG, DBCC DBREINDEX, etc.) and I get no output back unless there
> is an error in the syntax. Is there perhaps a setting somewhere in SQL
> Server 7 that's hiding the output or something?
>
> Andrew J. Kelly wrote:
>
|||I tried SET NOCOUNT ON and sent it as a batch with the DBCC command...
no luck. I do not own SQL SERVER myself, but I asked my ISP to run the
following DBCC statement in Query Analyzer:
dbcc dbreindex('tablename','',85)
Here's the response he got from SQL Server:
28-Feb-2006 05:25:23
RUN took 0.0 seconds.
<c1>: OK.
This is the same response I got through my client and its the same
response I get from all DBCC commands. Takes 0.0 seconds and no output.
Andrew J. Kelly wrote:[vbcol=seagreen]
> Have you tried using Query Analyzer or oSql? You may want to try and add
> SET NOCOUNT ON before the DBCC command and send them as a batch.
> --
> Andrew J. Kelly SQL MVP
>
> <aschrage16@.yahoo.com> wrote in message
> news:1142264035.895114.18780@.u72g2000cwu.googlegro ups.com...
|||Ok, I tried oSql (actually sqlcmd) and I got output from dbcc
showcontig. I wonder what the deal is with the client programs I have
been using? Do you know where to get one that actually works? sqlcmd
seems to work, but its kind of cumbersome. Unfortunately, I don't own a
copy of SQL Server... I just want to remotely manage the SQL database
that is hosted by my ISP.
|||That output does not look like it is from QA. But one thing to note. If
you do not have a Clustered index on the table a reindex will not have
anything to do since it can not defragment a HEAP. Do you have a clustered
index?
Andrew J. Kelly SQL MVP
<aschrage16@.yahoo.com> wrote in message
news:1142360307.440893.80110@.i40g2000cwc.googlegro ups.com...
>I tried SET NOCOUNT ON and sent it as a batch with the DBCC command...
> no luck. I do not own SQL SERVER myself, but I asked my ISP to run the
> following DBCC statement in Query Analyzer:
> dbcc dbreindex('tablename','',85)
> Here's the response he got from SQL Server:
> --
> 28-Feb-2006 05:25:23
> RUN took 0.0 seconds.
> <c1>: OK.
> --
> This is the same response I got through my client and its the same
> response I get from all DBCC commands. Takes 0.0 seconds and no output.
>
> Andrew J. Kelly wrote:
>
|||The output was actually from the client I was using, but my ISP said
they got "the same thing", which I guess meant no output, or "OK" or
something.
I don't have a clustered index (I don't think). So that would make
sense then. Is DBCC INDEXDEFRAG meaningless then too?
|||Yes it is. If you have nonclustered indexes then you can run either on them
but you need to specify the index name. It will do nothing for the data
itself though. For that you need a clustered index. It is highly recommended
that every table have a clustered index and a Primary Key but any one of the
indexes or constraints can be clustered..
Andrew J. Kelly SQL MVP
<aschrage16@.yahoo.com> wrote in message
news:1142442108.215232.323050@.u72g2000cwu.googlegr oups.com...
> The output was actually from the client I was using, but my ISP said
> they got "the same thing", which I guess meant no output, or "OK" or
> something.
> I don't have a clustered index (I don't think). So that would make
> sense then. Is DBCC INDEXDEFRAG meaningless then too?
>
Subscribe to:
Posts (Atom)