Interesting. Have you attempted to duplicate your results?

Andy

Havent tried it on Me, don't have a copy installed. Are you sure you have disk permissions for that folder?

Andy

I dont think so. You'd have to execute it as dynamic SQL using Exec().

Andy

Just right click on the server name in EM, look at the security tab - you can change it there.

Andy

Can you connect using Query Analyzer? Can you ping the machine? Try connecting using the IP address instead of the machine name.

Andy

We had just found this also - turns out we may have a supply of them on hand. Give me a day to make sure, if we do we'll send...

Not with SQL 7 - SQL 2000 behaves much better. I think Brian Knight has an article posted here on the site about it.

Andy

If you can open the view, then you can use the 'select into' syntax to create a table on the fly or just do an insert into an existing table.

Andy

...

Hey Paul - don't know much about Oracle, but have you looked at this article?

http://support.microsoft.com/support/kb/articles/Q240/3/40.ASP

Andy

Doug, its hard to sum up in a few word - or even if a few books! SQL Server (and Oracle) are a bit different from some databases (Access, maybe...

I don't know a thing about Unix! But still, the point is that you need some type of communication method. A VERY simple way would be to have your job...

I think you'll see this as a result of a service pack thats been applied since the backup.

Andy

Hey Bill,

I don't have 7.0 installed, works fine on 2000. My guess is that you've got some logins that don't have a default database assigned. Try running this query to...

Email it to Steve (email address above). Any problems with making it available for everyone to look at? We can upload to the site and post a link here.

Andy

Not sure what you're asking for. You could do this:

declare @dbname varchar(128)

set @dbname=db_name()

Andy