Roy it looks to me that this is a rounding issue when the convert is changing to smalldatetime; that is wierd to me as well, since i'd expect the rounding...

a user would need EXECUTE permissions on the functions in order to use them.. read(SELECT) access, like granting db_datareader, is limited to tables or views.

no limit the way you are thinking...you can have one default per column if you want...a table with 200 columns could potentially each have a default value for each of...

xp_cmdShell does not use your credentials.

this is a common security misconception . The problem is that when you access any resource OUTSIDE of SQL server, like network shares, local hard...

sure, it's just like any regular INTO NEWTABLENAME select statement: the column definitions will be derived from the output of the results of the SELECT.

SELECT TOP 3 *

INTO MyNewTable

FROM sys.tables

SELECT...

Paul i think you are on the right track about the collation issue;

your function and examples worked fine; i got the correct proper cas for all the examples you posted.

I...

Gil i don't believe it is possible.

I'd seen this question a couple of times before, and here are some threads on the same issue.

http://www.sqlservercentral.com/Forums/Topic921933-391-1.aspx

http://www.sqlservercentral.com/Forums/Topic906015-145-1.aspx?Highlight=whoami

http://www.sqlservercentral.com/Forums/Topic905937-146-2.aspx

i had tried reading the registry of...

I think Jim Dillon has posted the definitive way to create a linked server to MySQL here:

http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx

he posted some really good instructions, and there's a lot of sharp questions on...

then the error is in the logic where you are determining the substring; does this return any rows?:

;WITH CTE AS

(

SELECT Field9,

...

the problem is in the data; at least one row does not have every charindex you are looking for:

select * from evCreateUser

WHERE CharIndex(''User Account Created'', Field9) = 0...

there is absolutely no advantage to storing dates as anything except dates.

never store datetime as any other datetype except datetime.

what is the date of the integer 20105404?

internally, SQL stores it...

depends on what "kind" of integer you want:

select convert(int,getdate())

--40332 days since 01-01-1990, SQL's internal start date

select YEAR(getdate()) * 10000

+ MONTH(getdate()) * 100

+ DAY(getdate())

--an integer "20100604"

i don't know if this will help you, as it's not a canned solution, just how I've done it in the past.

I created a simple vb6, and then improved it...

davidandrews13 (6/4/2010)

---

thanks for the responses.

so if i wanted to find out if 'lowell@davidandrews.com' exists on my own server how would i go about that?

lets say that the email in the...

no sorry Dave; all you can do is check that the format of the email is correct...[something] @ [a correct TLD]

If you have your own mailserver for davidandrews.com,for example, then...