Another difference I noticed is under the Users context in database

in EM the dbo will be assigned to the login name which was executed

using sp_changedbowner, otherwise both the name and...

Let the login access any objects in the master database, but I do

not want the master database to be visible or opened in the query

analyzer to that login.

When I use sp_spaceused I get the reserved,data,index_size,unused

size. Does this include the size of the database objects(procedures,tables,views etc) or only the data and index size stored in it?

Then which is the accurate way to find the size of a database?

Suppose I execute the DBCC SHRINKFILE (@Filename) will I be

able to remove the free space and get...

I want to make clear about what my application developer wants.

create table test1 (A1 int identity(1,1),A2 datetime)

insert into test1(A2) select 19-12-2007

create table test2 (A1 int identity(1,1),A2 datetime)

insert into test2(A2) select...

First tell me how do I change the default format from YYYY-MM-DD to DD-MM-YYYY to a particular table. I know about the usual modification for Insert\Update using convert function.

Thanks for your reply I got to know what was the problem.

They have not installed the SQL Server 2005 engine in server2 instead they have only installed GUI. So when...

I have already defined the full-text catalog and indexes. I can view

them using

sp_help_fulltext_catalogs

sp_help_fulltext_columns

sp_help_fulltext_tables

however if query using a select statement against that fulltext tables it throws that error....