| 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 |