Ohh.. it was just near to eyes.... Thanks its done 🙂

Logn Failed for user 'sa' Error No 18456

I have tried it using -E (Windows authentication).... it was giving login errors for my local user.... the user already has sysadmin rights...hence I used the another way...and I am...

create table test

([name] sysname,db_size nvarchar(13),

[owner] sysname null,[dbid] smallint,

created nvarchar(11),[status] nvarchar(600),

compatibility tinyint)

insert into test exec sp_helpdb

select name ,db_size,owner from test where name not in ('master','model','msdb','tempdb')

exact answer...

My question was very simple.....

I am creating a stored procedure to create a database...and in that same stored procedure I want to create a table & insert values in that...

My apology I have used Newdb_info.dbo.Teachers

it was a typo error.... but still its giving same error...

I have used following procedure....

create procedure Newdb_info

as

begin

create table dbo.Newdb_info.Teachers

( Emp_id int not null primary key, lastname varchar(20) not null ,firstname varchar(20)not null,

Assign_div nvarchar(20), sp_subject varchar(20), Age int)

insert into Teachers...

Thank You Chris, Cath.....

I am really confused about my terminology about collation.

Please any one can explain in very simple terms "What is collation"?

This is somewhat I was thinking...but I am sure now... Thank you

Cath Trimble (8/5/2011)

---

The change in database collation will only affect objects created after the change. As per BOL:

You can change the collation of any new objects that are created...

Cath Trimble (8/5/2011)

---

The change in database collation will only affect objects created after the change. As per BOL:

You can change the collation of any new objects that are created...

I got task to Collate database. within same server.

I used this Query

Alter database DBname collate "collation_name"..

after executing it was showing Executed Successfully.

But there was no result ...

Alter Database mirrordb Collate Arabic_100_CS_AI_WS

After running this query still its sowing in default collation...

I just want to change it for a single database...

Grant Fritchey (2/22/2011)

---

Fox87 (2/22/2011)

---

Hi There,

The SQL Upgrade Advisor doesn't work if I run it on my SQL 2008 instance.

It give the following error:

SQL Server version: 10.00.4000 is not supported...