SERVER PRODUT DETAILS

ARE

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Is there any problem with this version.

When I run the script from Query Analyser it works fine. But when I schedule the same script to run as a job, it fails and i get the following...

when i run this script in query window it's not giving any issues.

but by executing as a job it's giving the error.

i didn't understand, could please explain.

thank you,

i have one more issue:

i have a job to archive data from the production to another log database(600 tables). for this purpose i have created the statements for each...

hi,

i'm taking daily full backup, so i think truncate the log is not a problem before taking the full backup.

please provider suggetions.

You hourly transaction log backups will keep on doing this automatically..

i have checked with the log file size after transaction log backup, but it's not decreased.After shrinking the database also,...

i've regular backups full & transaction log backups. How it will be affect if i do rebuild with switching from bulk_logged to full.

recovery process:

daily fullbackup at 1:00 am

transaction log...

hi,

thanks for you reply,

Is it correct that, when we rebuild the index log size will be increased. what can i do to prevent this growth?

Thanks for you reply,

i have modified the function with the schema binding, it is useful for me.

but when i'm creating index getting this error

Cannot create index on view "vw_userdata" because...

i have a screen with the user information updation,

here we are updating two tables userinfo,addressinfo

I need to track the user info changes, for that i have to create...

hi,

i have tried with this :

SET usernamevar=

SET /P usernamevar=Enter Username:

SET pwdvar=

SET /P pwdvar=enter password:

SET sernamevar=

SET /P sernamevar=Enter servername:

SET dbnamevar

SET /P dbnamevar=Enter databasename:

sqlcmd -U %usernamevar% -P %pwdvar% -S %sernamevar%...

Hi,

thanks for your great response. it was very useful to me.

Thank you,

thanks,

actually that is my issue. how can i create a configfile( server settings) for the ssis package.

my scenario :

i have created a package locally and now i want to execute...

thanks,

but it is long process, so i have tired with the import/export, but it is saying that validation error. could u please tell me why it's happening.