Does DEC_TXN.DATE_LOAD have non-zero times?  If so, your join will not return any rows, since in your example the Calendar table has zero times.

Also, you doing unnecessary work - use...

I would uninstall the client tools first. Also, don't forget to follow up by installing SP4 (or whatever service pack level you are using on the server). You want to...

Actually, Noel's code works fine with a little tweaking:

select object_name(id) as ObjectName

     , sum(datalength(text)) as char_cnt

 from syscomments

group by object_name(id)

order by char_cnt desc

I would reinstall the client tools, as you may have a corrupted file.  Before you do that, you could try to start the MMC in author mode.  To do that,...

IF you normally connect to the SQL Server using the server name, try to connect using the IP address instead.

I'm not a network expert, but it's my understanding that if you have DNS forwarding enabled, then the local DNS server skips the name resolution process and forwards the request...

This link at the University of Texas at Austin looks pretty good - of course, there are hundreds of others.

http://www.utexas.edu/its/windows/database/datamodeling/dm/overview.html

The relationship between agent and buyrate is many-to-many. Thus, you need another table (agentbuyrate) to create two one-to-many relationships.

In a typical one-to-many relationship (i.e. master-detail, such as customer and invoice), each...

Mordechai, can you post the CREATE TABLE statement for #repl_text_holder?

As Charles stated previously, sp_text is probably defined as an nvarchar.

If so, you would either need to...

You didn't provide enough information to properly analyze the situation. You've placed sortcode and groupid into both the agent and the buyrate table - I'm not sure why. I will...

Fred is correct. That's why using my query will work, since style 112 returns a date in the form of YYYYMMDD.  Personally, though, I always convert back to datetime to...

If for some reason you must convert the datetime values (to strip times, for example), use style 112 instead:

SELECT *

  FROM SAMPLE

 WHERE CONVERT(VARCHAR(8),CREATED_DATE,112)...

What version of SQL Server are you using?

For version 7 and greater, change all occurrences 'SQLOLE.SQLServer' to 'SQLDMO.SQLServer'.

Refer to: http://support.microsoft.com/kb/q152801/

The only way I know of is to modify the system stored procedure sp_password.  You should keep the scripts for both the old and the new versions in case you...

Try this:

truncate table mytable

SET IDENTITY_INSERT mytable ON

insert into mytable

select * from mytable_temp

SET IDENTITY_INSERT mytable OFF