Thanks for providing....

i will update u

select max(len(name)) from sys.databases

Result

32

Please check i have attached complete procedure.

Thanks in advance

Thanks Gila...

Need to start my analysis.

I am going to get some stats on that table.

--where the table is getting accessed in frount end

--what the table indexes, these...

SQL Server sends a new query notification to the application, SQL server can’t find the remote service.

Following errors are getting logged in application log. beacause of any loggings event...

we have cluster env.....if we do node failover to passive node will tempdb will recreate.

Above procedure execution is taking more time to complte

arround 2hour

we have desined this procedure to get data from another db where the data in able to huge.

tableA will having :ID and row_number

TableB is having :Document_version_id and row_number

TableC is having...

I am not getting report options

yes....

i need data for each table in database where as i am using sqlserver 2005.

will it right procedure for to get current login information

select ec.connection_id,es.session_id,es.login_time,es.host_name,es.status,es.prev_error,

er.request_id,er.session_id,er.transaction_id

from sys.dm_exec_connections ec INNER JOIN

sys.dm_exec_sessions es on ec.session_id = es.session_id join dm_exec_requests er

on er.connection_id=ec.connection_id where es.session_id>51

It really working fantastic solution........ many thanks.

Hi Sean,

i found there is tab separation in my column data.i suspect that due to tab space in the column data it was happening.

how can fetch the data...

hi Sean Lange,

I have a tab separation is column data where it was

Row delimiter (CR LF) in the column data?

''New Line"

Column delimiter in the column data?

|