Thanks Jeff for adding this little - but oh so crucial remark :w00t:

Excuse me for the very late response :blush:

Kind of lost track of this thread.

This drive mapping should loke something like this

NET USE * \\TheOtherServer\TheSharename Password /USER:Thedomainname\TheOtherusername /PERSISTENT:NO

xcopy c:\myfile.txt \\TheOtherServer\TheSharename

NET...

Did you grant read permissions to the designated users ?

figure out in what application query sequence the error occurs !

Then provide some connection details and the exact cmd with its

properties.

Start sqlprofiler to capture the load. If your programmes...

you have messed up your if - sequence.

if not update(...)

begin

...

end

-- no other statements can exist between the end and the else

else -- elseif does not...

here it is

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=928598&SiteID=1

Select ...

from tableA A

where not exists (select 1 from tableB B where B.FK = A.pk)

you could generate a script for view creation based on sp_pkeys or sp_fkeys

But you'll have to study the new datamodel to understand it symanticaly :doze:

for your queries to make sence.

search the package property "FailParentOnFailure". Set it to true.

and play around with the "forcedexecutionresult",....

Jeff Moden (2/7/2008)

---

Radovan Jablonovsky (2/7/2008)

---

Replay for Jeff,

Server was setup to use 2 CPU for parallelism and query execution plan showed parallel execution was used in sorting index. See attached pictures.

Sincerely,

Radovan...

I haven't experienced on excel with SSAS myself, but hope soon to

do so.

I'm still figuring out what kind of buggs or issues there are with office 2003 in...

you'd need the OLAP addons for excel.

(downloadable at MS)

But I've also heard that you would need office 2007 :doze: if you want to avoid anoying bugs.

How about a kind of split function that returns a table. (tvf)

and performing a left outer join to the same tfv with the new contend.

declare @mycolumn varchar(max)

select @mycolumn =...

search the SSC forums "developer sysadmin" and you'll find many hits .

Actualy best practise still is using Dr. Codd's rules fo Normalization of the Data Base Relational Model. http://www.sqlservercentral.com/articles/Advanced/coddsrules/1208/

An identity is just an incrementing number (altough you can increment with a...