Mohammed means that you use Client Network Utility (cliconfg) and specify the port for TCP/IP alias if you use TCP/IP. Or you may just create a named pipes alias. In...

Where the name and the password are stored? Could it be that on Windows 2000 computer these values are not configured? What is the front end?

For example, if the app...

This is great! 400K members! This is almost half a million.

Thanks so much for putting me on the list. I wish I could spend more time here  with my friends...

Can you just do:

Select Count(fieldname) from myTable?

select

count(*), count(addressline2) from Person.Address

returns from AdventureWorks database:

19614      362

Count(*) returns the number of all rows, and...

http://www.officekb.com/

I found it as a link from http://www.accessmonster.com that I use for my MS ACCESS questions.

Make sure you enter the extension without a dot like TRN and not .TRN

Also make sure that the Agent account or a proxy account if you are not a sysadmin,...

I don't understand the question. Looks like it mixed up the REMOTE and LOCAL definitions. Remote is the server that is linked to the local server and we are execuiting...

Don't you love error messages about Management Tools?

Figured it out: it was Integration Services that was not installed.

I can not create a plan at all on my 64 bit mirrored. I will post this now as a separate question on this forum

The correct answer is not exactly correct. It should be 2 of them beacuse Agent is using SQL Server Agent Mail which in turn can be configured to use either...

You probably have a custom log shipping process. It could be that users somehow are connected to the database if it is in the Standby mode and that is why...

If you have this amount of data it is possible that there are older and newer files. I would ask 2 questions before designing:

- Do we need all data to...

INSTEAD OF triggers do something instead of the intended action. You may try to custom-code your something to include your Image column. Instead Of triggers are not nested, so if your insert triggered...

See Using Char and Varchar Data in Books Online. It depends on Null or not Null column and on ANSI_PADDING settings:

This return right(mychar,4) as an empty string and right(mychar,5) as...