Under MSSQL 2000 I get a deadlock on a transaction. This victim transaction contains one single SELECT statement joining 2 tables using the READPAST hint. I thought this hint will cause the transaction not be blocked on locks. How can it happen that the transaction is part of a deadlock? The query looks...

Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/

what is the diffrence in DBMS and RDBMS?

Respected Exprts, We are using Sql Server 2000 on win2003 server . Our SQL sever 2000 is subscriber on Merge/push type replication. i backup databases daily on different interval but HOW CAN I BACKUP SUBSRIPTION AND OTHER NECESSARY FILES OF REPLICATION. AND RESTORING PROCEDURE OF ALL THESE. THANKS

hai to all, i want to export the data from xml to table in sql server can u help me

Good day all. I have about 25 SQL boxes that are 2000 and 2005. I have all the maintenance plans running successfully nightly now. What I would like to accomplish is to have all the history reports go to one location and email a report on the failed jobs. SQL 2005 doesn't have the option to add a...

Hi I have a table (Sql server 2000) which has 14 cost columns for each record, and now due to a new requirement, I have 2 taxes which needs to be applied on two more fields called Share1 and share 2 e.g Sales tax = 10% Use Tax = 10% Share1 = 60% Share2 = 40% So Sales tax Amt (A) = Cost1 * Share1 * Sales...

In SQL 2000 you could use this statement to get the path to a database file SELECT Filename FROM master.dbo.sysdatabases WHERE Name = 'MyDatabase' but this won't return anything in SQL 2005. Any ideas how to retrieve the path to the database from any other SQL queries?? I've seen other...

SAinCA, I think this is the code you are referencing from this tip ( http://www.mssqltips.com/tip.asp?tip=1112 ): -- Table - The base table is stored with the -- clustered index, so moving the clustered -- index moves the base table CREATE CLUSTERED INDEX IDX_ProductID ON dbo.OrdersDetail(ProductID)...

Firman, Here are a few options: Option 1 - New consolidated stored procedure CREATE PROCEDURE dbo.spConsolidated AS EXEC dbo.Sp_collecting EXEC dbo.sp_numtoWord GO Option 2 - Copy the code from the second stored procedure to the first stored procedure Option 3 - Have the first stored procedure call the...