|
|
|
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 An 'OnClientConnected' on the Server side Posted by Trex at 2/14/2006 1:25:28 PM Upon a client connecting to the server, is there an 'OnClientConnected'
-equivalent event on the server side that I can put some code to check who
has just connected or what application or workstation is connecting? I'm
looking for some way to check for 'valid' client applications....more >>
Remote Database Posted by Alberto Brivio at 2/13/2006 6:24:18 PM Dear ALL,
I've a customer of mine asked me for a web hosting , and internet site
contains a SQL database.
It seems to be very simple but customer wants database at his office, so my
problem is what is the most suitable solution to make communicate web and
database remotely in order to ...more >>
SQL2005: Linked Servers & Updating Text datatypes Posted by Rob Morhaime at 2/13/2006 1:16:28 PM I posted this in sqlserver.programming and did not get any responses. Trying
again..
This bugged me in SQL2000 and seems to still be here in SQL2005. Here's repro
code to run on two SQL2005 servers:
Run this on the "remote server":
Create Table RemoteTable (id int, txtdatacolumn text)
...more >>
There are multiple accounts with name MSSQLsvc/ad.domain of type DS_SERVICE_PRINCIPAL_NAME Posted by KayZer Soze at 2/13/2006 12:54:47 PM Win2003 SP1 + SQL 2000 SP3
Sometimes, i have to restart SQL Server, because new users (on their regular
PCs) cannont connecto to SQL. I have 100 SQL CAL licences, and 45-65 users.
Sometimes a user disconnects, change to another's one PC and can connect.
Maybe there is a relation with recent ...more >>
Why is it so hard to connect SQL2000 over Static IP? Posted by ARTMIC at 2/12/2006 5:27:02 PM Why is it so hard to connect SQL2000 over Static IP?
I thought it would be as easy as setting up a static ip with the ISP, and
forwarding port 5000 from the router to the actual server box, and the
sql2000 instance running on the server would listen to the port and do its
thing... IT ain't wo...more >>
SQL Connection denied after shutdown the Sql PC and restart Posted by mangia at 2/10/2006 5:03:27 PM I have a client PC running a C# program that obtains data from an SQL Server
database. The computer hosting the database is on a local network and is
accessed by using the following connection string: Both computers are
Windows XP SP2.
"Data Source=192.168.20.124,1433;Network Library=DBM...more >>
Same server multiple names problem Posted by Mario at 2/10/2006 9:38:31 AM I have a SQL 2000 server on a Windows 2003 server that i need to access with
a different name from the same machine only.
I added a hostname in the host file and associate it with the ip 127.0.0.1
In a test enviroment works fine but when i try to do the same in the real
server i cant conn...more >>
Question on permissions, net and xp_cmdshell Posted by Miguel Castanuela at 2/9/2006 4:31:27 PM I'm planning run a batch ( c:\CopyBkp.bat ) in a basis daily-night,
basically it makes a copy of my full backup files on another machine
in the net. The batch runs fine executed from a cmd window,
but from Query analyzer (testing purpose) the instruction
EXEC master.dbo.xp_cmdshell 'copy d:\b...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
DB2OLEDB and Linked Servers Posted by Andrew Robinson at 2/9/2006 2:17:12 PM Has anyone had any success with linked servers and DB2. My DB2 knowledge is
very limited.
EXEC sp_addlinkedserver
@server = 'SERVERR2',
@srvproduct = 'Microsoft OLE DB Provider for DB2',
@provider = 'DB2OLEDB',
@provstr='Network Transport Library=TCPIP;Network Address=10.73.102.115;...more >>
SQL Server 2005- Not getting Started Posted by Shyam at 2/9/2006 7:00:29 AM Hi,
I'm a newbie to SQL Server 2005 and i've installed 180 days trial ver.
When i tried to open the SQL Management Studio,i get the following
error.Kindly help in resolving this issue.
Regards,
Shyam
TITLE: Connect to Server
------------------------------
Cannot connect to SHYAMLAPT...more >>
Cannot connect to SQL2005 Express from PHP Posted by Jan Rok at 2/9/2006 12:00:00 AM Hello,
I have PHP 5.0.2 on Apache2/WinXP and database on MS SQL 2005 express.
I cannot connect to server:
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to
server: TESTSERVER\SQLEXPRESS in C:\xxx\test.php on line 11
My source code test.php:
....
$connectstring =...more >>
Yukon xp_cmdshell setting Posted by Vaibhav at 2/9/2006 12:00:00 AM Hello,
How does Yukon keep the information about the security context of
xp_cmdshell (user or agent) ?
How can we retrieve it ?
I could not find a registery setting for that.
Please help.
Thanks a lot in Advance
Regards,
Vaibhav
...more >>
failed to connect to new instance in MSSQL2005 Posted by stephanie at 2/8/2006 9:39:27 PM I tried to connect to a new created instance (specifying server\instance)in
MSSQL2005 server with mangement studio in another mssql2005 server. It show
an error
'An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caus...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |