Hi

if you want just data and structure then use the following for a quick and dirty

select * into newtable from...

if you run the root SETUP.exe it will detect your architecture and launch the appropriate installer. You can also see the architecture by clicking options on the left menu in...

is this a windows 2003 or windows 2008 cluster?

Good old DOS Jeff, you can't beat it can...

No, it is creating a new clustered instance 😉

there is...

newbie2sql (3/19/2010)

---

Hi Perry Whittle

Solution you had given me is correct for my solution. Currently I am checking the permissions and...

yes, that goes without saying!

OK, i made this real easy. The screenshots below shows the registry entries created when installing SQL Server and the instance configuration in the installer. Notice the default instance (MSSQLSERVER)...

i dont see whats wrong with my script?? :ermm:

As Gail says "no commit, no dice" 😉

it's also worth noting if the database is in simple or bulk-logged recovery the create\alter index is not fully logged!

you...

try this

--uncomment the where clause and specify a database user

--to get permissions for a single account

USE yourdbhere

SELECT

'Permission "' + CONVERT(NVARCHAR(10), permission_name) COLLATE Latin1_General_CI_AS + '" "' +

case CONVERT(NVARCHAR(10),...

the index which is being rebuilt is stored in a temporary area and brought in when the rebuild has finished to replace the existing index. An outage shouldnt really have...

Scott Wise (3/4/2010)

---

How would one go about adding an instance to a SQL2008 cluster? I am running a Server 2008 Cluster with the default instance installed and working beautifully,...

totally agree Thor.

the revoke thing is a little ambiguous i agree. I understand it as

if you take the user account out of the ACL you have neither allowed or...