Search Results | SQL Server Performance Forums

While restring Database Can Restore only MDF for that What type backup I have take -- Imp for me.

Thread by: sqldba_ind, Oct 31, 2007, 3 replies, in forum: General DBA Questions

HiI already asked couple of questions on Migration, to day my client asked me one question.Youâ€™re taking full backup (using Ent mng), while...

[SQLSTATE 01000] (Message 14157) --When I ran "sp_expired_subscription_cleanup"

Post by: sqldba_ind, Oct 31, 2007 in forum: Performance Tuning for SQL Server Replication

Hi satya Is it Network Problem

[SQLSTATE 01000] (Message 14157) --When I ran "sp_expired_subscription_cleanup"

Thread by: sqldba_ind, Oct 31, 2007, 3 replies, in forum: Performance Tuning for SQL Server Replication

Hi all and Satya My Schedule was running "sp_expired_subscription_cleanup" I got Below Error some help regarding this issue. Executed as user:...

How to check the Permission of Group in SQL Server - Urgent...

Thread by: sqldba_ind, Oct 29, 2007, 1 replies, in forum: General DBA Questions

Hi allHow to check the Permission of a group(Read/write) on Databases using SQL query.

How to make use of exported JOB,ALERTS and DTS packages

Post by: sqldba_ind, Oct 25, 2007 in forum: SQL Server DTS-Related Questions

Hi satya I am expecting response from your end. Off course every expecting repay from your end.Finally moved DTS packages to my Destination...

How to make use of exported JOB,ALERTS and DTS packages

Thread by: sqldba_ind, Oct 24, 2007, 2 replies, in forum: SQL Server DTS-Related Questions

Hi all I moved the Database from One server other Server now Database in READONLY mode. Now I exported JOB,ALERTS and DTS packages nad users also...

How to Move Database to Other server

Post by: sqldba_ind, Oct 15, 2007 in forum: General DBA Questions

Hi Satya,Jack Vamvas Thanks for replay, but my problem is little bit different Let me clearly discuses the problem 1. Productuions server having 18...

How to Move Database to Other server

Thread by: sqldba_ind, Oct 15, 2007, 4 replies, in forum: General DBA Questions

Hi all I have a Application server(Web application production 24/7) and DB Server(SQL Server 2000 production 24/7), I have to move Application as...

[SQLSTATE 23000] (Error 515) The statement has been terminated. [SQLSTATE 01000] (Error 3621).

Thread by: sqldba_ind, Oct 12, 2007, 1 replies, in forum: Performance Tuning for SQL Server Replication

Hi all I have a Job That got failed and thrown an error "Cannot insert the value NULL into column 'publisher', table...

Datetime Vs Small datetime

Thread by: sqldba_ind, Oct 4, 2007, 4 replies, in forum: T-SQL Performance Tuning for Developers

Hi all I have table (column) with Small datetime as a datatype,I am trying to insert date time into Table it is giving Overfolow error can some body...

Iam able to see DTS package in Query analyzer,but not in Enterprise manager why ?

Post by: sqldba_ind, Sep 21, 2007 in forum: SQL Server DTS-Related Questions

Sorry you guys I am wrong,I am looking into Job location.that is reason I did n't find DTS.

Iam able to see DTS package in Query analyzer,but not in Enterprise manager why ?

Thread by: sqldba_ind, Sep 21, 2007, 1 replies, in forum: SQL Server DTS-Related Questions

Hi Iam working in Production,Today I got alert Job failied JOB suppose to run today It ran and got failed see the code in Job "dtsrun /S <srvName> /U...

How to Impliment Replication between different collisions

Thread by: sqldba_ind, Sep 12, 2007, 1 replies, in forum: Performance Tuning for SQL Server Replication

Hi all What are the possible ways to Impliment Replication(any type) between two collisions. Thaks in advance

Not able to terminate the job

Post by: sqldba_ind, Sep 4, 2007 in forum: General DBA Questions

Are you tried "sp_stop_job" to stop execution of Job

How to tune MDX Queries.

Post by: sqldba_ind, Aug 26, 2007 in forum: Analysis Services/Data Warehousing

Thanks Satya.

How to tune MDX Queries.

Thread by: sqldba_ind, Aug 23, 2007, 2 replies, in forum: Analysis Services/Data Warehousing

Hi all I have MDX query,I want tune that Query for that what I have to do In Query analyzer i have excution plan,using that normal proc,queries i can...

How to ensure in T.Repliction my servers are in sync

Post by: sqldba_ind, Aug 17, 2007 in forum: Performance Tuning for SQL Server Replication

Thanks Satya, if we find those are not in sync what to do... manually solve the problem or any excisting technic is there to solve this problem.

How to ensure in T.Repliction my servers are in sync

Thread by: sqldba_ind, Aug 17, 2007, 4 replies, in forum: Performance Tuning for SQL Server Replication

Hi In t.replication how to ensure servers are in sync,is there any methode or agent to take care.