|
|
|
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 print list of tables Posted by smk23 at 11/27/2004 7:21:02 PM Greetings and thanks! Hope everyone had a great Thanksgiving.
Is there a way to print the list of tables in a SQL 2k DB?
--
sam...more >>
DISTINCT Query returning Duplicates Posted by Brad M. at 11/27/2004 6:11:34 PM Hello, I'm having a problem with the query below - unfortunately I can't
provide any sample data, all I can say is that this query involves SQL
Server System Replication Tables. I'm trying to get a list of subscribers
that have replicated, unfortunately I get duplicates for subscribers even
...more >>
dumb N question Posted by Paul Pedersen at 11/27/2004 2:49:19 PM I know this is probably a dumb question, but...
All over the BOL, I see things like this:
WHERE checksum(N'Vegie-spread') = blah blah
What is that N for??
...more >>
Sort Problem Posted by Hamid at 11/27/2004 1:44:30 PM Hi,
I have a DB in SQL-Server 2000 ( win 2000 server ) that used for storing
international data strings ( multi languages ) in its table . I keep them in
nvarchar DataType in DB.
I have problem with sorting non-english strings , for example sorting farsi
strings can't work properly and it h...more >>
select within stored procedure not working Posted by babuganesh2000 NO[at]SPAM yahoo.com at 11/27/2004 11:15:25 AM Hi everyone,
I have a peculiar problem. Not able to figure out what's the reason
behind it.
I have a stored procedure with the following sql which returns a
resultset.
select *
from tablea A
There are records in the table. If I execute the sql in the query
analyser it returns 50 recor...more >>
Error in SQL Server Agent Posted by Carlos G at 11/27/2004 9:12:25 AM Hi!!
Why the service when the Server restart it`s no active.
I write the password from the Administrator in my service SQLSERVERAGENT and
then Start.
An error 1069 - (The service did not start due to logon failure) ocurred
while performing this service operation on the SQLServerAgent servic...more >>
Locking Table Row In ADO (Help) Posted by AM NO[at]SPAM Yahoo.com at 11/27/2004 9:01:44 AM Hi All
I have a situation I am using Access 2003(MDB) as front end & sql server
2000 backend
Seneria is that I want to lock as table row thn do some updations in table
using that connection, running some procedures etc & then unlock that row
dim rst as adodb.recordset, conn as adodb.conne...more >>
Creating a User-defined function. Posted by Bob Bartel at 11/27/2004 7:47:52 AM I need to create a number of user-defined functions. Can anyone tell me how
to create a function that is available to all users by default? And I would
like to avoid appending the dbo.functionname() and just call the function
via functionname() without the dbo. ?
Also, does anyone know w...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
subquery results Posted by switter NO[at]SPAM enpathmed.com at 11/27/2004 6:35:41 AM I am looking for a creative way to total overtime on a report. My sql
involves the daily hours worked (detail) and a subquery that totals
thier hours to figure OT. The only problem is I get an OT result for
each detail, and this skews my results on my report. I am looking for
a way for my sub...more >>
Openrowset and Access 97 Posted by Chuck Berridge at 11/27/2004 5:33:26 AM I have seen a lot of posts about OPENROWSET, but I'm still not able to
figure out why the following statement
select * from OPENROWSET ('Microsoft.Jet.OLEDB.4.0','Jet OLEDB:System
DataBase=c:\Access97\system.mdw;
Data Source=c:\Access97\2004-01.mdb;User
Id=somebody;Password=something',ata...more >>
T-sql to restore log files similar to Log shipping Posted by Hassan at 11/27/2004 12:29:06 AM Id like to write a TSQL that would restore the log files similar to how the
automated log shipping restores do. The T-log files have the same format as
the way the default T-log backups are done with the date appended at the
end. Has anyone done this before ? All my T-logs would be saved at a
pa...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |