Search results for query: *

Hello all - Are there any disadvantages using a view in transactional replication. I am using Sql server 2000 enterprise edition and the objects being referenced by view already exists on the subscriber. Are there any steps consider before adding a view to the publication. Regards, Cyno

Hi We have Sql server 2000 Standard Edition with Service Pack 3a. I noticed a strange thing on the server. When i try to modify the permissions for a standard login the server will prompt to confirm the password. It is not happening for the Windows account. And even when i give the password...

Hi We have a table in which we need to audit the deletes. And iam creating a trigger for delete.I know we can use the user_name to get the DB user. Is there a way to get the workstation(hostname)name and login information as we have standard logins on that server and its hard to find which...

Hi All I would like to remove unnecessary users and logins from one of the servers. But i am afraid if any of the application or process may be still using that login. Is there any way that we can confirm that the application is not using the login anymore Cyno

Is there any way to get the IP address of the server. I just need only the ip address. It doesnt matter if its a windows or sql server command. Any help would be appreciated. Cyno

Hi Guys - We have DB maintenance plan that will backup the user databases everynight. Its full backup. Everything works fine. After running for certain days the backup job fails. Its Sql 2000 stnd on win 2000. Here is the error message in the job history and event log SQL Server Scheduled Job...

What is the best way to get all the Sql servers information that have been installed within a domain. May be i need to write a windows program to get this info. I am looking for the servername, IP address, Memory, SQl version and Service pack. Any help would be appreciated. Cyno

Hi Guys - I have question on temp DB. Last night we have huge updates on one of the user databases. I know these updates will use the tempdb space. I got an alert saying that the log file in the Temp DB database is full. Please back up the T log to free up some space. But the temp DB log file...

Hello All I have configured transactional replication within same domain.The publication and subscription were created successfully and and a snapshot is generated.But for some reason when i run the distribution agent its failing. here is error message iam getting on the distribution agent...

Hi We have a transactional replication set up on production server.I have to do schema changes to the article which is in one of the publications.The field i need to alter is Primary key and i would like to remove the identity property.Do anyone experienced the same situation?????? How would i...

Hi What is the best way to alter a coulmn which is in transactional replication. Cyno

Hi Iam tring to run a script which will update 5 tables(we have like 200000 records in each table) and inserts into different table after the updates.Iam getting the following error when i tried to execute the script.We added half gig to temp tablespace but still getting the same problem.Does...

Hi Folks Is there any roll up and cube operators in Oracle.Iam new to oracle.Any help would be appreciated. cyno

hi I have installed windows 2000 professional on my notebook.When i bought the PC i have win XP in it.I partitioned win 2000 professional in diff drive.I have downloaded all the audio drivers and display drivers.But i could not able to run the DVD ROM drive.Can anybody help me out with this...

Hi When i try to update a remote database table inside a cursor using the dynamic sql iam getting invalid column name error.Iam passing the query into a variable.when i use the same in the local database it is working fine.Any idea why it is not working? ORA-00904: invalid column name

Hi when i try to run a pl/sql script i get the following error message.But the same script will run after sometime.Did anybody encountered the same problem.Help me...... SQL> citi.txt ERROR: ORA-02067: transaction or savepoint rollback required DECLARE cc VARCHAR2(20); * ERROR at line...

Hi How do i get the server name in oracle.Iam new to oracle. In MSSQL we get the server name as select @@servername.

Hi Iam new to oracle.How to insert data in one table based on the status in the other table.The insert statement i use in sql server is not working in oracle.Any help is appreciated. Cyno

Hi I have 2 tables A,B.I want to update table A based on status in table B.Iam trying to run this update stmt,but iam getting error.The same update stmt works in MSSQL.Iam new to Oracle.Any help is appreciated. Update table A a,B b set a.status='XYZ' where a.ID=b.ID and a.name=b.name and...

Hi Iam new to Informatica.I got a problem in Informatica designer.Hope u can help me out with this issue.The thing is after installing Informatica Power mart 5.1 iam not able to see the navigator window in the Power mart designer.And one more thing is if we create a folder in Rep manager i...