Viewing 15 posts - 16 through 30 (of 56 total)
From what I can gather they could connect to the old server (standalone) which was configured to 1433 ? Now that you have moved to the cluster and the port...
June 1, 2011 at 5:50 pm
The sqlcmd being used is it the same from both area's ? What is the difference between the 2 machines you are testing from ? Ie are they both internal...
June 1, 2011 at 3:23 pm
With your cluster and your 3 instances did you do some post configuration changes after your install completed and set the port number for each instance to a static port...
June 1, 2011 at 7:17 am
When building a wsfc with 2, 3 etc number of nodes and then placing SQL server ( in your case 3 instances) you need to understand the overall set of...
May 31, 2011 at 4:32 pm
have a read of these links, they give a good answer
http://msdn.microsoft.com/en-us/library/ms137653.aspx
http://www.bimonkey.com/2010/10/the-merge-join-transformation/
May 29, 2011 at 3:40 pm
Sqlping will allow you to discover all servers and work stations on your network with SQL server installed. You could then use powershell to connect to all of the servers...
May 26, 2011 at 3:43 pm
Have a look at this URL to see how to set your Config file appropriately for the type of authentication you are chasing http://msdn.microsoft.com/en-us/library/ms157273.aspx
May 24, 2011 at 6:18 am
The stored proc sp_change_users is the old proc used to achieve resolving orphaned users. As outlined in BOL and available via this link http://msdn.microsoft.com/en-us/library/ms174378.aspx this will be removed and you...
May 23, 2011 at 7:11 am
You can create the stored procedure with encryption and then grant execute permissions on the proc. http://msdn.microsoft.com/en-us/library/ms187926.aspx[/URL]
May 23, 2011 at 1:51 am
imfairozkhan (5/19/2011)
Hi All,How do i generate the below output in sql server
agesex
10M
11M
12F
13M
15M
16F
17M
18M
19F
20F
Output
age rangeMF
10-1221
13-1520
16-1821
19-2002
thanks all
Are your age ranges always going to be ranges of 3 years ? What age group...
May 19, 2011 at 2:33 pm
Why do you need that many rows to be inserted from 1 table to another table in that short amount of time ? What are you going to being using...
May 19, 2011 at 5:19 am
You will need to use Kerberos if you require a double hop. If you do then only Kerberos can provide the pass through credentials. Kerberos is a big beast and...
May 18, 2011 at 7:26 am
An inplace upgrade is never a good idea as it does not give you an easy rollback option. A new install or side by side install followed by db upgrades...
May 17, 2011 at 1:19 am
Digs (5/16/2011)
.."Rebuilding indexes, no you can wait for the regular maintenance jobs."...ME: Like what sort of code does that??
.." recommend to use Update statistics."..
ME: yes I did, thanks
Digs, Regular Maintenance...
May 16, 2011 at 2:04 pm
Viewing 15 posts - 16 through 30 (of 56 total)