Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 8876

SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.

0 votes
0 answers
102 views

Remove requirement to specify [default] MS SQL port in vb and vbscript connection strings

I need to 'swap' an old database server (Windows Server 2008, SQL Server 2005) with a newer/better one (Windows Server 2012, SQL Server 2008) I tested this swap yesterday and everything worked on the …
MrVimes's user avatar
  • 629
0 votes
1 answer
632 views

Anything but small ODBC queries failing over long distance VPN after SQL Server Swap

I recently swapped database servers (restored databases from old to new and then swapped IPs)... Old: Sql Server 2005, Windows Server 2003 New: Sql Server 2008, Windows Server 2012 All processes tha …
MrVimes's user avatar
  • 629
0 votes
Accepted

Anything but small ODBC queries failing over long distance VPN after SQL Server Swap

Not my ideal solution (as I was hoping to avoid changing connection strings) but I solved this in my test script by adding Packet Size=1024 into the connection string. This didn't work for the Access …
MrVimes's user avatar
  • 629