dbTalk Databases Forums  

Maintenance and Impersonation?

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools Maintenance and Impersonation?

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Maintenance and Impersonation? in the microsoft.public.sqlserver.tools forum.



Reply
Page 3 of 3 < 1 2 3
 
Thread Tools Display Modes
  #21  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Maintenance and Impersonation? - 06-23-2008 , 05:13 PM





coconet (coconet (AT) community (DOT) nospam) writes:
Quote:
When I Execute the maintenance plan, it fails with this error embedded
in the log text:

xp_create_subdir() returned error 123, 'The filename,
directory name, or volume label syntax is incorrect.'

Which sounds like a permissions problem to me.
That sounds like a syntax problem to me. For instance, if I try this
in a command-line window:

mkdir :

I get:

The filename, directory name, or volume label syntax is incorrect.

What is the name of the database? Does it include any special characters?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #22  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Maintenance and Impersonation? - 06-23-2008 , 05:13 PM





coconet (coconet (AT) community (DOT) nospam) writes:
Quote:
When I Execute the maintenance plan, it fails with this error embedded
in the log text:

xp_create_subdir() returned error 123, 'The filename,
directory name, or volume label syntax is incorrect.'

Which sounds like a permissions problem to me.
That sounds like a syntax problem to me. For instance, if I try this
in a command-line window:

mkdir :

I get:

The filename, directory name, or volume label syntax is incorrect.

What is the name of the database? Does it include any special characters?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #23  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Maintenance and Impersonation? - 06-23-2008 , 05:13 PM


coconet (coconet (AT) community (DOT) nospam) writes:
Quote:
When I Execute the maintenance plan, it fails with this error embedded
in the log text:

xp_create_subdir() returned error 123, 'The filename,
directory name, or volume label syntax is incorrect.'

Which sounds like a permissions problem to me.
That sounds like a syntax problem to me. For instance, if I try this
in a command-line window:

mkdir :

I get:

The filename, directory name, or volume label syntax is incorrect.

What is the name of the database? Does it include any special characters?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #24  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Maintenance and Impersonation? - 06-23-2008 , 05:13 PM


coconet (coconet (AT) community (DOT) nospam) writes:
Quote:
When I Execute the maintenance plan, it fails with this error embedded
in the log text:

xp_create_subdir() returned error 123, 'The filename,
directory name, or volume label syntax is incorrect.'

Which sounds like a permissions problem to me.
That sounds like a syntax problem to me. For instance, if I try this
in a command-line window:

mkdir :

I get:

The filename, directory name, or volume label syntax is incorrect.

What is the name of the database? Does it include any special characters?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #25  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Maintenance and Impersonation? - 06-23-2008 , 05:13 PM


coconet (coconet (AT) community (DOT) nospam) writes:
Quote:
When I Execute the maintenance plan, it fails with this error embedded
in the log text:

xp_create_subdir() returned error 123, 'The filename,
directory name, or volume label syntax is incorrect.'

Which sounds like a permissions problem to me.
That sounds like a syntax problem to me. For instance, if I try this
in a command-line window:

mkdir :

I get:

The filename, directory name, or volume label syntax is incorrect.

What is the name of the database? Does it include any special characters?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #26  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Maintenance and Impersonation? - 06-23-2008 , 05:13 PM


coconet (coconet (AT) community (DOT) nospam) writes:
Quote:
When I Execute the maintenance plan, it fails with this error embedded
in the log text:

xp_create_subdir() returned error 123, 'The filename,
directory name, or volume label syntax is incorrect.'

Which sounds like a permissions problem to me.
That sounds like a syntax problem to me. For instance, if I try this
in a command-line window:

mkdir :

I get:

The filename, directory name, or volume label syntax is incorrect.

What is the name of the database? Does it include any special characters?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #27  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Maintenance and Impersonation? - 06-23-2008 , 05:13 PM


coconet (coconet (AT) community (DOT) nospam) writes:
Quote:
When I Execute the maintenance plan, it fails with this error embedded
in the log text:

xp_create_subdir() returned error 123, 'The filename,
directory name, or volume label syntax is incorrect.'

Which sounds like a permissions problem to me.
That sounds like a syntax problem to me. For instance, if I try this
in a command-line window:

mkdir :

I get:

The filename, directory name, or volume label syntax is incorrect.

What is the name of the database? Does it include any special characters?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
  #28  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Maintenance and Impersonation? - 06-23-2008 , 05:13 PM


coconet (coconet (AT) community (DOT) nospam) writes:
Quote:
When I Execute the maintenance plan, it fails with this error embedded
in the log text:

xp_create_subdir() returned error 123, 'The filename,
directory name, or volume label syntax is incorrect.'

Which sounds like a permissions problem to me.
That sounds like a syntax problem to me. For instance, if I try this
in a command-line window:

mkdir :

I get:

The filename, directory name, or volume label syntax is incorrect.

What is the name of the database? Does it include any special characters?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx


Reply With Quote
Reply
Page 3 of 3 < 1 2 3

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top