|
|
|
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 29 30 Limitation of "32" Nested Transactions or Object calling. Posted by Umer H. Minhas at 9/5/2004 11:17:02 PM Dear All,
We are using SQL Server 2000 here in our organization. We are
facing the problem of Nesting limitation by calling more than 32 procedures.
So I want to ask that is it possible to change or reset the figure of 32
(Support of Nested Object Calling or transaction in SQL Serv...more >>
Need help with string truncation Posted by tony c at 9/5/2004 9:37:26 PM
Hi,
I am using vb.net and am using a table to capture exceptions which
occur in my program. When I try to store the "exception.tostring()"
function - it gives me a string of length 277 which when stored in my
talbe gets truncated to around 100 characters. I see the whole string
going in w...more >>
Need help with foreign keys Posted by Donald Pickering at 9/5/2004 7:54:43 PM Running sql server 2000 on Windows 2000 server.
Table 1
CREATE TABLE tbl1
(
FileName varchar(3) NOT NULL PRIMARY KEY,
Description varchar(100)
)
Table 2
CREATE TABLE tbl2
(
FileName varchar(3) NOT NULL,
FileLine Int NOT NULL,
Description varchar(100)
...more >>
Help wanted on 'One To Many' relation Posted by Martin Heuckeroth at 9/5/2004 6:36:54 PM
Hi,
We are working on a 'One to Many' relationship in SQL Server 2000.
We are programming on a VB .NET application that is using stored
procedures and relations created in SQL server. No problem with that.
In VB we can program code for a relation that returns ONLY selected
rows. from two ...more >>
How to remove a defualt from an existing column when I don't kow the contraint name Posted by Tony at 9/5/2004 4:17:32 PM I have created all columns defaults using the DEFAULT keyword on the "alter
table add column" command.
But I have a set of columns in which I either need to change the default or
remove it programmatically (can't use EM as I need to push this change out
to client databases).
The "Alter tabl...more >>
Table that includes all stored procedure Posted by Guy Brom at 9/5/2004 3:39:01 PM Hi there,
Is there a system table that includes all stored procedures code? I've
changed a table name that is being referenced in 40 or so stored procedures
and I want to change the naming automatically there.
Thanks!
...more >>
Can I send a parameter to table's trigger? Posted by Willianto at 9/5/2004 3:28:07 PM Hi all,
I have a trigger in my_table. But, a client had made a special
request -and to fulfill his request, actually is just to bypass the
trigger. Of course I can add one flag column (say, a bit column), but
that would means, I have to change the table structure. I wonder if I
can send a par...more >>
Any reason that I should (should not) be using nvarchar instead of varchar? Posted by Larry Woods at 9/5/2004 1:09:22 PM I am used to using varchar (...history) but I have a feeling that I should
be using nvarchar for all text fields. True? False? Comments?
TIA,
Larry Woods
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Blocking Posted by Itzik at 9/5/2004 11:46:42 AM Hi
I see in managment blocking by select query
Can SELECT statement lock table like :
SELECT * FROM Table1
Or lock two tables like :
SELECT * FROM Table1 INNER Join Table2 on Table1.col1 = Table2.col1
Thanks
...more >>
Mandatory on one side of one to many? Posted by Mike MacSween at 9/5/2004 10:48:40 AM Production (one) to events (many)
Events must have a production (easy, non null FK)
A Production doesn't make (business) sense without an event. How to enforce
a mandatory relationship on the one side?
Any ideas?
Cheers, Mike MacSween
...more >>
Altered field: What is action "The following tables will be saved to your database" going to do? Posted by Larry Woods at 9/5/2004 9:51:23 AM I changed the length of an "insignificant" field in a table through the
right-click "table design" option of a table name. I then get a list of all
of the tables that reference this table, with a question "The following
tables will be saved to your database. Do you want to continue?" This is a...more >>
XSD from query Posted by Joey Bove at 9/5/2004 8:13:17 AM Does anyone know how if I can create an XSD from a query
or a table? (Basically I just want to know if I can not
be subjected to writing an XSD if I don't have to!)
Joey...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |