AS = ASSEMBLY
PP = PARENT PART
CP = CHILD PART
I have a table as below that lists sub assembly parts for main assemblies.

I need two scripts; 1-Create all FK in the DB, 2-Drop all FK in the DB.
I need to generate the scripts and run them from a Job.
Is their a way to script all the fk in a DB??

I have a series of rows in a table that need a value changed,
something I could normally accomplish like this:
UPDATE MyTable SET Status = 'X' WHERE caseid = 100
Let's say this updates 10 rows,

Hi, I am try to learn sql by read some sql code I can find,
I see a stored proc which select some rows from tables based on some ids,
e.g. @Ids ="1,3,5,9".
I thought it will be as simple as

Hi, I have the following statement that gives the error listed below for SQL
Server 2005.  I'm not seeing what the issue is:
Statement:
UPDATE    Stores.dbo.Categories

Two days ago we have an issue with one of the sql servers.
How can I read the log file to see what happend two days ago?
thanks
JFB

I've got a script to add a field to a table and need to update that field in
the existing rows.  However I get the error "Invalid column name
'active_flag'." when I try to execute it.  What am I doing wrong?
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS

I've written a procedure requesting variable of the p/n to look up.
How can I take select distinct query and pass all those values into the
procedure or create a new query that does all that into temp tables and
returns it all?

I am experiencing failure connecting to SQL Server 2000 from SQL Server 2008
64-bit (Error 18456, Severity 14, State 8). This error log event is
misleading because the problem is NOT a password mismatch as I have
thoroughly tested connection from multiple other servers.

I’m having strange issue connecting to a SQL Server 2000 machine from SQL
Server 2008 machine.
The connection to the SQL Server 2000 machine works fine from a SQL Server
2005 machine.

I have a job that as one of it steps executes an sp in one db, and trying to
create functions in another database. Don't ask me why I am doing it this
way, it's too complicated. When I try to run the script to create the sp, I
get the following error:

I have found that code to run a sp asynchronously.
set nocount on
declare @rc int
declare @object int

This may be very easy but I am drawing a blank. I have two tables.  The
first table is #Table3 Columns Code and Description and the second is #Table4
with columns DocType, Code and Description. I would like to insert new
#Table3 values into #Table4. What's difficult for me is ...

I have Table1 and Table2 with two fields each (sys_id, emp_id).  
I want to see what Table1.sys_id & Table1.emp_id combination is not included
in Table2.sys_id & Table2.emp_id.
For example, Table1 has a record where sys_id = 'ABC1' and emp_id = '1234'.

Any suggestions of how to run T-SQL code on a background of an application?
What I want is to run some sql code  from my app. but not to wait till sql
execution is done.
Is that possible?