Check the security settings if your package AND of your IIS.

If the package is configured to use SQLAuthentication (SQLusername and password), it should run fine if your IIS has the...

Keep in mind that if auto update statistics is on (on by default) there will be other incentives (usage driven) that cause this auto update process to update the statistics.

there are couple of SSC articles and scripts that should get you started :

http://www.sqlservercentral.com/scripts/31857/

http://www.sqlservercentral.com/scripts/Rebuild+Index/65933/

http://www.sqlservercentral.com/scripts/SQL+Server+2005/61278/

http://www.sqlservercentral.com/articles/Administration/createmaintenancejobwithaclickwithoutusingawizard/1102/

Just search SSC on "rebuild index" and the search result will show # of results.

You can use...

- With x64 you should always set your max memory config for each instance or they may eat up all your memory !

- Are the 3 SQLServer instances the only...

Indeed ... some times we overlook the obvious. :hehe: ( been there .. done that 😀 )

Happy mirroring 😉

Lower the autogrowth number of MB !

Seems to me your OS is having...

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...