Hi, I have two tables which form a master table via a union.
e.g.
SELECT A,B,C,D
FROM
(SELECT A,B,C,D FROM TableA UNION SELECT A,B,C,D FROM TableB)
What I want to be able to do is see if attribute A in TableB exists in
Table A.
If so I want to be able to add this to the "Master Select" ...
more >>
I'm setting up SQL Server 2005 and would like to develop a new application
architecture. Here are my objectives:
1) I want to be able to move a database from one SQL Server machine to
another without having to recode connection strings in applications.
2) I want to be able to redirect applica...
more >>
Hello there
On the place i work with i need to set role to the users to execute store
procedures without giving them db_owner permission.
does this role exist?
...
more >>
I have some code that I can write in a dll in vb.net 2003 or vb.net 2005
that needs to get executed whenever a new record is created in a sql server
2000 table. I know how to make a trigger on a table , but I am wondering
what code to use in the trigger to launch the execution of te Dll and p...
more >>
my query is too long to put into the SQL job.
it is cut when i paste it. How can i bypass length limitation? Thanks.
tony
...
more >>
Hi,
I am trying to experience the back/restore system dbs. I have two
machines with SQL 05 on each. I backup a msdb and a master db and want to
restore them on another machine. I found out I could restore the msdb with
"overwrite existing" on another machine. My questions is with "overw...
more >>