Search Results | SQL Server Performance Forums

Snapshot error-21268

Thread by: krajdba, Jul 2, 2007, 8 replies, in forum: Performance Tuning for SQL Server Replication

Hi Gurus, I have setup a Pubslisher,Distributor and Subscriber on 3 different boxes. When I started the snapshot agent, I encountered following...

No Mail icon

Thread by: krajdba, Jun 26, 2007, 1 replies, in forum: General DBA Questions

Hi Gurus, I am working on SQL Mail. I wanted to setup my email profile. But I could not, becauase I do not see any MAIL icon in the control panel....

Subscriber with Schema and Data

Thread by: krajdba, Jun 18, 2007, 3 replies, in forum: Performance Tuning for SQL Server Replication

Hi Gurus, I am setting up replication on a 100+GB database. In the Push Subscriber wizard I wanted to use " No, The Subscriber Agent already has the...

How many Transaction log files for a Massive db

Thread by: krajdba, Jun 15, 2007, 2 replies, in forum: Performance Tuning for DBAs

Hi Gurus, We have a Production db of 100+GB and it grows at the rate of 20GB in a month. How many transaction log files I must have to get good...

List of Best Practices for ALERT Notification.

Thread by: krajdba, Jun 11, 2007, 4 replies, in forum: General DBA Questions

Hi Gurus, Please can you give me a list of severe errors/error that I should setup for notification ALERTs on a production database. VERY VERY...

How to Alter a Table?

Thread by: krajdba, Jun 11, 2007, 2 replies, in forum: Performance Tuning for SQL Server Replication

Hi Gurus, How to Alter a table which is published for replication. How to fix this below error.VERY VERY Urgent Please. Msg 4929, Level 16, State...

Server not Found error.

Thread by: krajdba, May 19, 2007, 2 replies, in forum: General DBA Questions

Hi Gurus I am getting below error when I am trying to run a batch file. What could be the reason. Please help. ------------------Error...

How to add login to an existing database user.

Thread by: krajdba, May 2, 2007, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi Gurus, There is a login as raj and a user as raj in a particular database. I wanted to add login to the user in that database.I tried to doing...

Databases in a Cluster

Thread by: krajdba, Apr 24, 2007, 1 replies, in forum: SQL Server Clustering

Hi Gurus, I have a Active/Active Cluster namely Node1 and Node2. Can I tell MS SQL Server 2000 What/which databases (not all databases) in...

Timestamp suffix to a textfile

Thread by: krajdba, Apr 23, 2007, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi Gurus, I have a job which generate a output textfile.How to suffix timestamp to the textfile name. For example:If the textfile name is...

Error while creating Database Maintenance Plan

Thread by: krajdba, Mar 26, 2007, 3 replies, in forum: General DBA Questions

Hi Gurus, I am getting following while configuring Database Maintenance Plans for databases backup.The error is.. "Error 14258: cannot perform this...

Avoiding uniqueidentifier column

Thread by: krajdba, Mar 9, 2007, 3 replies, in forum: SQL Server 2005 Replication

Hi gurus How to avoid SQL Server from adding a "uniqueidentifier column" to the tables when the publication is created. Urgent Please Thanks...

How to Avoid deletes in Subscriber...!!!

Thread by: krajdba, Mar 5, 2007, 10 replies, in forum: SQL Server 2005 Replication

Hi Gurus, I have setup a publisber and subscriber between core database and a report db in two different servers. In the Subscriber database I would...

Backup of sql server 2000 to restore on 2005

Thread by: krajdba, Dec 13, 2006, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi Gurus I have a backup of a database taken on SQL Server 2005. When I am trying to restore it on SQL Server 2000 I am getting problem. Please let...

Using DTS between Oracle and SQL Server databases.

Thread by: krajdba, Dec 11, 2006, 8 replies, in forum: SQL Server DTS-Related Questions

Hi I am using DTS Import for transfering the SQL Server data to Oracle. I am unable to transfer the table for CLOB datatype of Oracle into SQL...

Dead lock

Thread by: krajdba, Oct 20, 2006, 5 replies, in forum: General DBA Questions

Hi Gurus,<br /><br />How can I change my application to force User B to lock Resource 1 first and then Resource 2. So that I can avoid deadlock or...

SQL Server Logs is missing......

Thread by: krajdba, Sep 25, 2006, 2 replies, in forum: General DBA Questions

Hi Gurus In the Enterprise Manager under Management folder I do not see SQL Server Logs.And also there is no log folder(or logs) in the C:Program...

Timeout Error during the Transfer......

Thread by: krajdba, Sep 12, 2006, 5 replies, in forum: SQL Server DTS-Related Questions

Hi Gurus I have a Source database and a remote Target db both are SQL Server databases. I have created about 10 DTS Packages in the Source database....

using BCP between tables.

Thread by: krajdba, Sep 5, 2006, 4 replies, in forum: SQL Server DTS-Related Questions

Hi Gurus, Can I transfer data from a source table of one server to a target table of a different server using BCP and schedule it. If yes, Please...

restoring a Table...

Thread by: krajdba, Jul 24, 2006, 2 replies, in forum: General DBA Questions

Hi Gurus Accidentally a table was dropped from the database. There is a complete backup of the database which is 2 days old. And there is no backup...