|
|
|
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 SQL 2005 Error Posted by Shyam at 3/21/2006 10:00:28 PM Hi all,
I receive the following error while try to connect to local database and the
error pops up,as soon as i open the SQL Mgmt studio.
Any help would be really helpful.
Thanks in Advance,
Shyam
TITLE: Connect to Database Engine
------------------------------
Cannot connect to X...more >>
Stop SQL Server 2005 from launching on Start Up Posted by Vayse at 3/21/2006 5:33:47 PM Hi
I have SQL 2005 installed on my laptop, just for development work. I only
want SQL to manually start - how do I do this?
At the moment, I'm going into SQL Server Management Studio, connecting and
then stopping the service.
Thanks
Vayse
...more >>
Restore Filelist Only Issue Posted by G. Ray Giacalone at 3/21/2006 4:50:32 PM The following command works great on all of my SQL Instances EXCEPT on new
boxes with new SQL2005 installations:
use master
restore filelistonly
from disk = '\\sqlcluster\SQLBackups\ASG-GP\VE\VE_db_200603210200.BAK'
I run the script with Domain Admin priviledges and the SQL Logs tells me
...more >>
SQL 2005 SSIS Flat File Data Source Posted by G. Ray Giacalone at 3/21/2006 4:41:42 PM Installed SQL 2005 Developers Edition including SSIS...when running the new
Import and Export Wizard all of the data sources come up in the Data Source
dropdown box except for Flat File Source :-[
How can I get the Flat File Source into my new installation for text file
imports?
Thanks!!...more >>
SQL Server 2000 Standard on a Windows Server 2003 box with 4GB RAM Posted by Loane Sharp at 3/21/2006 12:00:00 AM Hi there
We are running SQL Server 2000 Standard Edition (SP4) on a box with 4GB RAM
running Windows Server 2003.
I have set the Boot.ini switches ("/3GB", "/PAE" and "USERVA=3030") as
directed.
I have also run sp_configure to enable AWE and increase the minimum and
maximum memory set...more >>
Certification Posted by Ryan Langton at 3/20/2006 9:09:40 AM I'm looking into getting some type of DBA certification for SQL Server.
Should I take the MCDBA exam track for SQL Server 2000, or look more into
newer certifications such as the MCTS: SQL Server 2005?
My office currently uses SQL Server 2000 for all our database needs. We
have over 10 app...more >>
Transact SQL book recommendations please Posted by Mark at 3/20/2006 7:01:53 AM Hi Guys.
I am looking for some book recommendations for transact sql, preferrable
encompassing sql 2005.
I am writing some HTAs that will be querying sql databases. The quieries i
will be using will include some joins, unions and inserts. I have only looked
at books online sofar and want...more >>
restore db issue Posted by Sam at 3/18/2006 6:57:25 PM can not restore through Transact-SQL
when i use:
RESTORE DATABASE MyDB
FROM DISK = 'c:\MyDB.bak'
I get: "Exclusive access could not be obtained because the database is in
use."
even database is not in any use
thanks
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to move a database to a different server Posted by keithb at 3/18/2006 12:16:43 PM If I use backup a sql server 2000 database using Enterprise Manager, can I
restore it to different sql server 2000 instance? If not, what is the best
way to move a database to a different server?
Thanks,
Keith
...more >>
HTTP endpoint error Posted by Gouri at 3/17/2006 8:18:37 PM Hi,
Create ENDPOINT AWProduction
STATE = STARTED
As HTTP
(
PATH = '/ADVENTUREWORKS',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = 'SQLLaunchPc'
)
FOR SOAP
(
WEBMETHOD 'GetProducts'
(NAME = 'AdventureWorks.Production.Get...more >>
License Questions Posted by Conan Kelly at 3/17/2006 11:54:23 AM Hello all,
Our small business is going to need SQL Server for a couple more people and we do want to try to be ligitimate, so I have a few
questions about licensing.
We have SQL Server 2000 Standard w/ 5 CAL's.
Does this mean we can install Server and Client Tools on 1 server and Client T...more >>
starting sql server 2005?? Posted by VMI at 3/17/2006 11:51:46 AM How can I start sql server 2005?
Before installing sql server 2005, I installed studio .net 2005 and this
created, in my Windows Start menu, a folder called "Microsoft SQL Server
2005" with only one subfolder ("Configuration Tools") and a bunch of
shortcuts under this last folder. I'm almost ...more >>
SQL Server 2005 and MSDE Posted by Serge Myrand at 3/17/2006 9:41:41 AM Hi,
In MS online books for SQL Server 2005 express it is written that (in my
words) there is a possibility of port number confusion when connecting
to the server if MSDE is installed and the MSDE sp3 is not installed.
How to know the last service pack installed?
When googling for MSDE s...more >>
SQL Server 2005 express edition (client) Posted by Serge Myrand at 3/17/2006 12:00:00 AM Hi,
I installed SQL 2005 express on my server (XP Pro) and followed the
(Rick Byham) instructions (link) to create a fixe port in order to
remote access the server/database. I am still unable to connect to the
server (i made a small program which connect very well locally but not
remotely)
...more >>
filtering based on date Posted by r at 3/16/2006 4:57:53 PM I have a query/view in which I want to omit anyone whose signup date is ON
or AFTER 1/1/2005. The field is formatted as smalldatetime. How do I write
that in a WHERE statement?!
...more >>
Log file is growing Posted by Conan Kelly at 3/15/2006 2:16:07 PM Hello All,
Now correct me if I'm wrong, but the log file should not be growing if the Recovery Model is set to Simple, correct?
I have a DB that is set to Simple Recovery Model and the log file is growing.
we switched one of our other (much larger) DB's to Simple, because we were doing a lo...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |