SQL Server Performance Forum – Threads Archive

70-431 details

hi,
i am planning to do 70-431 ( MCTS–SQL 2005 certification ),
plz suggest me how to prepare for the exam, related links and also
can any one send the dump. thanks in advance!!

---

http://www.microsoft.com/Learning/exams/70-431.asp —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

Hi Bhushan, I visitied your website and found a useful code that you have written, about creating a new empty table structure based on the exsisting one, by having the value for 1=0. My question is , can I do the same using between two database under one server. So the query would go something like this:- Use Sumprit — database name
Go
SELECT * FROM Adventureworks.HumanResources.Employee
SELECT * INTO Employee FROM HumanResources.Employee WHERE 1 = 0
SELECT * FROM Employee
thanks.

---

Sumprit
If this is a seperate question to Bhushan’s then please use a new thread and in your case it should work. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

]]>