for a while if we not do your mentioned process and assign all these 3 existing roles to the new Login then why it is not working & locking the...

Thank you Guys, everything seems to be working now.

I did install SQL 2005 standard edition integration services. But now my buds 2005 is crashing. So it seems like I am making progress and missing part was not installing...

Yup, I did use right words, installed BIDS so that I could open up these packages look at them and also was being optimistic of being running them. Actually, I...

Thank you 'Orlando Colamatteo' for replying. I have tried that in past but I receive below error while running my job through SQL Server agent:

Error: 2016-01-14 11:20:40.48

Code:...

Hope I get opportunity to attend Itzik's seminar one day.

Create table #tbl1( empid varchar(4), name varchar(8))

insert into #tbl1(empid, name)

Select 'abc','Mayank'

union

Select 'xyz','Mayank2'

SELECT empid,name,ROW_NUMBER() OVER(ORDER BY empid...

Sourav (8/31/2009)

---

Thanks Mayank, JAson for all your response..

I have noticed one more thinj..

(1) While executing the query as:: DBCC inputbuffer(77)--SPID,

I'm getting one result.

---------------------------------

Output::

Exec ImportComponents '459087',''

(2) DECLARE @HANDLE BINARY(20)

SELECT @HANDLE =...

If you are getting blank using fn_get_sql then probably your query has zero cost plan, hence not stored in cache. If you turn on flag 2861(By...

That is funny 🙂

If you know the SPID of that particular user then use DBCC INPUTBUFFER or fn_get_sql as follows:-

------------------------------------------------

DECLARE @HANDLE BINARY(20)

SELECT @HANDLE = sql_handle from sys.sysprocesses where spid =

SELECT text FROM...

Thanks, that was a great information.

Article says

Microsoft Connector for Oracle by Attunity

The...

Is it possible for you to check the results of sp_who2 for this particular process when you are transferring records from SQL to Oracle? It could be your slow network...

The two Screen Shots are not getting displayed under "Analyze the Results" section. Is anyone else facing the same problem?

I ran ur scipt on my test database and it changed fillfactor fine for my Indexes on table.

Just include Print and see if your alter for your particular table...