all groups > sql server clients > december 2003 > threads for december 8 - 14, 2003
Filter by week: 1 2 3 4 5
An invalid argument was encountered
Posted by Mo Tarabishi at 12/13/2003 7:42:14 PM
Hi,
I am getting this message "An invalid argument was
encountered" when run my application(using ODBC
connection) from Windows 2003 server, but its working fine
when I use XP, or Windows 2000 Prof.
Any Idea about this problem?
Thanks... more >>
Execute batch file
Posted by Noorali Issani at 12/13/2003 4:11:53 PM
I have one move.bat file and I wanna execute it through sql server 2000.
xp_cmdshell 'c:\move.bat' (not executing the file)
how ?
waiting for your reply
Noor
... more >>
identifiy Identity field's value within query
Posted by Farhan Iqbal at 12/12/2003 7:42:40 PM
hi all
Is there any way to identifiy Identity field's value within query?
Farhan Iqbal
... more >>
stored proc takes long time the first time it is called
Posted by Jesse at 12/11/2003 5:10:14 PM
i have a stored proc that contains a single select stmnt. the proc runs
quickly enough most of the time (2 seconds). but it seems when the proc is
called for the first time in a while, it takes significantly longer (10-15
seconds) to finish. is the improvement in speed on subsequent calls to t... more >>
cannot open Enterprise Manager
Posted by Nitish at 12/10/2003 5:56:10 PM
for some reason SQL ent manager has stopped working on my
server. SQL
is up anmd running but I cannot get ent manager to work, I
get the following
error:
MMC cannot open the file c:\program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC
This may be because the fi... more >>
Cannot Open Enterprise Mangager
Posted by Nitish at 12/10/2003 5:33:56 PM
for some reason SQL ent manager has stopped working on my
server. SQL
is up anmd running but I cannot get ent manager to work, I
get the following
error:
MMC cannot open the file c:\program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC
This may be because the fi... more >>
Sequence number
Posted by Noorali Issani at 12/10/2003 4:16:43 PM
Dear Professionals
I have two colums in one table like FirstName, LastName and there are three
rows in it.
Steve, Rodger
Khan, Fundas
Brow, Fan
I don't wanna alter the table ! when I wanna select the table so the record
should disply like this.. means i wanna use sequence... 1,2,3....... more >>
Need Help ASAP
Posted by _M_ at 12/9/2003 1:08:21 PM
SQL Server 2000 will not start. In the ERROR LOG file it states that the
database model is undergoing a restore. Is there a way to stop the restore
and start the SQL server ??? Here is the error log file:
2003-12-09 12:35:20.94 server Microsoft SQL Server 2000 - 8.00.760 (Intel
X86)
Dec 1... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
XP managed passwords and SQL named instance.
Posted by Steven McCaa at 12/9/2003 11:25:25 AM
I am having issues connecting to a SQL server using XPs managed passwords.
Here is the configuration:
SQL 2000 server/Windows 2000 Cluster located behind a fire wall in a DMZ.
SQL is installed on virtual server FOO with instance name BAR in domain
FLUF.
XP client is installed in domain FUZZ.
... more >>
About logo ...
Posted by Lloyd Dupont at 12/9/2003 2:52:04 AM
we are writting a database application (currently) connecting to 3 database
including Microsofty's SQL Server.
we wonder if we could use the Microsoft's SQL Server logo in our
documentation diagram to represent SqlServer.
the guideline are not very clear and look much like you have to pay to p... more >>
date
Posted by kim at 12/8/2003 7:51:13 PM
i have a problem with MSSQL, my datatype is smalldatetime.
when i open enterprise manager i can see the date display is 12/8/2003 =
6:14:00 PM. But when i want to retrieve that time cannot, it only =
allowed me to retreived if my sql statement is select * from tbluserid =
where TDateTime =3D '12... more >>
Prometric Centre
Posted by Noorali Issani at 12/8/2003 6:22:36 PM
Dear Professional.....
Can any body tell me the list of prometric centre in Pakistan. From where I
can find out the list of that.
Waiting for your repl
Noor
... more >>
"No Items" in Database Tree
Posted by Stephane Collin at 12/8/2003 10:30:24 AM
The 2 Machine having the problems are Win2k Workstation=20
SP4.
SQL Server is another machine on Win2k Server SP4.
=20
Both the Clients and Server software has been upgraded to=20
SQL SP3a
Thanks ...
Stephane
>-----Original Message-----
>One previous post indicated the issue was rel... more >>
conection to sql server after change of ip address on server
Posted by Jared at 12/8/2003 8:09:26 AM
After an inadvertant ip address change on a server running
SQL Server 2000, I am unable to re-establish a connection
to the instance of SQL Server over the network via
Enterprise Manager. I am also unable to see other SQL
Servers on the network from the Enterprise Manager on the
server it... more >>
Log Shipping makes DB not available
Posted by jmorrison NO[at]SPAM eautoclaims.com at 12/8/2003 7:34:12 AM
We have a situation where we are log shipping from the
prod server to a report server every 15 minutes. However,
as the logs are being applied to the report server DB, the
DB is not available for a brief period of time. Most of
the time it is just a few seconds, but it has taken up to
2 mi... more >>
Licensing
Posted by Roger at 12/8/2003 7:23:49 AM
Will be setting up a SQL Server DB that could potentially
have 400-800 users off of 50-80 PCs. What are my
licensing options for the client PCs? Can I do an ODBC
connection at the clients or do I need a CAL for every
client PC.... more >>
sql 6.5 to talk to v 7.0 database?
Posted by Bill Carew at 12/8/2003 7:16:05 AM
Can I using the sql 6.5 client software, talk to a sql 7.0 database
on another machine? Should be upward compatible, right?
Please respond to william.carew@honeywell.com
bill... more >>
|