Reputation
586
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 10
Newest
 Caucus
Impact
~11k people reached

  • 0 posts edited
  • 0 helpful flags
  • 10 votes cast
Aug
25
awarded  Caucus
Aug
4
comment SQL Server Windows authentication - username not changed
Try using runas /user:NEWPCNAME\newusername ssms.exe. If you still have the same problem, then you need to delete a cached connection.
Jul
15
answered Intermittent DB connection failure
Jul
7
answered Merging Forms Authentication databases together
Apr
22
answered SQL Server Integrated Security without a Domain
Mar
11
comment How do I migrate a database between servers from SQL 2008 Std to SQL 2014 Std using T-SQL without losing data?
Can you post the query you used to compare the max IDs? Also, are the row counts of your main table different too?
Feb
26
comment Unable to connect to SQL Server on live server
Regarding your edit- just to clarify: SSMS is installed on the online server and it cannot connect to the SQL Server instance running on the same server? (I'm getting thrown off by the word "remotely".)
Feb
26
comment Outlook 2010 cannot reply to encrypted email
Yep, that sounds exactly like the problem I'm having. Which version of Outlook are you using?
Feb
11
awarded  Yearling
Jan
28
comment Is there a safe way to cancel updates during windows shutdown
When faced with the option of missing the last express train home or leaving your computer on all night, always choose the latter.
Jan
28
answered Theoretically, would two up-to-date windows systems be of a similar size?
Jan
15
awarded  Popular Question
Dec
18
awarded  Popular Question
Feb
11
awarded  Yearling
Nov
29
revised Outlook 2010 cannot reply to encrypted email
added new related scenario
Jul
9
comment SQL Server: Worse performance on a new server
Are you sure about this statement: "If there are any missing indexes (I don't think there are) they affect the old and new servers equally." I would start with the assumption that some of the indexes did not transfer with the restore, and take steps to make sure all of the indexes present in the source DB are actually present in the target DB too.
Jun
28
answered Unusal internet traffic drop off
Jun
28
comment Unusal internet traffic drop off
I disagree that historical data is needed to investigate. If historical data supported his theory, how would that help the investigation, except that you know you need to investigate?
Jun
14
answered AWS - Load Balanced EC2 Instances. Same or Unique public IP address
Apr
8
comment What MS SQL Server administrator client should I use?
I guess when the OP commented: "The ssms version is the most recent. I downloaded it today.", he must have meant he downloaded the most recent version of SSMS 2005.