Groups | Blog | Home


Archived Months
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
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 >>



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 >>


DevelopmentNow Blog