Which edition of SQL Server 2005 June CTP are you trying to install?

I don't think any of the server versions (Enterprise, Standard, and possibly Workgroup) will work on a Windows...

from SQL 2000 BOL - CREATE TABLE:

Temporary Tables

You can create local and global temporary tables. Local temporary tables are visible only in the current session; global temporary tables...

sysadmin is a system wide role, so it can't be applied at the database level.

While I agree with everyone else in suggesting using DTS, have you not tried just GRANT...

Only the features that are supported by Standard Edition will be functioning though.

For example, if you created an Indexed View in the database while it was on Enterprise Edt, the...

SQL Server 2005 splits managment tasks from development tasks. You need to use the Business Intelligence Development Studio to create DTS (now called Integration Services) packages.

I'm running SQLiMail with Beta 2 without any troubles.

Mind you, April CTP is out now, so there's probably a number of improvements again in there.

Unless collation has been specifically set for the columns, they would be defaulting to the database collation. You might find that after you change the database collation, that all you...

1. a one-to-many relation Task <-> Task will work

2. umm ... I think i learnt all i know about database design from the thousands of online articles and SQL Server...

Stefan, sounds like your on the right path, so you're definately not a retard

Create a Person table, and a Company table. That way...

I'd start finding your backups. IO Errors in SQL Server are never  nice thing and difficult to repair. Restoring from a backup is your best bet at getting a complete...

looks like someone is trying to download a file to your server.

use master
exec sp_dropextendedproc 'xp_cmdshell'

should drop the command shell access from SQL server. I'd very carefully check to see where...

Ah. In that case I'd put a unique constraint against the column, and handle the errors in the web app. If you get two requests at once, only one will...

You could catch the exception in the applications ADO Connection object, however that won't scale well. (You're talking about two requests executing at once... i've worked with hundreds executing at...

Hey Ramesh

Is PK_CatId meant to be a incrementing number? If so, use an IDENTITY column instead to create unique numbers.

Other that that, what happens before step #1 ? Where does...

run sp_helpfile and make sure that your maxsize either hasn't been reached or isn't set

you may need to run sp_updatestats first to make sure your database sizes are correct.