The default location specified in Enterprise Manager only applys when creating the database with Enterprise Manager and has no effect on the database file locations when using the command "CREATE DATABASE".

For...

Related my be the post titled ;701 "insufficient System Memory"' at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=344369

Actually, I stand corrected.  There is a MS blog on the SQL Storage Engine that has some insight and part of the blog is posted below. Looks like the logic of...

Based on the SQL posted, non-clustered indicies are being defragemented twice - one when the clustered index is defragemented, which also rebuilds the non-clustered indicies, and then again if it was...

IBM x3950 with 16 Dual Core 3Ghz CPUs and 32Gb of memory with average, maximum and minimum durations in milliseconds from 10 executions:

SQL Server 2000:

"Can you not use the DTS Dynamic Properties task to assign the gv value from the INI file?"

Yes the package does contain a Dynamic Properties, but the INI file...

Do not know if this approach would work for your requirments, but you use DTS.

1. Install the DTS run time where the "night operators" have access.

2. Create a DTS package,...

Just to let you know, none of the approaches suggested will work!

You can grant execute on xp_cmdshell but the internal code of xp_cmdshell will return an error if the invoker...

Your solution appears to be convoluted - selects nested within selects are not good.

create table Exports2001

(Districtinteger not null

,Teritoryinteger not null

, stat_monthinteger not null

, all_val_month integer not null

, constraint Exports2001_P primary...

There is a bug in Task Manager that applies to Windows 2000 and 2003, where the amount of memory used by a process is not correctly reported in all cases.

Also,...

'Your statement that 'A login with msdb database role TargetServer, can view any job.' was a great eye oener. How have I missed this tidbit? "

Because it is not...

Please provide DDL and sample data as described at http://www.aspfaq.com/etiquette.asp?id=5006

"The obsolete date will be the last time that recipe was used before the recipe changed"

This is not clear and without...

"I hope this is a simple one to answer."

Unfortunately, it is not a simple answer.

Here are some of the rules that apply to SQL Server 2000 jobs. These rules...

"When to script"

EM definitely for Jobs, DTS, log shipping and replication.

I have worked with Sybase or SQL Server since 1993 (inter-mixed with some Oracle), before there were...

"What FTP softwares can restart?

Most will restart, just check the manual before buying.

If using the internet or for sensitive information, try Sterling Commerce or Tumbleweed as they do encryption.

"Why not...