Schedule SQL job to run and export to CSV file
Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!

Answer Question   |  May 8, 2013  11:45 PM
CSV, SQL Jobs, SSMS 2008

Error Message in SQL Server 2008 code.
Hi, I am currently going through the Tutorials on SQL Server Management Studio 2008 R2. One of the samples instructs me to run the following code: SELECT  Mgr.EmployeeID AS MgrID, Mgr.LoginID AS Manager,  Emp.EmployeeID AS E_ID, Emp.LoginID, FROM EmployeeDemo AS Emp LEFT JOIN EmployeeDemo AS Mgr ON Emp.ManagerID = Mgr.EmployeeID ORDER BY MgrID, E_ID; [em]When [...]

Answer Question   |  March 31, 2012  11:20 AM
SQL Query, SQL Server 2008 R2, SQL Server Management Studio, SSMS 2008

Copying view from remote to local SQL Server with SSMS
Hi I’m currently trying to get to grips with an upgrade from sql server 2000 to 2008, forced by an upgrade at my ISP. I’m used to using Enterprise Manager to export data from my ISP to my local machine for backup, and this process copying tables as tables, views as views and so on. [...]

Answer Question   |  February 10, 2009  2:52 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2008, SQL Server 2008 administration, SQL Server Enterprise Manager, SQL Server Management Studio, SQL Server Management Studio 2008, SQL Server migration, SQL Server views, SSMS 2008

Exception from HRESULT: 0×80040104 (System.Windows.Forms)
Program Location: at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous) at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.LaunchFormHost.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHost3.ScriptToNewWindowAndExecute(String text, String scriptType) at Microsoft.SqlServer.Management.SqlManagerUI.ExecuteProcedure.OnRunNow(Object sender) at Microsoft.SqlServer.Management.SqlMgmt.PanelExecutionHandler.Run(RunType runType, Object sender) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)

Answer Question   |  November 13, 2008  6:17 AM
HRESULT: 0x80040104, SQL Server errors, SQL Server Management Studio, SQL Server Management Studio 2008, SSMS, SSMS 2008, SSMS 2008 Express SP3, System.Windows.Forms