Search results for query: *

This happens when you are running a big transaction where the tempdb is being used. It will grow up automatically and will allow the transaction to complete. But If you dont have enough disk space it will fail. If you could make transactions simple that would help.

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

Did you apply the initial snapshot?? When the snapshot agent runs it will drop and recreate the article at the subscriber by default.May be the subscriber table is source for different publication.... Cyno

No. There wont be any problem.

I think you will have an option to specify the destination table name and also the owner name under article properties. Cyno

Yes. You can implement bidirectional transactional replication. There should not be conflicts(updates more often). If you have updates(conflicts) more often then merge replication is best solution http://support.microsoft.com/default.aspx?scid=820675 cyno

Could you send more details?? What is the job doing?? Did you check the job history?? Cyno

Looks like to me while one process is restoring the database it holds lock on the file and at the same time other process is trying to access the file. How big are the .TRN files??? Cyno

Did you see any records in log_shipping_plans table in msdb database??? Try to copy the plan name from the table and run EXEC msdb.dbo.sp_delete_log_shipping_plan @plan_name = N'plan_name', @del_plan_db = 1 Cyno

Can you run this and see what happens EXEC msdb.dbo.sp_delete_log_shipping_plan @plan_name = N['AUTHORIS-LTZB8F\PRODUCTION.pubs_logshipping'], @del_plan_db = 1 Cyno

What version of Sql server you have?? Replication comes with Sql server. You dont have to install it separately

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...

I tried the below restore command and it worked for me. May be issues with the server access... Just guessing.. RESTORE DATABASE dbname FROM disk='\\server\D$\path\filename.bak' WITH STANDBY='D:\path\name.sby', MOVE 'logical_datafile_name' TO 'D:\sqldata\file.mdf', MOVE...

Run the following command in the QA sp_help_fulltext_catalogs It will return the catalog name. After that you can run this command specifying the catalog name as parameter to get table name sp_help_fulltext_tables 'catalog name' Cyno

Thank you so much.

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...

Thank you.

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

Can you give me more details of the job of what its doing??? Cyno

NORECOVERY Used only with BACKUP LOG. Backs up the tail of the log and leaves the database in the Restoring state. NORECOVERY is useful when failing over to a secondary database or when saving the tail of the log prior to a RESTORE operation. STANDBY = undo_file_name Used only with BACKUP...