Objects do not cross filegroups. If there is data being added to objects that were created in PRIMARY, that filegroup will grow. To move those objects to filegroup1,

- For tables,...

Do you mean 1434? It should also have TCP 1433. A reference: http://support.microsoft.com/kb/287932

Does this happen if you connect locally? I haven't seen this before, and it's not something I expect....

GSquared (12/8/2009)

Enterprise Manager, and I liked that. I think SSMS is OK, but I'd also like...

Explanation corrected.

Resorted. Not quite what you had, but 2008 is at the top

You should always restore with NORECOVERY and then when you are completely done, you can RESTORE DATABASE xx WITH RECOVERY to bring it online.

Try here: http://www.thinkgeek.com/gadgets/tools/8b97/

I'm not quite sure it's worth the price: US$999

Is a hot dog cooker inefficient? Having one means that my kid might be able to cook something without help. It might seem like a waste to a chef, but...

OK, I couldn't resist: http://www.sqlservercentral.com/Forums/Topic829828-338-1.aspx

Please do not cross post and please make your own attempt to do work. the "fellow experts" are happy to help, but not do the work for you.

If it is the journey that is important, perhaps you ought to try to do this yourself. Make an effort and try to solve the problems.

We are happy to help,...

Are you putting the rowcount in all rows you're inserted into the audit table? the count is easy

create trigger ...

for update

....

declare @cnt

select @cnt = count(*) from inserted

I tend to agree that Subway, and Chipotle, have a few issues. You do have to spell things out everytime, which is annoying for someone like me that tends to...

nice question, got me as well.

I'll correct the case sensitivity

I'm not sure that I agree multiple apps aren't simpler. You do have the same knowledge requirement, but when you go to perform a function, you have less clutter, and...