Viewing 15 posts - 6,256 through 6,270 (of 7,429 total)
Ok I think maybe I have been confused. If this DTS package is copying the objects over then you are suggesting is coming from a trigger or other process. Check...
April 25, 2002 at 9:11 am
So let me make sure I understand properly. When you open the job created to perform the scheduled task (which is in SQL Agent/Jobs) the jobs schedule is 00:00 daily....
April 25, 2002 at 9:08 am
Ok let's back up, what is the exact error message you are getting?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 25, 2002 at 9:00 am
Ok here is how you would do the update.
Update ScoreTable SET TotalScore = (
(CASE score1
WHEN 1 THEN 5
WHEN 2 THEN 10
WHEN 3 THEN 15
WHEN 4 THEN 20
ELSE...
April 25, 2002 at 8:59 am
When we refer to the DDL of a table we are referring to the CREATE statement to make the tables ourselves to test. This can be quickly obtained by using...
April 25, 2002 at 8:09 am
GRN is right except it doesn't look like you need the variable and you need to handle nulls if you table allows otherwise when you add a null to anything...
April 25, 2002 at 7:54 am
It is you use of " instead of ' that causes this. Use ' and ' + ' = '' on the inner quoted items. See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q135531 about this.
"Don't roll...
April 25, 2002 at 4:53 am
Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q305711 .
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 25, 2002 at 4:48 am
I assume sb is the DB you want to query, also master is where xp's live and you have to reference them that way so try.
Exec master.dbo.xp_sendmail
@recipients = 'jeffrey'(or...
April 25, 2002 at 4:42 am
I believe compaq and other vendors have these tools and other helpfull info normally on your install disks. If not check out your vendors site under support usually.
"Don't roll your...
April 25, 2002 at 4:40 am
This is not uncommon if the client machine does not have enough memory and VM to support the data amount. What is the clients total ram and their VM size...
April 25, 2002 at 4:33 am
100% correct, EM just submits the command for the backup, the server does the work.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 25, 2002 at 4:27 am
Really you cannot do this except possibly with an application permission but have never tried so cannot say. I suggest change the SA password and not let anyone have it...
April 24, 2002 at 7:43 pm
Not really unless you want to invest in a tool like Log Explorer which can read the actual transaction log and is very usefull. Otherwise, I would look at completed...
April 24, 2002 at 6:45 pm
First I read in an article either on SQLMag or some site or on the MS KB site that using a SELECT INTO to a #temp table does cause blocking...
April 24, 2002 at 6:41 pm
Viewing 15 posts - 6,256 through 6,270 (of 7,429 total)