FYI

Actualy with SQL2005 this would not make sence at all !

Reason ?

The ssis service only fulfills the role of "gateway" to if you want to manage the packages via...

you need to set you destination connection parameter

"retainsameconnection" to true (false by default) to be able to use

#tmp tables !

first it will try to find the (unqualified) object using username.object, if it cannot

find that, it will try with dbo.object.

If the connected user is the actual database owner, his db-username...

IMO the big difference is that the user assigned by sp_changedbowner can

create objects like "create table xyz (col1 int)" and the object will be created as dbo.xyz.

Members of the...

like it says: "check sqlserver errorlog" !!

dbid 2 = msdb

Perform DBCC checkdatabase for msdb !

You can even post the results within this thread. :hehe:

just to add ...

if you are planning to use reporting server, keep in mind it only supports accounts with a maximum character length of 20 characters!!

You'll need another filegroup.

Keep in mind that the clustering index actualy contains all table data, you may not want to move that to your indexes filegroup.

Also keep in mind, you...

you could install a second instance of sql2005 and use Windows system resource manager (WSRM)

to govern CPU usage %.

WSRM is also available for x64 !

Mark (2/5/2008)

---

Here's 'GrpBal' using XML

WITH CTE AS (

SELECT a.AccountID,

(SELECT b.Date AS "@Date",

...

I'd suggest you use a nested table expression, meaning

select nestedTSel.*

, [Monthly Pac] ....

from ( select 'Monthly Pac' = CASE

WHEN tPolicyBillPrem.POL_BILL_TYP_CD = '4' AND tPolicyA.POL_CSTAT_CD = '1' THEN tPolicyBillPrem.POL_SNDRY_AMT

ELSE 0

END,

'Annualized Premium'...

Script your SSMS changes to the table and you'll see it does something

completely different than you think.

Using SSMS it will not perform alter table alter column ...

but it will...

With sqlserver it doesn't work as with msaccess !

declare @myvar int

set @myvar = 15

select ... from myobject where thecolumn=@myvar

With odbc this would mean you define a commandobject,

type=storedprocedure

commandtext='select ... from myobject...

Can you test what happens if you alter the colums to nvarchar(max)?

This datatype is prefered in sql2005.

TheSQLGuru (2/1/2008)

---

I posted about this topic on the SQL Server MVP private forum. I will follow-up if anyone there comes up with anything. I specifically asked Iztik Ben-Gan...