Try this. Replace '11/12/01' with your date.

select CONVERT(SMALLDATETIME, '11/12/01 12:00AM', 1) from TableName

Darren

What kind of error do you get? Can you run this with a hard-coded database name and it works fine?

Darren

I think instead of doing a max() function in your "not exists" function you need to use a top 1 possibly. I think the Max is always returning 1...

I'd do an outer join on the table itself.

Example:

select a.* from Customer a

inner join Customer b

where a.Id <> b.Id --Use whatever keys are in this table

and a.firstnm =...

Check the event application log on the SQL server and look for MSSQL fatal errors. Also, run DBCC CHECKDB to see if the database has any errors. (This...

The only time I've seen the "Cannot generate SSPI context" error is when a user lost their connection to the database and had to relogon to her PC. I...

Also, you may find some additional help in BOL under topic "using OPENXML" or "Retrieving and Writing XML Data"

Darren

CREATE PROCEDURE dbo.spCustomerXMLIM01

@XmlDoc text

AS

DECLARE @docID int

EXEC sp_xml_preparedocument @docID OUTPUT, @XmlDoc

INSERT INTO tCustomer

SELECT *...

We use XML inserts for this type of mass insert. We format an xml document in chunks of about 1000-5000 records, then call one single XML insert statement. ...

Did you try the Suggestion Wizard to see if it had any ideas? Maybe try a question like "What servers are like Microsoft?"

Darren

You could make it the first page they see before entering for the day. As long as it's quick they will probably fill it out but give them the...

This script is in the transormation section correct? If you have a msg box at the very beginning and it doesn't show up, then it must not even be...

sp_lock will give you the locks. Try sp_who2 for deadlocks.

Darren

To see the lock first run the query, then from a different connection type sp_who2. This will show any blocked transactions. If a query is blocking that you...

The only other suggestion is to run system monitor while this is running next time and look for any outliers. Like CPU and memory usage on SQL Server.

Darren