|
|
|
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 Row versioning in SQL 2000? Posted by betbubble NO[at]SPAM gmail.com at 9/14/2006 8:41:45 PM I replicate (transactional replication) my data entry database to a
read-only database. Both are SQL 2000+SP4. The web server reads the
read-only database. At times, there will be lots of changes in the data
entry database, thus lots of replications to the read-only database. I
am concerned that...more >>
Synchronizing Access and SQL Server Posted by JA at 9/14/2006 8:41:03 PM Hi,
Is it possible to make changes to an Access 2000 database on my desktop, and
have it update those changes to SQL Server 2000 on the web?
I have to update stock and prices every night. Right now I am using Access
2000, and I just make the changes, and then upload the changed db to the
...more >>
Line Break in T-SQL Posted by nashak NO[at]SPAM hotmail.com at 9/14/2006 7:05:04 PM Hello,
In a Stored Proc, I am building a string variable. I am getting outputs
from 4 different queries and would like the string to have line breaks
to display each entry in a different line in a text area. How can I do
this?
i.e
result = result1 + result2 + result3 + result4.
What chara...more >>
sql 2005 client tools Posted by Phil Townsend at 9/14/2006 6:11:10 PM I have installed SQL 2005 on a new machine and cannot find any of the
client tools I am used to having: query analyzer, enterprise mgr.,
profiler. Shouldn't they be included in a default installation if I
chose to install client tools? Where do I go to find them?
*** Sent via Developersdex...more >>
Can I avoid temp tables, etc. Posted by betbubble NO[at]SPAM gmail.com at 9/14/2006 1:55:00 PM I need help on two questions:
1. Is temp table the only way to pass recordsets from a nested stored
procedure to a calling stored procedure? Can we avoid temp tables in
this case?
2. Are operations in a stored procedure are treated as a transaction?
Any help will be greatly appreciated.
Ba...more >>
sql server i/o bottle neck ? Posted by dunleav1 at 9/14/2006 1:38:11 PM I built a test job that loads data into the database. I get great
performance with Oracle and I'm trying to tune Sql Server to get the
same type of performance.
Based on system monitoring it looks like an I/O issue. So I started
investigating based on sql server perfromance tuning technical
r...more >>
For SQL Buffs Posted by maxvalery NO[at]SPAM gmail.com at 9/14/2006 12:25:59 PM Hi,
I have MyTable (ID, BUSINESS_UNIT_ID, CUSTOMER_NUMBER). I need a list
of customer numbers that exist in more than one BUSINESS_UNIT_ID.
Thanks!
...more >>
Newbie Question on DB Maintenance Plan Posted by DataPro at 9/14/2006 9:44:15 AM New to SQL Server. Running SQL Server 2000.
If a database is set to full recovery mode, and in setting up a
database maintenance plan you specify a database backup, why in the
wizard is the question asked if you want to back up the transaction
log?
In a db designated full recovery mode woul...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQLRef - Website Created by Programmer to Programmers Posted by Allen at 9/14/2006 3:54:28 AM Dear All Software Developers,
I am a hardcore programmer who treat programming as a hobby. Recently,
I have just created a website (http://www.sqlref.com) to share my
knowledge and programming experience and to record down any new tricks
that I learned. This website started with SQL info. bec...more >>
The user does not have permission to perform this action. Posted by kalaivanan at 9/13/2006 8:50:55 PM hi,
I am getting the following error while trying to add a remote server.
The user does not have permission to perform this action.
The command i used is:
exec sp_addlinkedserver 'remote_server_name'
What is the solution?
Regards,
Kalaivanan.
...more >>
PKZip issue Posted by Jim at 9/13/2006 3:08:40 PM I have command line PKZip (pkzipc.exe) installed on my SQL Server 2000.
I want to use it to zip up some text files that I receive and process
on a daily basis to save space. I want to schedule it to run as a job.
The problem is that when I run the job as a standard user, it just does
not work. ...more >>
Query is slow sometimes Posted by treschaud33 NO[at]SPAM yahoo.com at 9/13/2006 10:54:19 AM What might be going on here? The Query is against a single table with
some criteria. The database is active with upto 200 connected users
and at peak times there are 10 or more active sessions. Most of the
time, the query comes back in milliseconds. Occasionally though, it it
can take a whole...more >>
stored proc bug with datetime variable Posted by ujjc001 at 9/13/2006 8:06:38 AM two variables declared in my proc:
@DATE_RANGE_START as datetime,
@DATE_RANGE_END as datetime,
When I execute my SP it takes 34 seconds.
When I change the variables to:
@DATE_RANGE_START1 as datetime,
@DATE_RANGE_END1 as datetime,
and add this to my sp:
declare @DATE_RANGE_START dateti...more >>
export to sql 2005 Posted by HandersonVA at 9/13/2006 7:36:43 AM when i export data on sql 2000 to sql 2005, i lost all the primary key
setting and relationship.
how can preserve what database structure on the sql 2000 when i move to
sql 2005?
...more >>
Recurring Scheduled Job Posted by Bryan at 9/13/2006 3:08:41 AM Is it possible to display when a scheduled job is next due to run in
either a view or a table?
If so, how?
thanks
Bryan
...more >>
SQL Between Dates Posted by NO[at]SPAM sh at 9/13/2006 12:00:00 AM For some reason guys my SQL string isn't working and I'm probably doing
something stupid?
SELECT *
FROM sol_session
SELECT *
FROM SOL_Session
WHERE DateGiven > '10/09/2006' AND <
'1...more >>
Flattening Parent Child, an issue, please help Posted by Dip at 9/12/2006 11:09:41 PM Hello Experts,
Here is the code to flatten a PC hierarchy into a level based table. It
works fine.
SELECT
t1.TASK_ID AS TASK_LV1,
t2.TASK_ID AS TASK_LV2,
t3.TASK_ID AS TASK_LV3,
t4.TASK_ID AS TASK_LV4,
t5.TASK_ID AS TASK_LV5
FROM dbo.Project t1 LEFT OUTER JOIN
...more >>
SQL troubles with VPN connection Posted by Charles MacLean at 9/12/2006 6:46:00 PM We have an application that connects to a remote site's SQL server using a
VPN client. It also uses a local MS SQL database located on one of our
servers. It seems once the VPN connection is established the client machine
is always looking to the remote VPN connection/server for it's data. ...more >>
Best practice for storing long text fields Posted by Tzanko at 9/12/2006 8:31:11 AM As we all know, there is a 8060 bytes size limit on SQL Server rows. I
have a table which requires a number of text fields (5 or 6). Each of
these text fields should support a max of 4000 characters. We currently
store the data in varchar columns, which worked fine untill our
appetite for text f...more >>
Managing MS SQL on Linux Posted by Alex at 9/12/2006 8:20:51 AM Hi everyone,
I'm looking into moving my desktop system at work to Linux from Windows
XP, and one tool I've yet to find a suitable replacement for is MS SQL
Enterprise Manager. I mainly need to query MS SQL databases from
Linux, and management tasks (monitor backups, services, etc) can be
don...more >>
Find out the percentage complete of Stored Procedure Posted by nitinsharma717 NO[at]SPAM gmail.com at 9/12/2006 2:21:12 AM hi,
In my code i have to increment progress bar based on percentage
completion of Stored Procedure.I am not to get any solution on this.
Please Help me on this issue.
I am using win forms Visual studio 2005 and Sql server 2005.
Thanx in advance
Nitin
...more >>
Tree table Posted by Andrzej Jaworek at 9/12/2006 12:00:00 AM Hello,
I have a "tree" table:
Id - primary key
ParrentId - (foreign key) related to Id
Title
.....
when I delete some record I want to delete it with all childs (cascade
deleting). I can't set cascade deleting on the same table :(. Is there
any easy way in the MSSQL 2005 to do this ?...more >>
Memory setting right ? Posted by masri999 NO[at]SPAM gmail.com at 9/11/2006 9:48:06 PM I have a few questions about memory setting inherited
Windows 2003, SQL Server SP4, both Enterprise Edition 8 GB RAM
1. How to know how much Memory SQL can address ( SQL script is better
as there is no access to Perfmonitor or EM ) . ie what is maximum
memory SQL can use ?
2. In this s...more >>
How to get a SP return value on another SP? Posted by Cylix at 9/11/2006 8:19:35 PM I have a SP, which will exec other SP depend on the input.
the "other SP" need to return a integer back.
How to do this?
Thanks for give me a hand.
...more >>
SQL Server training Posted by Thyagu at 9/11/2006 4:58:31 AM Hi,
Our firm is migrating from SQL Server 2000 to SQL Server 2005. DBA's
would like to attend some training or techwave presentation on the
same. Could someone please point any such kind of activities in India.
Regards,
Thyagu
...more >>
Top and Views Posted by bozzzza NO[at]SPAM lycos.co.uk at 9/11/2006 3:20:43 AM Hi all,
We have a big table connected to a web server, and I want the number of
rows to be limited that get returned.
So I could do something like this:
select top 10 *
from object
order by code
I then realised looking at the help file, because the "order by" clause
is set the SQL Se...more >>
Passing SELECTed rows to a calling SP Posted by NiTiN at 9/11/2006 12:54:04 AM Hi!
I'm a new T-SQL developer and just hit a roadblock.
I have a scenario that goes like this: I have 2 stored procedures,
spInner and spOuter. spInner has a SELECT statement which would
normally be used by a class using MS Enterprise Library and that output
goes into a DataSet. However, I ...more >>
One more connection problem-Security Issue Posted by Curt at 9/10/2006 6:34:36 PM My company gave me their old Windows 2000 server. I installed my
database on it and the ODBC connection works perfectly on the server.
When I go to my client machine I go the the ODBC Connections in it and
it fails. It refuses connections and will not reply to pings. It is not
a network issu...more >>
cross server update problem Posted by dotnetfellow NO[at]SPAM yahoo.com at 9/10/2006 6:23:20 PM The system has worked for two years.
SQL Server 2000 runs on Windows 2000 Server "A".
Another instance of SQL Server 2000 was moved from Windows 2000 Server
"B" old to Windows 2003 Server "B" new, by restoring a backed
up copy from old to new.
The system has cross server updates, where Se...more >>
Computed Column Specification Posted by Dot Net Daddy at 9/10/2006 2:41:16 PM Hello,
I want to assign a column a computed value, which is the multiplication
of a value from the table within and a value from another table.
How can I do that?
Say the current table is A, column1; and the other table is B, column3.
What should I write as formula?
I tri...more >>
ADO.NET problem? Posted by billmiami2 NO[at]SPAM netscape.net at 9/9/2006 3:42:46 AM I'm experiencing a strange problem that I believe is related to ADO.NET
but I can't say for sure.
I have a simple ASP.NET reporting interface to a SQL Server 2000
database. One report that we run returns a listing of community
members and their contact information using a stored procedure.
D...more >>
SQL Server E-Learning Posted by Jean-Marc Blaise at 9/9/2006 12:00:00 AM Hi,
I have been trying to register for E-Learning for MS-SQL2005 ... but IE =
aborts any time before the registration is finished ... (after sign-up, =
or information fill up, or before those steps): "Microsoft Internet =
Explorer a rencontr=E9 un probl=E8me et doit fermer. Nous vous prions de...more >>
Order of Merge Replication Posted by Cameron at 9/8/2006 9:58:55 AM Hi, this is a repost from the SQL Server group.
I am wondering if it is possible to change the order that articles are
propagated to the subscriber. I currently have a table, say table A
that is used in view B. However, for a variety of reasons I need to
change the name of the table to C and...more >>
.NET assembly for BULK INSERT Posted by Thyagu at 9/8/2006 8:00:28 AM Hi,
Is there any .NET package/module/assembly for BCPing the data into SQL
Server.
The BULK INSERT utility works fine, but we are kind of worried on
placing the data.
If there is any utility to build the data into a data structure and BCP
in into the SQL Server, please let know. It would b...more >>
Please evaluate this approach to shrinking log files Posted by William at 9/8/2006 4:09:59 AM I've been tasked with taking over the support for a client's SQL Server
database. I'm not a DBA by profession, I'm a software developer who
uses SQL Server as a database designer.
The clients have reported that the server is running out of disk space
and examination shows that the log files f...more >>
how to use SP's output in the SELECT Statement Posted by Lucky at 9/8/2006 1:22:20 AM hi guys!
it's very very simple question for you mighty sql DBAs. but very hard
for a developer like me who is very very new to MS SQL.
anyways the problem is i want to use one SPs out to in the SELect
statement. here is an example :
select * from sp_tables tablename like 'syscolumns'
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |