RE: Guest account within MASTER
Here is the full link http://www.appsecinc.com/techdocs/presentations.html Cheers, Frank
2003-06-05
2 reads
career
RE: Guest account within MASTER
Another BTW, , maybe you want to check out Haunting flaws in Microsoft SQL Server on http://www.appsecinc.com . I think it's a powerpoint file. Cheers, Frank
2003-06-05
RE: Guest account within MASTER
BTW, I think you must have a guest user in master and temdb. You should not change its permissions in those databases. Cheers, Frank
2003-06-05
1 reads
RE: Simple Database Recovery Model
If the log file still grows after the Truncate log on check point ON, you might want to schedule a hourly job with the following commands use <Database_Name> go dbcc shrinkfile (Log_Filename, 300) go backup log Database_Name with no_log go As Randy suggested make sure you have full backup
2003-06-05
RE: Simple Database Recovery Model
Yes, jaybmehta's post is correct. In SQL7 EM, click the database's properties and on the options tab, check the truncate log on checkpoint box. I advise that you make sure you do full and possibly differential backups regularly though.
2003-06-05
1 reads
RE: Logins
Develope an application to change sql user password and deploy it using group policy. Using group policy you can deploy an application in the client system when it starts. After deploying the application let them change the password using that application.
2003-06-05
1 reads
RE: Partition table
I had a transactional database that held transactions for 6 european countries. I split the transaction table into 12 separate tables. For each country I had An "Active" table (because I figured out that 90% of queries were concerned with data in the past 2 quarters). An "Archive" table for data older than that My […]
2003-06-05
RE: Job restart on condition
Yes u r right u can do so buy updateing the next_run_date and next_run_time fikled, but be cautious as these filds in the tables are int, now dont ask y SQL has made the next_run_date and next_run_time as int :)) It sounds funny when i also saw for the first time.
2003-06-04
RE: Simple Database Recovery Model
Hi, Is there a specific way to set SQL server to use simple mode in SQL7 ?. I cant seem to find doco on this and have looked almost everywhere. Its easy to do on 2000 but i cant find it in SQL7. I would like to not have such a huge tlog for my […]
2003-06-04
1 reads
RE: Simple Database Recovery Model
With simple recovery you can recover to the point of the last backup. You cannot restore the database to the point in time. Since most of your database set to Simple you don’t have to worry abt the Transaction log backups. But for the Full Recovery or Bulk-Logged Recovery model you must take frequent log […]
2003-06-04
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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