what permission level does your account have?

mw112009 (1/25/2016)

---

Please see attached.

The highlighted field represents my PC name.

All this time I have been connecting to other servers. This time I thought I will have something locally on my...

lmacdonald (1/25/2016)

---

Hi,

We are relatively new to clustering. We are experience a lot of failovers and was wondering if someone could help me figure out where to start looking for...

try this

SELECTobject_name(i.object_id)AS TableName

, i.nameAS IndexName

, STUFF((SELECT ', ' + QUOTENAME(c2.name) +

CASE ic2.is_descending_key

WHEN 0 THEN ' ASC'

ELSE ' DESC'

END

FROM sys.indexes i2 inner join sys.index_columns ic2

ON i2.object_id = ic2.object_id AND i2.index_id...

mohit.699602 (1/22/2016)

---

Anyone can suggest ??

Microsoft SQL Server 2005 - 9.00.5000.00 (X64) Dec 10 2010 10:38:40

Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)

on Windows NT 5.2 (Build 3790: Service...

gary1 (1/20/2016)

---

Hi,

I have a user called USER 1 with dbcreator and securityadmin roles. He created a database DB1 and this database should be accessed by another USER 2. But he...

For me very good article, only down side was the lack of support for mounted volumes, but Ed has recognised this :satisfied:

SQLSACT (1/20/2016)

---

Hi All

Does anyone know of a way to preserve the users, assigned DB roles, owned schemas etc of a database that will be overwritten?

Scripting out the users is the...

Ed Wagner (1/19/2016)

---

Perry Whittle (1/19/2016)

---

ramya.sqlservr (1/19/2016)

---

Ed Wagner (1/19/2016)

---

ramya.sqlservr (1/19/2016)

---

Does this work for mounted volumes as well?

We have mounted volumes on our servers and I generally use fsutil to get free...

Use this rather than fsutil

wmic volume get name,capacity,"free space"

curious_sqldba (1/19/2016)

---

Perry Whittle (1/19/2016)

---

Yes you specify the listener name and the database...

Vmware DRS uses Vmotion to move vms around to balance usage across the hosts in an esx cluster

Andrew G (1/19/2016)

---

AG for either...

Yes you specify the listener name and the database name you wish...

GilaMonster (1/19/2016)

---

Perry Whittle (1/19/2016)

---

An availability group may have multiple databases, you need to specify the listener name, database name and readonly intent option, then (if routing is correctly configured) you'll...

An availability group may have multiple databases, you need to specify the listener name, database name and readonly intent option, then (if routing is correctly configured) you'll be redirected to...