REASON 1

Unless you specify "Change Default Database to" in ODBC source you have to set a default database for your user domainhere\meAsUser to your database. Then you have to re-link...

SET LANGUAGE statement wil allow you to enter dates with the day first then  month if the language is German. I don't think SQL Server supports input numbers with commas...

http://support.microsoft.com/kb/174943/EN-US/

PRB: 80004005 "Couldn't Use '(unknown)'; File Already in Use"

Oledb and ODBC could return differently worded messages, also message may vary based on the access...

Sure!

I install SQL Server program files on C and Data Files on the Data Drive. I do have installations where the system databases are on the C: drive but I...

Oh yes, sure, it will run for sysadmins....

I have a similar problem with one of my apps where I coded something that opens 3 connections to MS ACCESS database...

Angelindiego,

sp_MSforeachdb is Undocumented Stored Procedure and as such is in the article on this site by Alexander Chigrik

http://www.sqlservercentral.com/columnists/achigrik/sql2000.asp

SQL Server 2000 Useful Undocumented Stored Procedures

He has good descriptions for this...

I think you can query servers for each database as:

Select * from sysusers where SID = (Select SID from syslogins where name = 'previous sysadmin login name goes here') and...

Hello Angelindiego,

If you open sp_helpdb stored procedure on master database you will see that the line 53 is around this statement:

Insert into #spdbdesc (dbname, owner, created, dbid, cmptlevel)

  select name, suser_sname(sid), convert(nvarchar(11),...

How do you normally access this view?

Additionally:

I was able to use Change Computer link in the Surface Area Configuration Tool to connect to SQL Server 2005 from my workstation.

I was getting the same error message when...

When you click Read More in the Surface Area Configuration Tool it shows a page on the tool that refers to this Books Online Article. I wonder if it helps:

Debbie,

Sure! somebody who is looking on your stuff locally will be in better position to modify your code, we here can only give a general advice.

one correction: I automatically copied...

Debbie,

such a good job on the SP!

Now I understand that you need to insert the dynamic file name for the rows that were imported with each pass of the  While...

Debbie,

Could you post a part of the procedure that gets a file. You should have specified the file name for the source file. Are you providing the file name as...

???

I will try it tomorrow.

Did you try to connect from the same Management Studio just registering the server twice, once with Integrated Windows and one with SQL Server Standard...