You will these alternate ways to manage FK constraints discussed fully in BOL:

1. Under 'Index' tab in BOL, type 'constraints';

2. Double Click on 'FOREIGN KEY' and select 'Creating and Modifying...

You will find in the msdb database a role called TargetServersRole. By granting exec permissions to certain system stored procs, such as sp_start_job, you can make the user a member of the role...

Assume you have the table [tableLatLongs] with the latitudes and longitudes. Then to use the function, you can simply type something like this in Query Analyser or Enterprise Manager:

select LatDeg1, LonDeg1, ...

My apologies, I meant a longer QueryTimeout period, say 90000!

The error is common when your subscriber (for a PUSH subscription) or publisher (for a PULL subscription) is busy with processing long-runnning queries containing the articles that you are replicating.

As...

I've pretty much notched up 10 years of IT experience, and I don't have a CS degree (though I do have a Graduate Diploma in CS). My background is in...

If the data is already there, then make sure that the order of your inserts is correct.

You could try using SQL Profiler and capture the individual statements and/or SP and their duration over a set period. Then import this data into a database and perform your...

For a listing of the different flavours of Windows OS and SQL Server editions, and whether or not AWE is supported, have a look at this article:

http://www.sql-server-performance.com/awe_memory.asp

Another thing to...

You seemed to have summarised it well! Just remember to set both the minimum and maximum server memory. Your setting of 6GB for the second server could be upped a...

You can find out by using the following statement:

select cast('01-JAN-0997' as datetime)

You are pretty much limited with only 4GB RAM. Assuming the server to be primarily a database server, then the maximum RAM that SQL Server can use is 3 GB,...

Oh, one other possibility is to use the CASE statement:

Select Name, SUM(CASE @param1 when 'colA' then colA when 'colB' then colB ... end) AS Total 

from customer_order_lines

group by Name

I can think of two options:

1. You can use the IF... ELSE IF statement and repeat the SQL code that you've supplied for each requried column to sum.

2. You can use...

I am not aware of any 'simple' command that will do it for you, but there are plenty of third party tools that can generate the schema from a database....