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.
I have setup a Pubslisher,Distributor and Subscriber on 3 different boxes.
When I started the snapshot agent, I encountered following...
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....
My question actually should have been."How to create the subscriber
database using backup" and how to publish data from publisher to...
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...
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...
Thought you give atleast the ones you use.
Please can you give me a list of severe errors/error that I should setup
for notification ALERTs on a production database.
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...
I am getting below error when I am trying to run a batch file. What could
be the reason. Please help.
I used sp_change_users_login and it worked.
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...
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...
I have a Active/Active Cluster namely Node1 and Node2. Can I tell MS SQL Server 2000 What/which databases (not all databases) in...
I have a job which generate a output textfile.How to suffix
timestamp to the textfile name.
For example:If the textfile name is...
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.
How to avoid SQL Server from adding a "uniqueidentifier column" to the tables when the publication is created.
Separate names with a comma.