You can also use SET SHOWPLAN_TEXT ON option instead of graphical view.

Looks like your Log file is not at the same location where your Data file is. By default it looks for log file location where your data file is, though...

Are all the tables in one database?

You could use import export wizard or

Change the following query for inserts

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=c:\test.xls', Sheet1$)

I agree with everyone SQL DBA + SSIS +SSRS

With a (textID,TypeText) as

(Select t.textid,T2.Typetext from test t left join test t2 on t.ID=t2.ID where t2.typetext='Agree'),

b (textID,TypeText) as (Select t.textid,T2.Typetext from test t left join test t2 on...

Just curious to know if you found the solution.

Try changing the TCP port number of named instance and see it that works.

Check this blog if it helps

http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

Make sure your Browser Services is on

Try this

WITH ObjectLevelPermissions(ObjectName,ObjectType,GranteeName,GrantorName,[SELECT],[DELETE],[INSERT],[UPDATE],[EXECUTE],[VIEW DEFINITION]) AS

(SELECT ObjectName,

ObjectType,

...

Try giving Select permissions on Filtered Views. Microsoft recommends to query Filtered views in CRM rather then tables directly.

We use CTE's in our environment for 'on the run' queries where code is most likely not going to get repeated. For one time use, we do not want to...

Rename SRV1\A to SRV1\C and then rename SRV2\A to SRV1\A. Try if this works

Not sure if this helps

SELECT t1.TABLE_NAME,

FILEGROUP_NAME(t2.groupid) as FileGroup

FROM INFORMATION_SCHEMA.TABLES t1

INNER JOIN sysindexes t2

ON OBJECT_ID(t1.TABLE_NAME) = t2.[id]