Multiple Instances may not work in my environment as i am trying to get rid of performance issues when doing a heavy dataload and multiple instance will share all the...

how can i do that into a temp table.

where can i see default build or run options.

and 1 thing to share if you are hitting f5 it may run all reports but if you right click on sepcific...

I mean Iam running the report from the project, it is building and deploying but i cant see the report in a web page but the report is displayed ...

GSquared

Another alternative is have two instances of SQL on the server. Load up the staging copy, restore it to the second instance, then change the connection in your front...

From this post iam bit confused.

Right now we have all different servers and only 1 instance on each. In our environment we dont have any friont end applications connected...

I have no reply for this post, is this something silly i have asked? 😎

If KERBEORS is not working , can i acheive that through sql login.

ALready i havea sql login as Link between the servers but i just gave read access to all...

Is this not possible by clustering?

Tracy

Even i followed the same thread to configure my linked server, but it didnt work not sure where am i going wrong.

I ran this query

exec sp_MSforeachdb 'Select ''?'' as DB_Name, * from ?.dbo.Sysfiles'

and got all the database files listed , that looks good but

the result was in seperate grid for...

Kelly

Sorry am nto aware of "KerbTray". Can you please let me know how wud i troubleshoot with it.

thanks

Yes, I checked with with windows admin he says all the SQL Servers are KERBEROS and Delegation is also enabled.

Myself also checked on all the servers with the following sql...

I donno why my link server setup is not working. I still doubt my code here to setup.

EXEC sp_addlinkedserver @server='DevRevenue',

@srvproduct='',

@provider='SQLNCLI',

@datasrc='',

@provstr='Integrated Security=SSPI'

I used this code from the forum...

May be 1 thing i missed to mention here. I am not updating all the Db's at one time each db may be updated in different times. So When I...