What is the error message you are getting when you try to connect? Are you running SSMS on the SQL Server or remotely?

I don't think that there is a way to do this pre-2005.

BY default SQL Server install sets the MAX Memory option to 2 GB. My laptop has 1.25 GB RAM and SQL Server is set to max at 2 GB....

I think this is the code you are looking for:

[font="Courier New"]/*

Added IsNull because concatenating to a NULL yields NULL.  

Added ELSE to CASE statements so you keep the same value

Added Checks...

If you are really using SQL Server 2000 then you should get a syntax error because Create Role was added in 2005. I think in 2000 it was sp_addrole,...

Would be if I really KNEW anything beyond put left...

Yes you can. It is the same syntax as for permanent tables. Remember a temporary table is really a permanent table in tempdb that is hooked to a...

You would need a CASE as IF is a control of flow construct and CASE is an Expression.

Have you considered using a computed column as I suggested? I really...

This is a common problem people have. Here are some options:

[font="Courier New"]UPDATE paridtest

   SET parcel_id = parcel_id+CASE

                                   WHEN b.dir = 'North' AND LEN(RTRIM(LTRIM(STR(sect)))) = 1 THEN a.parcel_id+'00'+LTRIM(RTRIM(STR(a.sect +...

I would create a permanent table with a processed flag and insert salary changes to it from the trigger. Then have a job that runs every n minutes that...

I would venture to say that this means the import process is not CPU bound but IO or MEMORY bound.

Are you sure you have the necessary permissions to create a maintenance plan?

Are the files always put in the same location? If so you can use a foreach loop container that loops over .xls files in a the location. Processes...

Yes it is SSIS. SSIS does row by row processing so if you take 20 seconds to insert a 1000 records your date will vary. If you want...

The most common way I have seen recommended for this is to use dynamic SQL. Any other options depend on the behavior you want and the data you have....