|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Performing query 10 times faster over internet Posted by Ronald at 8/12/2006 8:45:30 PM Hi there!
I have a Sql Server 7 running on a webserver. Now I have a quite complicated
query that I run on 4 ways.
1: Using ODBC-driver directly on the Sql Server. time to execute: 12 seconds
(done this about 10 times)
2. Using OLEDB-driver directly on the Sql Server. time to execute: 12 ...more >>
SQL difference - mySQL and MS SQL Posted by Victor at 8/12/2006 6:36:51 PM I just bought a book that I thought was about the SQL query language. Turns out it's
really about mySQL. Uh.
What is the difference between query language for mySQL and MS SQL? Is there a good
reference?
Vic
...more >>
Connecting legacy application to remote instance of SQL 2005 Express Posted by Glenn Adams [MVP - Retail Mgmt] at 8/11/2006 3:40:13 PM Hi,
I've just done my first install of SQL 2005 Express and am having
problems connecting from a remote workstation using a VB6 application
that I believe used OLE DB/ADO.
I did get the application to connect, but only by installing an
instance on SQL Express on the remote workstation. I r...more >>
Service not starting Posted by Piku at 8/11/2006 6:55:02 AM SQL 2005, sp1 on win 2003, sp1.
while starting a named instance, getting error :
ERROR : The Service did not respond to start or control request in a timely
fashion.
I can NOT see those new ( 2#) named instances in "surface area config" where
as I CAN see them in "surface area configfor...more >>
Cannot connect to Query Analyzer Posted by Mike Collins at 8/11/2006 5:32:02 AM Just a few days ago, we changed the password on our server. After that, I
noticed that I could not open Query Analyzer from within Enterprise Manager.
I can open Query Analyzer from the start menu and login that way, but can
someone help in where to look to make it be able to open from with in...more >>
how to disable sql server login ?? Posted by calvin at 8/11/2006 12:00:00 AM e.g. in an local area network..
server = 192.168.0.1
me = 192.168.0.2
i just simply using Windows Authorization, then it could be abled to login
as an admin through the Studio Express.. ( do anything i want)
how can i setted it to disable those login from network ?
a bugs ?
i have ju...more >>
Complex Query (atleast I think so) Posted by We have a couple of Bill of Material tables in our SQL 2000 database and I
need to extract information.
The first table is the master table and the only relevant field is fpartno.
Table two is the child table, and it contains all of the parts that make up
the fpartno in the master table. Th...more >>
combining data on different sevvers Posted by Charles MacLean at 8/10/2006 1:42:15 PM I need to combine data from two different tables on two MS SQL servers
running on the same LAN into a single SELECT or VIEW. Is this possible and
what would the syntax look like?
Thanks,
Charles
MTS, Inc.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Connect to MSAccess on server X from SQL on server Y Posted by Chris at 8/10/2006 1:16:02 PM I would like to connect to MSAccess 2003 database from a SQL 2005 database.
I tried using Linked Server but it will not work as my MSAccess database is
on a different server.
I am also trying to use OpenDataSource but I am getting an error.
SELECT top 100 *
FROM OPENDATASOURCE('Microsoft...more >>
NIC settings for SQL 2005 and windows 2003? Posted by DBA Dude at 8/10/2006 11:54:57 AM All
Anyone know what is truly recommended for the NIC settings for SQL 2005 when
installed on Windows 2003?
Microsoft SQL MVP and SQL author: Mark L. states that the NIC should be set
to:
"Maximize date throughput for file sharing."
However, MSDN article states that the setting shoul...more >>
Cannot connect to Remote SQL Server Named Instance Posted by Forch at 8/10/2006 9:06:01 AM Hi...
On a remote server, I have SQL 2005 installed as the default instance as
well as a new named instance.
From SQLCMD, I can connect to both instances. However, from Management
Studio, I can only connect to the default instance. Is there something
special I have to do to connect to ...more >>
Can't get linked servers to work Posted by dj at 8/10/2006 6:40:02 AM I'm having trouble getting a new linked server to work.
Server Mfr is 2005 Dev (sp1) and is the 'local' server.
Server Krypton is 2000 EE sp3 and is the target server I need to link to and
query.
I have a valid Windows login on both systems and I'm in the sysadmin group
on both servers.
Af...more >>
Conncting to SQL Server 2005 database Posted by saurabh.sarode NO[at]SPAM gmail.com at 8/10/2006 4:25:23 AM Hi,
I have SQL Server 2000 Client installed on Windows XP and SQL Server
2005 Database on Windows 2003 which is not on domain. I want to access
SQL Server 2005 database from SQL Server2000 Client. When i am trying
to connect it, i get access denied error. Is it possible to connect...?
...more >>
SQLServer Connection Problems... Posted by Jon at 8/9/2006 5:12:32 PM I have read all I can find and am just frustrated...
Our system uses SBS on a company network and Server 2003 for our web server
that is not in the company domain. I am developing a web based system with
VS2005 Pro.
I can connect to SQLServer Express on my computer running on localhost. ...more >>
Connection lost Posted by Stephen at 8/9/2006 10:27:47 AM I'm running an access application on my local server (SQL Server 2000)
On my win 2000 it worked perfectly.
On my win XP, I always get this error message :
3151: ODBC--Connection to 'MyODBC' Failed.
This happens when I want to run a procedure that fills a table with records
from other tables....more >>
2005 cluster can't find Oracle client or local system OOBC Posted by FidelR at 8/9/2006 8:45:02 AM Hi,
I have 2 nodes SQL Server 2005 Ent. 64 bit SP1 cluster on Win2003 R2 Ent. I
would like to connect via SSIS to an Oracle DB. I don't get any Oracle data
providers on the list of providers. When I try to use one of the MS providers
like MS OLE DB for Oracle I get "Oracle client and networ...more >>
Query Analyzer. What settings to see the data output again? Posted by dba_222 NO[at]SPAM yahoo.com at 8/8/2006 3:08:33 PM Dear experts,
I hate to ask such a seemingly dumb question.
But I have spent some time trying to solve this already
to no avail.
When I was using my query analyzer last, a few months ago, I
was tuning some strange code. I changed some settings to
see what was going on.
Now, when I logi...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |