Viewing 15 posts - 7,546 through 7,560 (of 9,253 total)
turfnsurf4me (10/18/2010)
MSSQLsvc/<machine name>:1433 and with the FQDN
This is incorrect, when running SQL Server under the context of a user account the SPN is bound to that user and not the...
October 18, 2010 at 3:14 pm
Duran
It's only SQL Server 2008 that has the shared folder location issue, which itself is fixed in a later CU. SQL Server 2008 R2 as far as I am aware...
October 18, 2010 at 3:06 pm
is this a Windows 2003 or Windows 2008 cluster?
October 18, 2010 at 2:34 pm
which file occupies the most space and has the most free space?
October 18, 2010 at 2:32 pm
Abdul
as already stated you do not need to put the SQL server instance into single user mode to modify the file paths for model and msdb databases. Also, do not...
October 18, 2010 at 2:20 pm
Duran (10/18/2010)
Should I run and add node B now to make it a 2 node cluster, or should I install the other instances (Mulit-Instance) on node A first?
It doesn't...
October 18, 2010 at 2:16 pm
as Brandie states you probably have the client tools install disk only. The CD format has 2 disks and the second disk has client tool install only. The DVD image...
October 18, 2010 at 8:16 am
Doug
Could you confirm you see the following?
➡ splash screen appears when disk autoruns
➡ click install server components and wizard starts
➡ accept EULA and click...
October 18, 2010 at 7:19 am
Jeff Moden (10/18/2010)
Not quite so with your code.
Junk the snippy little aggregate function on the rownum with gaps too 🙂
October 18, 2010 at 6:01 am
First identify the column(s) that comtain the pertinent data. Once identified the following will suffice!
Select TOP 10 column, column, ...
From mytable
Order by somecolumn desc
October 18, 2010 at 5:32 am
Not all SQL servers are suitable virtualisation candidates!
October 18, 2010 at 12:34 am
the question displays a degree of ambiguity but not stupidity!
October 17, 2010 at 2:03 pm
please do not double post, you already have a thread on this subject in the appropriate forum.
Replies to http://www.sqlservercentral.com/Forums/Topic1005872-1549-1.aspx
October 17, 2010 at 1:36 pm
do you have a separate computer or are you installing your mirror instance on the same machine as the principal?
October 17, 2010 at 12:16 pm
Steve Jones - SSC Editor (10/16/2010)
Of course, that limits the size of the host, and then the VMs
This, I suspect, is the key here!
October 16, 2010 at 8:28 am
Viewing 15 posts - 7,546 through 7,560 (of 9,253 total)