No, formatting fixed length fields needs to be done by a using format file or by the table structure. The BCP command is inserted into a scheduled job as a...

http://msdn.microsoft.com/en-us/library/ms162802.aspx

BCP is a command line utility used to transfer data from SQL to text files. It is supported by SQL and the exe is located in the BIN...

The datatype of the table was nvarchar. I changed datatype in table to varchar, and used bcp export utility.

Now I have to enter 6 comments 😉 that's what happens when you see the glass half full! 😀

Thank you for the help. I think we have a solution to the fixed length export. Your example can help for ad hoc exports. 😀

I tested with bcp utility and have a result to test. If it doesn't work, I will try your

method. Can you print a small sample select statement?

I will ensure that Standard can be installed on a server where Enterprise is already present and Enterprise can be uninstalled where Standard exists. Has anyone successfully completed that?

I am considering a side/by/side migration from SQL 2000 Enterprise to SQL 2005 Standard on the same hardware platform, if that is possible. I plan to set up a VM...

exec xp_cmdshell 'cd' --> this will return the current directory

exec xp_cmdshell 'echo %PATH%...

Quality is difficult to measure because environments are dynamic. "Quality" code can be useful and correct one day and wrong the next. It can be applied to code design to...

I was able to pull the .mdf, .ldf and .bak information out of the tables specified. Thanks to all for the quick answers. I should be able to watch database...

Thank you, that is a solution for DB size and to track growth. i will be using this for overall DB monitoring.

I am also interested in managing hard drive resources...

Thanks. I am able to use the new SQL Job Scripter. Nice utility! It is quick and easy to use and saved me development time.:)

Shivaram,

I downloaded the 3 executables for automating job scripting and received an error on each install that states:

Unable to install or run the application. the application requires that assembly Microsoft.SqlServer.ConnectionInfo...

Steve,

Thank you. I use this site as a source for information frequently and find it very helpful. I am new to the forum and enjoy reading QOD daily. I appreciate...