One little give away is "Error:  -2147467259 (80004005); " this is usually a generic 'Access Denied' type message which indicates a permission problem.

Never was successful using SELECT * in the query. Here's what we use for Win 2K3 Active Directory.

 SELECT 
  AD.[SAMAccountName] as [Account]
  , AD.[givenName] as [GivenName]
  , AD.[SN] as [Surname]
  , AD.[title] as [Title]
  ,...

Mr Sufi

At the risk of increasing my post count once more.

You presented your problem, we gave a solution, you didn't like our solution...

Come on I've got 14 days ... I reckon a concerted effort to flood the forums with 200 messages per day should see me well on the way to surpassing...

You can type the full UNC path and file into the appropriate dialog in EM, you just can't browse for the file

Also, can...

Hey Sufi, If anyone is working on increasing their post count it must be you. How many posts have you contirbuted to the community with no actual useful solution yet...

We use a product called Servers Alive.

http://www.woodstone.nu/salive/index.asp

Works pretty well and is very inexpensive as well.

You should also take a look at this best practices article,

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_busintbpwithdts.asp

Some of it is specific to Analysis Services, but the DTS parts are worth their weight in gold.

Why should I stop posting here? Have you got something to hide from the rest of the forum members? Is your discovery so profound that no-one else is worthy of...

Mr. Phili,

u asked me this (So what is the exact syntax you used for the shrink command?)

It is funny. Good carry with ur postes.I think ur are intrested...

You cannot use mapped drives in SQL Server, even if you are logged in using the same account.

UNC names work if the SQL Server services are running under a...

You could implement you're own log shipping with out the added expense of upgrading to Enterprise edition.

If you break down the tasks that are performed in log shipping it becomes...

When you're executing the command, are you logged on as a user with dbo permissions, or as this user hov?

You could try qualifying the name of the table in the...

But Mike what about his other post where he claims to have found the solution and wants to know if he should post it?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=120&messageid=196219

You should use UNC filenames. EG: \\ClientMachine\ClientShare\ClientFile.txt