This works, but you will need to add a where clause into the update statement and change the decimal scale and precesion to fit your needs.  Also, if you need...

SELECT *

FROM Table1

 INNER JOIN Table2

 ON Table1.Date = Table2.Date

WHERE CONVERT(varchar(10), Table1.Date, 101) = '03/24/2006'

You would need to do it as part of the insert.  I don't know of a way for an update statement to work as SQL Server will have difficulty converting...

Take the double quotes off of "| GSL Account Search".  Use single quotes.  Also, you have multiple stray commas in your insert statements.  If you include the column name in...

You cannot schedule a job to run more often than 1 minute.  What are you trying to do that needs done every 3 seconds?

What is the error message that you...

You usually want to start your performance monitoring at a high level using only the basic counters for monitoring CPU, Disk I/O, and Memory.  If you find out that either...

If your drives become unavailable or full, SQL Server will mark your database as suspect, so if your database is available, the drives that hold your database files are also available. ...

Go into the SQL Agent>>Jobs view and look at the job properties.  Who is set as the owner?  Whomever it is needs to have permissions on your development server, so...

I do not know how you could accomplish this with a standard t-sql script.  I would say that you either need to create a vb script to check in your...

Is there a reason why you cannot just use the host name?

What are you trying to connect with, EM, QA, ODBC?  Are you getting any sort of message back?  Can you ping the IP?

From an optimization standpoint, you may get better performance from your while loop due to the overhead that a cursor adds when allocating/deallocating, but then again, you may not.  I...

The only way you will be able to significantly reduce the amount of time this takes is to re-engineer this SP to get away from row-by-row processing.  Removing the cursor...

Depending on how many tables you are talking about and how complex the data, I would look into creating a DTS package that can do your data pump and schedule...