I could not find the link I saw, but I remember reading it was to be released before the official launch of Vista (since it is required to run SQL...

CREATE TABLE #tblMonth (MatchDate smalldatetime)
DECLARE @Day smalldatetime
SET @Day = STR(Year(getdate())) + '0101'
WHILE YEAR(getdate()) = YEAR(@Day)
BEGIN
  INSERT INTO #tblMonth VALUES (@Day)
  SET @Day = DATEADD(d, 1, @Day)
END

SELECT 
DATENAME(mm, #tblMonth.MatchDate) AS Month,...

Easiest way for me to do this is just detach the database, move the files, then re-attach the files.  You can detach it in EM, but you will not be...

I recently saw a pretty good product for a affordable price.  SQLSpec from Elsasoft (http://www.elsasoft.org/) was actually written by a member here http://www.sqlservercentral.com/forums/userinfo.aspx?id=145142.  It does not do HTML...

If you are just want to extract the string into 50 character substrings, lookup in BOL for the SUBSTRING function.

If you have a delimiter in the string, you can specify...

Ninja's query may not be accurate.  If the text of a stored procedure is over 4000 characters, it is split across 2 (or more) sys_comments records.  That split could occur...

It may be that Enterprise Manager will do the copy/drop/rename method, but I think it will try not to, based on what you are doing.  If you do insert a...

neotokyo; Follow sqldba's advice.  Check sp_help_job, and use current_execution_status.  Not jobactivity and run_status.  Jobactivity is updated after each job step.

Datediff also calculates difference in hours (or minutes or seconds).  But the answer is, as stated by SQLBill, DateDiff never did account for DST changes before.  If you need that,...

Here you are asked if you would like to automatically send error reports and feature usage data to Microsoft. I always leave these options unticked.

Strongly suggest that you do check...

could a user feel something wrong?

If you put your right hand near the power supply, and you left hand over the CD drive door, similar to Vulcan mind-meld technique....

Sorry, but...

Look at using the DatePart function to extract the hour, then Group By on that value.

SELECT ...

Group By DatePart(hour, PinIssueDate)

Where are you running the .Net app?  From your XP workstation?  And I assume you are using integrated security in your connection string.

Unless you turn on impersonation in the .Net...

Yes, you can rename a worksheet (inside a workbook) from SQL.

Lookup using sp_OACreate and related sprocs, and use the Excel Automation object to rename a worksheet.

Depends what you are looking for.  If you are just looking to format the datetime value, use:

CONVERT(varchar(30), getdate(), 101)

If you want to keep the data type, you need to understand...