Instead of creating database for every user(which sound so absurd) you can create views for every user and grant permissions on the view. If you have multiple databases then how...

Vandy..I don't see anything wrong in the query but I need one clarification. Is the credit and debit stored as postive value in the database (with another column being an...

Like you said it was not ordering by sid but was ordering by dbid but was dsiplaying dbid as sid (as is optional)

Assuming that the work week is Monday to Sunday here is how you can do it.

Declare @date1 datetime

set @date1 ='9/3/2006'

SET DATEFIRST 1

select @date1 as date1,DateAdd(d,-1 * DatePart(dw,@date1)+1,@date1) as WeekBegin

SET DATEFIRST 7

Changing...

1.run DBCC OPenTran to see if any open tranasctions are there

2.Change Recover Model to "simple"

3.Do a complete backup.

4.Run DBCC ShrinkDatabase(DBName,10)

5.Change Recover Model to "full"

6.Do a complete backup.

7.Use the backup file...

Try this:

 Update _FinalTrans set LargestTicket = B.LargestTicket

 from ( Select  Acct, MAX(TransAmt) as LargestTicket

  FROM _FinalTrans

  GROUP BY AcctNo ) B where _FinalTrans.Acct = B.Acct

Hope this helps:

Select Auction.AuctionRefID,AuctionRefID.AuctionPrice,

 Customer.CustomerName,Products.ProductName

 from Auction INNER JOIN

 (

  select AuctionRefID,max(AuctionPrice) as MaxPrice,min(AuctionID) as MinAuctionID

  from Auction

  Group by AuctionRefID ) WinningBid on Auction.AuctionRefID = WinningBid.AuctionRefID

     and Auction.AuctionID = WinningBid.MinAuctionID

 INNER JOIN Customer ON Auction.CustomerID...

If your database is huge the backup and restore is going to take some time.But the same is the case of "snapshot" Replication. DTS is not the way to do...

DR is based on your requirements and the expectation by the end users on  How much data loss can your users tolerate and how long can the wait.

To begin with...

If this process needs to work it should keep running every X minutes. But the problem is then you need to schedule a job that keeps running and sends email....

Do you have trouble connecting to SQL Server with your "Machine Name"?

My guess is if you have a dot in the name SQL will assume it to be Owner.tableName instead of treating the table "Daily_transactions.hist" as table Name.

Thanks

Sreejith

SQL BOL(Books Online) has everything u have asked for.

Thanks

Sreejith

Just an FYI, keep in mind about what SQL considers a week. You can do that by SELECT @@DATEFIRST. Default is Sunday so if your week starts on Monday then...

Have u looked at query execution plan? That should point you in the right direction.Do you have Index on bloodType?