As long as the VPN connection server allows access to the SQL server then yes this should work properly. You don't really have to have domain access unless you will...

Do you have any package variables defined, or what does the package do specifically?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I think it depends as the select statement should use it's where clause to get the data together. ISNULL is checking that the one value is null or not. As...

I get this usually anytime I change the name or do not restore back to a server that is replicated. I believe it is due to the fact that the...

http://www.networknewz.com/2001/0709.html

http://www.intranetjournal.com/ix/msg/19607.html

These are the few I can think of right off hand.

The biggest advantage of SQL is it's ability to be setup and maintained. Oracle is quite difficult.

Next Oracle is designed...

Not really as there are dozens of items that use the tempDb for query support. An eager is an object built by the query execution manager to augment the speed...

I prefer the file backup method as you get a copy of the database then do a restore to the other server. The only thing you need to keep in...

You will need an application that is written to read the log file. A good example of one is Log Explorer which you can download a demo copy at it's...

Withut using replication or doing a file backup I have not seen a way to deal with DTS as a backup mechanism when their are constraints in place without disableing...

Transfer all objects does just that transfers them. They go in no particular order so yes if you have a constraint enabled that it breaks it fails. You can remove...

quote:

---

Suppose I have the original production DB of data 1000 MB and Log 250 MB. I have taken the backup and restoring...

Unfortunately unless you are going to concatinate each column together case only allows the selection of one output item. However you could do the following.

In procedure

IF myColumn = 1

BEGIN

SELECT Col1,...

Try it with aliases like this.

update t1 set t1.col1 = 'abc', t1.col2='def'

from t1 t1x

inner join t2

on t1x.col3=t2.col1 and t1x.col4=t2.col2

where t1x.col1 = 'xy' and t2.col3 = '123' and t2.col4 is...

Really and truely any may help but I have walked into places who don't care what you are certified for. Some want experience and some will take a certification (usually...

Using the Import Wizard it will do insert only and any unique constraints that are broken will cause this to fail. You can however handle a few ways using a...