about xp_sendmail
I got a very interesting issue, I may guess the reason but not sure why it is this way.
Symptom: Logon to...
2005-09-09
1,402 reads
Careful Blogging
I still not sure that this blog service was a great idea, but some of
you seem to like it, so...
2005-09-08
1,389 reads
one issue about SQL 2000 BOL
This is my first post, congrats to myself. 🙂
DTS Connection object does not list "UseTrustedConnection" property
I am working on a...
2005-09-08
1,372 reads
In praise of three day weekends!
I guess it might be because I have been so busy for the last two months with the book, but this...
2005-09-05
1,272 reads
Head back up above water
I've spent the last few weeks writing SOX documentation, more SOX
documentation, and even more SOX documentation. A lot the documentation
doesn't...
2005-09-02
1,416 reads
Of anarchy and thin veneers...
Following the horrifying stories that are unfolding in the aftermath of
Katrina, it is difficult for the mind to single out...
2005-09-02
1,349 reads
The Data Center in New Orleans
There's a blog running at LiveJournal from one of the guys at directnic. There's evidently an ISP that is still...
2005-09-02
1,481 reads
Blessed to live in the boring MidWest
The images on the TV news this morning were surreal. Hundereds of people dead, missing, homeless because of Katrina and...
2005-08-31
1,291 reads
Plagiarism
Seen this from Kevin Kline?
We went back and forth along with a few others this morning looking at
the many places,...
2005-08-30
1,634 reads
Online Protection
Grr, it's annoying, but it's a good thing.
After the ASP.NET errors, I ordered memory a few days ago from
Crucial.com. They...
2005-08-29
1,365 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCU TEGAL Telp:0821°7555°651
Telp/Wa 628217555651 Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim., Kota Tegal, Jawa...
Kantor Resmi BCA KCU SALATIGA Telp:0817°825°533
Telp/Wa 62817825533 Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo, Kota Salatiga, Jawa Tengah 50711
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers