|
|
|
January 2003 March 2003 April 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 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 July 2007 August 2007 September 2007 October 2007 |
trasnfer an entire database Posted by dawe at 10/29/2003 9:46:39 PM Hi folks!
I have a SQL sever installed in my laboratory and now I have to build a
database identical to a danish one (I write from Italy, the danish group
works on the same biological experiments and data) so I thought I can
tranfer the structure of that database into my SQL server (I dont' real...more >>
Adding user to SQL database Posted by Sunitapatil NO[at]SPAM hotmail.com at 10/29/2003 1:47:51 PM Hi All,
I have deleted an user from a SQL server database, after deleting I
refreshed the list the user name disappeared,
But when I try to add a new user to the database in login name box -
the deleted user still shows and if I select this user, it gives me an
error that the user already e...more >>
VB Service Posted by David M at 10/25/2003 1:01:52 AM Hello -- I'm currently working on a VB application that will essentially be
a front-end monitoring application using SQL Server. The front-end
application will simply read data from SQL Server and display in a datagrid.
What I also need is a backend application that can run as a NT service and...more >>
Single Quotes, SQL Inserts, Identifiers and Base 64... Posted by Liddle Feesh at 10/23/2003 10:38:26 PM Hi all!
Please - I really hope someone can help me...
As part of a document management tool, I am trying to read and write files
(of varying content - some txt, bmp, jpg, doc, xls, xml, etc) to and from
the windows filesystem and a SQL database.
The file content is stored as an ntext in a...more >>
restoring old mdf file Posted by frank brown at 10/23/2003 5:01:31 PM I need to restore a Sql2000 database from an .mdf file from last July. Can
people tell me if the following procedure is correct, or am I missing
something? :
1. restore the .mdf file from backup to temp location (done)
2. backup existing database (in case I need to restore this one)
3. delet...more >>
query help(2) Posted by u753143310 NO[at]SPAM spawnkill.ip-mobilphone.net at 10/23/2003 3:41:41 AM got slightly similar table.
#Temp Table:
name,name1,name2,exam,score
A,A1,A21,
A,A1,A21,math100,88
A,A1,A21,math101,56
A,A1,A21,
A,A1,A21,math102,67
A,A1,A21,
A,A1,A21,math104,45
A,A1,A21,Chm100,55
A,A1,A21,
A,A1,A21,chm101,86
A,A1,A21,chm102,44
A,A1,A21,
(skipping)
A,A1,A22,math100,...more >>
how to convert varchar to numeric ? Posted by meh at 10/20/2003 10:08:28 PM
I have imported data from excel file. When data came to SQL table, the type
of AMOUNT column was varchar. I tried to convert and cast amount type of
amount column to number type but it does not allow me to convert.
What is the best way of importing data into SQL and type stays the same as
...more >>
SQL Reporting Services. Posted by Neal Boxrud at 10/20/2003 3:06:08 PM Does anyone know when Microsoft plans to release the second bata of SQL
Server 2000 Reporting Services?
Thanks, Neal...
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
MAPI email service for SQL 7.0 Posted by chris NO[at]SPAM groupinfo.com at 10/20/2003 12:35:22 PM Hello,
We recently set up our SQL 7.0 server (on Win2k) to email us on
different things (mainly results for Database Maintenance Plans). We
went through the process of installing Outlook and configuring SQL to
use its MAPI profile, etc., and it works fine. But my question is, is
there an al...more >>
MSDE vs SQL 7.0 .dll files Posted by malpmcc NO[at]SPAM hotmail.com at 10/13/2003 4:09:11 AM I am currently looking to run my database using MSDE as
opposed to SQL 7.0. My database runs ok using 7.0 but
when i use MSDE i generate an error. I have run a windiff
on the files installed by 7.0 and those installed by MSDE
and came up with the following results. Can anyone help
me with ...more >>
SQL Server project management Posted by allancady NO[at]SPAM yahoo.com at 10/12/2003 11:07:49 AM I'm a veteran software developer who's relatively new to the world of
databases. The project I'm currently working on is growing to the
point that I'm starting to wish I had the kind of project tools that
I'm used to with languages like C++ and Java, namely compilers, "make"
utilities, source c...more >>
Free Graphical Database Sizing Utility Available Posted by NoMail at 10/9/2003 11:20:34 PM We have just developed a Graphical utility to view the row counts,
space used, index space and other information on your Microsoft SQL
Server databases. The data is presented in grid and chart format and
can be exported to various formats for external analysis.
Can connect to servers over the...more >>
Database Backup in 0.5 B and Transaction log backup in GBs Posted by Narendra Talreja at 10/8/2003 11:59:07 PM SQL gurus,
Simple question:
Our database is 470MB and transaction log has become 18GB! (Clustered). I
see local Fixed drives in both the SQL boxes from 'System Information' and
disk manager where data is being stored.
We are backing up database once in 24 hours and transaction logs every ...more >>
Transaction log 18 G and database 470MB Posted by Narendra Talreja at 10/8/2003 9:34:39 PM SQL gurus,
Simple question:
Our database is 470MB and transaction log has become 18GB! (Clustered). I
see local Fixed drives in both the SQL boxes from 'System Information' and
disk manager where data is being stored.
We are backing up database once in 24 hours and transaction logs every ...more >>
Transactionlog Posted by Martin Edwards at 10/8/2003 10:40:20 AM Hi
My transaction log has reached an unwanted size, 2GB for a 5 MB database. I
am using SQL 2000. How do i shrink it?
- Martin...more >>
SQL query problem Posted by kiran NO[at]SPAM boardroomlimited.com at 10/5/2003 6:38:15 PM Hi, I hv the following query that is returning correct values.
However, I want to add one more condition to this query.
select b.btdnumber as btdnumber,
b.btdtrfno as bbtdtrfno,
a.btdtrfno as btdtrfnohidden,
a.BtdAcno as BtdAcno,
a.BtdCertNo as BtdCertNo,
a.BtdShare as BtdShare
from shrba...more >>
Self Joins Posted by kiran NO[at]SPAM boardroomlimited.com at 10/2/2003 8:02:31 PM Hi, I want to display the results of the following query in my
program.
select a.cdecode as cdecode, a.cdename as cdename, a.cdecallid as
cdecallid, a.cderecID as cderecid, b.cdecode as bcdecode, b.cdename as
bcdename, b.cdecallid as bcdecallid, b.cderecid as bcderecid
from shrcodemaster a...more >>
insert error ('name is not permitted in this context...') Posted by frank brown at 10/2/2003 5:26:25 PM When I submit the following TSQL to SqlServer 2000/SP3:
INSERT dispinfo (datetime,incno,alarm,units,loc,type,insType)
VALUES ("9/29/2003 01:36","F041069908","1","AU32","3052 NW 134 ST #2
,SEA","AFA (AUTO. FIRE ALARM)",2)
it fails with the following error:
Server: Msg 128, Level 15, State ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |