-
Script all jobs out in Sql Server 2005
In Sql Server 2000, there is an option to script out all jobs in an instance. That option disappeared in Sql Server 2005. You can still do it. In Object Explorer, click on Jobs folder. Then go to the Object Explorer Details window. All jobs in this instance will be listed there. Select all, and…
-
Watching Yao Ming play
We saw Yao Ming’s Houston Rockets play at Chicago United Center before Christmas. Houston won. The seats we got were pretty high up, and they were not cheap. Those athletes earn way too much money. I haven’t watched sports for a while. Judging from this game and one I watched last week on TV while…
-
Sql Server 2005 DMO backward compatibility component
When you use DMO to connect to a Sql Server 2005 instance, you will likely get the following error: Microsoft SQL-DMO (ODBC SQLState: 42000) error ‘800ad903’ [Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO). This is because in Sql Server 2005,…
-
许巍、伍佰很不错
我大学时算是歌迷，偏爱摇滚。 95年来美时，伍佰的音乐好像处于起步上升阶段。听说而已，还没来得及欣赏，就来到了大洋彼岸。 去年到过几次纽约，其实在曼哈顿的中国城时就很想买他的唱片。但想起我们的陋室已经几乎无立锥之地，我买的刘宝瑞、侯宝林、马三立（个人目前最喜欢刘宝瑞）等人的相声、动画片《大耳朵图图》、《西游记》等光碟也占了不少地方，就没买。 去年回国，终于买了伍佰的精选，一共三十首左右。果然名不虚传，他的歌真棒！我在车里放，儿子也跟着哼。他好像喜欢《白鸽》和《黄色月亮》。我基本上每首都喜欢，包括闽南歌《往事欲如何》，《世界第一等》等。 去年八月在上海时，在出租车里听了周杰伦的歌。在YouTube上看了看他的MTV，有的不错，有的觉得很搞笑。 最近从我的博客订阅里两次读到一个叫许巍的歌手。上周在华盛顿听到朋友谈到一首叫《蓝莲花》的歌，想起儿子和自己刚刚读完英文的《丁丁历险记》之《蓝莲花》，就在网上听了听。哇塞，太牛了！许巍很棒！ 有时间会多搞一些国语音乐听听。不知读者能不能推荐一些好的音乐与歌手。 写完这一些，好像有点老土的感觉～～～
-
Find out which Sql Server Agent job it is running
In Activity Monitor (Sql Server 2005) or Current Activities (Sql Server 2000), if you suspect a job has been running unusually long, all you see is something like this: SQLAgent – TSQL JobStep (Job 0x1D8274F1H00B7D44912BD78DCADB1AD0 : Step 1) Use this statement to find out the job name: select name from msdb.dbo.sysjobs where job_id = cast(0x1D8274F1H00B7D44912BD78DCADB1AD0…