View Complete Post
I am trying to execute a simple command via a job. The job step is of type "Operating System". The following is the command:
sqlcmd -Q "select * from sys.databases" -E -S <ServerName> -o %SQLJobRoot%\test3.txt
%SQLJobRoot% is defined on my server as a directory. I can execute this fine via XP_CMDSHELL. SQL Service and SQL Agent are running with the same account. The following works fine via a job: "DIR > %SQLJobRoot%\test3.txt"
Yet when I try to run the SQLCMD I get the error:
Executed as user: <DOMAIN\Account>. Sqlcmd: Error: Error occurred while opening or operating on file %SQLJobRoot%\test3.txt (Reason: The system cannot find the path specified). Process Exit Code 1. The step failed.
I am not looking for a workaround because we already have one but I just want to know why is it not possible to use environment variables in this case?
How do I change the environment variables as in this statement :
in the environment variables change both the TEMP and the TMP from the x:\documents and Settings\user\...
To c:\Temp or any other folder
I have a web application in which i need to logout the user if he clicks the logout button or even if he closes his browser window. On Logout button click, i am doing session.Abandon(), but how to go about his browser window close.
Can anybody help with a code sample.
I am building a small application that can
1. Dynamically load 2 text boxes on a web form
2. Build a logic on those textboxes in IronPython to sum them and return the result.
3. I have already built a IPY script that does some opearions on a static text boxes. How to build a script on the dynamic textboxes?
This month we explain how pseudo variables and format specifiers provide a wealth of information for use in debugging.
MSDN Magazine December 2008
One of the many great features of the .NET Framework is that it has asynchronous infrastructure built in. In .NET you can call any method asynchronously by defining a delegate for the method and calling the delegate's asynchronous methods. This is beneficial to your application because when a synchronous call is made, the calling thread is blocked until the method completes whereas an asynchronous call is made on a different thread, and this allows the original thread to continue its work while the asynchronous call is in progress.This article explains delegates in .NET and how to use them to perform asynchronous calls, eliminating age-old threading problems.
MSDN Magazine August 2001
MSDN Magazine May 2001
This article provides an overview of writing applications for Windows CE 3.0. Unicode support in Windows CE, the kernel, memory management, the object store, and COM and DCOM are discussed. The article also covers the user interface, graphics, the Internet, and how Windows CE compares to the desktop in each of these areas. eMbedded Visual Tools 3.0 is discussed in depth. To help the reader decide which tools to use, development with Visual Basic, Win32, MFC, and ATL are explained. Text editor samples with this article have been developed with Visual Basic and Win32 so their implementations can be compared.
MSDN Magazine January 2001
MSDN Magazine November 2000
MSDN Magazine October 2000
MSDN Magazine September 2000
MSDN Magazine March 2000
We developed an InfoPath form using a local DEV environment. The site collection under which the form was developed was
We are now attempting to deploy this form to a TEST environment that uses a slightly different structure for the collection, namely
In both cases the site that contains the form is /fin (so we were using
http://server1/fin in DEV and want to use
http://server2/sites/sitecol1/fin in TEST).
The form contains VBA code and so requires admin-based deployment via Central Administration, so to deploy to TEST we:
1. Publish the form against the TEST server using InfoPath Designer
2. Upload the form using Central Administration > Application Managment > Manage Form Templates
3. After upload, we activate the form for the site collection
4. The form is then associated with a Form Library
When we try to create an instance of the form within this library we get the following error when we click on New to create the form instance:
The following location is not accessible, because it is in a differ
We have installed Reporting Services 2008 integrated with MOSS with SQL Server 2008 on a 64 bit platform.
The environment has worked fine in test (but the servers are not hardend).
With the production environment, any attempt to export from a report into another format (eg excel, tiff etc) results in an unexpected error within SharePoint requiring closing the browser and reopening.
There are no details behind the error. We can also find no traces of the error within any of the logs (SharePoint, Reporting Services, Windows event log etc)
When the report is opened directly from Reporting Services (ie
http://servername:8080/reportserver) the report exports fine. Similarly, if the report is opened directly from Report Builder 2, or through opening Report Builder 2 from SharePoint there is no issue. This issue
only happens when the report is invoked directly through SharePoint.
We can only assume that this issue has something to do with server hardening/UAC as we have
I have a dedicated SQL 2008 x64 std edtion with SP1 for MOSS 2007 SP2, I would like to apply the CU2 for activating the lock memory page feature, I would like to know if there any incidence on the sharepoint farm after applying this CU on my SQL server?
Thank you for your feedback about that.