Change DB Owner to sa for multiple DB's
Changes DB owner to sa for Online DB's where owner is not sa
2013-04-26 (first published: 2013-04-12)
2,106 reads
database owner
Display Names and Locations of SQL Database Files and DB Owners
Displays the names of all of the SQL databases on a SQL Server instance, their data and transaction log files, their owner, and their physical locations.
2012-08-20 (first published: 2012-07-27)
1,557 reads
Database Create Date after restore.
I restored from a *.bak to two different servers. The restore was succesful yet the database create date is different. Should this date change? Does the create date update at the time of "define new DB" Does this date ever change without delete and define?Unable to confirm it myself but will keep trying and report back.
2004-02-02
610 reads
RE: Remote connecting from behind a NAT router
Your NAT router hopefully has the capability to map ports directly to systems and ports behind it. If that's the case, you'd open a port on the NAT router and point it to your remote SQL Server. You'd then point the main SQL Server to the NAT router IP and the port you opened on […]
2003-12-21
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers