724 reputation
313
bio website
location New York, NY
age 36
visits member for 2 years, 2 months
seen just now
stats profile views 43

Dec
22
comment Deleting duplicates with group by and count
is it possible to add a column to the table and fill the column with a unique key then drop the column after the clean up?
Dec
21
comment unique key violation occuring on a unique value combination
ahhhhhh. I should not have missed that. Thanks yper.
Dec
21
accepted unique key violation occuring on a unique value combination
Dec
21
comment unique key violation occuring on a unique value combination
Added Update statement that is failing as well as rows that are causing conflict.
Dec
21
revised unique key violation occuring on a unique value combination
added 4234 characters in body
Dec
21
awarded  Editor
Dec
21
comment unique key violation occuring on a unique value combination
table definition added
Dec
21
revised unique key violation occuring on a unique value combination
added 1929 characters in body
Dec
21
asked unique key violation occuring on a unique value combination
Dec
15
accepted Cant connect to Server using SSMS on my desktop
Dec
14
comment Cant connect to Server using SSMS on my desktop
@Matt M When I ping the servername the ip address resolves correctly.
Dec
14
comment Cant connect to Server using SSMS on my desktop
@Shawn Melton. I can remote desktop to the computer and connect with out a problem.
Dec
14
comment Cant connect to Server using SSMS on my desktop
the way I worded that is a little confusing. I ran the command telnet <my servers name> 1433
Dec
14
comment Cant connect to Server using SSMS on my desktop
I dont really know telnet but when I run the command (swapping the servername with sql01) the cmd screen goes black and just sits there for about 30 seconds then takes me back to a prompt.
Dec
13
comment Cant connect to Server using SSMS on my desktop
ok. I disabled the firewall and tried again but I'm still receiving the error. OS = Windows Server 2008 R2 Standard.
Dec
13
awarded  Commentator
Dec
13
comment Cant connect to Server using SSMS on my desktop
hmmm the windows application log says its listening to 1434 though... Thats the udp default right? Do I need to open the udp port in the firewall? or is there a way to force it to use the tcp/ip port?
Dec
13
comment Cant connect to Server using SSMS on my desktop
The browser service is running. When I check the TCP/IP protocol it has 1433 listed as the port.
Dec
13
comment Cant connect to Server using SSMS on my desktop
I can ping the server using both name and ip address.
Dec
13
asked Cant connect to Server using SSMS on my desktop