Viewing 15 posts - 35,941 through 35,955 (of 39,903 total)
Very nice and an interesting idea for auditing packages. One question: Any issues with a trigger in msdb for patches/service packs? Not sure I like the idea of changing the...
October 6, 2003 at 10:11 am
If the restores only need to be periodic and not up to the minute, then I'd use the "Simple" recovery model for each db. This will handle the logs for...
October 6, 2003 at 10:04 am
Do you mean a back TO another server? So your data is in two places?
You can use transactional replication. But the 2nd server is read only for the most part....
October 6, 2003 at 10:01 am
Not sure which one you mean, but check with Brian Kelley's articles. He's our security writer.
http://www.sqlservercentral.com/columnists/bkelley/
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 6, 2003 at 9:47 am
Or build a job that loads the results of jobs into some table and let them query that table.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 2, 2003 at 4:35 pm
BOL will have data on operators
SQLMail : http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 2, 2003 at 4:34 pm
We used to run pieces of the JD Edwards suite on SQL, others on DB2 (on AS/400).
SAP has a large presence in Redmond and test engineers there. I'll make a...
October 2, 2003 at 4:28 pm
Interesting. Have to give that a try. I missed that. I wonder if there are other filters that extract from .MP3, .JPG, etc.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
October 2, 2003 at 4:25 pm
I think it gets easier...
Just more frustrating!
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 2, 2003 at 4:23 pm
If I remember correctly, a table is only on one file. Perhaps there is a table(s) that is growing larger on the first filegroup and so this file grows disproportionately?
Are...
October 2, 2003 at 3:43 pm
If disk space is an issue, and you can afford a little time, you might also run a differential backup once or twice a day and delete all log files...
October 2, 2003 at 3:41 pm
I've used all three and have tended to favor white boards, usually with everyone present spending a few minutes at the end trying to copy on their notepad what they...
October 2, 2003 at 3:29 pm
Isn't camelcase uniqueNameForObject?
In any case, I completely agree. Spaces are a pain!!!! especially when scripting.
I'd expand this to include stupid folder names as well (#$%#^#$%$# Program Files folder)
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best...
October 1, 2003 at 4:39 pm
Yes it is running on his workstation.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 1, 2003 at 4:37 pm
Viewing 15 posts - 35,941 through 35,955 (of 39,903 total)