It could be a number of issues the things i would check would be.

--Make sure you have the correct password

-- Make sure your account has access to the server.

-- Check...

The error log will not be on your PC, but on the Linked server that is rejecting your connection.

Make sure that you use a Unicode data type for your Description field, and when you insert the data use the leading unicode N.

http://msdn.microsoft.com/en-us/library/aa223981(SQL.80).aspx

Check the SQL error log on the server that you are trying to connect to , this will give you a more detailed description on why the login failed..

you can use sp_cycle_errorlog...

Do you mean the transaction log? or one of the error logs or maybe something else?

there are some good questions (and answers) here.

http://www.mssqltips.com/tip.asp?tip=1299

But I agree with what the others have said that learning Q+As will only get you so far, ...

Krishna Potlakayala (6/8/2009)

---

Vani (6/5/2009)

---

There was a discussion in my company with one group holding the view that Database Mirroring could not be deployed in production in SQL Server 2005.

Has...

Sumanta Roy (6/8/2009)

---

Hi,

The transaction log backup of the user databse has taken the almost disk space(size 122GB). The datbase recovery model is set to full. What is the best and...

Are you using a Witness?

do you have the fail-over partner defined the conneciton string of the application?

try using UNION

SELECT ClientId, ClientName, Versionsource

FROM YourTable

WHERE Versionsource = 'Manual'

Union

SELECT ClientId, ClientName, 'Auto' as Versionsource

FROM YourTable

WHERE Versionsource 'Manual'

What account is SQL server/agent running under is it a local or domain account?

Yes we have been using it succesfully in production for over a year, the warning that it was not ready was fixed since sp1

you can use the COALESCE function in SQL server to perform a simliar opertion to Nz

select coalesce(FieldName,'NewValue')

http://msdn.microsoft.com/en-us/library/ms190349.aspx

have you have a look at the index fragmentation? as this could cause issues over time as data is entered