| Groups | Blog | Home |
|
March 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 |
Log Shipping or Replication Posted by Gabe Matteson at 10/31/2005 4:46:34 PM Which would you recommend to setup as a failover database server? (We do not
have the ability right now to setup a sql cluster). What is the difference
between log shipping and database replication? Pros/Cons? Thanks.
- Gabe
...more >>
Microsoft Distributed Transaction Coordinator call failed. Posted by umer.zafar NO[at]SPAM gmail.com at 10/31/2005 2:11:27 AM hi...
I am trying to run MS DTC sample application (dblib) equipped
with MS SQL Server 2000.I am using following commnd line to
link SQL Servers on two different systems
"dblib -s1 abc -u1 administator -p1 password1
-s2 xyz -u1 sa -p1 password2 "
Server 1: my PC (OS Xp)
Server 2: R...more >>
Ad-hoc query builder for users; similar to BusinessObjects Posted by Levent ORER at 10/26/2005 2:24:02 AM Hi, is there a SQLServer utility or tool to equip regular non-techie users
with the ability to create, run and save their own reports?
That would be similar to the Webintelligence product of BusinessObjects:
It's basically a graphical drag&drop tool for creating SQL queries with "more
Englis...more >>
sp_addlogin from vb.net security Posted by fasttrack via SQLMonster.com at 10/23/2005 12:00:00 AM A problem of security:
From a vb.net form I created the chance to add an SQL Server user with role
as administrator.
To create it, username and password are retrieved from two text box and then
the login is created with:
cmdSQL = "EXEC sp_addlogin '" & txtUser.text & "', '" txtPwd.text & "'...more >>
Receive Error: 17805 Invalid buffer received from client Posted by Brett Davis at 10/21/2005 3:33:20 PM Hello
I am running SQL Server 2000 with SP 4 on Windows Server 2003. Every hour I
receive several notifications with the following:
Reply: Message not found. Insertion strings:Error: 17805, Severity: 20,
State: 3 Invalid buffer received from client.
I want to create a SQL Profile...more >>
Inserting Comma(,) into the cost field (of Money Data Type) Posted by snarala NO[at]SPAM yahoo.com at 10/21/2005 9:36:57 AM Hi,
I am trying to insert Comma (,) into the cost field in my application
which is of money data type.How can I insert Commas(,).Can some one
help me out.
Here is the sample query what i am trying to write.
INSERT INTO TempTable
(FirstName,LastName,Salary)VALUES('XYZ','ABC',10,000.00)
...more >>
searching date problems Posted by bafidi at 10/20/2005 11:03:03 PM i have a table:
RECORDS1
fields:
DATE1,NAME1
data is
21,10,2005 10:24:34 ANDY
21,10,2005 15:24:45 DAVID
i search date with this sql
select * from RECORDS1 where DATE1='21,10,2005'
nothing found its empty
i try this also
SELECT *
FROM RECORDS1
WHERE (D...more >>
How to access SQL Server 2005 with Query Analyzer (SQL 2000) Posted by Sal Young at 10/20/2005 8:27:06 AM I'm not able to run queries on a MS SQL Server 2005 using the Query Analyzer
from an XP Pro machine running MS SQL 2000. I'm able to connect to the SQL
2005 server and display all objects in the Object Browser but can't run a
simple query. Any ideas?
By the way, I'm connecting with a new ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Memory leaking Posted by Rogers at 10/17/2005 12:00:00 AM I am facing memory leaking problem and its increasing more and more. I would
appreciate if you can guide me regarding this.
O/s:- Windows 2003 Service Pack 1
Sql Server : SQL Server Service Pack 3a
Memory was leaking to 1 GB and its increasing high and high even it's not
reducin...more >>
Change the Delimiters Posted by John Smith at 10/16/2005 9:19:57 PM Does anyone know how to change the delimiters on SQL Server 2000 SP4 Client
software?
From " " to [ ] ?
For example:
"dbo"."myTable"
to
[dbo].[mytable]
Running the Client tools on Windows XP.
John
...more >>
Help!! Newbie Posted by Taishi at 10/16/2005 4:46:28 PM Situation: 1st time using Oracle for a training class. 1st install
Problem:
I just went through the instructions for " Installing the Oracle9i
Database[1]". My problem is that I don't remember the passwords I created
and I'm following the instructions for loggin in... I am failing
mise...more >>
A SQL Server and Access Question Posted by John Lane at 10/13/2005 12:35:01 PM How do you execute a SQL Server stored procedure or query from an Access mdb?
Thanks....more >>
How to uninstall SQL 2000 client Posted by Dave K. at 10/11/2005 10:48:04 AM What started this is that I was having the following problem with my SQL
Server Client. The problem was in the Enterprise Manager SnapIn creating
database diagrams. I think the error was 'Invalid Class ID.'
I attempted the fix this problem by reinstalling the Client over the
existing copy...more >>
Accessing shares over internet Posted by scottdog129 at 10/11/2005 8:09:08 AM I have a remote client accessing a SQL database via an internet connection to
a public IP address on our SQL server. THe program needs to access a shared
folder for printing reports in the program, but the client does not recognize
the UNC path to the folder because they are not on the networ...more >>
Saving Excel workbook in SQL server using c# Posted by Jitender Khanna at 10/9/2005 11:06:03 PM Could anyone please help me out as to how we can save the excel workbook in
the database and
read it back.
I was able to convert the text files and image files into binary format and
save them to the
DB and finally able to retrive them back in the same format. But was unable
to do s...more >>
Database deployment Posted by Gareth Sharp at 10/7/2005 9:32:07 AM Hi there
Firstly, apologies for the multi-post - I could not decide which group would
be best to post this to.
I have a simple (I think) question.
We are about to roll out our first SQL server based application. The
application and run times are no problems - I'm pretty sure I know what ...more >>
SQL Scripting - Create New Column Posted by Gabe Matteson at 10/6/2005 5:57:16 PM SQL scripting... is there anyway to create a script that inserts a column
into all the USER tables in a database that is a primary key column, doesn't
allow nulls and identity is set to yes, the seed is 1 and the increment is 1
as well? I am enabling a database for replication and need to crea...more >>
sql client connectivity errors Posted by GaryC at 10/6/2005 4:43:03 PM We're getting error messages on XP Pro clients connecting to an SQL 2000+SP3a
server running Windows Ent. Ed.+SP1. The clients have SP2 installed which
includes MDAC 2.81. The error messages come up in the following sequence:
SQL Error: 01000 (10054):[Microsoft][ODBC SQL Server Driver][TCP/IP...more >>
security proplem Posted by bafidi at 10/6/2005 12:06:02 AM i go to security and open a user
username=salih
password=12345
i have a database name Stok
i want this user to write and read only and execute prosedures not create
tables etc.
only use a program and connect to this database and use it
how can i create a new user and make changes for th...more >>
datatypes Posted by bafidi at 10/6/2005 12:00:06 AM i am confused about inputing decimal numbers to access database and then to
the sql database
i use double at access and foalt dataype at sql server is this ok for
inputing decimal numbers
ex: 123.123.125.125,125,253,2145
i want to see digits after recoording them to acces database and to ...more >>
Client timeout expired, settings on 10hrs on server, how change cl Posted by Urban at 10/5/2005 1:44:02 PM A client has to insert many files with bulk insert. I start it using windows
scripting host with VB Script and ole db provider for SQL Server. works good
and fast. Only really big files will take several minutes to terminate.
How can I set the client timeout?
I'm using windows server2003 ...more >>
Client Connection Problem. Posted by JoseTA at 10/5/2005 8:26:06 AM Hi Everyone,
I have a problem while executing my application on the network. I don't know
why this error "cannot generate SSPI context". I have been developing client
server application in VC++.NET with SQL Server 2000. I installed my SQL
Server on Windows Server 2003 machine and configured...more >>
SQL-server error Posted by Massie at 10/4/2005 10:59:58 AM IN our network with Windows 2000 server and Windows XP clients the following
problem occurs.
On our accountingfirm book-keeping is done with a prograam that runs on
sql-server. The following happens:
After some time (approx. half an hour) SQL-server reports the following
error:
"Cannot c...more >>
Connection no longer works Posted by Alton Chinn at 10/3/2005 10:42:01 AM I was able to connect to a SQL Server 2000 instance using ODBC on a Windows
2000 workstation (Service Pack 4). But after installing several security
updates and rollups, I am no longer able to connect to SQL Server.
The drivers tab in the ODBC Administrator lists SQL Server as Not marked
u...more >>
linked view in access don't use index Posted by toni at 10/3/2005 1:17:01 AM
Hello,
I have a table with two field (name of the table : table_with_two_field)
field1, field2
when i create a simple view with no clause where:
create view dbo.view_on_field WITH VIEW_METADATA
as
select field1 from dbo.table_with_two_field
and i linked this wiew on acce...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |