Viewing 15 posts - 2,191 through 2,205 (of 3,061 total)
Just to be sure... transaction is running on Oracle, inserting on remote SQL Server database - is that correct?
February 16, 2010 at 5:30 am
Check if you have an unique index on empid column...
if yes then build your PK on it.
if no then check for and fix empid duplicates then build your PK on...
February 16, 2010 at 5:26 am
What's your background?
Do you have any foundation in relational theory? No? ==> check C. J. Date
If you have a rdbms background check BOL, it installs alongside SQL Server.
February 16, 2010 at 5:06 am
Nice Marmot (2/8/2010)
Oracle RAC (Real Application Clusters) corresponds to SQL Server Clustering
This is incorrect. As far as I know there is nothing in the SQL Server side providing Oracle RAC...
February 10, 2010 at 12:16 pm
Not sure why you don't want to use Access as front-end when you keep saying you like it 🙂
If you are concerned about security you can always handle security...
February 10, 2010 at 12:08 pm
sgambale (1/25/2010)
Has anyone implemented his script or something similar in a production SQL Server?
Yes. Logon trigger is the way to go.
February 1, 2010 at 3:03 pm
Either your resume poorly reflects your working experience or your working experience is closer to a Sysadmin than a DBA. Based on the resume I would say you might...
January 31, 2010 at 8:42 am
wow wow WOW! :w00t: No need to declare Jihad on me... we both read from the same book! remember? :laugh:
hey ... you missed an opportunity to...
January 22, 2010 at 8:04 pm
gary-951320 (1/22/2010)
By catalogue do you mean working with the rdbms metadata or do you mean simply adding another table to the database
The idea is to build your own "catalog", in...
January 22, 2010 at 7:50 pm
David Portas (1/22/2010)...you can always create a truly normalized design without them.
Yes! I'm agreement... but the truth is you can do with or without them :Whistling:
I know there are...
January 22, 2010 at 3:48 pm
Peter Priebusch (1/22/2010)
Wow, perfect.Many thanks.
"I love it when a plan comes togheter" 😎
January 22, 2010 at 7:13 am
Roy Ernest (1/22/2010)
Great catch...
Glad to help 🙂
January 22, 2010 at 7:03 am
Roy Ernest (1/22/2010)
delete from table1where email not in (Select email from table2)
This will delete all records that does not have any corresponding email address in the second table.
:w00t: nahhhh! it's...
January 22, 2010 at 6:49 am
Check this pseudo-code...
delete table1
where table1.email in (select email from table2 where table2.email = table1.email)
go
January 22, 2010 at 6:45 am
mhilligas (1/22/2010)
What do you think?
I think you may be developing a resistance to read documentation 😀
Check if MSDTC is running on your SQL Server host; also check if your...
January 22, 2010 at 6:39 am
Viewing 15 posts - 2,191 through 2,205 (of 3,061 total)