Viewing 15 posts - 16 through 30 (of 33 total)
What version SQL Server? NT or Windows 2000?
And how have you tried to get SQL Agent to run the batch command?
December 18, 2001 at 4:30 am
My technical controller is pushing for us to use the SQL backup part of Veritas for our SQL Server backups, despite my demonstrating that I could do all kinds of...
December 18, 2001 at 3:14 am
Hope you have a good christmas too!
I have found this site to be excellent for getting help when you don't know what you are doing and can't find help...
December 13, 2001 at 2:59 am
To move model do the following
right click the SQL Server in EM and click properties
click on startup parameters
add new parameter -T3608
Stop SQL Server via control panel, Services
Restart SQL Server via...
December 13, 2001 at 2:19 am
Not too sure if it is the same in SQL2000, but in SQL 7 the following moves master:
Take a backup first!
right click the SQL server in Enterprise manager and click...
December 12, 2001 at 7:01 am
I totally agree, I made sure all the sa accounts on the servers I was responsible for had passwords, everyone here thought I was being a control freak, but the...
December 6, 2001 at 2:12 am
Thanks guys, I have passed the info onto our technical controller. All SQL Servers under my control do have a password for SA, but we have one that was set...
December 5, 2001 at 6:51 am
I have managed it! I did the restore and everything just fine.
The only odd thing I have is that when you look at the database information on the user...
November 23, 2001 at 5:56 am
I have come to a radical decision! The server that I am restoring from will eventually be re-used as a development machine and the replication that is set up on...
November 21, 2001 at 7:26 am
SQL Server Agent, along with MSSQLServer and MSDTC all run under a domain account QHDOMAIN\SYSSQL. I am logged in as QHDOMAIN\PGlover. Until I did the restore from the other server...
November 21, 2001 at 2:13 am
Cheers, I did it, then discovered I had to restore the database from another server which already had the dbowner as sa, so I needn't have bothered - but hey,...
November 20, 2001 at 7:10 am
Steve, Thanks for the advice, it worked fine once we had disbled the Anti virus software!
(It took a bit of persuading to get our techie to let...
November 15, 2001 at 4:55 am
Cheers, Will try that today.
November 15, 2001 at 2:04 am
We are trying to install SQL Server 7.0. The only difference between this and all other installs we have done is that this particular server has NT4.0 with service pack...
November 14, 2001 at 10:06 am
No, or maybe yes. At present, with the databases and the data files on the remote servers we can create the attachments with no problem. When we try to create...
October 12, 2001 at 1:49 am
Viewing 15 posts - 16 through 30 (of 33 total)