{"id":641,"date":"2006-05-13T21:48:23","date_gmt":"2006-05-13T21:48:23","guid":{"rendered":"\/blogs\/kimberly\/post\/TechNet-Webcast-Series-for-the-ITPro-Part-10-of-11-errata.aspx"},"modified":"2006-05-13T21:48:23","modified_gmt":"2006-05-13T21:48:23","slug":"technet-webcast-series-for-the-itpro-part-10-of-11-errata","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/technet-webcast-series-for-the-itpro-part-10-of-11-errata\/","title":{"rendered":"TechNet Webcast Series for the ITPro – Part 10 of 11 – errata"},"content":{"rendered":"

In the last few minutes of the webcast (part 10), I goofed up one line of code and didn’t realize it until today. As my very last demo (and there were at least 10 different scenarios\/concepts\/demos yesterday<\/EM>) in my webcast, I decided to show a Database Snapshot on a Mirror database. It was the second database snapshot that I had created so my first database snapshot demo was just fine. However, when I went to create the database snapshot on the mirror, I inadvertently left off the most important part “AS SNAPSHOT OF AdventureWorks”. The irony is that I tried to query some tables and just ended up (because we were right at the end of the webcast ;)) saying that I probably wasn’t getting the table names right. Ha – there were no tables… I hadn’t created a database snapshot, I had created just another database – so the only tables I was seeing were the catalog views.<\/P>
\n

Anyway, just for clarity, I corrected the “Demo Scripts” zip that’s associated with Part 10 BUT if you’ve already downloaded it then you’ll have the old (and incorrect) version of this script (SnapshotOnMirror.sql). And, for completeness, I’ll put the code that I executed during the webcast here: <\/P>
\n


\n

USE<\/FONT> AdventureWorks
<\/FONT>go<\/P><\/FONT>
\n

USE<\/FONT> master
<\/FONT>go<\/P><\/FONT>
\n

CREATE<\/FONT> <\/FONT>DATABASE<\/FONT> AdventureWorksSnap
<\/FONT><\/FONT>ON
<\/FONT>(<\/FONT> <\/FONT>NAME<\/FONT> <\/FONT>=<\/FONT> N<\/FONT>‘AdventureWorks_Data’<\/FONT>,<\/FONT>
<\/FONT><\/FONT>FILENAME<\/FONT> <\/FONT>=<\/FONT> N<\/FONT>‘C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data\\AdventureWorksSnap_Data.mdfss’<\/FONT>)
<\/FONT>— , SIZE = 167872KB , MAXSIZE = UNLIMITED, FILEGROWTH = 16384KB )
<\/FONT>go<\/P><\/BLOCKQUOTE><\/FONT>
\n

and the code that I should have executed here:<\/P>
\n


\n

USE<\/FONT> AdventureWorks
<\/FONT>go<\/P><\/FONT>
\n

USE<\/FONT> master
<\/FONT>go<\/P><\/FONT>
\n

CREATE<\/FONT> <\/FONT>DATABASE<\/FONT> AdventureWorksSnap
<\/FONT><\/FONT>ON
<\/FONT>(<\/FONT> <\/FONT>NAME<\/FONT> <\/FONT>=<\/FONT> N<\/FONT>‘AdventureWorks_Data’<\/FONT>,<\/FONT>
<\/FONT><\/FONT>FILENAME<\/FONT> <\/FONT>=<\/FONT> N<\/FONT>‘C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data\\AdventureWorksSnap_Data.mdfss’<\/FONT>)
<\/FONT>— , SIZE = 167872KB , MAXSIZE = UNLIMITED, FILEGROWTH = 16384KB )
AS<\/U><\/FONT> SNAPSHOT OF<\/FONT><\/U> AdventureWorks<\/U>  <\/FONT><<<< ———-<\/STRONG><\/FONT><\/FONT><\/FONT><\/FONT>
<\/FONT>go<\/FONT><\/P>
\n

USE<\/FONT> AdventureWorksSnap
go<\/FONT><\/FONT><\/P>
\n

SELECT *<\/FONT> FROM<\/FONT> person.contact
go<\/FONT><\/FONT><\/FONT><\/P><\/BLOCKQUOTE>
\n

So, quick demos right at the end of the webcast might not have been my best idea ;). But – I’m surprised none of you called me on it?! I’ll blame it on this<\/a> for now. <\/FONT><\/P>
\n

Have a great weekend,
kt<\/FONT><\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

In the last few minutes of the webcast (part 10), I goofed up one line of code and didn’t realize it until today. As my very last demo (and there were at least 10 different scenarios\/concepts\/demos yesterday) in my webcast, I decided to show a Database Snapshot on a Mirror database. It was the second […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,58,65,74,78],"tags":[],"class_list":["post-641","post","type-post","status-publish","format-standard","hentry","category-events","category-resources","category-sql-server-2005","category-technet-webcasts","category-tips"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/comments?post=641"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/641\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}