I don't believe it will effect you one way or the other so entirely up to you. And I am glad you pointed out was Step and not task. Never...

I see what you are saying. I tested and works perfectly (as long as you have a clustered index to use or can just make one then remove it, does...

Reindex is not the same as moving the table to a new filegroup and there is no parameter to reindex to another filegroup. Create a complex table and change between...

You state you can get to it from home using SQLs client tols so I doubt firewall is the issue here. Try setting up in Client Network utility an alias...

I personally prefer to name them just for easy reference in documentation and just looking at the package the names provide a logical answer to what it is for. However,...

quote:

---

Maybe I am a bit sleepy today or something but if just rebuild the clustered index on your new filegroup why would...

I wonder if this happened to stick this way during the upgrade. I checked mine on serveral machine (none of which were upgrades but clean installs) and found the key...

Are you saying the server has 250MB? If is using .7-.8GB then how much is physical memory. Also if it wants to use that much then be carefull as you...

The problem with using int is it only goes to 2147483647 so 8885551212 will not work at all. You could also try bigint which should cover most all the possible...

Yes but 4 is the max for Standard. See BOL "SQL Server Editions".

Try this

SELECT TG.* FROM

(SELECT [Name], Min(TestNo) As TestNo FROM TestGrade Group By [Name]) As FT

INNER JOIN

TestGrade TG

ON

FT.[Name] = TG.[Name] AND

FT.TestNo = TG.TestNo

Order By TG.Grade, TG.[Name]

What does your VB code do? Can you give us a look at the section affected, could be something wrong that just did not show up with regards to developement...

You could try a tool such as LogExplorer

http://www.lumigent.com

Also, you could try DBCC LOG to look at the information but as of yet I have not found the details of understanding...

Possibly, I am trying to find that documentation to verify. It may be I am thinking of the MaxMTU units in the registry.

Just took a look and none of my boxes are doing this. When I turned on on my machine it took forever to do anything.

Now have you checked the properties...