That should be a good idea.

Thankyou for your input.

I am sorry for not puting my question clearly.I am not having the problem running from the DTS Design view or from the Query analyser but when...

I think you can create an archive table for keeping the historical data in any other machine which has space in it. Other option is Create a batch file to...

Thankyou Matthew for your input.It is very clear.

I think you can do it by doing the self join to the table.

My Question is why it is not showing the tables which does not have indexes, if i.indid = '1' is in the where clause.

I might be wrong but to my...

I think you can get the job ID from the sysscheduledjobs table in MSDB database.

Check this out.

USE PUBS

UPDATE TITLES SET Type =

CASE type

...

There is a webcast on the microsoft site about deploying SQL Server 2000 Clustering step-by-step from preparation through setup.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q325106

I am giving the code used in Oracle and SQL Server for converting the character value to date.

Oracle:

SELECT TO_DATE(

'15.3.2000 23:56:33',

'DD.MM.YYYY hh24:mi:ss',

'NLS_DATE_LANGUAGE...

You should be able to find this information in MSDB Database.The tables of your interest might be sysdbmaintplans,sysdbmaintplans_Jobs,sysdbmaintplans_History,sysdbmaintplans_Databases,SysJobs,sysjobschedules Etc.

I think this is what you are looking for.

DECLARE @indexname varchar(50),@Cmd VARCHAR(500)

SELECT @indexname = 'hej_baberiba' + CAST(DATEPART(MM,GETDATE()) AS VARCHAR(5))+ CAST(DATEPART(SS,GETDATE()) AS VARCHAR(5)) + CAST(DATEPART(MS,GETDATE()) AS VARCHAR(5))

PRINT @Indexname

SELECT @Cmd = 'CREATE...

Apart from the option which Anteras686 you can also use dtsrun utility.

Example. dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name /Mpackage-password

Hope this will help.

The code which you gave is actually trying to create a new column with a default value of Commercial on the central_fact_table table.

Code:

ALTER TABLE dbo.central_fact_Table ADD

MED_COM char(10)DEFAULT 'Commercial'

Whatever you are seeing is fine there is no need for you to worry about.You should start worring if the chache hit ratio falls below 85% and CPU touches 100%...