| Groups | Blog | Home |
|
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 MSDB Transaction log growth Posted by Curt Spanburgh at 3/28/2007 12:42:04 PM I've encountered a clients SQL Instance that experiences a large growth of
the MSDB Transaction log.
At one time the MDF was 14 MB and the log was 25 GB.
I used T-SQL commands to shink the file.
Auto growth is set to 1 mb.
This morning is was 4 GB.
I check for uncommitted transactio...more >>
SQL 2005 Install Posted by Phil Andersen at 3/28/2007 4:34:00 AM I am trying to install SQL 2005 but it errors on install everytime. I am
running 2003 Ent Server. here is the log from the install. I thank you for
any help in advance.
Phil Andersen
=== Verbose logging started: 3/28/2007 3:25:24 Build type: SHIP UNICODE
3.01.4000.1830 Calling process...more >>
SQL Mail - No Profile Posted by SAC at 3/28/2007 12:00:00 AM I want to use sql mail, but I don't have a profile.
I have Outlook 2003 installed on the computer with an email account using
exchange server.
In the Control Panel I see a profile named Outlook, but when I attempt to
configure sql mail no profile is listed.
What do I need to do?
Than...more >>
user name change Posted by Anita at 3/27/2007 11:44:29 AM Hi,
we are using a Microsoft SQL Database (Version Microsoft SQL 2000) in a
windows domain. We use windows authentification for the SQL permissions. One
user married in the past and we changed her windows login name. When I try
to create a the new user in SQL, I get an error message (can't ...more >>
SQL Server 2000 Log Shipping (Standard Edition) Posted by Jerry at 3/27/2007 10:10:25 AM I need to setup Log shipping between 2 SQL 2000 Servers(Standard Edition).
I know Microsoft don't support Log Shipping for the Standard Edition but I
hear you can setup a manually process. Can someone help me with this one?
Thanks
Jerry Stanfield
...more >>
Multiple table query Posted by Sid Price at 3/26/2007 10:12:18 AM I have an application that has a number of tables that I need to query and I
am having no success in selecting the data I need.
T1 has a set of columns that describe a business entity (name, address,
etc), T2 has a set of columns that describe various business categories,
and T3 is a table...more >>
What books should I get to start with SQL Server ? Posted by Wayne at 3/26/2007 12:00:00 AM Howdy all,
I need to add SQL Server to my skillset as I am going to be involved in an
ERP implementation in the next 12 months that will rely heavily on it. I
have a background with Oracle and have done some pretty in depth development
with access, (an add on SAP tool I wrote in MS Access p...more >>
Modify default Enterprise Manager font. Posted by Panos Tsapralis at 3/25/2007 6:48:47 PM I have installed Microsoft SQL Server 2000 along with Service Pack 3 on a
system with Microsoft Windows NT, Ver.4.0 (with Service Pack 6a).
Everything seems to work fine except that everything in the Enterprise
Manager application is displayed in an annoyingly tiny font and I do not
seem to be...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to get and use SQLServerExpress Posted by Tina at 3/24/2007 4:50:31 PM I already am using SQLServer 2005 Developer edition along with Management
Studio and Visual Studio 2005 Professional edition.
Now I have a project to develop and deploy a forms application that will
have to be distributed with SQLServer Express and have some questions...
Where do I get SQL...more >>
difference between owned schemas and roles members Posted by Bart at 3/24/2007 4:14:49 PM Hi,
I want to create a login (for account ASPNET from the Active Directory) in
sql server express 2005 for a specific database.
When addidng a new user to a specific database, i see:
Owned schemas, where i take db_datareader and db_datawriter
Roles memmbers: also db_datareader and db_datawri...more >>
Non-Equi Joins Posted by Justin Ryan Grenier at 3/22/2007 3:45:20 PM I am taking Microsoft Course 4329 on Joining Data from Multiple Tables in
SQL Server 2005, and I am stumped in the Lab, Task 2, Step 3.
How can I rewrite the following SQL Statement to produce the same results by
using a non-equality operator in the join?
use adventureworks
select firstna...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |