| 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 |
Cant connect to SQL 2005 from another PC Posted by Ishan Bhalla at 12/23/2006 4:13:02 PM Hello,
I installed the Enterprise evaluation edition on a virtual windows 2003 server
I can connect to SQL Server from the management studio when i remote connect
to the server, but cant connect to it when i try from another PC.
i sometimes get: "A connection was successfully establishe...more >>
attach SQL 2000 DB files to 2005? Posted by Leythos at 12/15/2006 12:39:46 PM I have a couple large databases (20 databases, many GB of data in each).
the vendor has told me that their application will work fine with 2005,
but, I've not done the migration yet.
Is it as simple as a backup from 2000 /restore to 2005?
Can I detach the files for each DB and then just r...more >>
Tempdb ! Urgent Help please ! Posted by Rogers at 12/14/2006 10:39:50 AM How I can change the tempdb location from C:\ to E:\ drive without any
downtime.
Please send me the query to implement this as I am getting this error.
ERROR MSSQLSERVER
Event ID: 17052
ERORR 1101, Level 17, State 3
Could not allocate new page for database 'TEMPDB'. There are no more...more >>
Who is starting SQLSERVR.EXE? Posted by Chris Shearer Cooper at 12/9/2006 10:13:00 AM I see that I have an instance of SQLSERVR.EXE in my task manager, and I
certainly didn't start it, and can't think of any applications or services
that use it.
How can I find out who started it? Is there a way to connect to SQL server,
and ask it what connections it has currently (or what ...more >>
Connecting to a 2005 database using 2000 EM Posted by Robert Dufour at 12/7/2006 6:35:19 PM What are the steps to be able to add a 2005 server to a server group in the
2000 enterprise manager?
Thanks for any help,
Bob
...more >>
Where do I find a step by step how to use SSIS Posted by Robert Dufour at 12/7/2006 6:33:54 PM I need to transfer a tables data between a sql2000 server table and a
sql2005 server table using the 2005 server management studio. I knew how to
do this with the 2000 enterprise manager but they changed everything again
<GGG> where do I find step by step info on how to do this with 2005 serve...more >>
Client / server data retrieval Posted by Hans Munkwitz at 12/6/2006 1:17:31 PM I have a Client/Server application where the Client is MS-ACCESS 2000 and
the Server is SQL SERVER 2000. The two entities reside on separate
platforms(Machines). The server contains tables in which some
columns(fields) are encrypted and must therefore be decrypted to view them.
This works great ...more >>
Problems With Client Connections Posted by William Downey at 12/4/2006 2:46:37 PM I will try to keep this as concise as possible. I am trying to set up a new
SQL Server 2005 Express server.
The OS is Windows XP Pro SP2. SQL Express is SP2.
I am able to connect to the instance locally through shared memory. I am
also able to connect to the instance locally with TCP by...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How can I have table and column definitions? Posted by ThunderMusic at 12/1/2006 2:50:40 PM Hi,
I want to develop a code generator for our Data-Access Layer and I'd like to
know if there are queries I can make to have the table and column
definitions... something like Select * From Tables and Select * From
Columns Where TableName=@TableName.... something like this... I know there...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |