| 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 Can you upgrade SQL Server 2000 to SQL Server 2000 Enterprise? Posted by Preoscott at 4/28/2005 12:20:04 PM ...more >>
Using a Query to show just the month in of a date field Posted by Steve Roberts at 4/28/2005 8:57:33 AM I need to create a query to show the month as Jan, Feb ... instead of 1, 2.
Is there a way to do this?
This query works fine except I get the month number instead of Jan, Feb
SELECT emLastName, emFirstName, emEmployee, emHireDate, DATEPART(m,
emHireDate) AS HireDate
FROM dbo....more >>
Does MSDE Support Replication? Posted by AaronJ at 4/28/2005 8:38:03 AM Hi,
I am looking at MSDE as an option but unsure if it supports replication like
SQL Server? Does it support all replication options as in SQL Server (e.g.
Merge)? If so, I would assume it would replicatable with another SQL Server
(from what I have read, MSDE is SQL Server minus the User I...more >>
Trial install Posted by saintalan at 4/27/2005 1:33:11 PM I am learning Visual c# and have bought a book called c# Evolution which
requires "any edition of SQL Server 2000", so I have downloaded the 120 day
trial. However the AutoRun does not work and I can not see how to install it.
The book offers no guidance, just says "open Enterprioise Manger a...more >>
What SQL Server Version Do I need? Posted by AaronJ at 4/27/2005 12:57:59 PM Hi,
I am unsure which version I need to purchase? I want to have the ability to
synchronize a remote server with a local server. Here are my specs:
Windows 2000 SP4
Management Console v1.2 SP4
C drive: 12G Total, 6G free
D drive: 90G total, 66G free
4 physical hard disks in a RAID confi...more >>
MSDE 2000 - Release A - Setup failed to configure the server Posted by Samy at 4/27/2005 7:18:10 AM I downloaded MSDE2000A.exe file from
http://www.microsoft.com/sql/msde/downloads/download.asp. I unzipped this
file. I used the following command in DOS window to install it.
setup SAPWD="g0612s" /L*V D:/MSDELog.log TARGETDIR="D:\" DATADIR="D:\"
But I end up with the following error messa...more >>
right in Enterprise Manager Posted by isabca at 4/26/2005 1:14:03 PM Hi,
In Enterprise Manager, I want some user to have access in all the DTS but i
don't want them to access table in the database. Can I do something like
that.
thank you
--
isabca:)...more >>
SQL server 2005 Beta Posted by FVDB at 4/26/2005 9:34:03 AM How do I index external files (documents not stored in the database) using
the full text possibilities in SQL Server 2005?...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Maintenance plan Posted by DavidE at 4/26/2005 6:28:01 AM I have a maintenance plan to backup my database and the T-Logs. When I go to
the directory were I set these to be backed up to I have the DB backups but
there are no .TRN files for my t-logs. any idea why my maintenance plan
wouldn't backup my t-logs...more >>
SQL DBO Posted by DavidE at 4/26/2005 6:26:03 AM I have created a database logged in with my domain admin account which is now
the dbo for my new database. I am trying to change the database owner to
another user account. Can anyone tell me the easiest way to change the
database owner?...more >>
Database information Posted by Marcell at 4/26/2005 1:54:02 AM Hi
I would like to display the following information in respect of a specific
database in one single report?
1. Database size
2. Number of tables
3. Number of rows in each table
4. Number of views
5. Number of stored procedures
Is there a stored procedure or command I can use to display...more >>
subquery help Posted by r at 4/26/2005 1:05:58 AM Following is code I've written to help sort my data on three fields, then
"rank" them based on the results.
select a1.dealercode, a1.dealername, a1.firstname, a1.lastname,
a1.region, a1.district,a1.groupsize, a1.promotionalprogram, a1.PPPPoints,
a1.OSOPoints, a1.TotalPoints, a1.completed_m...more >>
Setting up replication with access front end Posted by John at 4/26/2005 12:00:00 AM Hi
We have an access app (front-end+backend) running on the company network. I
am trying to setup replication for laptop users who go into field and need
the data synched between their laptops and the server upon return to the
office. I am planning it this;
Move all access tables to sql ...more >>
What-if scenario Posted by winUser at 4/25/2005 7:41:17 PM I am trying write an application that does what if scenarios. For example,
change a few parameters and draw a graph of how that would effect inventory
requirements for the next few months. I am new to SQL Server, so looking for
pointers on how to implement this.
Initially I was going to cre...more >>
sql service Posted by docb at 4/25/2005 6:40:08 PM i recently installed a program that uses msde/sql. how can i connect to my
sql server? i get a prompt that no service has been selected, where do i
select the service?...more >>
defining description field Posted by r at 4/25/2005 1:46:53 PM I need to add a description field in a table - the length of the field will
vary for each record. What is the best datatype and field length to use in
a case like this??
...more >>
Linked Tables via ODBC? Posted by David Alger at 4/25/2005 12:00:00 AM Hi,
I have some data in another database which I need to be able to query
periodically and import new records into my SQL Server database.
At present I've got an access project which has linked ODBC tabels from this
external database and from SQL Server and manages the transfer.
What I'...more >>
Newbie book Posted by Bill M. at 4/24/2005 7:15:10 PM Please make a recommendation for SQL Server 2000 for a beginner with very
little programming background. I need something for a raw beginner. Thank
you.
...more >>
Setting up replication Posted by John at 4/24/2005 12:00:00 AM Hi
I have just converted an access mdb app to an access adp app with msde
backend. I am very new to sql server. My question is how do I create
replication for a few laptop users who would like to take away the app for a
few days and when they come back would like all the new data (laptop & ...more >>
Calling a web service from a CLR SQL stored procedure Posted by Krishna at 4/22/2005 11:15:01 AM Hi,
I am trying to call a remote webservice from within SQl server using CLR.
However, SQL Server gives me an error saying that load(), loadModule() etc
are disabled. Of what I can tell, C# needs to dynamically generate and load
the XML serialization for the web service call. Does anyone kn...more >>
A database clone Posted by juValdiv at 4/22/2005 10:57:49 AM Is there a simple way to copy an entire database to another new one?
I need to copy my production database to another for training purposes.
Thanks for your help,
Juan.
...more >>
Display column name of forgien keys Posted by VinayPM at 4/22/2005 1:14:02 AM I am using SQL Server with Northwind database. My intention is to display all
forgien key references for a particular table.
declare @objname nvarchar(776)
declare @objid numeric
declare @cnstid int
declare @cnsttype char(2)
set @objname='Employees'
(select @objid=id from sysobjects wh...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |