|
|
|
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 |
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 31 Drop index error Posted by Gary at 5/29/2005 11:42:01 PM Dear
I would like to using script to drop index and columns automatically. When I
run the script , it occur a error :
Cannot drop the index 'ADDRESS._WA_Sys_SHORTNAME_5A2A0B13', because it does
not exist in the system catalog.
I don't know what is the problem here and the "XXX_WA_Sys_X...more >>
sp_OACreate and DDLHost.exe Posted by mayetski NO[at]SPAM gmail.com at 5/29/2005 10:23:56 PM Hi,
I have a .NET DLL which I need to access in SQL Server.
I followed David Browne's article on how to register the .NET DLL, use
it like a COM object and access it in SQL Server using the extended
stored procedures.
Here's David Browne's article:
http://groups.google.com.ph/groups?hl=tl&...more >>
grant to all objects Posted by Rob at 5/29/2005 9:17:01 PM Is there an easy way to assign permissions to all objects for a user/group?
For instance, in the following BOL example, SELECT permissions are granted to
the public role:
GRANT SELECT
ON authors
TO public
GO
In the above example, the table object 'authors' is explicitly listed; is
th...more >>
Database Design - How do I model a product availability matrix? Posted by Dave at 5/29/2005 4:14:02 PM I have a list of products with dependencies that determine what a customer
can purchase.
Using a simple example, let's say I have 2 types of widgets, a standard and
a deluxe.
If a customer who has not previously purchased any widget logs on to the web
site, he should see both the standard ...more >>
Output prameters sometimes null when they should have values Posted by PeteJoules at 5/29/2005 3:05:01 PM SQL server 2000, running the stored procedure from Visual Studio .net2003.
I have a procedure which sometimes returns the values in its output
parameters and sometimes doesn't. This behaviour is consistent. If the
login details for an admin user are given then the return value is 3 and all ...more >>
Need View to return "NULL" values Posted by kvrdev1 at 5/29/2005 10:03:01 AM I have a view that is joining multiple tables. How do I modify this view so
that it also returns when the value is "NULL" for some of the join table
fields???
Any help would be greatly appreciated!!!
Thank you,
-Valerie
SELECT TOP 100 PERCENT dbo.PATIENTMEDICATION.PatientMedicatio...more >>
Some simple questions Posted by §Chrissi§ at 5/29/2005 9:23:38 AM Hi,
1. What is the diffference between raiseerror() and print?
2. What is the diffference between BEGIN...END and BEGIN TRAN...END TRAN?
Thanks
...more >>
How do I Filter by Current Date Posted by Colin Spalding at 5/29/2005 8:04:24 AM I have used 'GETDATE()' but it appears to ignore the current date
because the data does nor have any time information in it. How do I get
filter the data just by date?
Regards
Colin
*** Sent via Developersdex http://www.developersdex.com ***...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
The Case For GUID; Surrogate Key Alternatives Posted by PB at 5/29/2005 1:04:55 AM Under what circumstances, if any, are GUIDs *desirable* as primary/foreign
keys.
I'm just learning relational DB theory and implementation. I understand
natural keys vs surrogate keys. I also am clear that natural is preferred,
but surrogate keys are desirable or even necessary in some sce...more >>
Error handling?! Posted by Johnny van Cadsand at 5/29/2005 12:00:00 AM Hi
I have the following problem.
When I execute a statement i get an error and my statement stops running
but there is errorhandling.
Does anyone knows why i don't get the print statement?
15 is a wrong number to generate the error.
Thanks, John
DDL:
DECLARE @intError INTEGER
...more >>
Performance of "SELECT COUNT(*) FROM X WHERE Y" queries Posted by Richard Hollis at 5/29/2005 12:00:00 AM I have a web application which has queues with different views for different
users. The site has several hundred users a day. With enough RAM in the
server (the application effectively living in RAM) is it quite reasonable
and ok performance wise to be able to use "SELECT COUNT(*) FROM X WHERE Y...more >>
Linked Server and Remote Server Posted by A.M at 5/29/2005 12:00:00 AM Hi,
What is the difference between Linked Server and Remote Server?
Thanks,
Alan
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |