I have a problem registering a SQL server 7 in Enterprise Manager. It always shows message Timout Expired.
The problem started when I was forced to reinstal Windows 2000 and than SQL client. Before that it worked OK.
I already increased login timeout to 1 minute. It does not help.
I can connect to server through Query analyser
Another simptom: BeforeI reinstaled windows I could import table to Access 2000 through ODBC without always uncheking "Use trusted connection", now the connection always fails, and the dialog box appears with checked "Use trusted connection". When I uncheck it it and try again, it works. I can not make it unchecked by default. I know from my previous experience that Acces can mess up things, ie disable ODBC for other programs.
To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…