Here is an initial article: http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-1/[/url]

http://www.codeproject.com/KB/books/MSReportingServices.aspx

-------------------

StarWind Software developer ( http://www.starwindsoftware.com )

Hmm...yes the SELECT TOP WITH TIES returns sometimes more than N values.

It returns all of the lines which have the same value of the ordering column as the one...

Here is a description about the experiments with Linux+VmWare+MSSQL 2005: http://scottf.wordpress.com/2007/02/09/sql-server-on-vmware-server/[/url]

Here is an official document: http://communities.vmware.com/docs/DOC-8964, http://blogs.vmware.com/vmtn/2009/04/virtualizing-sql-server-communities-roundtable-podcast-42.html

And this from Serverfault.com: http://serverfault.com/questions/741/sql-server-in-vmware

---------------

StarWind Software developer ( http://www.starwindsoftware.com )

Are you sure that was an express edition? As far as I know Mail is not provided with MSSQL 2005 Express.

But here is the dirty hack in order to get...

MSSQL Express 2005 has no SSIS but it has SQL Server 2005 Backwards Compatability Components that includes DTS2000 Runtime.

Look here to see how to use this tool to import MDB.

-------------------

StarWind...

CREATE TABLE [dbo].[SCCall] (

[Call_Num] [int] NOT NULL,

[Call_RDate] [datetime] NOT NULL

....

======================================

SELECT CASE WHEN

DATEDIFF(HOUR, GetDate(), [Call_RDate] )=1 THEN

'

ELSE

CASE WHEN

DATEDIFF(HOUR, GetDate(), [Call_RDate] )=2 THEN

''

END

END,

[dbo].[SCCall].*

FROM [dbo].[SCCall];

Or I did not understand the...

Have a look at this thread here are the recommendations about this message: http://www.eggheadcafe.com/conversation.aspx?messageid=31692932&threadid=31692932

Hope this will be useful.

-------------------

StarWind Software developer ( http://www.starwindsoftware.com[/url%5D )

There is an option to remove Express and then install only MSXML again, e.g. from here: http://www.microsoft.com/downloads/details.aspx?familyid=3144b72b-b4f2-46da-b4b6-c5d7485f2b42&displaylang=en

----------

StarWind Software developer ( http://www.starwindsoftware.com )

Elliott W noticed the right thing: check whether there is a default instance or check the instance name.

--------------------

StarWind Software developer ( http://www.starwindsoftware.com )

Double click (as far as I remember) the protocol settings and check the interfaces SQL Server listens. Also check the port numbers.

Run "netstat -a -p tcp" to check the listening...

As the first suggestion: try using sp_lock and sp_who stored procedures to find out the information about the locks.

http://doc.ddart.net/mssql/sql70/sp_la-lz_2.htm

http://msdn.microsoft.com/en-us/library/aa260384(SQL.80).aspx

-------------

StarWind Software developer ( http://www.starwindsoftware.com )

Try looking at this one: http://www.microsoft.com/india/msdn/articles/116.aspx

I think that looks close to your need.

------------

StarWind Software developer ( http://www.starwindsoftware.com )

Have you tried this one:

EXEC [dbo].[sp_BackupAllFull] 'test', 'c:\', NULL, '0'

OR

EXEC [dbo].[sp_BackupAllFull] 'test', 'c:\'

because all of the last argumants have default values

Hope that helps

-----------------

StarWind Software developer ( http://www.starwindsoftware.com )