Viewing 4 posts - 1 through 4 (of 4 total)
I've seen systems where using Windows Auth fails due to Login timeouts set to over a 60 seconds. Mostly due to Cross Forrest setups and Domain Controller issues. SQL Logins...
March 30, 2018 at 1:42 pm
The code has several issues.
- Missing sp_removedocument means there is SQL memory leak. sp_PrepareDocument is no longer recommended.
- Placing a string into a XML type variable parses it automatically, there...
April 8, 2015 at 4:48 pm
Make sure SQL Browser service is running using port 1434. This service is the one to tell the client what Port number the instance is using.
I still see port 1434...
March 30, 2015 at 6:27 pm
Need to do with a derived table. Here is the command to return what you want.
SELECT t.id, t.colC, t1.RowNum
FROM #test t
left outer JOIN ( SELECT Id
...
January 30, 2015 at 11:18 am
Viewing 4 posts - 1 through 4 (of 4 total)