I have Sybase 12.5.4 running on the same box. When I am trying to connec to the SQL Server 2000 using isql, I am getting connected to Sybase and not...
Same service packs across the board. raj
No aliases. raj
Hi Gurus, I have setup a Pubslisher,Distributor and Subscriber on 3 different boxes. When I started the snapshot agent, I encountered following...
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....
Hi Satya, My question actually should have been."How to create the subscriber database using backup" and how to publish data from publisher to...
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...
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...
WOW...What replies....cool Thought you give atleast the ones you use. thanks raj
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...
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...
Hi Gurus I am getting below error when I am trying to run a batch file. What could be the reason. Please help. ------------------Error...
Thanks Satya, I used sp_change_users_login and it worked. Thanks raj
When I am trying to give access to the logins it is giving error like user already exists and also I am unable to delete the user because user owns...
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...
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...
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...
Hi Gurus, I am getting following while configuring Database Maintenance Plans for databases backup.The error is.. "Error 14258: cannot perform this...
I am using transaction replication. Well now how to avoid it. Thanks raj
Hi gurus How to avoid SQL Server from adding a "uniqueidentifier column" to the tables when the publication is created. Urgent Please Thanks...
Separate names with a comma.
