good point, Steve.

Or more than one file in the filegroup. SQLServer is supposed to be able to balance the data over all files of a single filegroup, so in that...

- You can indeed switch your sqlserver instance to "audit login all", that will insert a row for every logon attempt in the sqlserver instance Errorlog file.

Off course you'll have...

To the OP: another not so recent SSC member, working on the Fora2009 rudiness program ? :sick:

btw, did you try it like the good old msaccess worked around your problem...

You have already received the eplication ...

I would always prefer the JOIN syntax, because that has the nicest separation of Join predicate(s) and Where caulse conditions.

So these JOIN syntaxed queries...

Check the autogrowth of your database files !

If it is in percentages, it would be better to switch it to extend in MB !

(e.g. per 100 or 500 MB, depending...

- another alternative is to just copy that table into another database and create a full backup of that db.

I would not suggest to do it this way all the...

hmm .... problems doing a os level file move ?? .... scary !!:unsure:

here's an article regarding moving database files...

http://www.mssqltips.com/tip.asp?tip=1604

Be sure you know what you do or you may get into...

Krasavita (8/21/2009)

---

I have another stuped question, in my directions it says:

Physically move the files and full-text catalogues of the database. Is this mean That I have to do ctrl X...

If you excute sp_helpfile in a database you get to see the logical filename and the...

I would go for the solution Perry Whittle provided.

Use the alter database methode because this will always have you db defined at your sqlinstance, it will also keep all security...

Very nice way to tackle the issue of hardware replacement !

Thank you for this valuable feedback !

Keep in mind trace flag 4621 is only available with SP3

and is only advised if the combination of trace flags 4618 and 4610...

Did you manage to get smtp to work on your 64-bit win2008 ?

indeed ... as Lynn stated, use the column 'name' to order the result set and you'll be fine.

For you query the ordinal column 1 is the variable value for the...

Did you try making an indexed view for the phone number part ?

I usually don't use indexed views, but if you insist on having a single query doing it all...