A computed column cannot be used as defining expression may only reference base columns within the same table.

You will need to add a physical column and then use a trigger...

The system function works as defined, which is for the current database user

When connection with a domain account with sysadmin role:

select is_member('UserRole'), user_name(), suser_sname()

execute as user = 'Carl.Federl'

select is_member('UserRole'), user_name(),...

Use the SQLCMD program:

sqlcmd.exe

[{ { -U login_id [ -P password ] } | –E }]

[-S server_name [ \ instance_name ] ]

-Q"execute msdb.dbo.sp_startjob @job_name = 'PREPROD_ORA_POPULATE'"

and any other parameters that...

Jeff & GSquared:

Did either of you get a chance to perform any additional analysis ?

For your reference: "The Ntbackup.exe operation may break the differential backup chain of a SQL Server database and may invalidate the differential backups when you perform a snapshot backup of...

I intend to do something like this:

SELECT @FValue =

CASE @FieldName

...

SSMS is short for SQL Server Management Studio and only works with SQL Server.

Are you sure that the product name is Progress?

Progress is a company, and their DBMS is ObjectStore.

Postgres...

As written, the WHERE restrictions are causing any left outer joined rows to be removed from the result. Try this:

FROM T_OrderLine

LEFT OUTER JOIN

...

Joe's code looks complex, so i need some time to analyze it.Probably i will analyze it on my home PC (this weekend). Thanks for highlighting his method here.[/code]

I misread you...

Joe Celko wrote a solution back in November of 1996 titled "aggregate product function" and can be found in "SQL For Smarties"

Here are Joe Celko's remarks:

Here is a version of...

In SSMS, on the job step propertiesm there are two pages in the upper left: "General" and "Advanced", both of which have a "Run As" option:

On the "General" page, the...

Birth year may not be that easy.

If...

What is the datatype of the column ?

If datetime, then the display format is what needs to be changed, so read BOL about "SET DATEFORMAT"

The Reuters Market Data System appears to be using StreamBase although it is not clear if other DBMSs are supported.

Congratulations to Dr. Stonebraker, who has developed four DBMS with...

The privilges of the built-in database role are hard-coded into SQL Server based on the value of the sysusers.uid column, and sp_addrole does not add with the needed values.

The solution...