New_to_being_DBA (6/25/2009)

---

I have my database set to autogrow. I understand that it will continue to grow until it reaches the limits of the hard drive with autogrow on. But my...

try this:

goto Job properties, check the owner and change it to SA or use a windows account with higher priviliges.

Also can you let us know the following:

start services in Start-->Control...

Thanks for the detailed info it helps:

as i said before uninstall SSAS 2005 as in the link i provided, then run the setup for 2008 again and choose only SSAS...

Ian must be right, bus as far as i can remeber hazily.. this parameter writes dump files in case of error...

😀 We must be the long lost brothers 😀

There is Service pack 3 Available for SQL server 2005. how about upgrading to SP3 directly.

Sp1 had some Memory leak issues still pending and were solved in SP2, but SP3...

sqldba725 (6/25/2009)

---

Hi ,

any one has any idea , how we can uninstall SQL analysis services only ...wihtouy impacting anything else ...

Or how to upgarde analysis SP from 9.00.3042.00 to...

Sudiendra (6/24/2009)

---

It is OS memory and i have used 15 GB to SQL and 4 GB to OS. I will see if i leave more memory to OS to see...

Sudiendra (6/24/2009)

---

Memory ...

SQL 2000 use this:

DECLARE @Handle binary(20)

SELECT @Handle = sql_handle FROM sysprocesses WHERE spid = (paste the spid here)

SELECT * FROM ::fn_get_sql(@Handle)

SQl 2005

select ss.text,sp.*

from master..sysprocesses sp

cross apply sys.dm_exec_sql_text (sp.sql_handle)...

connect to integration services insted of database engine and then list the packages in the left side obect explorer... right click on package and delete....

or using DTUTIL

DTUTIL /SQL (PACKAGENAME) /DELETE...

Answer: check database integrity task:

but here is how you should form the maintenance plan:

BAckup Database Task:

Maintenance Cleanup

history cleanup

if required seprate out the integrity checks and index rebuild tasks in another...

No it is not possible to create duplicated .mdf files or .ndf files or same name mdf and ndf files even across filegroups.

if you are using 2 diff servers.. yes...

see if this helps:

http://sqlblogcasts.com/blogs/jorg/archive/2008/02/12/SSIS-_1320_-Lookup-Transformation-is-case-sensitive.aspx

if you have admin right on SQL Server: Write

DBCC USEROPTIONS and check to see the last option, what does it say.

I bet what is happening is the SQL server might...