What is not "standard" about that date format?

All built-in string functions are deterministic, including PATINDEX and CHARINDEX.

String Functions (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms181984(v=SQL.90).aspx

That SSCrazy guy really seems to know his stuff.

Your error is very simple: You cannot use an expression as a parameter of a stored procedure

Change this:

exec sp_getezquerylist 'DO' + CHAR(39) + 'SULLIVAN', 'n', '100'

to this:

declare @@sUser as nchar(500)

set...

Use a case expression to filter the results; evaluation of the case conditions ends with the first true condition and avoids the conversion errors.

declare @tmp table (field8 varchar(20)) ;

insert ...

From SQL Server 2005 Books...

You can only access more than 4 GB of memory under Windows 32-bit if you have Windows Enterprise Edition.

Break it out into normal entities:

User

Course

CourseLession

CourseTest

UserCourseLession

UserCourseTest

I use the SQLPing 3.0 tool to look for server instances.

http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx

Roger Abram (4/14/2011)

---

Thanks for the input. There are coming off an old server and SQL 2000 to a brand new machine with SQL 2008. The mdf files aren't...

If you think there may be IO problems, I would say to run it, but only with SQL Server shutdown.

I usually run SQLIO before putting it into production, and save...

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

mtillman-921105 (4/13/2011)

---

Craig, you're probably right! Then it was my fault, not the documentary's. I should have looked it up before relying...

Does this topic have a purpose?

Anyway, I think Gila Monsters are warm and cuddly.

Dan.Humphries (4/13/2011)

---

I did not write this but here is a little script I picked up a while back that I use. It provides some pretty useful information. I would...