| Groups | Blog | Home |
|
March 2003 May 2003 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 |
SQL Server 2000 & Access 2007 Project Posted by I. Kinal at 6/30/2007 4:44:00 PM Hi,
I use an Access Project as a front end for my database, which is in SQL
Server 2000. Everything is working fine in Access 2003. However, I just
upgraded one machine to Access 2007, and now Access cannot open any query or
table in design view - I get an error saying that the object does ...more >>
Access sometimes won't use index of linked view Posted by at 6/29/2007 12:00:00 AM Hello,
I have a weird problem with sql server 2000. I have a view wich
combines 2 tables like this:
SELECT foo
FROM dbo.tblA LEFT OUTER JOIN
dbo.tblB ON dbo.A.ID = dbo.B.ID
Table B contains a field named fldSorting, wich has an index. It is
used - you have ...more >>
Trying to install the northwind database but run into problem Posted by TonyJ at 6/29/2007 12:00:00 AM Hello!
I have found a document that says run from command line
osql -U sa -i [password] -i instnwnd.sql
This file instnwnd.sql exist from where I execute the osql/sqlcmd command
When I do so I get this error
"C:\Program\Microsoft Visual Studio .NET
03\SDK\v1.1\Samples\Setup>osql -U s...more >>
can not run dts Posted by Amir Steta at 6/28/2007 5:56:00 AM I have sql server 2005 standard edition version 9.00.3054.00 (service pack 2
installed). Recently, I have run sql server hotfixes deliveres over our
organizational sus server. Although, it was run at least 6 times update could
not be finished. Some errors were reported.
Now I can not run DTS...more >>
Visual Studio 2005 Posted by koenraad NO[at]SPAM willems.com at 6/27/2007 2:28:35 AM Hi,
A client is having some issues with software (Progress) conflicting
with Visual Studio 2005 (related to debugging).
As I understand it, Visual Studio 2005 gets installed when SQL Server
2005 is installed?
I was wondering if Visual Studio 2005 is a requirement for any of the
components (i...more >>
Determining Last Day of the Month--Quick UDF Posted by Namwar Rizvi at 6/26/2007 11:47:24 PM Hi All,
Getting the last day of the month, for the given date, by TSQL is bit
tricky. Following user defined function provides you a handy general purpose
function to get the last day of the month.
It gets the last day of the month as follows:
For example we have a given date 17-March-2007...more >>
using Client network utility on sql server 2005 Posted by Roy Goldhammer at 6/21/2007 5:10:06 PM Hello there
On sql server 2000 if i needed to see all the available servers can be use i
was do it with client network utility and server network utility.
which tool on sql server 2005 do the same thing?
...more >>
Non-admin Citrix users cannot connect to SQL Server Posted by LehrSJ at 6/21/2007 5:52:00 AM We have an application that accesses a SQL 2000 server that is running on
several Citrix servers. Recently users started getting a message from the
application that there was a catastrophic failure when connecting to SQL
server. This was only happening if the user was not an administrator on...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Server IP Address. Posted by Roger at 6/20/2007 6:55:39 PM I don't know this is right place to submit this question or not, I have one
URL i.e... www.rogers.net right when I type this URL it works perfactly fine
but after loading the main page it convert the URL into IP address like
http://64.40.140.52/MainPage.aspx. Can any body guide me how I can re...more >>
SQL Server client components - What is this? Posted by Bob at 6/20/2007 3:15:49 PM Hi,
I need to install SQL Server client components (as Symantec calls it) so as
to access my SQL Server 2005. Where do I find the SQL Server client
components installation code? Is this on the SQL Server 2005? Maybe the
install menu item " Run the SQL Native Client Installation Wizard"?
...more >>
sqlclient: existing connection was forcibly closed Posted by pb at 6/20/2007 8:54:03 AM
i just made the switch from OLEDB to SqlClient in my .Net apps.
now with SqlClient often my db calls throw the following exception:
System.Data.SqlClient.SqlException: A transport-level error has occurred
when sending the request to the server. (provider: TCP Provider, error: 0 -
An exis...more >>
C# - Need to find instances of SQL Server on client Posted by Stratum at 6/20/2007 5:00:40 AM How can I determine using C# which instances of SQL Server 2000,
MSDE, 2005 or 2005 Express, if any, are installed on a client
computer?
For instance, by knowing the computer's name, I could
guess at a named instance of the data provider and use
it in a connection string, assuming Windows Int...more >>
Can't install sqlncli.msi Posted by Michael Tissington at 6/19/2007 12:41:14 PM When trying to install sqlncli.msi on Windows XP SP2 I get the following
error
"The system administrator has set policies to prevent this installation"
Given that I am the system administrator ...
What do I need to do to resolve this ?
What policies have been set ?
...more >>
Uninstall SQL Server Service Pack 4. Posted by Rogers at 6/18/2007 3:28:55 PM Can I unistall Service Pack 4 or I have to re-install SQL Server again?
Thanks
...more >>
DCOM Error - Event 10009 Posted by EightBall at 6/18/2007 12:00:00 AM Hi,
We have 4 workstations that connect to remote SQL servers (2000 & 2005)
using SQL Server Management Studio 2005. Whenever we first launch SQL
Management Studio, it will hang for 5 - 10 secs. Additionally, sometimes
when connecting to a different registered server, it will hang again for...more >>
Can't apply Sql 2k server service pack 4 on XP workstation. Posted by Pleo at 6/14/2007 9:46:14 AM After install sql 2000 server - client tools on Win XP workstation, it won't
allow to install sql 2000 server Service Pack 4 (it will quit to desktop
immediately without any error or warning) But we can intall it on win2000
workstation.
- Is it normal that can't apply or not need to apply serv...more >>
arithmetic overflow error Posted by mike padula at 6/13/2007 12:30:03 PM When attempting to view the properties of a database in SQL Server Management
Studio we are getting an error dialog that states the following.
----------------------------------------------------------------------------
Cannot show requested dialog.
Arithmetic overflow error converting expressi...more >>
SQL2000 Client to SQLServer 2005 Posted by Aussie Rules at 6/11/2007 11:33:38 PM Hi,
I have upgraded to SQL Server2005.
I have some tools that seem to only support SQL 2000, and I am wondering if
I install the basic connectivity tools of SQL 2000 on my client, will they
be able to connect to the SQL 2005 server ? For example can I connect the
old ISQL/W tool to SQL 2...more >>
Duplicate table Posted by Omar Abid at 6/11/2007 4:20:46 PM Hi,
In my program i need to duplicate a table in a current data base.
I'm thinkin' of reading the data base columns and then rows and so i
create another table
Is there any other easy and fast method with SQL Server 2005, because
my idea is so slow
I'm using VB 2005 Express with SQL Server 200...more >>
DB Busy in Detach Posted by Alex Maghen at 6/10/2007 10:16:01 PM I want to detach a SQL Server database in SQL Studio. Each time I try, I'm
told that the database cannot be detached because it is "busy." It is busy
because I must have something going on in one of my IIS applications which is
keeping ti busy. If I restart IIS, SQL Server always then lets me ...more >>
Forum and read tag Posted by ThunderMusic at 6/8/2007 2:13:04 PM Hi,
I'm currently developping a forum for my web site and I wanted to include a
"read tag" feature to it. This forum stores it's data in a SQL Server 2005
database. I've seen on my forums that when you log-in as a registered user,
you have forums marked with a special icon or color if there a...more >>
Optimization and Integrity Error Posted by Gabe Matteson at 6/5/2007 3:41:36 PM
Is there any way to run an optimization and integrity check against the
master and msdb databases? Below are the log files. Thanks!
- Gabe
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'SRVDB1' as 'RRG\rrg-sqlserver' (trusted)
Starting maintenance plan 'System ...more >>
SQL Performance Tools Posted by Elrond Bishop at 6/5/2007 12:00:00 AM Hi All
I am looking for a tool that can fire a profile trace into the database.
anyone know of something out there ?
Thanks
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |