Viewing 15 posts - 37,201 through 37,215 (of 39,720 total)
You can look at the MS Baseline Security Tool (http://www.sqlservercentral.com/columnists/sjones/reviewmicrosoftbaselinesecurityanalyzer.asp), but it has bugs.
There isn't a good patch manager for SQL. Hopefully one will get built soon.
Steve Jones
August 9, 2002 at 3:24 pm
Agree with andy. It can cause disk space issues as the more your capture, the more is stored.
Steve Jones
August 9, 2002 at 3:23 pm
I'd suspect you have an application problem. SQL Server should take up most everything except 128MB or so which is left for the OS. I had about 1GB of databases...
August 9, 2002 at 9:59 am
When testing Brian's suggestion, log into the server with the same account that SQL Server runs under.
Steve Jones
August 9, 2002 at 9:54 am
All services, including SQL Server, run under some account. By default, this is the local system account on the server, which CANNOT access domain resources, or any resource not located...
August 9, 2002 at 9:35 am
Do them as often as you can. Depends on time it takes to do them and your requirements.
There are scripts in the library here to do full backup. You could...
August 8, 2002 at 4:08 pm
Check the event logs on each server. And set a different account for each SQL Server, it prevents this.
Steve Jones
August 8, 2002 at 4:06 pm
add up the results.
Why do you need this? It's not necessarily a useful number.
Steve Jones
August 8, 2002 at 4:05 pm
If you can mark record to timestamp them,
Use SQL instead, something like this pseudo
select top xx rows from your table that INNER JOIN with the other database and perform updates...
August 8, 2002 at 3:57 pm
You are welcome. Let us know if something doesn't work right.
Steve Jones
August 8, 2002 at 9:29 am
They are stored as binary and retrieved with a select statement, like any other field.
The trick is on the front end. It has to be able to read the values...
August 8, 2002 at 9:18 am
negative. No attach. You must restore, which can be tricky. Your segment and device layout must be the same. Be sure you script the database creation exactly on the old...
August 8, 2002 at 9:16 am
For saving and recovering packages:
http://www.sqlservercentral.com/columnists/sjones/recoverthosepackages.asp
links to the save article inside.
Steve Jones
August 8, 2002 at 9:07 am
Entirely possible. The Windows protection should prevent older files from being written. I'd suspect that SQL might write older files than SP2. Install SQL 7, add the service packs and...
August 8, 2002 at 8:39 am
Viewing 15 posts - 37,201 through 37,215 (of 39,720 total)