And referring to an object in a database on the SAME server is as easy as:

select stuff from databasename.objectowner.ojectname

From the BOL entry on 'dbo', "any object created by any member of the sysadmin fixed server role belongs to dbo automatically". I would suggest that your connection to your...

.net framework is going to be part of Windows, soon enough. I believe that XP machines with Automatic Updates turned on will already have .net framework 1.1 on them. Installing it...

Having the trigger call an SP won't help, because the SP would still have to execute synchronously.

I would suggest having the trigger set a value, or create a row, in...

I imagine you have been experimenting with various GROUP BY and HAVING clauses on the Date fields yes? Tricky business. What I would do here is to cheat a bit. I...

Tell you what Bill, you write a T-SQL UDF that implements VB's Format function, and I'm sure you will get a special prize

I like this method! My usual solution to such requirements is to use selfjoins or EXISTS subqueries, but I think in future, at least when doing quick-n-dirty stuff in QA,...

>> I tried to read the database details using "SqldataReader", it says "System.Byte[]" for the "audiooriginaldata" column.

That's because that's what an Image data type is - a sequence (array) of...

Yes you can do this in pure SQL. Condition by condition:

-- Only dash or dot, @, 0-9, a-z characters only.

(myfield NOT LIKE...

Here you want a member that has Activity code Coordinator and Business codes code1 AND code2. The way to do this is to LEFT JOIN to Business twice, in effect...

The recent series of articles at sqlservercentral.com about SQL Server change control might be of interest also

Are you saying that if there are no records meeting the Custid condition, then you want only 1 row in your resultset? If so, try this:

select c from 
( select...

Looking at your sample SQL calls, those are exactly what would you would expect from a pre-.NET application that didn't use stored procedures...

I believe that changing your client data access...

The broad heuristic is that if what you want to do can be done with set-based operations, do it with set-based operations; only use a cursor if you have to.

Depending...

I correclty guessed that the desired answer was Yes, however for me the question seems to break one of the cardinal rules of relational databases - there is no such...