Viewing 15 posts - 35,806 through 35,820 (of 39,771 total)
Save them as a "Structured Storage file", which will be a .dts file on your local drive. Zip them, email them, whatever. On the remote machine, right click the "Data...
October 14, 2003 at 10:51 am
Not sure I have a good answer, but here are a few thoughts.
There is no current way to load a single table. It was a great feature in 6.5, mainly...
October 14, 2003 at 10:42 am
Not sure you can attach a filegroup. You can do a restore, so perhaps that is an option.
I believe snapshot replication can use ftp, but I'm not sure. Might do...
October 7, 2003 at 10:02 pm
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
Viewing 15 posts - 35,806 through 35,820 (of 39,771 total)