RE: Moving all log files to a new disk
So you can do the same think to restore your database on the new disk with the move option.
2003-06-27
1 reads
security
RE: Moving all log files to a new disk
We have to move all databases to a new server last month with distribution. The best way i have found was to backup all databases and restored all db on new server in order : distribution and published db, then master and others. If you restore distribution Db after Master you have a error occured […]
2003-06-27
RE: Do you think education matters?
Frank, He's a character from the film Ghostbusters I think. Ritch *I didn't do anything it just got complicated*
2003-06-27
1 reads
SQL Server Security: Security Admins
As we mentioned before, Brian will be writing a column covering all facets of security. Turns out that there is so much to cover, he has agreed to write two columns per month! This article talks about the principle least privilege, why it doesn't always work, and some good info about removing the Builtin\Admin account.
2003-06-27
20,963 reads
RE: Mail Intergration in SQL Server
All you need is exchange server and valid MAPI Profile. Specify the profile name under the SQL Mail -> support services and start it. And at the backup job go to the notification and specify the email operator. Alternatively you can buy a Skytel pager and you can directly use it as a email notification […]
2003-06-26
RE: public fixed DB role - a pain?
A lot depends on your application. I have an application (third-party screwup) that runs using PUBLIC! It give PUBLIC access to just about everything. Can I change it? No way...the product will then be unsupported. -SQLBill
2003-06-26
1 reads
RE: SQL7.0/2000 Win98/XP .NET Application
Okay, because I love the programming community I'm going to let loose with a little bit of As it turns out, I didn't have the Win98 box as a member of the domain, therefore validation for SQL2000 was failing on that point. What I still think is odd is that SQL7.0 had no problem dishing […]
2003-06-26
1 reads
RE: record formating
Or select col1, col2, max(col3), max(col4), max(col5), max(col6) from tablename group by col1,col2 to group by first 2 cols. Edited by - davidburrows on 06/26/2003 06:44:56 AM
2003-06-26
1 reads
RE: Moving all log files to a new disk
If you have replication set up it won't let you detach, you have to drop replication first. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-26
2 reads
RE: record formating
A (primitive) solution could be joining 4 time the table with itself, like this: select tbl3.col1, tbl3.col2, tbl3.col3, tbl4.col4, tbl5.col5, tbl6.col6 from (select * from #tmp where col3 is not null) tbl3 inner join (select * from #tmp where col4 is not null) tbl4 on tbl3.col1 = tbl4.col1 and tbl3.col2 = tbl4.col2 inner join (select […]
2003-06-26
1 reads
Blogs
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Monday Monitor Tip: Compliance Checking for Old Versions
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
A reader of one of my previous posts pointed out that the legend order...
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