Shouldn't be a problem.

Well, I am at a loss here - the summary you showed does not show an instance being available on that system. The service pack cannot update what it...

On SQL Server 2005 and greater, you can right-click on the database in Object Explorer, select reports, standard reports and run the disk usage by tables report. There are...

ALTER DATABASE database SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

RESTORE DATABASE....

ALTER DATABASE database SET MULTI_USER;

I use the above to refresh my training environments every day.

Lookup ISNULL and COALESCE in Books Online.

SELECT COALESCE(column, '') AS column;

Yes, you can attach documents. Scroll down further and you will see a button to Edit Attachments.

The errors you are getting show that you have a problem with WMI...

I really don't know what else to tell you. In Object Explorer - what is the actual name of the server you are connected to?

Does it match the name...

Not sure if that would have fixed your problem with Workgroup edition - just something I remember having to do with multiple instances.

GSquared (8/14/2008)

---

SSIS is based on the default instance. I ran into a major bug with that a little while back, since Workgroup Edition doesn't support SSIS, but Standard does,...

BTW - reviewing the summary will show you that this server does not have the database engine installed.

Time: 08/13/2008 08:59:36.608

KB Number: KB921896

Machine: DPPSQL5

OS Version: Microsoft Windows Server 2003 family, Enterprise...

Okay, let's go all the way back to the beginning. Where are you seeing that the version is 9.0.1399 (RTM)?

If this is in Help | About for SSMS -...

Not sure about why those options are greyed out. Normally, I see those options greyed out when I have the server setup in the registered servers list, but can't...

You do not need to reorganize and rebuild your indexes. Pick one of them -...

Jack Corbett (8/13/2008)

---

When everything is in the same schema ownership chaining rules apply, so if I have schema1.proc1 and access schema1.table1 then all my user/role needs is exec permissions on...

When you RDP into the server with the SQL Server name - do you connect to a machine with a different name? For example, if you RDP to a...