hi yes you can move the files and also add new files

First set the database offline.

Copy the current disk files to the new location.

Use the "ALTER DATABASE MODIFY FILE"...

at the end of the day SQL Server is just another application, the OS is the fundamental part of the equation. Every DBA whether Oracle\SQL\etc should understand and be able...

Jay Murthy (7/16/2008)

---

A Q. are following 2 queries same or diff and why?

declare @val1 varchar(25),@VAL2 varchar(25)

SET @val1 = ''

SET @VAL2 = 'W'

If 'W' In(@val1,@VAL2)

Begin

PRINT...

yes, its under HKLM\SYSTEM\currentcontrolset\services but i find a WMI query easier personally

here you go try this, reports database name, logical filename and log file locations for all databases on an instance

select a.name, b.name as 'Logical filename', b.filename from sys.sysdatabases a

inner...

do you have any databases you want to keep?

open the services console from administrative tools and check the sql service properties. A default instance will have the service name...

check this link

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

as for cost, who do you normally purchase licences from ?

Give them a call and get a quote would be best?

Basically Ent allows online indexing , max CPU...

check the services.msc console or enumerate through code

a default installation of SQL server will have the following service name

MSSQL$SERVER

for a named instance it will be

MSSQL$instancename

is this a typo, your...

😉

ungmax

it would be helpful for everyone including yourself if you didnt hijack someone else's thread. Best to start your own you probably get more response that way

double check spelling of domain\username

do you have a firewall enabled?

if so check the firewall log

ALZDBA (6/16/2008)

---

Another downside of virtualisation is cpu licensing:

If you license an instance on a physical server, you license per cpu socket.

With virtual servers, you license per available cpu (i.e. cpu-core...