i think u need to execute a job with someother user. otherr than the owner of the job. try to use the "execute as user" in the execute step and...

I am not confident but hope that it can be done using DTS tasks. I shall try and let u know the steps to be followed for that.

din't u try with CASE statements.

FOr database u can detach and attach the databases. For logins and job u can use DTS to move the jobs and the logins to the new server.

Remember to d...

I think named pipes id disabled in ur sql server. enable named pipes or use TCP/IP to create the ODBC.To enable named pipes follow the belwo pipes.

1. connect to the...

did u check which process consumed most of your memory and processor time. if tis sqlserver then we have to tune the server to perform optimally.

just read the below link it gives u a brief about transactions

http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart3.asp

just add a registry key to the given path

key type: String Value

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo

OLE DB provider 'SQLOLEDB' could not INSERT INTO table '[MUSSORI].[pubs].[dbo].[jobs]' because of column 'job_id'. The user did not have permission to write to the column.

Just check the permission...

just type eventvwr.msc to bring ur event viewer where u can find the errors related to sql server service startup lok for the errors in application and system logs and...

yes u can but u will have to script out all the required ones. read the below procs in books online this will surely help

sp_trace_create

sp_trace_generateevent (Transact-SQL)

sp_trace_setevent (Transact-SQL)

just look at the sysjobhistory tables u will find the step wise details of the job. the sttus, start time, runtime, next start time. etc

wats the number of rows returned by each database. i hope u r trying to create a view that will for sure hit ur sql performance.

try to create a UDL fiel and use the information from the UDL file to create a connectionstring

since the same query works fine with QA and EM i hope this should not be a permission issue, but it should be a configuration issue.  Check the way how your...