Viewing 15 posts - 31 through 45 (of 140 total)
Even though you close the connection in VB, SQL Server keeps the connection open for a while anyway. This is like caching, it is to speed up reconnecting if your...
September 28, 2004 at 8:32 am
Have you checked in enterprise manager that there aren't any locks in the database holding up your job?
Does your application specifically CLOSE the connection to the database?
Peter
September 23, 2004 at 6:51 am
The first thing I think is wrong is that you need to use '&' instead of '+' for concatenation of strings. Also, it is best to put dates into 'dd...
September 22, 2004 at 9:02 am
If server2 is a linked server on server1 you just do
SELECT *
from database1.dbo.table1 t1
LEFT JOIN server2.database2.dbo.table2 t2 ON t1.keyfield = t2.keyfield
WHERE t1.col2 <> t2.column2
UNION
SELECT *
from database1.dbo.table1 t1...
September 22, 2004 at 8:40 am
If you are retiring the old server and the new server doesn't have any other SQL server databases on it, you can go for the easier approach:
Make sure both servers...
September 21, 2004 at 8:13 am
Did you increase both the command and connection timeouts? It sounds likely to be a connection timeout as the user ID verification would be the first thing run (I guess). Also,...
September 21, 2004 at 7:25 am
I am doing the same (XP pro at home, connecting via VPN).
I am guessing, but the first problem I had was DNS name resolution of the server name. Try...
September 16, 2004 at 10:26 am
It sounds like you might not have put in the correct user name and password to link to SQL server, or, if SQL Server is set up to use 'windows authentication' only, you...
September 16, 2004 at 10:09 am
You don't say what your restrictions are, so the easiest thing you can do is :
1) stop SQL server on source and destination servers
2) copy all the databases and log...
September 16, 2004 at 9:48 am
Try exec [AVB1\AVB1].msdb..sp_start_job 'UpdateMTS_AVB1'
But, remember that you have to set up your 'restore' server up as a linked server and you can give it any alias you want on the...
September 16, 2004 at 3:03 am
When you view text fields it uses carriage returns/line fields in the text to split the view of the text onto multiple lines. You can't see the other lines of...
September 15, 2004 at 8:59 am
Outlook is a memory hog and some versions have been known to not release memory to other applications even when closed down. It also checks for new mail every few minutes and can...
September 15, 2004 at 7:39 am
Edit the job steps and go to the Advanced tab. Make sure that the option to 'Append output to step history' is ticked.
Also right click in enterprise manager on 'SQL Server Agent' and display...
September 14, 2004 at 8:20 am
I am doing the same thing. I have a server called Callserver and a warm start server called callserver2. I have a maintenance plan that created a full and transaction...
September 14, 2004 at 8:11 am
Why don't you change the data grid to just display the loaded records that are not yet linked to a project. When you link the records to a project you...
September 14, 2004 at 7:47 am
Viewing 15 posts - 31 through 45 (of 140 total)