If the proc is in A and A is down, then they wont be able to run the proc as they cant get to A, so your logic is flawed.

What...

michael.higgins (2/5/2013)

---

Unless i'm missing the point??

The stored procedure exists on the server. The application connects to that server. If you need to change the server in the application...

Because the query is dynamic, and without sp_executesql it will not expand the contents of the variable.

Dynamic queries like this are bad practice, I would highly recommend not doing this.

SQL has to install some things on the C drive to integrate with the OS, but the majority of the main important binaries will be on the D drive.

what error?

declare @mypath varchar(50), @sql nvarchar(100)

set @mypath = 'myserver.mydatabase.dbo.'

set @sql = 'select * from ' + @mypath + 'order'

sp_executesql @sql

Take a look at a tool called RSScriptor which will do the migration to disk then you can upload to 2008.

If you have the solution files for the 2005 reports,...

You could use PSLoggedOn from the sysinternals suite of tools.

or

Login to the server and see who is logged in

or

Use windows based authentication instead of using a generic account, then you...

You want the name of the logged on users of the server, or the SQL login used

Did you try Google or your favorite search engine?

select

DB_NAME(database_id),

sum(size) * 8 AS SizeInKB,

(sum(size) * 8) / 1024.0 AS SizeInMB,

((sum(size) * 8) / 1024.0) / 1024.0 AS SizeInGB

FROM

sys.master_files

GROUP BY...

Sorts will affect TempDB as thats the holiding area while it sorts the records.

Referring back to you other post on this topic a while back

http://www.sqlservercentral.com/Forums/Topic1413043-391-1.aspx

You can assign permissions at individual object level inside the DB, so that is why you have security at...

Jeff Moden (2/4/2013)

---

anthony.green (2/4/2013)

---

Jeff Moden (2/1/2013)

---

anthony.green (2/1/2013)

---

ChrisM@Work (2/1/2013)

---

Or this:

SELECT

T1.IDCUST,

T1.IDINVC,

T2.AMTPAYM,

TotalPayment = SUM(AMTPAYM) OVER (PARTITION BY IDCUST, IDINVC)

FROM MyTable1_ARIBH T1

INNER JOIN MyTable2_ARTCP T2

ON T2.IDCUST = T1.IDCUST ...

Out of interest what have the resellers quoted you for and how much roughly?

You could go server cal on that one then.

Last time I checked the OpenNL pricing is

$6874 - Enterprise Core - 20 cores (2x6)+(2x4) = $137480

Enterprise doesnt come server & CAL...

30 individual users or 30 max concurrent users?