Viewing 15 posts - 346 through 360 (of 2,387 total)
July 21, 2004 at 12:13 pm
Have both netwokd cards been assigned separate ip address. If they are, Try to create server alias with client network utility to connect SQL Server with specific ip address to see any improvement.
July 21, 2004 at 11:37 am
You can create local and global temporary tables. Local temporary (#) tables are visible only in the current session; global temporary tables (##) are visible to all sessions.
If a local temporary...
July 20, 2004 at 7:21 pm
Try to drop the user from database B and re-grant him/her to access database B with proper permissions.
July 20, 2004 at 7:11 pm
delete from a
from TEST3 a join
(select cust_id, max(tran_date) as max_tran_date from TEST3
group by cust_id
having count(*) > 1) b
on a.cust_id = b.cust_id...
July 20, 2004 at 6:27 pm
They charge it by number of processors the SQL Server runs. Call them to get the price, It is fairly reasonable.
July 20, 2004 at 6:07 pm
Interesting. How do you know there is a such database there? Can you confirm that by running sp_helpdb and paste the result here?
July 19, 2004 at 6:58 pm
Which data type do you define for "causeno" on both SQL Server 7.0 and SQL Server 2000?
Also, Paste the results of "DBCC USEROPTIONS" from both servers here.
July 19, 2004 at 2:37 pm
Qouted from BOL.
DBCC PINTABLE does not cause the table to be read into memory. As the pages from the table are read into the buffer cache by normal Transact-SQL statements,...
July 19, 2004 at 2:27 pm
I perfer to copy entire database over by using sp_detach_db/sp_attach_db or backup/restore commands.
July 19, 2004 at 1:02 pm
Do you have any SQLDump created in Log folder? You may contact Microsoft SQL Server support to setup SQL Server dump and memory dump from Windows system.
July 19, 2004 at 1:00 pm
As long as your application does not use the features of SQL Server Enterprise, you should be fine.
See BOL Features Supported by the Editions of SQL Server 2000.
July 19, 2004 at 12:41 pm
Try example.
insert into jobs1 (job_id, job_desc, min_lvl, max_lvl)
select b.job_id, b.job_desc, b.min_lvl, b.max_lvl
from pubs..jobs b
where b.job_id not in (select a.job_id from jobs1 a)
July 19, 2004 at 12:36 pm
You have to restore database and get it from restored daatbase.
July 19, 2004 at 12:16 pm
Viewing 15 posts - 346 through 360 (of 2,387 total)