Check if Named Pipes protocol is enabled and try connecting using the Machinename\InstanceName.

What ever you see in your system (SSMS) that can be typed and described, alternately you can take a screenshot and attach to your next reply. Do not edit previous...

Quoting Books online..

The money and smallmoney data types are accurate to a ten-thousandth of the monetary units that they represent.

Ans it does not represent currency symbol...

Without error details, and how are you trying to restore the DB (SSMS or through SQL command) it is highly unlikely to suggest you since we don't have enough information...

You may...

As Jeffrey suggested, have the SSIS Package scheduled as a SQL Agent job and let the Sproc kickoff the job. Let the users action (clicking a button) call that sproc.

Any specific reason for this?

The_SQL_DBA (1/7/2010)

Bru Medishetty (1/7/2010)

ALZDBA (1/7/2010)

GSquared (1/7/2010)

Servers usually aren't all that loud, but...

ALZDBA (1/7/2010)

GSquared (1/7/2010)

Servers usually aren't all that loud, but the limit would...

Use this.

select [NAME],CREATE_DATE from master.sys.databases

The_SQL_DBA (1/7/2010)

Bru Medishetty (1/7/2010)

You can start creating databases one by one until...

Lynn Pettis (1/7/2010)

Bru Medishetty (1/7/2010)

You can start creating databases one by one...

In short, it can't be done in systems prior to SQL 2008. SQL 2008 has resource governor that enable the Admin to limit system resources to groups.

My suggestion to your...

Have you checked if the protocols needed are enabled? Check in SQL Server Configuration Manager.

You can start creating databases one by one until it says max...