You're probably referring to SQL-DMO (SQL Distributed Management Objects). Look this up in SQL Server Books Online (BOL) - there is a lot reference material there. Although, SQL-DMO is primarily...

Not sure about spell checking from Transact-SQL, but for use with applications and servers at the time of data entry, check out http://www.wintertree-software.com/ 

I use the following UDF for Hex to Dec conversions. In my tests, it is marginally faster than the fn_basetodec, and it doesn't require a numbers table:

CREATE FUNCTION dbo.fnHex2BigInt

(

  @hexNum...

Noel is once again correct.

DBCC CHECKIDENT permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database role,...

Noel is correct, but permission to run DBCC CHECKIDENT extends to the table owner, which should be the user who creates the temp table.

Geoff,

You could you use Kenneth's idea with a slight modification. Assuming the starting ID is greater than 1 (you could check for this), use the following code:

declare @i int

set @i = 100  --...

Scott,

I ran your code without a problem. I assume that you just left off the SELECT at the beginning of the code because of a cut-and-paste error. If you leave...

James,

John's correct - it is usually a version mismatch (probably MDAC, but I'm not sure).  For example, when I installed SP 4 on my servers, I didn't apply it to...

Here's a UDF you could use to examine each Firstname, or combine it with Wayne's query to view only those Firstnames that contain control characters.

The input string is displayed as...

SQLBill,

Yes, I see that later on in the posts. I wasn't sure what Ilan wanted, because the problem changed from the original problem:

how to...

See if this helps:

http://support.microsoft.com/?scid=kb;en-us;321003&spid=2509&sid=50

Also, are you sure the file is dBaseIII/IV/V and not FoxPro?  Try using the Visual FoxPro driver and see what happens.

Ilan,

Sorry, I reversed the calculations for StartTime and EndTime. The corrected version appears below.  It's not clear as to what date range is required relative to GETDATE().  If today...

DECLARE @StartTime datetime

      , @EndTime datetime

SET @StartTime = CONVERT(datetime, CONVERT(varchar(8), GETDATE(), 112) + ' 16:00:00')

SET @EndTime = CONVERT(datetime, CONVERT(varchar(8), GETDATE(), 112) + ' 20:00:00') - 1

PRINT @StartTime

PRINT @EndTime

SELECT *

  FROM...

I have three forms of user-defined functions that I use, and each has different possible permissions when viewed in EM.  For this discussion, I'll ignore the DRI permission.

1. A "regular"...

RAISERROR arugment type i specifies an integer. BigInt is not an integer (which uses 4 bytes of storage). Although similar, they are not the same datatype. When you run your...