Try creating a stored procedure that the user does have permission to. The procedure could access MSDB..sp_help_jobs or the system tables directly (although I do not suggest accessing the system...

1) You could try changing EM connection string to use SA (or a different SQL user just so you are not using NT Auth) and see if that effects the...

Should also note that if applications running against sql server that restarting the services may cause a conflict when restarted.

Example: if an applications is running a transaction through Com +...

Not to mention possibly taking a job from a qualified SQL Server DBA that needs it.

Besides t-sql is t-sql there are only simple differences between the syntax from SQL...

You can also run SP_who2 'active' to see what active connections are doing.

How is the VB application connecting to SQL Server? The are many timeouts some sql server some other...

I am a SQL Server DBA from Minnesota and I am intrested in this position, my email address is JD785727@Yahoo.com.

Thanks

I did not give a but why just a will work.

Then Backup the database when you are done. You have to do what you have to do.

In the future:

I have dealt with this in many ways.

I am about 99.9% positive this will work.

1. Backup Log File - Transaction Log
2. Change recovery model to simple
3. change recovery...

Correct - the suggestion is to do a self join

You could use xp_cmdshell to call osql: see below>>

USE PUBS

GO

CREATE PROCEDURE ExportTest1

AS

SET NOCOUNT ON

DECLARE @cmd VARCHAR (255)

SET @cmd = 'OSQL -E -S 424XG61\DBA -d Pubs -Q "EXIT(SET NOCOUNT ON...

You can also get the results by using temp tables:

USE Pubs

Go

CREATE TABLE #OrderNum

 (ord_Num VARCHAR (20))

INSERT #OrderNum

SELECT top 20 Ord_Num

FROM sales

SELECT TOP 10 ord_Num

FROM #OrderNum

SELECT Top 10 ord_Num

FROM #OrderNum

WHERE ord_Num...

1. Open Query Analyzer
2. Ctrl+shift+O or Tools > Options
3. go to "Results" tab
4. Set "Default results target" to "Results to File"
5. Set "results output format" to "Comma Delimited (csv)"
6. Run script (you will get a prompt...