Viewing 15 posts - 1,411 through 1,425 (of 1,535 total)
A ping and traceroute might give results that show you can access the server, however you have to bear in mind that it's possible that those ports are open throught...
March 30, 2004 at 4:58 am
Due to the fact that you could be using potentially all 8 cpus on either machine in an active/active cluster you would need to licence for 16. If you were...
March 29, 2004 at 12:37 pm
Ask your network guys if there is a firewall between the machines and if there is what ports are open, they should also check to see if there are any denys...
March 29, 2004 at 9:10 am
Possibly you created the dts using Windows Authentication for the db connection, and from your machine you cannot authenticate against the SQL server using Windows Auth.
March 23, 2004 at 1:55 pm
Interestingly I am having the self same problem on SQL 2k SP3a on Windows 2000 Advance Server, MDAC 2.71, Oracle 8i.
All the entries are set as Microsoft suggest. I wouldn't...
March 23, 2004 at 10:12 am
If you want to update the lastname value to equal the value of a column that has the lastname value of king
update Employees SET lastname = newlastname where lastname =...
March 21, 2004 at 5:17 am
My belief is that Citrix will take 100Mb of RAM for each user connected. If you have only a couple of Citrix users that won't be an issue in the...
March 19, 2004 at 12:04 pm
How 'bout this.....
declare @IDENT INT, @sql varchar(1000), @DBNAME VARCHAR(200)
select @IDENT=min(DBID) from SYSDATABASES WHERE [DBID] > 0 AND NAME NOT IN ('PUBS', 'NORTHWIND', 'TEMPDB')
while @IDENT is not null
begin
SELECT @DBNAME...
March 19, 2004 at 10:30 am
Yes the database will still be available for use. Don't forget to make sure to back up the system db's...
March 18, 2004 at 11:24 am
You should add a filter to the machine to exclude all *.mdf, *.ldf, *.ndf files. Make sure that you backup to disk the master, model, msdb and user databases that...
March 18, 2004 at 11:07 am
Your database was in full recovery mode?
March 12, 2004 at 1:04 pm
Viewing 15 posts - 1,411 through 1,425 (of 1,535 total)