Thank you very much John!

Are DDL triggers available in SQL 2000?

1.) Mention the servername in a fully-qualified domain name (FQDN) format or use ip address.

2.) Try changing the protocols, its better to use TCP/IP port.

Try connect using [servername,portnumber]

in...

Is this the link?

http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerberr.mspx

We are having the same problem.

http://www.microsoft.com/technet/pro.../tkerberr.mspx

this link doesn't work!!

The application is using different sqlUserID and password, so it should be OK.

Thanks Greg,

I have changed the database owner and everything seems fine so far.

Hi all,

Application calls SP1 for result set

and

calls SP2 for how many results from SP1

This application is kind of reporting tool. Even though two SP sounds they are related, they are...

Hi,

Thank you for the reply.

However, the application which calls those procedures need both of them explicitly.

Which means,

Application needs

SP1 to get the result set

SP2 to get how many of them

Any...

Thanks

I set the same configurations on the client side (cliconfg.exe)

For the new instance (Test Instance), client can connect to the server via Named pipes.

I could not get the connection working...

I definitely agree!!

I fixed the problem as following:

Start>All Programs>Microsoft SQL Server>Server Network Utility

Named pipes>Properties>

Changed path into previous settings.

My problem is I can see the instance on the server locally but I cannot...

Thank you for the advice, it was helpful.

The client-side is very thin, it doesn't hold any component except a pointer to the application which is running on the server side.

I...

Now, I need also [Balance] field in the view. Since [AmountIn] and [AmountOut] are not a physical fields, I cannot do something like this:

Can anyone help me with this?

SELECT

CASE...