happycat59 (10/14/2014)

---

I get error

Msg 156, Level 15, State 1, Procedure my_sp, Line 2

Incorrect syntax near the keyword 'FROM'.

because "Column" is a reserved keyword and needs to be delimited if you...

Jeff varchar follow non Unicode characters while nvarchar...

Thank you dear, I will get back to you on monday.

Happy weekend.

I didn't find any error, Will you show me complete error-

This will help others too.

Hi Shiva,

Great job,

still i find one column empty.

you may use either ,[Uniqueidentifier10] UNIQUEIDENTIFIER Default NEWID() at create table statement or INSERT INTO tblWithAllDatatypes (bit1,Uniqueidentifier10)

select null,NEWID();

+1

Vimal Lohani (9/25/2014)

---

Hi,

Is it possible to get all information about modification of sql objects,

For eg. I have stored procedure i have altered it 5 times, can i get all date...

Shiva you are right.

Good observation...:-)

uff, what a question, so concentration required.

my (70-461) preparation, helped me to solve this.

Good one..

spectra (9/20/2014)

---

There...

Hi asrinu13,

May you have some constraint in ref table, Please check it.

Other wise no problem in transferring data from one table to another.

Create table #temp1 (id int, name nvarchar(20), salary...

Interesting and Important for (70-461) preparation.

+1

Use

RESTORE FILELISTONLY FROM DISK = '<FILELOCATION>' WITH FILE = 1

GO

OR

restore headeronly from disk = 'c:\restore.bak'

If you will get null null in all columns then either the backup is corrupted or...

+1