Viewing 15 posts - 1 through 15 (of 20 total)
In my example both database are on the same Server.
Abrahim
April 7, 2008 at 2:01 pm
Here is the real code:
select cp2abc.*
from prd2.dbo.abc as prd2abc, prd1.dbo.abc as prd1abc
where not exists
(select prd1abc.subj_num from prd1.dbo.abc as prd1abc where prd2abc.subj_num = prd1abc.subj_num
and prd2abc.abc_DATE = prd1abc.abc_date)
Abrahim:Whistling:
April 2, 2008 at 9:08 am
I tried:
select prod.dbo.A.*, dev.dbo.B.*
from prod, dev
where prod.dbo.A.id = dev.dbo.B.id
and prod.dbo.A.id <= 100
but getting error:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'prod'.
Server: Msg 208, Level 16, State...
February 4, 2008 at 12:18 pm
I found this script that it finds the table's name.
SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name = 'SC_BL_ADAPT' )
Abrahim
June 25, 2007 at 11:16 pm
Michaela,
Thanks for the help,
Abrahim
June 24, 2007 at 12:27 am
Eugene,
Sorry, I guess I missed your post 🙁
Abrahim
September 20, 2006 at 9:55 am
Unfortunately Login to the box with jim didn't fix the problem.
I fund this fix on Microsoft site
1. | Start SQL Server Enterprise Manager. |
2. | Expand Microsoft SQL Servers,... |
September 20, 2006 at 9:11 am
December 13, 2005 at 11:36 am
Jonathan,
That would be great!
Do I need to use IIS and Apps server?
Thanks,
Abrahim
December 12, 2005 at 9:30 am
Jonathan,
Our users do not like Access or Excel.
Not to forget that they are MAC users.
I'm not an asp programmer.
I was hoping to find a tool that is out box ready...
December 9, 2005 at 10:53 am
Thanks Rick ,
I'll give it try.
Regards,
Abrahim
June 9, 2005 at 9:27 am
Thank you all for the wonderful feedback!!
I can't wait to see a simple documentation about how to secure the SQL server 2000.
Best regards,
Abrahim
April 5, 2005 at 9:56 am
Is there any link to the security and user setup for SQL 2000 out there?
Thanks in advance,
Abrahim
April 4, 2005 at 9:41 am
Viewing 15 posts - 1 through 15 (of 20 total)