400 mb for a new profile seems more than enough space. Espescially for a new service account.

I would check the profile of the default user if it contains lots of...

We recently installed Windows 2003 SP2 we had to install on each node individually, we paused the node in cluster admin, moving the resource(s) off the server before installing the...

You probably need to restart the SQL Agent. Any changes in database mail profiles used by SQL Agent won't be active until you restart the SQL Agent.

Seems like you didn't change the account through Configuration Manager.

When you install SQL2005 a service master key (SMK) for encryption is created. This key is then used to encrypt...

Well EXEC sp_MS_marksystemobject 'myConflictTable' does work in SQL 2005. It might not be the solution to your problem, but it does work.

Try this

use tempdb

go

CREATE TABLE Test1 (c1 int, c2varchar(20))

GO

EXEC...

Since BIDS is basically a part of Visual Studio I would expect that the procedure should be the same.

If you build your reports in a Visual Studio project, you can deploy them from VS.

See here for details

There's not really a way tosee the progress of a job running, but the restore statement has an option STATS which you can use to print a message every time...

First thing when investigating issues like this is to look at the execution plans. Are they any different ?

Do they make use of paralleism at all?

I have no experienc with...

Sounds like you need to enable "Allow ownership chaining" under database options. Under SP4 this is by default disabled.

---

Yes we do backups. I should have said that's a option I would rather not use right now because of all the tranactions that have occured in the last 4...

The DMV sys.dm_db_index_physical_stats will give you the information which indexes are fragmented.

What action you should take depends on the fragmentation. MS recommends rebuilding an index if the fragmentation is...

As the error message already said, you cannot create foreign key relationshsips between databases.

As a workaround you could create create a check constraint.

The issue is not the allocation of space, but the allocation of rows onto the pages. When you create a new database with a file size of 10 Mb, that...

In order to work correctly, you must surround the source and target with the delimiters in the column... in this case, spaces.

[font="Courier New"]SELECT myvarcharCol from mytable

WHERE ' '+myvarcharCol+' ' LIKE...