| 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 |
Filter by week: 1 2 3 4 5 Distributed system patterns - SQL Server deployment Posted by Bert Nieves at 12/7/2003 6:19:45 PM DEV ENVIRONMENT: .NET and some COM
DATABASE: SQL Server 2000
CLIENT OS: Win2K, WinXP
SERVER OS: Win2K3
Greetings,
I have a client who insists on having their customers in separate SQL
databases for an online component. I instinctively feel that a consolidated
database for all clients is ...more >>
plz help......... Posted by mark at 12/6/2003 10:28:34 PM does the sql server 7 desktop edition does not have the
attach file option at all..
i donot know how to start it/..
help plz..
thanx
mpax
...more >>
Cannot access SQL Server now that server is a domain server Posted by Simon Graffe at 12/6/2003 10:54:17 AM Hello, all:
We recently reconfigured our Win2K/SQL Server to act as a domain server, and
now the SQL Enterprise Manager in client PCs cannot connect to the server,
unless Windows explorer is used first to navigate to the server.
We have mixed authentication in SQL Server, and the clients do no...more >>
Client Install from server Posted by JCG at 12/5/2003 1:21:54 PM How can I have SQL 2000 client automatically install
itself from a windows 2000 sever? thanks...more >>
Sleeping Status Posted by Yama at 12/5/2003 11:18:28 AM Hi,
I am using a connection to the database with the following:
Try
Dim conBO As New SqlConnection(Me.strConnect)
Dim cmd As New SqlCommand(GetSQLString, conBO)
cmd.CommandTimeout = 120 '-- 2 minutes
conBO.Open()
Dim rdrBO As SqlDataReader =
cmd.ExecuteReader(CommandBehavior.Cl...more >>
Runaway Delete Posted by Jeff Block at 12/5/2003 10:45:26 AM I am having a problem with a simple delete, I can replicate the problem but
have yet to find a viable solution:
table xyz has roughly 40000 rows
Foreign Key (it is the primary) to several (empty tables)
can issue a delete from xyz with completin in 10-15 seconds UNTIL
the case where the delet...more >>
SQL client install on NT failed Posted by Ken Petschel at 12/4/2003 8:40:00 PM Dear sir
I have tried installing the SQL Server 2000 Client drivers
on a client PC running NT (SP6) and win98, the install
(for connectivity only - local pc) goes right through to
the copying of the files. This is where it fails giving
the following error message:
Installation of the ...more >>
How do I get Windows 98 to AUTOMATICALLY start SQL Server??? Posted by Aaron Ackerman at 12/4/2003 4:35:41 PM I need the service to start without user intervention with the following
switches:
scm -Action 1 -Service MSSQL$SQLDB -Server TESTBED
I cannot simply place SCM.exe in the startup folder that is not going to
work.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Can't Connect Posted by Fred Block at 12/4/2003 2:06:39 PM Hi All,
Can someone tell me what might cause a networked workstation not to connect
to the SQL Server?
Here's more information:
The enterprise was running SQL7 and the workstations had the Client Network
Utility installed. The server was upgraded to SQL2000 and now users cannot
connect. ...more >>
VB.Net and Sql database Posted by anonymous NO[at]SPAM discussions.microsoft.com at 12/4/2003 9:50:13 AM Unable to access Sql tables when using VB.Net that contain
tables in Sql database installed on my Desk PC
Error message "
An unhandled exception of
type 'System.data.SqlClint.SqlException'
Additional information System error"
system.enterpriseservices.dll', No symbols loaded.
Also on the d...more >>
SQL Server Log Message Posted by ashok khandelwal at 12/4/2003 2:39:17 AM SQL Server is optimized for 8 queries.by incresing 1 more
query the performance will be adversely affected.
this is the message I am getting in SQL server log as well
as Windowns 2000 Event log.
---details.
we are using sql server 2000 and we have current 10 clients
which are connecting thro...more >>
Yukon breaks Enterprise Manager Posted by nite_eagle NO[at]SPAM hotmail.com at 12/3/2003 12:19:28 PM Here is my configuration:
Windows XP SP1 Pro
SQL Server 2000 SP3 Client and Server
Yukon Beta 1 Full Install - Reporting Services
After installing Yukon the Enterprise Manager crashes/exits when you
try to open the Management folder. All other EM functions seem to work
properly. It does no...more >>
Calculating DB size... Posted by Brett at 12/3/2003 10:59:58 AM Is there a way programmaticlly calculate database size?
If so, how would I go about it? Also, to make sure that
the number matches that to the task pad in enterprise
manager. I am using SQL Server 2000.
Thank you,
Brett
...more >>
Attach a network database problem... Posted by skc at 12/3/2003 2:26:38 AM I want to attach a database that resides on another
machine on our SBS2000 Network.
Whe I go to attach a database, it always seems to list the
local HDD volumes (not the mapped ones to other machines
on the network).
How can I attach a database using a mapped drive??
Thanks,
skc...more >>
convert(Decimal(10,3),13/7) Posted by Sandeep at 12/2/2003 2:18:11 PM
Select convert(Decimal(10,3),13/7)
is giving 1.00
What is wrong?
TIA...more >>
Is there a function in Query Analyzer to input data? Posted by Calid at 12/2/2003 1:29:51 PM Hi All,
I want to test my code in Query Analyzer, and don't want
to change data assigned to variables, so is there any
function e.g. like scanf in C to read data from the
keyboard buffer.
Thanks in advance....more >>
Adding field messes up ADO queries Posted by minus273 at 12/2/2003 10:46:56 AM I recently added a bit field to a SQL table. When I
subsequently ran queries through ADO, values for field A
would appear in field B, field B would appear in field C,
etc. The problem was fixed after I ran the query in Query
Analyzer. Is this typical behavior? Whenever I alter a
table ...more >>
Replication Posted by Noorali Issani at 12/1/2003 11:56:54 AM Dear Professional
I just wanna know that when I use the DML command so it's replicated on the
subscription server perfactly but when I use DDL command so it doesn't work
like I have created one table which is failed to replicated, can any body
tell me that how can I replicated the DDL command...more >>
Performance Posted by Noorali Issani at 12/1/2003 11:45:03 AM One important question !
There are alot of queries written in our front end and I just wanna know
that which query is expensive or we can say that which query is decreasing
the whole application performance. Is there any tool through which we can
identify it.
Waiting for your reply
Noor
...more >>
Database Status ! Posted by Noorali Issani at 12/1/2003 11:35:12 AM Dear Professional
How I know that my database is perfact is all espects, is there any way
through which we can identify that that current database is 100% perfect
according
to all espects.
Waiting for your reply
Noor
...more >>
new database in disabled on client of developer version Posted by Ann at 12/1/2003 7:51:59 AM We have a sql server standard edition on our web server.
For me the developer, I have also a developer version
installed on my testing PC1.
Now I have client installed on my workstation PC2.
I created two SQL server group by using sql server
registration in Enterprise manager in my client...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |