| Groups | Blog | Home |
|
January 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 |
Filter by week: 1 2 3 4 5 Information Schema Query Question Posted by Akintoye Olorode at 10/31/2005 2:57:56 PM Hello All,
Could someone help provide a query that I can run to
determine the primary key and unique columns for any
given table ?
Thanks in Advance,
Akintoye
...more >>
Unique Constraint on Multiple columns Posted by Dave at 10/31/2005 2:42:28 PM Can you create a unique constraint on multiple columns, or does it have
to be implemented as a unique index?
If possible can someone please post some sample code?
Thanks,
...more >>
Stored Procs and db_owner Posted by db55 at 10/31/2005 2:15:08 PM I have some users that I need to run stored procedures, but they can't
seem to run them unless they are in the db_owner role of the database.
How do I give them access to run the stored procs without giving them
the complete rights of the db_owner role?
Thanks in advance.
...more >>
Passing authentication from PHP to reporting services Posted by andrewdmason NO[at]SPAM gmail.com at 10/31/2005 10:01:57 AM Hello,
My boss wants me to create a front end webpage for our Reporting
Services reports that customers can log onto through a webform. I'm a
PHP programmer, so I'd rather do this site and the authentication in
PHP than learn .NET. The main problem I see is finding a way to pass
the authent...more >>
Possible to keep MS Access interface and migrate the MS Access to MS SQL Server? Posted by Bon at 10/31/2005 3:34:19 AM Hello all
Would it be possible to migrate the MS Access 2000 to MS SQL Server
2000?
My application is using MS Access 2000 as database and as user
interface such as forms. Now, I want to migrate the backend database
from MS Access 2000 to MS SQL Server 2000. However, I want to keep the
MS ...more >>
Rendering directory structures Posted by Ben at 10/30/2005 9:23:45 PM Hi, I have a table of folders that I would like to be able to display
in a depth first manner, similar to what you would see in Windows
Explorer. the table is defined similar to
CREATE TABLE Folders (
folderID int,
parentFolderID int,
name varchar(32)
)
.... ...more >>
Problem with HOST_NAME Function with Linked View Posted by Neil at 10/30/2005 8:55:45 PM I have an Access 2000 MDB file with a SQL 7 back end. I have a main table
with 50,000 records; and I have a selections table with 50,000 records for
each machine that uses the database (about 25-50). This allows each user to
have their own set of selections.
The selections table has three f...more >>
Use DEFAULT CONSTRAINTs or BOUND DEFAULTs? Posted by serge at 10/30/2005 4:22:49 PM I am doing a little research on Google about this topic and I ran into
this thread:
http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/63cce060ff152dcc/1dc13d4ee6758966?lnk=st&q=difference+constraint+sql+defaults&rnum=14#1dc13d4ee6758966
I read SQL Serv...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
question about log file size when alter Huge table Posted by Gordowey at 10/30/2005 4:14:30 PM I have the next question, and i would like to hear what do you think
about, and if is there a better solution for "my problem"
here is the question, I have a huge table with 60GB of data (image
files). The problem happen always when i try to ALTER the structure of
the table. For example I chan...more >>
have sql file and want to run it on an ftp connection Posted by strawberry at 10/29/2005 12:02:18 PM i have a db set up that i access using an ftp connection, and an sql script
file that i wish to run, how do i go about doing so?
tia
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |