sqlguru (7/7/2009)

---

These are two of the most fundamental features needed for SQL Server in terms of administration, developing, performance.

Pointer-based foreign keys

The relational model has no place for surrogate keys. When...

What edition of SQL Server, and what have you written so far to meet your requirements?

ChandraMohan Nandula (7/7/2009)

---

Hi,

I did not find any articles related to sql server 2005 architecture here. Even in the forums when a user ask about the sql...

I think I'd do it more like this:

declare @NextProductID int;

update dbo.ProductsSequence set

@NextProductID = ProductID = ProductID + 1

from

dbo.ProductSequence with (tablockx)

where

...

I think he is asking about the naming conventions used for naming the transaction log backup files, but I could be wrong.

I'm not a zealot, and i don't have any supporting documentation. What I will tell you is that you will get a lot of differing opinions on the matter.

I...

we still need to see the different scenarios that may be present inthe values provided in the variable.

Haven't tried it or fully researched it, but I don't think you can convert an existing table into a partitioned table. If this is possible, I'd love to see...

Double posted. Please post reponses here.

hi_abhay78 (7/6/2009)

---

As per this MSDN , yes its not supported .

http://msdn.microsoft.com/en-us/library/ms165636(SQL.90).aspx

But there is a tweak 🙂

Copy DatabaseMail90.exe, DatabaseMailEngine.dll and DatabaseMailProtocols.dll into the MSSQL\Binn directory and execute below mentioned system...

You'll have to excuse me, but I'm much more of a visual person, could you show us the various forms the query could take based on the various parameters passed?

What application are you tracing? There are several third-party applications that use server-side cursors in this fashion, one such application is PeopleSoft.

I'm having a little trouble visualize what you are attempting to accomplish, and I have looked at this several times over the past week. If you could provide the...

Here is an alternative solution. I added an additional column to show you what was being returned.

declare @customers table (cus_id int);

declare @orders table (cus_id int, order_date datetime);

insert into @customers...

Database Mail is not supported in the Express Edition, nor is SQL Server Agent.