Unless the machine is Windows 98 or prior, it can still have multiple logon accounts.  The key is what account is the program running under.  If it is being run...

If you are looking for info about errors in Event log, or for errors from SQL Server 2005, this site is very handy:

http://www.microsoft.com/technet/support/ee/ee_advanced.aspx

If you are looking for SQL Server...

I have had this when I was a dbowner, but not in sysadmin role.  I could only view properties, but could not change them.

(Another) Mark

You do not have any SQL Servers registered for the current user (which ever the user is when the program is run).  If you open SQL Server Enterprise Manager when...

Just a followup on item 2):  According to Breaking Changes to Database Engine Features in SQL Server 2005 , clients using MDAC versions prior to 2.6 cannot connect to named...

On a number of applications, I have just distributed the MDF file. Especially if this is for a database used by just your application, this may be appropriate.  For a couple...

Did you check this?

You receive error 7391 when you run a distributed transaction against a linked server

http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql

I don't have an answer why, but you may want to try to alias the table in the query:

SET @qry = 
'SELECT * FROM ' + @tablename + ' t...

Varchar can be as large as 8000 characters, so just changing them to 2000 should not be a problem, depending on how much data you actually will store in the...

To follow-up on Paul's explanations:

If Mike performs "select * from T1", he will access the [dbo].[T1] table.  If he wants to access [kevin].[T1], Mike has to qualify the table name...

Probably a little more information in the answers might be helpful.

1)  Installing SQL Server 2005 as the default instance will upgrade your SQL Server 2000 default instance.  If that is...

Not being a C++ developer (nor do I even play one on TV), I don't know exactly what is available for C++, but I can point you to a couple...

How about:

insert #t2 (lname, fname, mname)
select 
LEFT(#t1.name, CHARINDEX(',',#t1.name)-1) as lname, 
CASE WHEN CHARINDEX(' ',REVERSE(#t1.name)) > 0 THEN RIGHT(#t1.name, CHARINDEX(' ',REVERSE(#t1.name))-1) END as mname,
CASE WHEN CHARINDEX(' ',REVERSE(#t1.name)) > 0 
 ...

How about:

update ss_comments set
comments = a.comments
from ss_comments s inner join ac_course_comments a
on s.course_code = a.course_id

You can only update one table in an Update statement.  Use the FROM clause to do...

Depending on your disk architecture, I might add to Steve's suggestion to make the File Growth increment an appropriate size.  If it is too small, then you will end up...