From a license point I don't think that this is allowed.

Also you posted this question in a SQL 2005 forum and you cannot restore backups from a 2005 database...

1) With SQL 2000 you can have a maximum of 16 instances on one server. SQL 2005 supports up to 50 instances.

2) Seems like either an IO issue or database...

What's your OS?

If you use Windows2008 or Vista the UAC can cause this error while attaching a database.

You can query msdb.dbo.backupset for this.

It contains a column backup_size which will give you the size in bytes.

Sounds like the server has been installed with a case-sensitive collation.

Run SELECT SERVERPROPERTY('Collation') to check.

Could this be a problem with your client settings? SSMS and Query Analyzer have a setting called "Maximum number of characters displayed". You find it under Tools>Options>Query Results.

The default value...

DKG (5/6/2009)

---

No i didn't mean that way 🙂

The question just came in my mind was, if a user can do other limited operations (can see the DBs by Ent Manager)...

Here's another very usefull document:

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displaylang=en

If I remember correct, SQL 2000 only supports adding and deleting of columns on a replicated table, but not changing an existing table. See also http://msdn.microsoft.com/en-us/library/aa237127(SQL.80).aspx

So if you want to...

It sounds like your monitoring app is issuing a sp_helpdb command against a databases which has an owner which does no longer exists.

This can happen when a windows login...

Yes, don't give them a login. :-):-):-)

No seriously, why would you create...

Vinoo (5/6/2009)

---

Works:

------

ALTER DATABASE CCBS ADD FILEGROUP [1111]

Does Not Work:

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

declare @filegroupname varchar(10)

set @filegroupname = '11111'

ALTER DATABASE CCBS ADD FILEGROUP @filegroupname

Question:

As you can see, in the first scenario, I am having the...

Ok, I stayed away from this thread so far and it looks like it's about a lot of other things not related to the quality of the questions but I...

Oh sorry, I thought you needed it the other way round.

Oracle knows the terms temporary tables, but they don't use the # prefix and are more like derived...

SQL Server has a stored procedure called sp_processmail, which you can use. Behind the screens it will call xp_readmail, xp_sendmail etc. For security reasons I usually create a copy of...