| 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 problem about registering a remote sql server Posted by creek at 1/14/2005 10:10:52 AM hello
my pc is in LAN , os: win2000 server sp4 ,sql server:sql server2000 sp3
remote pc : win2000 server sp4 ,sql server 2000 sp3
I can connect to remote sql server using osql. when I register the remote
sql server by enterprise manager .the error occur :
connectionread{recv{}} general ...more >>
"Design Table" unavailable? Posted by Jeff Cobelli at 1/14/2005 9:15:34 AM I am using VisualStudio.NET's Server Explorer to access two SQLServer
databases. The right-click menu on "Tables" for the locally hosted database
inlcudes the "Design Table" option, but not for the database hosted by our
web hosting service. It will allow me to add records, however. When I ...more >>
Truncate Log on Checkpoint Posted by here NO[at]SPAM there.com at 1/14/2005 2:13:17 AM In the old days of SQL 7 this was an option on databases.
I have a couple databases that I really do not need to log and would really
like this funtionallity in SQL2000. Is there such an option hidden away
somewhere?...more >>
Database design question Posted by xfile at 1/13/2005 5:27:09 PM Hi:
Appreciate if anyone can help me on the following DB design questions.
I wish to have a table which stores all customers' information, say TB1.
And another table, say TB2, for only those "active customers".
TB1 will contain all information of TB2 and those are inactive, which means
...more >>
copy data in table with identity column Posted by Owin at 1/13/2005 3:23:50 PM Hi all,
I want to copy 40 tables from one database to an identical database for
simulation purposes.
Everything well untill the script reacges a table with an identity column:
set identity_insert [Database].[dbo].Table on
insert into [Database].[dbo].[Table]
select * from [Database]...more >>
How to copy databsae from other sql server Posted by Sunny at 1/13/2005 1:18:15 PM I have installed SQL server 2000 on WIN2K server and have 3 different
database creatd on the server. Now I also have installed sql server desktop
engine on my local m/c (win 2000 workstation). Now I would like to copy all
database from enterprise server (production server) to my desktop engine
(...more >>
Incorrect syntax near the keyword 'OR'. Posted by Kiran at 1/13/2005 9:17:58 AM Hi,
I have a stored procedure
CREATE PROCEDURE dbo.Retrieve
(
@SEARCH_STRING nvarchar(200),
@COUNT int
)
AS
DECLARE @STRING_COUNT varchar(3)
DECLARE @SQL varchar(1000)
SET @STRING_COUNT = CAST(@COUNT AS varchar(3))
SET @SQL='SELECT TOP ' + @STRING_COUNT + '[ID] FROM [EMPLOY...more >>
Programmically take only only changed backup. Posted by Nilang Shah at 1/12/2005 9:05:08 PM any one have any idea, whether we can programmically take only only changed
backup.
Meaning of that statement : if yeasterday i took backup and transferred data
then toady i only want to transfer the newly added data or modifiled data.
Thanks in advance.
Nilang Shah
Jr. Developer
ETI,G...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Select works, but update query hangs Posted by Amit at 1/12/2005 3:16:03 PM Hi,
I just started getting this problem in one of our databases. If I run a
select query, it works fine. But if I try to update something there is no
response from the server - all I see in the query analyzer is that its
running the query. The queries work fine in other databases. I took the
da...more >>
W2K bug Posted by tobink at 1/11/2005 11:11:03 PM hi people,I've got a problem here
by the way I'm just a beginner in Sql server programming
the problem is when I insert a new value such as a date it doesn't appear as
I want, for example: "insert into msdatabase values january 12 2005"
when I run it shows January 12 1900
can anybody help me to...more >>
Dump data structure Posted by Christoph at 1/11/2005 2:41:41 PM MySQL has a little command line utility called
mysqldump
that can be used to dump the entire data structure (and the
table data, if needed) of a particular database in one fell
swoop.
Does SQLServer have a similar utility?
thnx,
Christoph
...more >>
Backing database up on network device Posted by amark213 at 1/10/2005 11:51:04 AM Running SQL Server 2000 Enterprise Edition and I'm trying to back up a series
of databases on a network device. When I try to backup a database to the
networked drive, SQL server isn't seeing the device. Is what I'm trying to
do possible?...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |