I will try this next time, think will work:

1. Use GUI or dtutil to copy all packages from one server to other.

dtutil /COPY DTS;"msdb\maintenance plans\testdtutil" /DTS "msdb\maintenance plans\testdtutil" /SOURCESERVER server1...

Thx, I agree , I added Chk DB maint plan for system dbs on my servers.

Anyone?

I can try the above process next time, step 3 is still the issue tho, can't export pkg coz of the error, anyone knows what the error is about, for...

Hi Jose,

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/567ca99e-3627-4787-b54b-413ba5ce278c

Link for the issues I am having with IS export.

Just FYI, I have been recommended to try this step:

Increase the size of the file a little bit & then try to shrink. I can't try this as we are...

Sorry, I thought Auto-Shrink was ON, It is at OFF only as thats the default for all dbs.

I am following these 2 links tho:

http://weblogs.sqlteam.com/tarad/archive/2007/11/08/60394.aspx

http://support.microsoft.com/kb/960567/EN-US

I did DBCC UPDATEUSAGE on...

Auto-shrink is enabled. Trying to shrink as need disk space. I myself hate shrinking as there is no point if the db grows back again, in this case there is...

6GB is pretty less memory for Production servers, but I guess you got to make do with what you got.

You already have /pae set up which will help OS see...

Yo espanolanthony, you made it clear that "you know the product but you are a newbie".. kinda explains it all..

Only way to release disk space to OS from SQL server is by 'Shrinking' as pointed above by LeeM.

**

Don't think it will increase index fragmentation, you can check that by...

How do sequences work in Oracle?

You can set up 'Snapshot Isolation' Level in SQL to have readers not block writers & writers not block readers.

Suggest you talk to the Oracle DBA & get some real stuff that Oracle does & SQL doesn't. Both of the things you mentioned hardly matter.

Good question, I see the same, DB properties says setting is False ,

SELECT 'abc' + NULL;

GO

-- gives 'NULL' tho.

SSMS 2008 does a good job in displaying the row count next to the table itself.