| 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 |
duplicates Posted by Brad White at 7/27/2006 4:00:16 PM I have many occurances of two rows that have the same ID.
How to select just one of each?
I can copy into a temp table, and add an identifier of some kind.
But I don't know what to use for an identifier.
--
Thanks,
Brad.
...more >>
Domain or Workgroup Posted by Mernick at 7/26/2006 2:28:01 PM We recently moved our main application from a work group environment, to a
server environment.
What are the trade offs in having our users becoming part of our new domain
or to remain in their work group and access SQL Server through Server
Authentication?
Hope to hear from you soon
...more >>
DHCP errors after installing sql server 2005 Posted by Thomas Dais at 7/24/2006 9:29:14 PM Hi,
After installing SQL SERVER 2005 on Windows 2003 SP1 the DHCP server =
fails to start. I ve searched the google and other sites in the net but =
didn't find anything usefull.
The error code tis 20013.
In the event viewer I get these messages (errors):
tcpsvcs (2548) Corruption was detect...more >>
During SQL Server 2005 Management Studio install error Posted by Joe at 7/24/2006 3:27:02 PM OWC11 Error
From Setup log
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0006_L0082986_OWC11_1.log
Error Number : 1603
-------...more >>
Accessing SQL 7 from Mang Studio Posted by SalamElias at 7/24/2006 7:43:03 AM Is there a possibility to access a sql 7 database from a SQL 2005 studio
management.
I have only 2005 setup on my laptop and need to access 1 sql 7 maybe once
each 6 months.
...more >>
Protocol analyzer Posted by Gerko at 7/24/2006 5:31:02 AM We are looking for a tool that we can use to analyze the (network)
communication between a MS SQL Client and SQL Server.
Does anyone have a suggestion?...more >>
Adding a Datafile Posted by Federico G. Babelis at 7/21/2006 1:28:52 PM Hi:
I have SQL Server 2000; a database with three file groups located in three
different operating system files; the database size is 200GB; for
performance reasons we added an additional storage to the server and we have
an additional disk volume, what we want to do is to add a new dat...more >>
Any good site suggest for learning how to write stored proc? Posted by German at 7/20/2006 10:56:46 AM Hi all,
I have a hard time to learn the stored proc, because I don't have a
good reference on the internet. Please let me know some good web site.
Thanks in advance,
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Same query returns different result when in a stored procedure Posted by Terence Leung at 7/20/2006 8:56:02 AM We came across a very strange problem recently. The same query of calculating
median when run within a stored procedure, produces different (wrong)
results, when it is run outside of a stored procedure, and that the results
can be different every time the procedure is run.
We also found out...more >>
Server does not exist or access denied error Posted by Sandy M at 7/19/2006 8:51:02 AM Hi,
We have some applications that run on off of a Windows SQL Server
database.
The Database server was recently joined to a different domain.
All of the users who have PC's on the new domain can logon fine, but we
have
one PC that is in a Workgroup that cannot logon. It used to...more >>
sql 2000 + sql server management studio express Posted by FoxHill at 7/17/2006 12:00:00 AM Dear experts,
I've been developing VB.net DB projects with VS 2003 + sql 2000 (with
..net framework 1.1) installed.
Now i'm trying out the new version of sql 2005 express on another
machine. I found that the new interface of the management studio
express is very good. I'm wondering if I c...more >>
Delete log of DataBase Posted by MatÃas at 7/14/2006 7:13:46 PM I have a DB in SQL Server who has very big log 60gb and I want to delete,
how can I do it that???
Thanks in advance
...more >>
SQL Server 2005 Posted by Steve H at 7/11/2006 11:28:01 AM Sorry to be a pain. But can I clear up finally the issue regarding cals etc.
We are about to install a web server into our office. The server will be
running SQL Server and a web site via IIS through an SDSL connection. We
could have as many as 500 clients interacting with the SQL server via t...more >>
SQL Server Restart Posted by Rogers at 7/10/2006 11:30:11 AM I have a quick question, I have a server that running SQL Server 2000 and
that didn't restart for last 6 months, I am not having any problem but I am
wondering is there a good practise or any microsoft recommendation to
restart the SQL Server Box once in a week like that?
Please guide me.
...more >>
Optimization Tool Posted by Rogers at 7/6/2006 11:55:46 AM I would appreciate if you can let me know the SQL Server Database
Optimization tools, like that tool can analyzed the database and gave us the
feedback.
Thanks
...more >>
sqLServer2000 desktop user access Posted by Steven Bragg at 7/6/2006 10:19:34 AM I can access all the tools of SQLServer2000 desktop when I'm logged on to my
pc with administrator privileges, but if I'm logged on with power user and
debugger user privileges the client software refuses to connect me. I
prefer to use my pc without administrator privileges. Does anyone know...more >>
Download worksstaion components Posted by madeelaslam at 7/4/2006 11:11:01 PM i want to know how to download and install workstation components for sql
server 2005. ...more >>
Windows Web Edition & SQL Server 2000 CLIENT ONLY Posted by GeorgeBR at 7/4/2006 7:18:02 AM Hi
I know (and fully understand why!) you can't install SQL Server 2000 on a
Windows Web Edition server. However, I only want the client tools. Actually,
I don't even want the client tools, just the connectivity.
As I understand it, the only way to install the client tools is by running
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |