| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 SQL Server 2005 Express - A license question Posted by Peter Klinge at 3/28/2006 6:40:30 PM Hi all,
we are a small company developing software for doctors. We are using SQL
Server 2005 Express. We have registered ourself to distribute that
version of SQL server. So it's not a problem for single workstations.
But we must support small practices too and they need a small network
s...more >>
Modifying Data in a View Posted by James_101 at 3/28/2006 12:10:03 PM I am developing a database on my desktop using Developers Edition of SQL
Server 2000. The database will ultimately be sent to my client to run on his
db server. I would like for a specified employee at the client to be able to
modify data, add records and delete records.
I understand that...more >>
Restore only a file from one server to another Posted by Panagiotis Ladas at 3/28/2006 6:26:02 AM Hi everybody
I'm supporting a developers team and for testing reasons I have to provide
them with a copy of one of the files in the production database (SQL server
2000) very often. The whole database is restored in the test environment now
and the only data that change very frequently and ...more >>
RFC: Trigger uodating records in INSERTED Table Posted by Jonathan Orgel at 3/28/2006 12:00:00 AM 1) We have a trigger which applies further changes to the inserted/updated
records. Is this fundamentally bad or an acceptable practice?
2) We suspect that one version of such a trigger is causing deadlocks.
Interestingly this does not seem to happen if we use a cursor. See two
versions bel...more >>
How to detect foreign key entries that would prevent deletion Posted by keithb at 3/27/2006 7:04:04 PM Is there a query command that will detect whether or not a table row has any
foreign key entries that would prevent deletion?
Thanks,
Keith
...more >>
Command line with constraint clause Posted by Smokey at 3/26/2006 2:49:39 PM List authors name and state of author with a "415" phone exchange (first 3
digits)....more >>
SQLExpress Services not Running Posted by Shyam at 3/23/2006 7:16:27 AM Hi,
The SQLEXP service is not running and when i try to start it,i get the
following error,
ERROR:The request failed or the service did not respond in a timely
fashion.Consult the event log or other applicable error logs for details.
Any help on this would be appriciated.
Regards,
S...more >>
Help - SQL Posted by Luiz Horacio at 3/23/2006 1:07:21 AM Hi,
I have a simple query, that worked fine until I realized I made a stupid
error.
I need to update one table with the value from another table. So I used this
query:
Update p1, p2
set p1.value = p2.value_ch
Where p1.exam = p2.code
The problem is that, on very rare occasions, p2.val...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help with query Posted by Luiz Horacio at 3/23/2006 12:41:41 AM Hi,
I have a simple query, that worked fine until I realized I made a stupid
error.
I need to update one table with the value from another table. So I used this
query:
Update p1, p2
set p1.value = p2.value_ch
Where p1.exam = p2.code
The problem is that, on very rare occasions, p2.val...more >>
Help with query Posted by Alejandro at 3/22/2006 1:37:05 AM This is my select statement
SELECT *
FROM Attachments
inner join attachmentlinks on Attachments.attachment_Id =
Attachmentlinks.attachment_id
WHERE object_type = 'emp'
I need to update attachments table and set visibleindividual = 0
where object_type = 'emp'
Problem is that object_t...more >>
Work with all stored procs in database? Posted by Daves at 3/22/2006 12:00:00 AM hi,
I need to
1) delete all stored procedures from a database
2) replace a common text string in all stored procs
is it possible?
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |