CLUSTER NAME

Hi ,
is there any command to display current cluster name through query .
Thanks
ARR
C:\>Cluster /list:[DomainName]
Displays a list of clusters in the computer's domain or a specified domain.
You can use xp_cmdshell to run it in QA.
Ayad Shammout
SR.DBA/Analyst
Caregroup IS
"Aju" <ajuonline@.yahoo.com> wrote in message
news:e5fOYDLGFHA.936@.TK2MSFTNGP12.phx.gbl...
> Hi ,
> is there any command to display current cluster name through query .
> Thanks
> ARR
>

cluseter name (virtual server name)

Hi ,
is there any command to display current cluster name through query .
Thanks
ARR
Aswered in this NG: xp_readreg thread
Regards
Mike
"Aju" wrote:

> Hi ,
> is there any command to display current cluster name through query .
> Thanks
> ARR
>
>

cluseter name (virtual server name)

Hi ,
is there any command to display current cluster name through query .
Thanks
ARRAswered in this NG: xp_readreg thread
Regards
Mike
"Aju" wrote:

> Hi ,
> is there any command to display current cluster name through query .
> Thanks
> ARR
>
>

cluseter name (virtual server name)

Hi ,
is there any command to display current cluster name through query .
Thanks
ARRAswered in this NG: xp_readreg thread
Regards
Mike
"Aju" wrote:
> Hi ,
> is there any command to display current cluster name through query .
> Thanks
> ARR
>
>

CLR test script SELECT returns no row data

Hi,

The test.sql scripts I write to test CLR stored procedures run successfully, but when I want to display the resulting data in the database with a simple "SELECT * from Employee"

I get the result as:
Name Address
- -
No rows affected.
(1 row(s) returned)

But not the actual row is displayed whereas I would expect to see something like:

Name Address
- -
John Doe
No rows affected.
(1 row(s) returned)

I have another database project where doing the same thing displays the row information but there doesn't seem to be a lot different between the two.

Why no results in first case?

Thanks,
Bahadir
You maybe still have the transaction open and uncommitted, thats why you don′t see the actual row.

HTH; Jens SUessmeyer.

http://www.sqlserver2005.de

Client Side Cursor vs Sever Side Cursor?

I having a difficult time here trying to figure out what to do here.
I need a way to scroll through a recordset and display the results
with both forward and backward movement on a web page(PHP using
ADO/COM)..

I know that if I use a client side cursor all the records get shoved
to the client everytime that stored procedure is executed..if this
database grows big wont that be an issue?..

I know that I can set up a server side cursor that will only send the
record I need to the front end but..

Ive been reading around and a lot of people have been saying never to
use a server side cursor because of peformance issues.

So i guess im weighing network performance needs with the client side
cursor vs server performance with the server side cursor..I am really
confused..which one should I use?

-JimJim:

> I having a difficult time here trying to figure out what to do here.
> I need a way to scroll through a recordset and display the results
> with both forward and backward movement on a web page(PHP using
> ADO/COM)..

Not sure why you would need anything else other than a forward only
recordset on a website. Unless you are planning on persisting the recordset
for the session and then navigating back and forth thru it.

> I know that if I use a client side cursor all the records get shoved
> to the client everytime that stored procedure is executed..if this
> database grows big wont that be an issue?..

Please note that your "Client" in this case would be the web server and not
the actual end users browser.

> Ive been reading around and a lot of people have been saying never to
> use a server side cursor because of peformance issues.

Does your web server (IIS or Apache) reside on the same physical server as
the database?. I would think that the performance issues would come from the
network trip hit. But if the web server and database are on the same
physical server, then this wouldn't matter.

Personally, I don't like the idea of returning 1,000,000 records just to
display 20 at a time. Nor do I think you can keep a connection/recordset
alive in between web pages without severaly affecting scalability.

You may want to do a search on this newsgroup thru google groups for other
paging techniques that will return only the results the user needs.

HTH,

BZ

"Jim" <jim.ferris@.motorola.com> wrote in message
news:729757f9.0312181931.4e4bba84@.posting.google.c om...
> I having a difficult time here trying to figure out what to do here.
> I need a way to scroll through a recordset and display the results
> with both forward and backward movement on a web page(PHP using
> ADO/COM)..
> I know that if I use a client side cursor all the records get shoved
> to the client everytime that stored procedure is executed..if this
> database grows big wont that be an issue?..
> I know that I can set up a server side cursor that will only send the
> record I need to the front end but..
> Ive been reading around and a lot of people have been saying never to
> use a server side cursor because of peformance issues.
> So i guess im weighing network performance needs with the client side
> cursor vs server performance with the server side cursor..I am really
> confused..which one should I use?
> -Jim

Client Logo is not display on client computer

We are using Crystal Report 11 with ASP.Net 2005 and Sql Server 2005 as database.
When the application is deployed to a client computer and the report is previewed, the report appears but the Client Logo (JEPG Imange) do not.
in place of logo it is displaying cross.

Kindly help me to solve this problem as soon as possible

Regards
Amit JoshiIs it a client server application.

If yes, you need to put the picture on client machine as well or access it from server.

check out the path you specified for image.

Hope this Helps you.|||Thanx for reply.
No This is web based application. while testing it was woking fine in test server but after deploy on client PC (UK) it client logo is not showing.

Kindly help to solve this..

Regards
Amit|||Thanx for reply.
No This is web based application. while testing it was woking fine in test server but after deploy on client PC (UK) it client logo is not showing.

Kindly help to solve this..

Regards
Amit

I would say 90% that it's going to be the file path. either the client PC can't see it or it can't access it.

Check you server logs for 404 errors coming from the client.