Betty, use the Stuff() function for that, like...

Not sure about MSDE, but other versions of SQL Server 2000 control that value with a registry key. See if you have this key on the server:

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer

There should be a...

The parameters for mssql_connect are server, username, password.  This means you are using SQL security, so SQL Server must be in mixed mode (the default is Windows Authentication only).  Are...

CI means case-insensative, and CS means case-sensative. It's one or the other, so I'm not sure if any other values would make sense.

I think most of that info is stored in the master.dbo.sysconfigures table. However, I would use sp_configure to change any of those values.

Before replacing any memory, visit this link:

http://oca.microsoft.com/en/windiag.asp

and...

You specified the default port 1433, but the error indicates the connection was attempted using Named Pipes, not TCP/IP.  If you run the server network utility (svrnetcn.exe) is TCP/IP listed...

I'll vote for all of the top forms of racing (I'm partial to MotoGP motorcycle racing). Like NASCAR and other huge-dollar racing genres, the number of sensors recording real-time data...

It should. The way I'm suggesting means that data on your D: drive always available (except while rebooting and shutting the machine off, of course).

If something goes wrong, you can...

If I understand you correctly, you have a mirrored D: drive. You are only replacing the two drives used for D:.  If that is the case, after making the appropriate backups,...

Here one way. Create UDF to parse a single string, then you can use the UDF in a query.

--EXAMPLE query, run after the UDF is created.

-- SELECT dbo.fGetEMail('Name: Joe...

You just recently asked this same question here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=284300#bm284434

I assume that previous post did not answer your question.

A composite key is simply a primary key that consists of two...

Do you have other user roles to which the user may belong? We don't give any user permissions directly. All permissions are assign to roles we create, then the user is...

naila, do you mean Foreign Key? That is, paymentId is the primary key in another table.

You have to specify the port. there are two ways to do that.

1.  Change the default port number for each client using the Client Network Utility. Highlight TCP/IP in the...

You can use Substring to access blocks of text from a text column (or ntext). The blocks are limited by the maximum varchar sizes, which are varchar=8000 and nvarchar=4000. 

The...