Viewing 15 posts - 301 through 315 (of 366 total)
Forget my last statement. I think you were alone the right lines about multiple log files.
I have tried to attach the db to a test sql2000 box and noticed the...
March 20, 2002 at 7:23 am
Just restored the database, and found the mdf has a max file size set (which it was close to)
That explains one thing (I couldn't quite understand why a 10gb log...
March 20, 2002 at 5:32 am
Forgot to say. There is a large turnover of data loaded into that database (as you can see from the size of the log file).
Not a lot else on that...
March 20, 2002 at 5:09 am
Only one file for each the mdf and ldf.
The mdf is only around 200mb and the log file was over 10gb.
They are restoring the last backup for the time being...
March 20, 2002 at 5:04 am
One other email package I have used is aspemail (www.aspemail.com).
This email package is free (if you don't want to use the premium features), and needs a smtp server which doesn't...
March 13, 2002 at 8:45 am
I add alerts against the following error codes (in sql server agent), then add myself as the operator for the alert.
18454 Login succeeded for user '%ls'. Connection: Non-Trusted. (with the...
February 28, 2002 at 9:18 am
If you plan not to use the SA account, remember to put a password on it.
I don't use the SA account so just to be sure I have placed an...
February 28, 2002 at 2:19 am
Using SQL 2000 Transactional Replication I had added a new table to the article without breaking replication.
I had to rerun the snapshot which then generated the article for the one...
February 28, 2002 at 1:28 am
Never really had a problem with them.
The only thing I find you have to be careful with is the scheduling. Otherwise you find you get the job failing with...
February 20, 2002 at 2:13 am
sp_addlinkedsrvlogin [ @rmtsrvname = ] 'rmtsrvname'
[ , [ @useself = ] 'useself' ]
[ , [ @locallogin = ] 'locallogin' ]...
February 19, 2002 at 9:09 am
Use sp_addlinkedserver to create the linked server, then sp_addlinkedsrvlogin to add the login details.
EXEC sp_addlinkedserver
@server = '???',
@srvproduct = 'Oracle',
...
February 19, 2002 at 8:42 am
Thanks,
After playing I have worked things out in my head etc.
February 5, 2002 at 1:18 am
One for me to test I think.
I presume that if the extended stored procedure is placed on one of the shared drives, that when the instance changes modes it should...
January 31, 2002 at 1:12 am
No I don't have a problem at the moment. I am about to install a test A/A cluster with different db's on each node.
Hence I started wondering about if a...
January 30, 2002 at 6:43 am
As long as the two servers can talk to each other ie not blocked by firewalls etc. you can replicate between the two.
As for security you can state a sql...
January 24, 2002 at 1:26 am
Viewing 15 posts - 301 through 315 (of 366 total)