| 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 |
Copy database problem Posted by Woody at 7/27/2007 1:52:02 PM I am running SQL Server 2005 and trying to make a copy of a database from
Management Studio. Using the Backup wizard I go through all the steps that
you would normally walk through to make a copy, and actually start the copy,
but when I do I get the following error message from the copy datab...more >>
Using DISTINCT and ORDER BY in the same query Posted by Nathan Sokalski at 7/26/2007 8:08:15 PM I have the following SQL statement:
SELECT field1 FROM table1 WHERE field2=25 ORDER BY field3
This statement works fine, but the results contain duplicates, because
field1 contains the same value in multiple records. I would have thought
that modifying the statement with the keyword DISTIN...more >>
Connect to a server from client Posted by Joseph at 7/26/2007 10:16:07 AM I'm receiving ths following error message when I try to connect to my server:
Cannot generate SSPI context. (.Net SqlClient Data Provider)
An idea?...more >>
Connection Timeout Posted by tc at 7/24/2007 6:46:11 PM Hi all.
I have a PPC app which connects to an SQL server via RF. App is fine, but
when
out of range the connection timeout is too long. I don't want to backlog
data, in this instance the user must be within range for the connection to
work. Using CF SQLClient namespace.
I've had a loo...more >>
Like Bug with Sql Server 2005 Posted by MicroComputer Solutions at 7/24/2007 5:46:04 PM I guess this is the right forum. When I got at it from inside of Sql Server
Communities, t-sql was an option.
I am using SQL Server Management Studio to query a SQL Server 2000 database.
If I do this:
Select * from sop30200 where sopnumbe like '%197215%' I get 49 records.
If I do...more >>
odbc sql native client Posted by gracie at 7/24/2007 9:12:01 AM I've installed the SQL Server 2005 client utilities on a laptop that's used
for development. When I try to create an odbc connect to SQL Native Client
2005.90.1399.00 that specific driver doesn't appear in the list of drivers
available for selection. I've verified that it is in fact installed....more >>
Strange behaviour in record ordering Posted by Jason Speight at 7/19/2007 4:49:28 PM Hi,
Can anyone suggest what is going wrong here? I have created a stored
procedure in SQL2005 Express, which builds a temp table, messes with data a
bit, and returns this data. The order of the returned records is important.
This is the last line of the SP.
SELECT * FROM #TempTable WHERE...more >>
Flummoxed by Connection Problem Posted by DesCF at 7/17/2007 12:00:00 AM Everything was working fine until suddenly this problem appeared from
nowhere:
Boot up the pc and go into SQL Server Management Studio. The database is
present and the data can be accessed.
Go into VB2005 Express and run the project. Everything works fine.
Open Database Explorer and con...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
The parameter is Incorrect Posted by Tarek Al-Jamal at 7/15/2007 5:31:06 PM Hi,
When I try to open any table in Management studio in design mode I get =
the error message "The parameter is incorrect"
Please Help
Tarek Al-Jamal...more >>
Creating an ODBC connection Posted by Cuzzi at 7/13/2007 8:18:09 AM When creating an ODBC connection to a SQL server, a handful of PC's do not
show a list of drivers to create a connection. To create the connection, I
go through Control Panel> Administrative Tools> Data Sources (ODBC). I then
select the System DSN tab and click Add. When I click Add, the li...more >>
My menubar is all messed up Posted by John Scott at 7/10/2007 2:40:04 PM Ok..this is a weird one.
When I open up SQL Server Management Studio Express my menubar has multiple
instances of the File, Edit, View...menu options.... and every toolbar
(Standard, Query Designer, Database Diagram, etc..) all have multiple options
as well.
I've gone in an modified thos...more >>
Function like SUM() but multiply Posted by Christoph Boget at 7/9/2007 11:50:24 AM Is there a function that I can use to multiply all of the values of a column
from a result set together? Much like SUM() adds all the values together?
Or am I going to have to just use AVG() and COUNT() and multiply those 2
values together?
thnx,
Christoph
...more >>
SQL 2000 Client with SQL 2005 Server Alias Posted by Stewart at 7/7/2007 8:17:10 PM Hello,
Does anyone know how to configure a SQL 2005 Alias where SQL 2000 Clients
can access it by name? I migrated a db over to a new server and would like
to decommission the old one but point all of the clients to the 05 server.
Regards,
Stewart
...more >>
.net framework version Posted by Esteban Arturo at 7/5/2007 8:58:03 AM We have an application that requires a different version of .net framework
(not 2.0). Can the SQL Server 2005 client tools be installed with a different
version of .net framework? I would rather the programmers use the SQL 2005
tools instead of SQL 2000.
Thanks.
--
Esteban Arturo...more >>
Concurrency with .net app Posted by Rotsey at 7/4/2007 12:00:00 AM Hi,
I have a Access 2003 talking to SQL 2005 express DB via
linked tables.
I also have .NET forms application that also talks to the
SQL DB.
I want to know how to handle concurrency in the .NET app.
I don't want to have to change the Access app though
Is there a method that would wo...more >>
TSQL-Accmulations Posted by Batool at 7/1/2007 4:45:10 PM I need an appropriate select statement for my case, the case is a table with
two columns (row id ,col1) I want to retrieve a three columns
RowId, col1 ,accumulation of col1
I wrote this select statement, but the performance is going down is there an
alternative way for writing this SQL state...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |