Hi David

I've not come across that one, but these guys have :

http://pcpitstop.invisionzone.com/lofiversion/index.php/t110543.html

Good luck

Cath

Thanks Homero - it sounds as though you're being authenticated via your Windows account in that case.  You really need to find out what permissions your Windows account has within SQL...

Hi Homero

What permissions does the login you're using have?  There's a SQL Server role 'Process Administrators' which allows you to kill any process running, but if you already have sa permissions...

Hi Bill!

Not sure how you've tried to change the  authentication mode, but if you go to Management Studio and right click over a server there should be two options on...

Hi Homero!

To find out who/what is accessing your database, in EM browse to Management, Current Activity and Process Info.  If you right click over the process you can kill it. ...

Hi!

Try this site

http://www.sqldts.com/default.aspx?1

the faq section has tutorials and the download area has samples.

There's also the MS site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_pkgmng_7uat.asp

Have fun!

Hi Leezhang

Check BOL for Log Shipping and/or Replication which both automate server synchronisation.

Hi Sameer

Try running DBCC LOGINFO against your database.  This will show the status of the virtual log files in your log.  If the status of a VLF is not 0, then...

I had a similar situation with services running under domain accounts when problems with the domain controller prevented the 'log on as service' being pulled down through group policy.  I...

Hi Brandt

Try this link for some alternatives:

http://www.sql-server-performance.com/tempdb.asp

Cath

Hi Igor

If you double click over Job Activity Monitor you'll get the icons you're after.   If you look closely in the Jobs Summary pane you'll see a tiny red arrow...

Thank you Jonathan.

User must be granted Execute permission on xp_cmdshell unless they are a member of the Sysadmin fixed server role.  Not sure if this allows them to see each others packages...

If you uncheck the option for 'Reorganise data and index pages' you'll be able to check 'Update the statistics used by the  query optimiser'.  I'm not sure, but I think...

There's a fix for this in SP4 - worked for my users.