http://msdn.microsoft.com/en-us/library/ms173763.aspx

It is SET at the connection level as stated in Books On line.

By default SSIS tasks like [Execute SQL] or [Data Flow], open a connection upon start and close...

Well you did not specify that it was not sorting in the order you wanted, numeric first by value, character next. It sounded like it was an issue with...

It sounds like you have the data in both a csv file and in a MS Access table.

If I am wrong, please tell me.

1 - Use the import / export...

There is not guarantee to order with a union or selecting from a heap.

Use separate inserts to make sure order is preserved as below.

-- Create table

CREATE TABLE #varchar_field1

(

ID...

Hi Sharky,

I do not totally agree with you!

A - Did you even look at Glenn Barry's scripts?

-- Top Cached SPs By Total Worker time (SQL 2008). Worker...

Again, a job is one way to do this.

See "Set Job Step Success or Failure Flow" - http://msdn.microsoft.com/en-us/library/ms177461.aspx - Conditions for optional execution.

I tried to elaborate more on...

It all depends upon the target database server. http://msdn.microsoft.com/en-us/library/ms188279.aspx

This link has a nice diagram for linked servers. As you can see, the provider can be anything. With...

Hi shatrughna,

Interesting idea from Oralce to use a select to do the lock first. Look at the note section since this applies to SQL Server.

---

Link:

http://docs.oracle.com/cd/E17952_01/refman-5.1-en/innodb-locking-reads.html

Note:

Locking of rows for update...

Hi All,

First, I am assuming that you are using at least the standard or higher version of SQL Server.

I think the Express version does not have the agent.

The SQL Server...

Hi vijayarani

I took the liberty of changing the table aliases to a two character abreviation to make the code simple.

I reformatted the select statement. The condition of the table...

Hi Guys,

I took a look at the MSDTC article. I have been down that path before during setup.

I guess the question is why use a transaction at all when...

Create a job named J. Schedule each call as a seperate Step.

As a default, the error in the Stored Procedure will be returned to the job.

Use the conditions on...

Take a look at Brent Ozars article on "playing doctor".

It lists a bunch of free scripts out there to help identify problems such as high CPU.

http://www.brentozar.com/sql-server-training-videos/playing-doctor-with-dmvs/

Take a look at the...

This renaming of a server article has a code snipet to find all the instances.

http://craftydba.com/?p=1832

I agree with sgmunson that most of these posts do not have enough information to make a judgement call.

However, this is what I am thinking.

1 - You said that when...