|
|
|
January 2003 March 2003 April 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 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 What's Up With This Group? Posted by Smithers at 2/5/2005 9:03:12 PM Just wondering if all of you SQL dba types need a big hug or something. This
group is, by far, the most emotional group I've ever seen.
...more >>
automaticly create a record's field Posted by authorking at 2/5/2005 6:19:31 PM I used a field as the record's number,how can I get a automaticly created
number field (it can inrease automaticly) when I insert a record into a
table?
...more >>
Change Column name with ALTER statement Posted by Christian Perthen at 2/5/2005 3:02:07 PM Hi,
Quick question.
How do I change a column name with the ALTER TABLE statement without losing
the data?
Thanks
Christian
...more >>
TSQL view syntax Posted by smk23 at 2/5/2005 2:33:03 PM I'm a newbie. I have a large table that holds descriptions for many types of
codes used in tables:
table CodeLookUp:
Code int
Description varchar(150)
CType int
Now I am trying to develop a view which interprets all those codes so I can
put the descriptive value in a report.
Here is my...more >>
solved mySQL to MSSQL partially now i need a quick TSQL solution to solve the end part ( is there a Kalen Delany over here :-) Posted by M. Posseth at 2/5/2005 11:07:23 AM Hi ,,,
It is me again the guy that wanted to import a MYSQL dump file into MSSQL
server
The problem was that this file is 7 GB big and i could not even open it in
the query analyzer ( or even in notepad :-) ) also the SQL syntax of MYSQL
is different as MSSQL
However that part is ...more >>
Failed to obtain transaction dispenser interface resultcode=0x8004 Posted by Darryl Bedford at 2/5/2005 10:33:07 AM I have some students that are unable to connect locally to MSSQL 2000
Developer Edition using the com.microsoft type 4 JDBC driver. Their OS is
XP SP2. If I run netstat, MSSQL does not appear to be listening on port 1433
yet it is configured to listen on 1433. I suspected Windows Firewal...more >>
Create Text File and insert it into database Posted by Ben at 2/5/2005 10:18:55 AM Hi
How can I create a text file (with my own file extension), populating it
with a few values from our database using a stored proceedure and naming it
using a field from the database.
Any advice would be much appreciated.
Thanks
Ben
...more >>
set autoclose to false. Posted by Per W. at 2/5/2005 10:06:51 AM Is it posible to set autoclose = false on all databases at the same time?
With sp_dboptions it will only work with one database at the time.
/Per W.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
MSDE and ODBC Tables Posted by Frank Bishop at 2/5/2005 8:39:53 AM I have a MSDE database and I need to delete the contents of the exiting
tables and then import new data on a scheduled basis from an ODBC data
source (preferable through a system DSN). This was easy to do in SQL
2000 Enterprise given the DTS tools and then just scheduling a job thru
the agent.
...more >>
xp_sendmail issue in 2000 Posted by Don at 2/5/2005 8:21:31 AM Hello,
I 've the following issue, any help greatly appreciated
I have SQL 2000 with service pack 3a:
When I use xp_sendmail with a file attached, it doesn't save to the
specified folder, SQL 7 does.
Any help, would be great.
Thanks
Don
...more >>
Execute trigger as a specific user Posted by allanmartin NO[at]SPAM ntlworld.com at 2/5/2005 8:20:57 AM Hi,
Within my database I have some triggers on the tables (in database a)
which execute stored procedures and alter data in a separate database
(database b).
I have a security issue here as when ever I alter the tables in
database a, I have to make sure that the user exists in database b. I...more >>
What does the blue arrow in the SQL analyzer do? Posted by Jim Warren at 2/5/2005 6:48:55 AM I pressed it and it said batch ran, what batch where?
...more >>
Clone a record Posted by L Mehl at 2/5/2005 3:02:03 AM Hello --
I want to create a new record in the "sales_quotes" table so the salesperson
can explore alternate quote(s) to present to a customer.
The new record will have these characteristics:
- identical values for all fields with the exception of the primary key
field
- the primary key...more >>
How to change/Move the log file location Posted by Sharad at 2/5/2005 1:33:31 AM Dear Friends
I want to move my log files from D:\ to E:\ Please
suggest the procedure i can follow. Please suggest will
it have any effect on the replication as my Dabases is in
replication.
Your earlier reply would be a great help.
Best regards
Sharad...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |