What is the default database of the login running the job?

Try to change that to Tempdb or Master.

HTH,

Robbert

I created a table tblUsers and inserted some data.

The query failed with this error:

Server: Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'WITH'.

I am using SQL...

When setting up mirroring between 2 non-trusted domains you need certificates.

Search BOL or look at this article: http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx

HTH

Robbert

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

Starting SQL Server in single-user mode enables any member of the computer's local Administrators group to connect to the instance of SQL Server as a member of the sysadmin...

Jeetendra,

as Lynn stated, start the SQL Server in single user mode.

When you are administrator on the server, you will have sysadmin rights on the SQL Server, no matter what.

HTH

Robbert

Did you check the boot.ini for the /3GB switch? It shouldn't be there.

Robbert

Neil,

First you have to assign other users rights within Reporting Server using an administrative account.

(This group has all the rights after installation)

So use an administrative account and choose Properties then...

The QotD needs a Moderator !!!

Thanks Grant,

This SP is executed every morning (to gather information about backups etc.)

The execution plan is a suspect, the cursor prcocesses the same number of databases once it goes the...

Try starting SQL Server in single user mode:

If SQL Server 2005 is started in single-user mode, any user who has membership in the BUILTIN\Administrators group can connect to SQL Server...

You should reinitialize (between BEGIN and second WHILE)

either @resnr or @tot, like you did in the beginning:

set @resnr=1144894

set @tot = @resnr + 1500

or when you want to count...

Peter,

is this policy setting disabled: Network access: Do not allow storage of credentials or .NET Passports for network authentication

KEY: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Lsa

VALUE: disabledomaincreds

SETTING: 1

This should be: “0”

HTH

Robbert 😉

Are you able to start SQL Server Agent in SQL Server 2008 Express Edition?

I can't find any proof of this.

According to http://msdn.microsoft.com/en-us/library/cc645993.aspx it is not supported.

Please explain.

thanks,

Robbert

What I know is that you have to turn OFF Auto Growth for the database to monitor free space.

HTH

Robbert

Maybe this KB article will help: http://support.microsoft.com/default.aspx/kb/968749

Robbert