Execute something like the following and then restart the service

use

master

go

Alter

database tempdb modify file (

These are the instructions

http://sourceforge.net/docman/display_doc.php?docid=33453&group_id=168612

hth

David

I know this doesn't directly answer your problem but you should have a look at this on sourceforge its a webadmin tool for sql server it looks just enetrprise manager and...

I've taken the approach in my packages that getting the value for and assigning it to the variable is done in one data flow and then I would either create...

To use the variable in an excute sql task set the sql statement to something like the following

SELECT * FROM HumanResources.Department WHERE DepartmentID = ?

set bypass prepare to true

and then...

If it shows as still loading it sounds like you chose to leave the database in non-operational state in the wizard so the database will not have performed the recovery...

When you restore the database it will try and put the files back into the same location they were in when the database was backed up. What you need to...

In the start menu go to

Start Menu\Programs\Microsoft SQL Server 2005\Configuration Tools

and open the sql server configuration manager expand the sql server network configuration manager and click on protocols for mssqlserver...

If you install the dts components in the feature pack then you can maintain existing DTS packages in management studio but you cannot create new ones.

hth

David

The example is incorrect in transact sql the syntax would have to be

SELECT USER_NAME() -- Returns Andy

EXECUTE AS USER =  'Brian'

GO

EXECUTE AS USER = 'Steve'

GO

REVERT

GO

SELECT USER_NAME()

The syntax provided would provide a syntax...

I know that when you use linked server with access that you often have to change the maxlocks per file if you are importing/exporting a lot of data otherwise is...

Very bored tonight

If all else fails have a look at these posts and you can bin outlook.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=187&messageid=133926

This solution works well.

David

This might be of use to you

http://support.microsoft.com/default.aspx?scid=kb;en-us;263556

David

What version of outlook is it?

Outlook 97/98 requires you to leave the outlook open othersise the mail will get stuck in the outbox.

hth

David

A clustered index scan is a table scan. If you put  a clustered index on a table you will never actually see a table scan.

All that happens is that it goes...