I have 3 questions on Above subject How can we configure VIP's (Virtual IP address) for SQL Server?? If we have to install 3 instances of SQL Server...
There should be a online chat option, possible with queing up and also for each user max time devoted in this chat to be 3 min or 5 min. Also there...
I am planning to use SQL reporting service to connect to oracle database and generate a report. I'm able to see the table from my SQL Reporting...
How can we assign VIP to SQL server and reporting server?? This server is not clustered and we are running win 2003. I need SQL server (which is...
I am just trying to alter a function and this process goes on for ever. Moment I start this process it starts blocking all other users. when I check...
Our jobs are failing whichever job is accessing this table "fr_ext". attached below is the error message. This fr_ext table is part of merge...
How can I view object level permissions for all users in sql 2000. We can do this in SQL 2005, but is there a way how we can list down which users...
Hi group we are having issues inserting rows in published table. This table is set to replicate (transactional replication with update, 2 way...
Hi Group, We had foreign key contraint on a table, now instead of table we now have synonym on table, to which foreign key was referring to. Now...
We are using snapshot and transactional replication. We have distributor server on separate server. We have publisher and subscriber on cluster....
Can we set up transactional replication on Virtual server. Basically we want to setup distributor server on Virtual server. Please update Is it...
We have sql server 2005 with sp1 and on win 2003 environment. This is 32 bit server with 16GB memory. All of sudden replication and all jobs came up...
Hi aLL, wE ARE running backup using this script below, Reason why we are running using script because We want to have timestamp in backup name We...
We have SQL 2005 clusters on Windows 2003 R2. Recently I am getting below mentioned errors that stump me: Eventid = 124 Source = SQLWEP Named Pipes...
How to change replication agent frequency from "Real time" to may be 15min or 30min without resynching publication. We have SQL server 2005 with SP1...
Whats actually the difference between "View server state" and sysadmin permissions. I know what sysadmin oermissions are, however since View server...
We have SQL server 2005 with SP1 on windows 2003 server. Just today we are having issues with this SQL server. There are 2 issues First: - Though...
We already have system to trace blocking information and that also generate email to all users if there is blocking on system. This current setup...
We have SQL server 2005 servers with SP1. we have page verification option disabled for production databases. We look forward in turning on this...
I can check up for blocking and can check for processes blocked or deadlocked, however I want to store this information in a table and also want to...
Separate names with a comma.
