Nope. A snapshot is created on database level. Could be...

@amit-2 Gupta: In your example all results will become unique because of a newid() added to your select. Therefore the DISTINCT will not work anymore.

@Charbel: this is never gonna...

Thanks for the reply. What I meant with a "snapshot allowed to run for weeks" is a snapshot taken some weeks ago, that will generate double activity. Every change in...

Great article! It describes all the things you need to know to get started with snapshots.

I have a question though. Do I understand...

Also, take a look at this thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=309030

It describes problems with editing User Defined Functions on a SQL2000 machine via Management Studio.

I just found this on SQLJunkies forum:

*********************** Reply******************************

Yes, this is a known bug, and it has been resolved as fixed. It only

affects connections to SQL 2000.

See also...

I've got SQL Server Management Studio Express installed on my computer here. I tried to edit a UDF on a SQL2000 machine and experienced no problems with that. Saving on...

To me it sounds like you should use two connection strings in your application. One to the SQL Server and one to the Oracle Server. In my opinion you don't have...

@adam-2: You should use a Stored Procedure in which you use transactions. With a transaction you can safely insert all the data you want, also spread over several...

Mark, in your case you shouldn't use IDENT_CURRENT if you don't use transactions. Requesting the IDENT_CURRENT could provide a newer ID that another user just inserted before you were able...

I'm not sure if I understand you correct. Your sample data shows only one customer (sk016) with more than one (three) record. This would result in TotalSalesPositive = 112.7 and...

You could LEFT JOIN this table with itself for which you only want to join if your data field is either positive or negative. Something like this:

SELECT  NBillingF.Customer, SUM(ISNULL(NBPos.InvoicedValue, 0))...

SELECT ((A.amount1 + A.amount2)/2 * B.amount4) AS MyValue

FROM TableA A

    INNER JOIN TableB B ON A.Key1 = B.Key1 AND A.Key2 = B.Key2

This is a very simple query. Why not search...

@sblock: I agree with you that you wouldn't want to use an INSTEAD OF trigger in this case. You should only use it, if you want to manipulate the data...

I usually use some kind of 'CacheManager' within my code. In case a user/client makes a change in the database, you can either update your CacheManager at once or flag...