SP4 adds support for Windows 2003 64bit. AWE patch should not be needed with 64 bit.

Andy

You explained your one question yourself, you can only assign the creation of an object to the FileGroup, not the file. Example:

CREATE DATABASE MyDB

ON PRIMARY

 (NAME = MyDB_Data, FILENAME =...

If you "can" create all of your database objects in dependancy order, you will not have any issues with sysdepends.

I personally have no sysdepends issues and take any to be...

Try ADO and ADOX:

' Begin ProceduresVB

Sub Main()

    Dim cnn As New ADODB.Connection

    Dim cat As New ADOX.Catalog

    Dim prc As ADOX.Procedure

    Dim cmd As ADODB.Command

    Dim prm As ADODB.Parameter

    On...

Try:

UPDATE ventven

   SET priori = toer

FROM ventven

   INNER JOIN TOEROK ON ventven.ship = TOEROK.nomat

WHERE ventven.codaff IN ('tale','talk','tbre','tdle','tdlk','tdpe','tele','tepe')

I made assumptions for the table.field pairing, so you may need to edit,...

Not sure how "correct" this is, but works a treat for me. SQL Mail has no "Service" so needs to be restarted within SQL Server.

Be aware that if the mail...

CREATE TABLE #Family (ID int identity, Father char(2),Son int)

INSERT INTO #Family (Father,Son)

SELECT 'AA',11 UNION ALL

SELECT 'AA',43 UNION ALL

SELECT 'AA',11 UNION ALL

SELECT 'AA',11 UNION ALL

SELECT 'BB',22 UNION ALL

SELECT 'BB',11 UNION ALL

SELECT...

If you are using ALTER PROCEDURE, change to DROP PROCEDURE | CREATE PROCEDURE, and see if this cures the problem.

Andy

Old school trick: after Daylight savings change, shutdown server, count to 30, and power on.

I have found 3 of 16 2003 servers that where cured this week by using this...

you can change your transform to convert the mal-formed date:

CDate(Left("2005101811:25:28.35",8) & " " & Right("2005101811:25:28.35",11))

Andy

Be careful with WHERE clauses that combine OR and AND, I suggest always adding () around the ORed clause, like:

WHERE (it1 <> 'Y' OR it1 is null)

   AND issuetype IN...

[snip]

Posting created 2 replies, did not post twice this time...

Andy

See:

http://www.sqlservercentral.com/columnists/bknight/renameserver.asp

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=209175

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=16709

Andy

[snip]

Posting errored, so tried again and see two copies!

Andy

The SELECT INTO is one problem, this is much slower than CREATE TABLE and INSERT INTO SELECT.

Try:

-- CREATE TABLE Summary_Flag with no rows

SELECT pole_bottom.Stock_sk

        , pole_bottom.Trading_Date as 'pole_bottom_Date'

        , pole_bottom.Low_Price...