Following up on what AJ wrote, you could do the this:

1. Create the following UDF ( dbo.fOccurs() )

2. Run the script that follows the UDF, adapted for your situation.  The...

Neither script will work, because DBCC SHRINKFILE only works in the current database. From TSQL, the only way to change the database context is with the USE statement (for example, USE...

Look up CREATE TRIGGER in BOL (SQL Server Books On Line). The definition from BOL is, in part:

... a special kind of stored procedure that executes automatically when a user...

Do you have an UPDATE trigger on the table? Maybe something is happening there. Also, you could hard code the SQL statement in your .ASP page, then strip off columns one-by-one until...

You would have to strip the double quotes after the data is loaded, as in the following example:

CREATE TABLE #tblTest

(

  id int IDENTITY(1,1)

, data varchar(70)

)

SET NOCOUNT ON

INSERT #tblTest (data) VALUES...

You cannot, if you are trying to install SQL Server 2000 Standard Edition or higher on WinXP. Those versions of SQL Server require a server version of Windows. You will...

Frank,

He was joking. The letter L represents the word LOSER, which in this case means "someone who fails consistently, especially a person with bad luck or poor skills". The usage...

I agree with Frank and Wayne - use decimal, or even float, and format the display as currency when needed.

--Mike

I have a UDF to format values of type DECIMAL, and have adapted it here for type MONEY. Modify as necessary.

DROP FUNCTION dbo.FormatMoney

GO

CREATE FUNCTION dbo.FormatMoney

(

  @num money,

  @decPlaces int

)

RETURNS varchar(20)

AS

BEGIN

 ...

Sometimes I use the following technique to create a "temp" table which is actually a real table in the current database. I then drop the table when I'm done.  This...

According to my tests, the maximum is actually 63 characters. 63 works, 64 fails. I wonder if there is a unicode issue that cuts the 128 in half. Interesting.

I must...

Maybe I've misinterpreted you question, but why can't you just copy the .mdf and .ldf files from your computer to the web server and then attach the database? Of course,...

I just tested this on a server ( Windows 2000 SP4, SQL Server 2000 SP3a ) and it worked fine. I created a SQL Server login call LONGTEST with a...

First, let me say that this question is totally irrelevant to this forum.

That said, digging deep into my memory, I'd say the file would end up like this:

PRIME...

Hmm....

On my calendar, the first row in January contains Saturday, Jan 1, 2005. That is week 1, where a week is defined as Sunday thru Saturday AND each day of...